Easy Populate 1.2.5.4 support

prosam:

I am going to use EP to upload over 8,000 products to my site and even though most product images will be named according to their product number I'm sure there will be some that do not get named correctly or are not found at all so I would like the no_image gif to show up instead of a broken image.

I know there has to be a modification done to the zen_image function file I'm just not sure how, I'm not much of a php coder, I can understand it but cannot write it. Something like if image not found display no_image.gif

I can't even find the zen_image function file for the life of me.
Ok I found the answer to my question and here it is if anybody else needs it. This worked in ZC 1.3.8 not sure about the older or newer versions coming out.

In includes/functions/html_output.php after

//auto replace with defined missing image
    if ($src == DIR_WS_IMAGES and PRODUCTS_IMAGE_NO_IMAGE_STATUS == '1') {
      $src = DIR_WS_IMAGES . PRODUCTS_IMAGE_NO_IMAGE;
    }

Enter the following:

	if (!file_exists($src)) {
      $src = DIR_WS_IMAGES . PRODUCTS_IMAGE_NO_IMAGE;
	}

This will replace any broken product images with the no image file.

Anguz:

oavs, did you look for the txt file in the temp dir? Did you look at the EasyPopulate entry in the Tools menu in the Admin area?

Yes, I did . Can you tell me what am I supposed to be looking for? There are text files as per original installation.

After I upload my datafeed file, I get this message on the bottom. Then what ?

Upload Results

File uploaded.
Temporary filename: /tmp/phpXgT8SQ
User filename: new datafeed 051308.txt
Size: 129316

Upload Complete

I have no idea what to do with these??
Download EP and Froogle Files

Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file

Create EP and Froogle Files in Temp Dir (temp/)

Create Complete tab-delimited .txt file in temp dir (Attributes Not Included)
Create Model/Price/Qty tab-delimited .txt file in temp dir
Create Model/Category tab-delimited .txt file in temp dir
Create Froogle tab-delimited .txt file in temp dir
Create Model/Attributes tab-delimited .txt file in temp dir

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.

davewest <

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

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.

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

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?

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 :)

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

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

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:

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.

Anguz >

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

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

Was this ever changed? How is it done?

I have loaded the version for zencart 1.3.8 with Easy Populate. My website is a bookstore with lots of new fields like reference, version, binding, index, red letters, etc. I have not loaded a small sample as of yet. Wondering how to get the extra fields on my access file that is tab-delimited.

I have been searching through the forums and have not found the answer.

Hello, Can EasyPopulate be used to upload bulk Digital Goods?
I dont see the field in the example files. Any help would be appreciated.

Thanks,

JR

Thanks you for your help, i will try that. I did not know about the "9" to remove the product from catalog. That is very very useful!!

Thanks

Hi I recently installed easy populate and im a bit lost on how to use it, so far i've Selected the first link under

"Download EP and Froogle Files

"Download Complete tab-delimited .txt file to edit (Attributes Not Included) "

and downloaded this, i then went to the .txt file and copy pasted it to xcel 2007 and saw how easy it was to edit everything, unfortunately...when i save it after making corrections back to a .txt file, i try to upload the file to "Upload EP > insert into DB" and it does nothing. Then i was thinking if there was a way to upload this file manually with my ftp ... but Im not sure where abouts in my phpadmin where i would do this. Could someone help point me in the right direction?

lizar5-:

Hi I recently installed easy populate and im a bit lost on how to use it, so far i've Selected the first link under

"Download EP and Froogle Files

"Download Complete tab-delimited .txt file to edit (Attributes Not Included) "

and downloaded this, i then went to the .txt file and copy pasted it to xcel 2007 and saw how easy it was to edit everything, unfortunately...when i save it after making corrections back to a .txt file, i try to upload the file to "Upload EP > insert into DB" and it does nothing. Then i was thinking if there was a way to upload this file manually with my ftp ... but Im not sure where abouts in my phpadmin where i would do this. Could someone help point me in the right direction?

Hi,
Go back to the start.
Download Complete tab-delimited.txt file and save to your computer...
Find the file and right click to "Open with" and scroll to Excel.
Do all your editing on the open Excel file.

When complete, "Save As" and it will notice it is a tabdelimited.txt file and say yes. close the Excel program and click no to save the changes. (that part refers to if you changed any cell width or height).

Now that you have a tabdelimited.txt file you can go back to tools/EP and upload either as a single file, or split file. Unless you ftp'd it to your temp directory.

Let me know.

lizar5-:

Hi I recently installed easy populate and im a bit lost on how to use it, so far i've Selected the first link under

"Download EP and Froogle Files

"Download Complete tab-delimited .txt file to edit (Attributes Not Included) "

and downloaded this, i then went to the .txt file and copy pasted it to xcel 2007 and saw how easy it was to edit everything, unfortunately...when i save it after making corrections back to a .txt file, i try to upload the file to "Upload EP > insert into DB" and it does nothing. Then i was thinking if there was a way to upload this file manually with my ftp ... but Im not sure where abouts in my phpadmin where i would do this. Could someone help point me in the right direction?

in response to this, i read the previous page and found most of my answer, does it matter what you name the text file? and when your ;inserting from temp... do you have to add the file extension? Is it normal for this upload to take forever?

mydssbin,
If you used 9 to delete the product, don't worry about removing it from your tabdeliminated.txt file. It will just show up in a purple color saying it can't be deleted since it was already deleted. You may want to reinsert the product later. Saves extra writing.

lizar5-
How big's the file. Look under your "Server Version" and see if it says 127.0.0.1

That should be "Database Host" localhost -------