Easy Populate 1.2.5.4 support

[kobra]

chadderuski,

Well I am no lawer, but this is from the gnu(emphasis mine): GPL

How to Apply These Terms to Your New Programs

If you develop a new program, and you want it to be of the greatest
possible use to the public, the best way to achieve this is to make it
free software which everyone can redistribute and change under these terms.

The Original work was not langers and the history outlines this fully.

This is only for up to 1.2.5.4 as I am aware...

[chadderuski]

Kobra: Thanks for taking a look. I read the GPL again and I believe you're right.

New IMPORTANT Issue:

Easy Populate 1.2.5.4

I have two store fronts that I am working with. In one I am adding products, description, and also updating the the order of products (moving items around and consolidating categories).

I exported the Complete data using EP, and also the Model/Category file.

I wanted to update the test site to reflect my additions/changes. So I first uploaded the new Model/Category file and then the complete file.

When I uploaded the file it appeared to be okay, however, the items that I moved or consolidated now appear as links products!!

How do I get around this? Or did I do something wrong or wrong order?

[pawelsad]

I also noticed this behavior, I think the easiest way to fix it is to make a manufacture for <blank> and to use that instead of leaving the manufacturer blank.

Its good idea but when i set up us <blank>

On manufactures list it will display <blank> and i dont want to display anything, i think i know where is the problem in the code, when script its adding manufacturesrs its not deleteing values after each adding, do you have any idea where in the code i can find line and reset it ??

[chadderuski]

Its good idea but when i set up us <blank>

On manufactures list it will display <blank> and i dont want to display anything, i think i know where is the problem in the code, when script its adding manufacturesrs its not deleteing values after each adding, do you have any idea where in the code i can find line and reset it ??

Hi Pawelsad,

Okay, you don't have to use <blank> in the name, you could call it "generic" or something similiar, and then put it's sort order to the bottom.

I have looked at the code briefly. Although not horribly complicated, it is not simple.

What is likely happening is that once the manufacturer's id has been set (I do not remember if they use ids or names) it does not get reset when it comes upon an empty entry.

i.e. <tab><tab> produces a null or empty value

So, you'll want to find the code, test for empty or null and then assign that id to 0. Zencart manufacturers id's start at 1. So I believe they use id 0 to leave as blank. But don't take my word for it!!! Just tossing out ideas.

Be careful though. I don't know that easy populate uses id's here, but rather manufacturer names.

If you get a working solution, by all means post the code update here for testing!

-cj

[jrb1512]

ive installed easy populate ok now, but i can't make sense of the txt files it generates how can i work the data with excel?

i get the following options for download, i did the complete txt file but i cant make sense of it, any advice? many many thanks

Download EP and Froogle Files


[FONT=Times New Roman]Download Complete tab-delimited .txt file to edit (Attributes Not Included) [/FONT][FONT=Times New Roman]Download Model/Price/Qty tab-delimited .txt file to edit[/FONT][FONT=Times New Roman]Download Model/Category tab-delimited .txt file to edit[/FONT][FONT=Times New Roman]Download Froogle tab-delimited .txt file[/FONT][FONT=Times New Roman]Download Model/Attributes tab-delimited .txt file [/FONT][FONT=Times New Roman]Create EP and Froogle Files in Temp Dir (temp/)[/FONT][FONT=Times New Roman]Create Complete tab-delimited .txt file in temp dir (Attributes Not Included) [/FONT][FONT=Times New Roman]Create Model/Price/Qty tab-delimited .txt file in temp dir[/FONT][FONT=Times New Roman]Create Model/Category tab-delimited .txt file in temp dir[/FONT][FONT=Times New Roman]Create Froogle tab-delimited .txt file in temp dir[/FONT][FONT=Times New Roman]Create Model/Attributes tab-delimited .txt file in temp dir[/FONT]

[Scrat]

Download the complete file and the Model/Attributes file and open them in excel and you will see how to import additional products into your cart, by coping the format you have just downloaded. EP will update existing products and import new products working from the unique product ID.

[jrb1512]

Great i can see them in excel. Is it possible to update the spreadsheet data i.e. product price and if so in what format do i save it. it looked complicated with adding and removing products so i was thinking of adding and removing products from the admin area and using easypopulate to update product pricing? It takes me forever doing it manually through admin as i have been doing this now for a year

[Scrat]

jrb1512 - It must be a TAB seperated file and saved as a .txt file.

Down load a complete file delete all the products but one and the header row and just change/alter price and description as a test and then upload that file and you will see what EP does. But do keep the

v_products_model

the same as it will upload load as a new product other wise it will just update the product with the changes you have made.

[pawelsad]

Hi Pawelsad,

Okay, you don't have to use <blank> in the name, you could call it "generic" or something similiar, and then put it's sort order to the bottom.

I have looked at the code briefly. Although not horribly complicated, it is not simple.

What is likely happening is that once the manufacturer's id has been set (I do not remember if they use ids or names) it does not get reset when it comes upon an empty entry.

i.e. <tab><tab> produces a null or empty value

So, you'll want to find the code, test for empty or null and then assign that id to 0. Zencart manufacturers id's start at 1. So I believe they use id 0 to leave as blank. But don't take my word for it!!! Just tossing out ideas.

Be careful though. I don't know that easy populate uses id's here, but rather manufacturer names.

If you get a working solution, by all means post the code update here for testing!

-cj

Thank you i fixed myself i did some search and change some code, i reset manufacturer id after adding manufacturer name into database and now its working great :)

Thanks for your help.

Pawel

[chadderuski]

Thank you i fixed myself i did some search and change some code, i reset manufacturer id after adding manufacturer name into database and now its working great :)

Thanks for your help.

Pawel

Pawel, could you post the file you changed and the code snippet?

Thanks!