Easy Populate 1.2.5.4 support

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

Quote:

---

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:

PHP Code:

---

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

Quote:

---

Originally Posted by 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:

PHP Code:

---

$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

Quote:

---

Originally Posted by 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 >

Quote:

---

Originally Posted by 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)

Quote:

---

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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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 -------

Quote:

---

Originally Posted by elkbow

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

---

Server Date: 06/24/2008 00:34:44 Database Date: 06/24/2008 00:34:44
PHP Version: 4.4.8 (Zend: 1.3.0) PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 3,473 kB Database Index Size: 1,978 kB


if it has something to do with the database data size... i think my host has a limit of like 2 mb or something.... is there anyway to get around this if thats the case without contacting my host.... like uploading / copy pasting somewhere in phpmyadmin?

but theres a prob with this idea because the file is only 600kb as .txt file... unless its represented by "database data size" in which case im trying to upload 3 mb with 2 mb cap????

Can anyone please help me.

I have been looking around for help with the following error I received when trying to import a test.txt file.

Warning: fopen(/var/www/html/uploads/test.txt): failed to open stream: No such file or directory in /var/www/html/catalog/admin/includes/easypopulate/classes/eclipse/FileIterator.php on line 146

Warning File Import Failed! Primary index column p_products_id or c_categories_index_path missing from uploads file. Please consult the readme.html file for more information

The file was exported from Easy Populate and then I added 1 line and then uploaded the file and tried to import the file. The above error occurred. I tried to change the permissions on the files uploaded to see if that was a problem and the same error occurred. When I changed the permission on the file to "777" and tried, the same error occurred and the file then disappeared off the server.

Please can you assist with this problem.

Cheers

My Debug data shows the following

Quote:

---

Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
370:c0fcb6e4e2bc502d949be6d0f3b491a3
336:c8afefd20d349d32604dfdbf9c6817bd
290:1f79049c49bac2cf89601014c9ba4e86
334:11940a676c6ab31a3f81a0c28fa3731c
336:862e735e4bdddd3c5d7b684431b05d1c
400:85e02b1712ba498420c37c6687ca4318
344:0d1243b0038cbfd5f1c57ed6833f0b15
290:36ceadceb1048b9d30ab52b0ea56dcce
957:563816b8e55d0b53fcf89bf350c5b28d
326:3ae665e8592c677106965ae369fb4275
957:8e0008095ca1cc337f72705ccc1347e9
366:f2264ff4000970f5e2847680a934b6e0
316:a96e564be49545178c4435b1bb070b92
326:c247991421fa2ee5a9c74745c337e9e5
96:7f9f51ceea4104e758afb1070d6d2bb1
246:993508d90ae187c45031655c1bf7553b
914:ea5cd0dc80b8bf5359a550a407ff8f43
It is recommended that you delete this corrupted data using phpMyAdmin.

---

Is there a quick way (sql statement) to remove them???

[FONT=Arial]I've just installed easypopulate. Everything went smoothly - it was in my admin-tools, when I clicked on install this is the error message I get:

Warning: fopen(/home/momandba/public_html/servlet/temp/Full-EP2008Jun24-2210.txt) [function.fopen]: failed to open stream: Permission denied in /home/momandba/public_html/servlet/admin/easypopulate.php1089

