Easy Populate 1.2.5.4 support

[Anguz]

oavs <

Out of those links you quoted, click on the "Create Complete tab-delimited .txt file in temp dir (Attributes Not Included)" one. Then go to your temp dir and get the generated txt file. Open the file with MS Excel or OOo Calc.

If your store has no products yet, then you'll only have one row with the headers, which are actually the database table's column names. In each following row fill the data you will add, including the product's model, which is what EasyPopulate uses instead of the product's ID, so make them all unique.

To be sure what data to include, you may want to add a single product using the cart's admin and then export the file as explained above, then in the file you'll have that product in the first row after the headers. Then, for the other products, follow the guide of that product regarding the data you see filled. One product per row.

When you're done with the file, save and copy the file back to the temp dir. Go back to EasyPopulate in the admin area of the Zen Cart and paste the name of the file in the third text input field, the one named "Import from Temp Dir (temp/)" and click the "Insert to DB" button. You'll get a confirmation of the action after done, with a detail at the bottom of the page.

[Anguz]

davewest <

I just tried it again and it does create the category if it doesn't exist. ;)

[Anguz]

I have a couple of questions, the first out of curiosity and the other out of trouble.

In the products table, EP doesn't save a master_categories_id value. Is this bad or of no concern?

I've just populated for a second time a new store, which had everything working fine before I removed every product, but now in the category listing, when I click on an other page, i.e. ?page=2, it just keeps displaying the same products from the first page. Does this have anything to do with EP? I ask because its the only thing I did after checking the it worked before removing the products and repopulating.

Thanks in advance.

[EyUpDuck]

hiya
I have previously used zen cart and easy populate with no problems, but in the last few days I have needed to use zen cart and EP again.
I have downloaded and installed the latest version of both zen and EP, then have gone into admin and downloaded a blank spreadsheet.
I have uploaded a small sample of stock to the store, and am getting the following error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/performe/public_html/shop/admin/easypopulate.php on line 2067

When you look at the shop, it is adding the categories but not the stock. Please can anyone tell me where I am going wrong?
I have opened that easypopulate.php file up and on line 2067 it says:

$row =  mysql_fetch_array($result); 

but I dont have a clue what that means lol

I have thousands of products to list, and almost 6000 of them are already in a spreadsheet so could easily copy the columns over to the EP one .. I would hate it if I had to add them all one by one eeek

Thanks for any help you can give

[allerup]

I have a problem with EP. When I add a new product, it makes a new post in the products_description table, but not in the products table.. Therefore the new items never show up in the shop.

Anyone who has a solution to this?

[EyUpDuck]

please ignore my query, I had installed the wrong EP. The one I had previously used was the one by Langor and I had not installed that one this time. I have removed the EP I installed and replaced by Langor's and its all working perfectly :)

hiya
I have previously used zen cart and easy populate with no problems, but in the last few days I have needed to use zen cart and EP again.
I have downloaded and installed the latest version of both zen and EP, then have gone into admin and downloaded a blank spreadsheet.
I have uploaded a small sample of stock to the store, and am getting the following error

When you look at the shop, it is adding the categories but not the stock. Please can anyone tell me where I am going wrong?
I have opened that easypopulate.php file up and on line 2067 it says:

$row =  mysql_fetch_array($result); 

but I dont have a clue what that means lol

I have thousands of products to list, and almost 6000 of them are already in a spreadsheet so could easily copy the columns over to the EP one .. I would hate it if I had to add them all one by one eeek

Thanks for any help you can give

[mydssbin]

Hello Everyone!

i installed EP and the problem i have is when i upload my products in a inactive "0" mode they show up in my live catalog. This happens whether if I upload 5 or 500 items.

Can someone help me fix this problem?

Thanks

[elkbow]

Hello Everyone!

i installed EP and the problem i have is when i upload my products in a inactive "0" mode they show up in my live catalog. This happens whether if I upload 5 or 500 items.

Can someone help me fix this problem?

Thanks

mydssbin,
It's suppose to do that. If the product is at anytime available to your store, just change the inactive (0) to active (1) and mark your quanity to zero. That way it you just notify your customer -- Out of Stock--. Otherwise remove the item using status (9).

No matter what I do if I add a NEW CATEGORY in EP, it always shows up. Never an error with EP to date.

[oavs]

Anguz >

davewest <

I just tried it again and it does create the category if it doesn't exist. ;)

Ok I think I got the concept now. Unfortunately in my case it only created the first line of the datafeed with one category and details. Rest of the info is ignored even so I can see in admin following (only included some of the lines for the forum)

Upload Results

Filename: Full-EP2008Jun22-0012.txt

UPDATED! - Model: 80067 | 80067.jpg | 80067 - Be | Beautiful | | | | | | | | 10.5 | 0 | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80083 | 80083.jpg | 80083 - Sh | Sheer net | | | | | | | | 12 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80085 | 80085.jpg | 80085 - Ma | Marabou fe | | | | | | | | 12.5 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80070 | 80070.jpg | 80070 - 2 | 2 piece la | | | | | | | | 12.5 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80038 | 80038.jpg | 80038 - Sh | Sheer unde | | | | | | | | 13 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80042 | 80042.jpg | 80042 - St | Stretch la | | | | | | | | 13.75 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80043 | 80043.jpg | 80043 - Fl | Floral emb | | | | | | | | 14.5 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80040 | 80040.jpg | 80040 - Cr | Cross dye | | | | | | | | 14.5 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80069 | 80069.jpg | 80069 - Sh | Sheer baby | | | | | | | | 14.5 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80046 | 80046.jpg | 80046 - So | Soft nylon | | | | | | | | 15.25 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80077 | 80077.jpg | 80077 - Kn | Knit chiff | | | | | | | | 16.25 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80050 | 80050.jpg | 80050 - St | Stretch sa | | | | | | | | 16.25 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80048 | 80048.jpg | 80048 - Ch | Chiffon co | | | | | | | | 18.75 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80071 | 80071.jpg | 80071 - Se | ######## sheer | | | | | | | | 17 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80068 | 80068.jpg | 80068 - Sh | Sheer net | | | | | | | | 17 | | | 22/06/2008 | | Sensual My | BABYDOLLS | | | | | | | | | 80041 | 80041.jpg | 80041 - Ch | Charmeuse | | | | | | | | 18 | | | 22/06/2008 | | Sensual My | BABYDOLLS | 80100.jpg | 80100 - 2 | 2 piece ba | | | | | | | | 20.5 | | | 22/06/2008 | | Sensual My | BABYDOLLS | 80029.jpg | 80029 - Pi | Pink strip | | | | | | | | 21.75 | | | 22/06/2008 | | Sensual My | BABYDOLLS | 80049.jpg | 80049 - Mi | Microfiber | | | | | | | | 21.75 | | | 22

[oavs]

Anguz > thanks for sticking with me on this one. Its now working.