Warning: fwrite(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1090

Warning: fclose(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1091

[/FONT] on line on line on line [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/warning.gif Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected][/FONT] [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/success.gif Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.[/FONT] [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/success.gif File Full-EP2008Jun24-2210.txt[/FONT] successfully exported! The file is ready for download in your /temp/ directory.[FONT=Arial]
The file isn't in the temp folder as there are errors. I've looked through those lines 1089 - 1091 and I don't see any glaring errors.

I eager to begin using this mod. I would appreciate any help you can offer.

Erin
www.momandbabyboutique.ca/servlet
[/FONT]

Quote:

---

Originally Posted by lizar5-

Server Date: 06/24/2008 00:34:44 Database Date: 06/24/2008 00:34:44
PHP Version: 4.4.8 (Zend: 1.3.0) PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 3,473 kB Database Index Size: 1,978 kB


if it has something to do with the database data size... i think my host has a limit of like 2 mb or something.... is there anyway to get around this if thats the case without contacting my host.... like uploading / copy pasting somewhere in phpmyadmin?

---

It appears that the MySql does not reside on your store hosting server, rather than on an external server is why is says only 2mb Max Size. Local host would usually be 4mb. Did you try splitting the upload EP?

All else, go to phpmyadmin and dump the entire database of products and go back to EP and split the files. Backup prior and use the store manager to reset and optimize the database.

I have a bookstore with lots of attributes like binding, version, closure, red letter, etc.

I loaded Easy Populate did the config and everything went fine. I also took my access file with three products and changed to txt file and changed the header names with v_products_model format. I made sure to follow format even down to EOREOR at the end of each line. I did the load from my admin area and bottom said everything went fine with no errors. But, no products showed up.

Besides no products showing up - my other concern is additional attributes. I have so many attributes that are listed on my original file. I had to delete them to get the sample ones to work. Is there anyway to follow the file format for txt file with new names that fit my attributes, so they can be loaded? Or should I be using something else instead of Easy Populate?

Thanks,:wacko:

Quote:

---

Originally Posted by elkbow

It appears that the MySql does not reside on your store hosting server, rather than on an external server is why is says only 2mb Max Size. Local host would usually be 4mb. Did you try splitting the upload EP?

All else, go to phpmyadmin and dump the entire database of products and go back to EP and split the files. Backup prior and use the store manager to reset and optimize the database.

---

i spoke to my hosting, they changed my limit and even regardless of my increased limit.. they say the file was small enough to be uploaded.. so thats not the issue :(

Hello everyone!

I managed to get Easy Populate installed without a hitch. I uploaded my set of products, but when I did so I recieved this error:

Code:

---

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

---

Additionally, I received this error in the output:

Code:

---

No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

---

The weird thing is, all products seem to have uploaded just fine. I have to make some minor tweaks, but everything seems to be working...

What does this mean?

I've re-ftp my files and tried again and I'm still getting the same errors:

Help!

Any ideas...

Erin

Quote:

---

Originally Posted by erinl

[FONT=Arial]I've just installed easypopulate. Everything went smoothly - it was in my admin-tools, when I clicked on install this is the error message I get:

Warning: fopen(/home/momandba/public_html/servlet/temp/Full-EP2008Jun24-2210.txt) [function.fopen]: failed to open stream: Permission denied in /home/momandba/public_html/servlet/admin/easypopulate.php1089

Warning: fwrite(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1090

Warning: fclose(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1091

[/FONT] on line on line on line [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/warning.gif Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected][/FONT] [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/success.gif Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products.[/FONT] [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/success.gif File Full-EP2008Jun24-2210.txt[/FONT] successfully exported! The file is ready for download in your /temp/ directory.[FONT=Arial]
The file isn't in the temp folder as there are errors. I've looked through those lines 1089 - 1091 and I don't see any glaring errors.

I eager to begin using this mod. I would appreciate any help you can offer.

Erin
www.momandbabyboutique.ca/servlet
[/FONT]

---

I am not a developer, so I can't cash in on this, but why, oh why doesn't someone take the initiative to build *something*, *anything* that will actually deal with editing attributes through a spreadsheet? I would likely pay some decent bucks to have this happen.

I installed ZenCart for several different clients - assuming that I'd be able to use EP to edit the hundreds (literally) of attributes in these stores and now it seems like there really isn't a tool to do this.

One client needs to up all their prices July 1. There is virtually no way (that I know of) to edit their attributes "offline" so that they can be uploaded and become effective on July 1 - or is there?

Any suggestions? Anyone?

Janelle

Quote:

---

Originally Posted by janellez

I am not a developer, so I can't cash in on this, but why, oh why doesn't someone take the initiative to build *something*, *anything* that will actually deal with editing attributes through a spreadsheet? I would likely pay some decent bucks to have this happen.

I installed ZenCart for several different clients - assuming that I'd be able to use EP to edit the hundreds (literally) of attributes in these stores and now it seems like there really isn't a tool to do this.

One client needs to up all their prices July 1. There is virtually no way (that I know of) to edit their attributes "offline" so that they can be uploaded and become effective on July 1 - or is there?

Any suggestions? Anyone?

Janelle

---

Hi Janelle,

I do not use attributes but have played with them a little. If all of them are assigned within a store, and just need updating, then the option to download Model with Attributes in EP should get what you need. The one that I played with had three attributes and the final total was priced via the attributes chosen. It is a little cryptic but I figured it out after a couple of attempts. Depending on how the values were originally assigned, an incremental dollar amount may be needed, instead of the actual price.

Regards,
Dennis

Hi Dennis,

Thanks for your reply. I didn't find it cryptic, I found it impossible! Once you get past the first set of columns of products, it seems to start a new set of columns (but with the model numbers missing). Whether I open it in OpenOffice or Excel, I see this same oddness.

I'm wondering if someone could help me with some SQL though and maybe we can all figure out if this is the best way to go about this. After running this SQL, I propose to edit the resulting spreadsheet, to remove the products_description column and then to upload the products_attributes table with this new data.

Here's the SQL statement I've come up with - however, it limits the products_id to one (and there are three attributes on each of my products). If I'm not being clear, let me know. I'm *really* rusty with my SQL. Can someone help me fix it so that it returns all rows in products_attributes with the products description matched up?

Select A1.products_name, A2.*
From products_description A1, products_attributes A2
Where A1.products_id=A2.products_id
Group by A2.products_id

Thanks!

Janelle

Woops - thought I had it - more work needed.

Hi

I have installed easy populate 1.2.5.4 and it seems to work ok but when I go and download the "Model/Category tab-delimited .txt file to edit" it only gives me the model and there are no categories

v_products_model EOREOR
EML4032 EOREOR

It does not give any error and I cant seem to get a sample file to download. The other files download all fine

Please help

Quote:

---

Originally Posted by fakeDecoy

Version 1.2.5.4 from 2005 is the last EP version, is that right? The Froogle feeder doesn't work - Google changed it to Google Products and changed almost all the required fields, and field names, a couple years ago. I modified some of the code last year, but it needs more work. Does anyone plan on working on it?

---

Anyone know about this? Is this the latest EP version, and will it be the last?

fakeDecoy : Google have changed the format of the feed since 1.2.5.4 was written and it will not work now. There is a new contr. for this which I believe works with XML, other wise you would need to edit the file to the new format, search in the download section.

navneet : Are you sure you have Cats. set up correctly ? Have you edited the EP file at all as it is only showing

Quote:

---

v_products_model EOREOR

---

as my unedited version gives me

Quote:

---

v_products_model v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 EOREOR

---

kburner : Enter one product in a cat. via ZC and then download that file via complete download, edit/add products to that file and reload. EP will only work if there are product already in the database. OO and Office will only work with I think 255 columns which you can use up very quickly with EP, so you may need to use a different text editor.

hbombza : Check your version of EP Version 1.2.5.4 is the best that works out of the box !

milobloom : This is a known bug in 1.2.5.4 search this thread for details.

erinl : What version are you using ?

xt0rt : read your error 'Empty delimiter ' & 'No model field in record' it looks as if your upload file format is incorrect, the best way to test is download a complete file to start with and look at that alter a few things and then upload the new file, and I am sure that will work for you.

janellez : The problem with doing it via sql, ZC needs to update several tables at once, attributes are held in a different table to product details and ZC uses table ids not model name/numbers as references in the these tables,so when EP updates the db it queries the model number/ref to get the table id number and then inserts the data or updates the data by the table id's. Other than coding it yourself or seeing if EP Advance works better for you, you will just have to live with the present version.

scrat

I have not edited easy populate at all. I have the following layout

I have one product in category B and this category is in category A.
I also tried to add another product directly in category C

still the same

navneet : By default EP gives you 7 categories which should be showing in the header live in the download file whether you have 7 or not set up in ZC.
Did you upload your products via EP firstly ? as ZC does not like excepting uploads from EP unless there is a product and category already set up originally via ZC not EP. What Version are you using ? (Langer 1.2.5.4 from Modhole not ZC Downloads is the one to use! as the others seem to be buggy.)
What does your complete file give you ? is there 7 cats. in that ?

scart:
it seems that i didnot go into configuration of easypopulate. once i did that it is working fine. Thanks for help

hello all,

i have been using google "site:www.zen-cart.com/forum stuff i want found"
and it had worked well until now..

i have installed easy populate and found it helpful - but now i would like to remove all products or rather rename models and products and generally clean up my products.

problem is when ever i change the model, the easy populate add a new product.

note: at first i thought it would use excels row numbering as a primary key to make sure no duplicate records exist, but i dont think that works.


so now i have lots of half arsed products in one of my categories. what would be manageable way of correcting my catalog of products ?


thank you.

omen - download a Download Complete tab-delimited .txt and change the second to last field v_status from 1 to 9 and that will delete that product from the database - see the readme file in EP zip file.

Can u tell me how u resolved your easy populate problem ?

Quote:

---

Originally Posted by Scrat

omen - download a Download Complete tab-delimited .txt and change the second to last field v_status from 1 to 9 and that will delete that product from the database - see the readme file in EP zip file.

---

thank you - that worked perfectly :)

there are so many un-documented zencart scripts that i forgot to check the readme.

by no means is easypopulate a perfect solution for product/stock management, but its the best thing we have so far.

Quote:

---

Originally Posted by oavs

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

---

I'm really glad. You're welcome.

Regarding my other post on having trouble witn the categories pagination, it wasn't EasyPopulate, just in case someone was wondering.

kburner : Enter one product in a cat. via ZC and then download that file via complete download, edit/add products to that file and reload. EP will only work if there are product already in the database. OO and Office will only work with I think 255 columns which you can use up very quickly with EP, so you may need to use a different text editor.

I must have missed this in the directions. I load the product first via admin/catagories with model # and ?. After that I can load .txt file with all other information? I am using access database. It has all file information. I have to change all the category names and delete a lot of attributes as I save it to a different file name as a .txt file also.

Hi, can I make the minimum order quantity by EP module?
I have thousands of products feeded by EP and can't find how to make this minimum quantity for them!

I wish someone has got a solution for it. Tried to look also advanced EP but this 1.2.5.4 still looks otherwise best for me.

Elli

hi,

i have a site located in this way:
public_html/o-bean.com (o-bean.com is where my zen cart is)

i've unzipped ep and renamed 'admin' to 'ep_admin' and 'temp' to 'ep_upload'

may i know where i sld upload the files to? and how about the others lik history, install sql, read me... etc?

ellivir - Sorry EP will not do this but I would have thought that you could write a sql script to do this easily ?

francesca_ph - You haven't put EP in the right folders ! as with any addon module the folders are set out like ZC's format so just drop the files in the same folders as your ZC format. You cannot rename these folders to your liking.:no:
So if mod. folder is named admin put those files in ZC's admin folder, or if they are in includes put then in ZC's includes.
'/public_html/' is your 'www' folder which everyone see on the internet.

Hi Scrat,

under public_html/o-bean.com/admin, i also have the folder name 'include'

and inside both 'inculdes' folder, i have functions, languages, datafiles and boxes as folders....

what can i do? i can't just replace them like that, right?

and I also have a 'temp' folder in EP, but i have no 'temp' folder under obean.com/

Quote:

---

Originally Posted by Scrat

ellivir - Sorry EP will not do this but I would have thought that you could write a sql script to do this easily ?

- -

---

Ou, that would be nice but I do not know exactly how and the minimum quantities are not applied for all the products, neither the same quantities for those that it is applied to!

Elli

francesca_ph : You don't seem to have grasped how Zencart and add-ons folders work.

You will of cause be the same, as the folder structure are the same, because the author is showing which folder the files are put...

Under the Mod's folder - Admin you have file easypopulate.php

So you put this in the Admin folder of your ZC, then in admin/includes/boxes/extra_boxes/easypopulate_tools_dhtml.php you would that file in public_html/o-bean.com/admin/includes/boxes/extra_boxes/easypopulate_tools_dhtml.php

etc etc etc...

ellivir - Have a read up on sql its pretty straight forward mysql tutorial I am sure if you cannot program you should be-able to do this in excel again with some research.

Quote:

---

Originally Posted by Scrat

francesca_ph : You don't seem to have grasped how Zencart and add-ons folders work.

You will of cause be the same, as the folder structure are the same, because the author is showing which folder the files are put...

Under the Mod's folder - Admin you have file easypopulate.php

So you put this in the Admin folder of your ZC, then in admin/includes/boxes/extra_boxes/easypopulate_tools_dhtml.php you would that file in public_html/o-bean.com/admin/includes/boxes/extra_boxes/easypopulate_tools_dhtml.php

etc etc etc...
.

---

sorry, but i really do not know how to go about it.

so how about those folders or files which have the same name? should i 'combine' them or 'replace' them?

as for the 'temp' folder, where should i put it as i do not have a temp folder under o-bean.com/

oh my!!!
i did it!!!

Quote:

---

Originally Posted by greatpriceshopping

Sorry as to not much detail. I probably have this all wrong but what I am doing is taking the data files from my supplier (who says there files are ready to work on zencart) and using the easy populate function I try and add it to the database. It says it was successfull, but nothing shows up. If any more detail is needed let me know, I appreaciate all of your help and for having this project around. I did dontae and will continue to do so when I can. I hope my post does not come off as rude or anything, as that is not my intention.

Thanks!

---

Have you fix the problem yet? i"m getting the same thing. Says " uploaded successfully" but nothing shows up. I'm using Easy populate advanced. Unable to get any help from anybody so far. It is frustrating...:wacko:

hi,

i guess i'm also getting the same thing

n when i upload a new file, it says at the top, cannot find easypopulate on line XXXX cannot rem the exact ones...

n also, after uploading, how do i make it shown on the site?

The error message i get:

Warning: file(/home/musicalv/public_html/o-bean.com/temp/temp/) [function.file]: failed to open stream: No such file or directory in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1223

Warning: Invalid argument supplied for foreach() in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1301

Hello all,

I used to be able to update my database via the admin easy populate tool. However, changes at my host - coupled with the size of the file - have made me switch to updates via SSH (which I have yet to do successfully).

I am getting the following message when trying to upload a file:

ERROR at line 1: Unknown command '\ '.

The structure of the file is as follows (note the "|" symbol has been added to this post to delineate fields):

v_products_model | v_products_image | EOREOR


Any ideas?

Thanks in advance, Newbie Linda

> maxim

Did you try using the temp dir to generate the txt file into to download from and then upload the txt file to it and insert into db from it?

francesca_ph :- Look at your error message it tells you your problem...
You haven't /home/musicalv/public_html/o-bean.com/admin/easypopulate.php installed on the server. Also you would need to create a /temp folder on your server with permissions correctly set, read the readme file...

maxim : - have you tried to download a complete file and open, changed some detail and re upload to the server to see if this works, as usual errors are in file format, this is always a good test to see if everything works OK.

Dear Anguz and Scrat:

This newbie isn't quite advanced enough to understand all of your guidance, but I think I have discovered the problem based on trying to do what both of you suggested.

The file that I am trying to insert is listed in the temp directory as the following file type: ASCII text, with CRLF line terminators; whereas files that I have generated to the temp directory are listed as ASCII text files (only).

I've tried cutting and pasting the data into one of the generated files, but I still get the CRLF line terminator format.

Any ideas?

Newbie :wacko: Linda

maxim : Don't know anything about SSH, but after goolging I found this quote:

Quote:

---

This is because SSH
# servers seem to treat CRLF as two line-ends.

---

Quote:

---

FTP and SFTP clients will often have an option to send files as
ASCII/BINARY/AUTO. This option controls how CRLF is handled when
encountered in the source file. This option has nothing at all to do with
the FTP/SFTP protocol itself; but is an option often included in client
software.

---

Basically you need to SFTP your file in ASCII not BINARY so you should have setting in your FTP software to send .txt files as ASCII.

Hope that helps ?

:frusty:
hi all zenners, I am very newer at this and may ask questions that seems stupid, but please help. So far, I have been able to successfully install and configure zen all by just reading up on the support post. After spending hours and days trying to figure out this "Easy-Populate" module, I got say, its not so "easy". Guess i just don't know where to look and the right questions to ask. I am able to sucessfully install it, but don't know how to use it. If there is anyone out there that willing to show me step by step. Much appreciated. Hope I not asking too much. thankshttp://www.chopstickrestaurant.com/zen

[QUOTE=Scrat;581855]francesca_ph :- Look at your error message it tells you your problem...
You haven't /home/musicalv/public_html/o-bean.com/admin/easypopulate.php installed on the server. Also you would need to create a /temp folder on your server with permissions correctly set, read the readme file...

hi scrat,

i already have it installed......all the files r in it

Quote:

---

Warning: file(/home/musicalv/public_html/o-bean.com/temp/temp/) [function.file]: failed to open stream: No such file or directory in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1223

Warning: Invalid argument supplied for foreach() in /home/musicalv/public_html/o-bean.com/admin/easypopulate.php on line 1301

---

francesca_ph : PHP gives you error messages as above if you read the error it is saying that it cannot find the easypopulate.php file, so I would check that all your files are in the right folders first. Strange thing you seem to have two temp folders one inside the other

Quote:

---

home/musicalv/public_html/o-bean.com/temp/temp/

---

I would start again, ftp all the files again to make sure you have them all in the right folders, check that you have the /temp folder in the right directory and then import/export a test file.(Also the right permissions especially the temp folder!)

winwallc : Easyiest way download a complete tab file and it should be pretty straight forward how it works, then add a product to that file and upload it via EP.

Hi hi,

i only get the error msg when i try to upload a file in EP. eg, i download the 'full', edit in excel, save as .txt and upload it again

then when i 'insert into db', i get the error msg....

francesca_ph :
Have you reinstalled the files ?
You had so much problems setting this up putting the files in the right folder, I can only think a file is corrupted or in the wrong folder ?
As I stated, start again, delete the EP files off the server first , and reinstall.
EP just works if you have it set up correctly.

i juz updated the file and uploaded it.
it says upload successful and shows all the items being updated
but when i refresh my store, it does not show anything at all

i have included product model (tho i do not know what is that for), item name, qty, statues, brand, AND PUT ALL 'EOREOR' (also do not know what is dat)

francesca_ph : First of all ZC needs some products already in the database for EP to work, so enter one or two products in via ZC not EP.
Secondly EP will only work if you have a model ref this is unique to that product you CANNOT have duplicate model ref's or EP .

:frusty:
Like the gentleman who seems frustrated by not being able to see anything when using EP to upload product - I am having the same issue.

My file is in excel, but is a tab delimited text file - what I did, to be sure that I used the same contextual file as EP uses, is that I first downloaded the current prod/price/category file and deleted all the previous content, leaving the heading in-tact.

I then formatted my content to fit in the proper columns and uploaded the file. It tells me the upload was successful and I go to look in the specific category, but there is nothing. So I thought perhaps that I needed to Import from Temp Dir (temp/) so, copy and pasting the temp file name into the import section - it tells me that the import was successful, but again, nothing is there.

I did read something about htaccess and global settings set to on - but mine is already set so...I'm not sure where to turn. I read the "readme.txt" file, but I am finding nothing useful to help me with this issue.

I have no other specifics that I can give on this issue as there are no warnings, errors or anything other than it stating it was successful and below that a list of all that was supposed to have been uploaded.

Would it be helpful to reinstall this mod, overwriting the old, or does someone have some information that may help me with this issue? Any help would be extremely appreciated.

Thanks in advance,

When you are preparing your .csv file for upload, what is the best way to add the line breaks in the descriptions if you have thousands of products?

I think that would be in your EP Configuration in the admin - from what I have read.

This is what I see under the smart tags:

Smart Tags Replacement of Newlines

Quote:

---

Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).

---

But then I am a newbie so don't quote me on this - someone else may have a better answer - but thought it just might be something to look into.

Hi,

I am having the same problems as others:

I am using EP_v2_76g_MS2 with Zen Cart v1.3.8a/v1.3.8

When I import, I get the follwing report:

Quote:

---

emporary filename: D:\apache2triad\temp\php23.tmp
User filename: zencart.txt
Size: 14326
| B1702S-B2 | | Iiyama PLB | 0 | 0 | 12.00 | | Monitors | | | !New Product!

| B1702S-W2 | | Iiyama PLB | 0 | 0 | 6.00 | | Monitors | | | !New Product!

| B1902S-B1 | | Iiyama PLB | 0 | 0 | 15.00 | | Monitors | | | !New Product!

| B1902S-W1 | | Iiyama PLB | 0 | 0 | 11.00 | | Monitors | | | !New Product!

---

from my source file zencart.txt

Quote:

---

v_products_model,v_status,v_products_name_1,v_products_price,v_products_priced_b y_attribute,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categ ories_name_2,v_categories_name_3,v_categories_name_4,EOREOR
B1702S-B2,,Iiyama PLB1702S-B2 17 Inch LCD-Black,0,0,12.00,,Monitors,,,,EOREOR
B1702S-W2,,Iiyama PLB1702S-W2 17 Inch LCD-White,0,0,6.00,,Monitors,,,,EOREOR
B1902S-B1,,Iiyama PLB1902S-B1S 19 Inch TFTLCD Black,0,0,15.00,,Monitors,,,,EOREOR
B1902S-W1,,Iiyama PLB1902S-W1S 19 Inch TFTLCD White,0,0,11.00,,Monitors,,,,EOREOR

---

EP reports that it has imported OK but it does not show up in the product list....

However... it WILL update an existing product if it is already in the DB using this method.

What can i possibly be doing wrong?

mentor : Use a better version, hence the thread title

Quote:

---

" Easy Populate support for Version 1.2.5.4 " NOT Version :-EP_v2_76g_MS2

---

As far as I can tell all the versions in the downloads are buggy, version 1.2.5.4 from modhole is the best and proven :yes: search this thread for the address see no.1 reply in this thread in Langer signature.

SaMortensen : Have you got products in ZC already as ZC does not accept EP imports otherwise. If so edit the present data and upload and see if that works, 9 times out of 10 it will be your file format which is wrong. Also check your version => Version 1.2.5.4 is the one to use...

Quote:

---

Originally Posted by Scrat

francesca_ph : First of all ZC needs some products already in the database for EP to work, so enter one or two products in via ZC not EP.
Secondly EP will only work if you have a model ref this is unique to that product you CANNOT have duplicate model ref's or EP .

---

dear Scrat,

ZC already have products in it. its the demo. i haven deleted them as I need the various examples as guides.

Mine is a pet food store, therefore under 'model' i cannot have the same word like 'treats' 'kibbles' 'toys' ? coz under the demo, which i opened, it has 4products 'normal' and 2 products 'special'. only 1 was sucessfully uploaded. i.e. the 1st one.

also what do you mean by duplicate EP? meaning i can only have 1 file in the temp dir?

and what is 'EOREOR' ?

francesca_ph : You have to have a unique model reference which is the first field in all the file .csv download files.

Quote:

---

v_products_model

---

So product1, product2, product3 etc etc

Otherwise EP cannot find the product to insert/update/delete

If you download a complete file it will show you an example from the sample data.

Quote:

---

Originally Posted by Scrat

francesca_ph : You have to have a unique model reference which is the first field in all the file .csv download files.


So product1, product2, product3 etc etc

Otherwise EP cannot find the product to insert/update/delete

If you download a complete file it will show you an example from the sample data.

---

ok, so is dis field compulsory? i did read the sample, that's why i mentioned i saw the same product model and it was actually updated well in zc...wierd?

Quote:

---

Originally Posted by Scrat

SaMortensen : Have you got products in ZC already as ZC does not accept EP imports otherwise. If so edit the present data and upload and see if that works, 9 times out of 10 it will be your file format which is wrong. Also check your version => Version 1.2.5.4 is the one to use...

---

Yes, I already have products in ZC - Store has been in operation for two years now - been using ZC since January.

Also, I am using version 1.2.5.4

I'm not sure what you mean by editing my present data - can you explain?
Attachment 4224
I have attached one of the files I have been importing for reference - also a screen shot if you prefer that format:

http://www.knotnbauble.com/Files/screenshot.gifplease tell me what I need to do to edit this file.

Thanks!

SaMortensen
Two Very Import Fields : -

Quote:

---

v_status EOREOR

---

You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.

I tried to upload files today using easy populate v1.2.5.4 .....i was trying to update my first half of my files with the produtcts url's and then I upload some new files...well...i kept getting this error

and the only thing i added was the manufacturers url to my product information that shouldnt have messed it up should it?

This is the error i kept on getting:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator,
[email protected] and inform them of the time the error occurred,
and anything you might have done that may have
caused the error.</p>
<p>More information about this error may be available
in the server error log.</p>
</body></html>


Then after i tried to upload my files so many times i got this error:

1226 User 'u70568462' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = 'ba0414ffc29cc39d6fa5871e0407183b' and expiry > '1216072998']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I know what the second error is....its because i had to many products/attributes uploaded at one time and the server cannot handle it....

But the first error (internal server error) i have no idea whats going on that has never happened before.


I know i have it set up right to because the other day i uploaded 1299 items with no problem.....

Could this be a problem with my hosting?
I have netfirms right now

Quote:

---

Originally Posted by rickiesdiscount

I tried to upload files today using easy populate v1.2.5.4 .....i was trying to update my first half of my files with the produtcts url's and then I upload some new files...well...i kept getting this error

and the only thing i added was the manufacturers url to my product information that shouldnt have messed it up should it?

This is the error i kept on getting:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator,
[email protected] and inform them of the time the error occurred,
and anything you might have done that may have
caused the error.</p>
<p>More information about this error may be available
in the server error log.</p>
</body></html>


Then after i tried to upload my files so many times i got this error:

1226 User 'u70568462' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = 'ba0414ffc29cc39d6fa5871e0407183b' and expiry > '1216072998']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I know what the second error is....its because i had to many products/attributes uploaded at one time and the server cannot handle it....

But the first error (internal server error) i have no idea whats going on that has never happened before.


I know i have it set up right to because the other day i uploaded 1299 items with no problem.....

Could this be a problem with my hosting?
I have netfirms right now

---

I forgot to mention Also my files are split in to 200 products per file.....
the first time i uploaded them they worked fine...now after i uploaded them with the manufacturers url...it has an internal server error

Quote:

---

Originally Posted by Scrat

SaMortensen
Two Very Import Fields : -


You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.

---

Scrat,
Thank you so very much. I have finally achieved success! Now all I need to do is get those pictures uploaded!

Thanks a MILLION for your help! :clap:

Quote:

---

Originally Posted by Scrat

SaMortensen
Two Very Import Fields : -


You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.

---

Scrat,
it worked!!!!

only.. 1. it created catogories of the same name for some. 2. I have e.g. 'treats'
for cat. 1 for some items and cat 2 for others. when i go back to zc, it says invalid master id, and created 2 ids of 'treats' for me

Hi, I was wondering if there is a way to make all my products "product is virtual" with easy populate. At the moment all my products are prompting the customer for a shipping address which I dont want.

lizar5- : Sorry in short the answer is no :no:

If all your products are virtual then the easiest way would be to use a sql script.

Quote:

---

Originally Posted by Scrat

SaMortensen
Two Very Import Fields : -


You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.

---

Just telling if somebody finds this useful:
And 0 is a hidden product. I use for example when not wanting to delete but the product is longer time out of stock or I need to change the info but has no time exactly on that moment.

I have read through the thread and am unable to find my answer.

everytime i try and add a product, i get this problem:


| T696969 | T4444I.jpg | This is a | Test | | 69 | 0 | 0 | 0 | | 0000-00-00 | 69 | | Hex Keys | Hex Sets | | | --none-- | 1 !New Product!

| | | | | | | | | | | | | | | | | | |

No products_id field in record. This line was not imported

products_id???

every line does end with EOREOR

Sc0rian : EP has to have a product_id/model, other wise EP just does not work.
By the looks of it your file format is incorrect, you look to have a empty TAB to start with

Quote:

---

*****| T696969 | T4444I.jpg |

---

As always if you have problems with EP start with a downloaded Complete File and work from there.:yes:

Hi

I'm very new to all this so please bear with me.

I installed Zencart and easypopulate yesterday and managed to get it to add a product or two okay.

I don't seem to be able to see the images though, is it supposed to upload the images at the same time?

If it is, what path name am I supposed to use and if not is there an addon within Zencart someone can recommend for me to do this.

Cheers
Jayne (the dizzy blonde):bigups:

Quote:

---

Originally Posted by bluedogatdingdong

Hi

I'm very new to all this so please bear with me.

I installed Zencart and easypopulate yesterday and managed to get it to add a product or two okay.

I don't seem to be able to see the images though, is it supposed to upload the images at the same time?

If it is, what path name am I supposed to use and if not is there an addon within Zencart someone can recommend for me to do this.

Cheers
Jayne (the dizzy blonde):bigups:

---

you put the image name in the excel file, and upload the image into the /images DIR using FTP.

Quote:

---

Originally Posted by Scrat

Sc0rian : EP has to have a product_id/model, other wise EP just does not work.
By the looks of it your file format is incorrect, you look to have a empty TAB to start with

As always if you have problems with EP start with a downloaded Complete File and work from there.:yes:

---

Hey,

thanks for the reply

I downloaded the complete excel document, it downloads as a .txt file.

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_priced_by_attribute v_products_weight v_products_sort_order v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_tax_class_title v_status EOREOR

those are the list of items i get. i'm missing product_id?

i tried adding in v_products_id as my very first list, still doesnt work.

| 496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated!
| 497 | T69696 | T4444I.jpg | T69666666 | a test | | 1212 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !New Product!

Thanks - I really wanted my customer to be able to do it all through the control panel on Zencart. I take it that this is not an option.

Sc0rian : Your product_id column is 'v_products_model' column one in your file.

Post your Complete file as an example and we can have a look. ( To me it looks as I said previously you have a leading TAB

PHP Code:

---

| 496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated! 


---

Where as it should be

PHP Code:

---

496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated! 


---

bluedogatdingdong : No, other than coding it yourself in PHP for server side or coding it on our customers PC.

Quote:

---

Originally Posted by bluedogatdingdong

Hi

I'm very new to all this so please bear with me.

I installed Zencart and easypopulate yesterday and managed to get it to add a product or two okay.

I don't seem to be able to see the images though, is it supposed to upload the images at the same time?

If it is, what path name am I supposed to use and if not is there an addon within Zencart someone can recommend for me to do this.

Cheers
Jayne (the dizzy blonde):bigups:

---

Read this: http://www.zen-cart.com/wiki/index.php/Easy_Populate

Quote:

---

Originally Posted by Scrat

Sc0rian : Your product_id column is 'v_products_model' column one in your file.

Post your Complete file as an example and we can have a look. ( To me it looks as I said previously you have a leading TAB

PHP Code:

---

| 496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated! 


---

Where as it should be

PHP Code:

---

496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated! 


---

bluedogatdingdong : No, other than coding it yourself in PHP for server side or coding it on our customers PC.

---

ok, i've uploaded my example.

Just started a webshop and added some items manually, exported the list to get the right EP format.
I added the rest of the products and try to import this file.
Record format is correct but I get message "No products_id field in record. This line was not imported" and no products are imported.
record format starts with
"19-10pdu samples/19-8pdu.jpg 19-10pdu powerstrip....etc"
In this case 19-10pdu is a unique identifier connected with v_products_model
The manually added products do get updated whenever I import the file but no new items are added. Images are already downloaded to server.
I use Zencart version 1.3.8 and latest version of easypopulate.
Tried to import files with less columns but no success.
All help is welcome.

i got the exact same problem gerhard59

Sc0rian & gerhard59 : What version of EP are you using, please note this is the thread is for Version 1.2.5.4 and that is the version to use any other seems to be buggy (Excluding EPA of course which is a commercial version)

Hi Scrat,
I am using version 1.2.5.4 that is what the zipfile is named.
Although readme talks about another version, not shure now if I use correct version.
Where can I re-download 1.2.5.4 and compare with my version?

gerhard59 ; see the first reply in this thread in Langers signature for the download from Langers Modhole if you downloaded from the ZC download area Yes you have a buggy version.

Quote:

---

Originally Posted by Scrat

gerhard59 ; see the first reply in this thread in Langers signature for the download from Langers Modhole if you downloaded from the ZC download area Yes you have a buggy version.

---

oh.. why don't you upload a NON buggy version on zen-cart? thats a bit miss leading no??

where i cant find this download link anywhere??

only one i can find is:

ftp://portability.dnsalias.com/EP_v1.2.5.1.zip

which don't seem to be working....

never mind

http://www.modhole.com/modhole/index..._Document_id=2

found it