Easy Populate Import not displaying in categories/products

So first post and first time Zen Cart user. website is Synthetic Motorsports. Still finding my way around but I am vary familiar with forum etiquette and have used the FAQ and search function quite a bit already. I installed easy populate and ckeditor last night with filezilla. ckeditor installed fine but Easy Populate did not give me the option to use it in the tools drop down. I can go direct to the easypopulate.php like it was indicated to everyone on the you tube install video.

So I exported the initial database and looked at the headers across the top. pulling my sql database from my previous cart I realigned the columns to match what is in the zen database. After adding a v_products_model (my db didn't have this) and adding the import category (test examples), I imported this csv file which has over 300 items in it. It did not show any errors from the import. When I went back and refreshed the test example category but only 1 of the items shows up.

I then went and did a second import with only 4 files. Again this imported without error but is not showing up in the test examples category. It wont let me upload the csv but again I matched up the correct columns with the correct header. It shows 5 items in the test examples category but it only display's the one shown above. Any ideas what I am doing wrong?

Thanks,

Well after tinkering with the data for a couple more hours I figured out what was wrong. I needed to add a 1 in the status field and a date modified field.

Greetings I am using zencart 1.5.0 and easy populate 2.5 i imported my file through easy populate and it seems it is in the database of site but it's not showing up in catagories or products in zencart any ideas of what i should do?

No model field in record. This line was not importedG-vibe 6 f | 99.73 | 49.87 | The G-Vibe | In Stock | Fun toys | ELD | 2013-02-04 | http://fee | Vibrators | Luxury | | 5060320510 | 1.20000 |
No model field in record. This line was not imported2013 playb | 17.93 | 8.97 | Enjoy some | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 1847091310 | 0.96000 |
No model field in record. This line was not imported2013 playb | 16.73 | 8.37 | It'll | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 9781554842 | 0.50000 |
No model field in record. This line was not importedSex smarts | 11.17 | 5.59 | This page- | In Stock | | ELD | 2011-09-23 | http://fee | Extras | Books | Cards, Cal | 1847091210 | 0.96000 |
No model field in record. This line was not imported2013 olivi | 16.73 | 8.37 | Fan-favori | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 1847091391 | |
No model field in record. This line was not importedG-vibe 6 f | 99.73 | 49.87 | The G-Vibe | In Stock | Fun toys | ELD | 2013-02-04 | http://fee | Vibrators | Luxury | | 5060320510 | 1.19000 |
No model field in record. This line was not importedG-vibe 6 f | 99.73 | 49.87 | The G-Vibe | In Stock | Fun toys | ELD | 2013-02-04 | http://fee | Vibrators | Luxury | | | 1.20000 |
No model field in record. This line was not importedRocks-off | 9.95 | 4.98 | Rocks-off | In Stock | Miscellane | ELD | 2012-08-11 | http://fee | Extras | Batteries | | 8110410110 | 0.11000 |
No model field in record. This line was not importedPanasonic | 2.59 | 1.30 | There' | In Stock | | ELD | 2011-12-20 | http://fee | Extras | Batteries | | 0730965002 | 0.05000 |
No model field in record. This line was not importedPanasonic | 4.39 | 2.20 | Batteries | In Stock | Panasonic | ELD | 2000-01-01 | http://fee | Extras | Batteries | | 0730965002 | 0.16000 |
No model field in record. This line was not importedPanasonic | 3.77 | 1.89 | There' | OOS | Panasonic | ELD | 2000-01-01 | http://fee | Extras | Batteries | | 0730965002 | 0.24000 |
No model field in record. This line was not importedEnergizer | 10.55 | 5.28 | Keep your | In Stock | Energizer | ELD | 2000-01-01 | http://fee | Extras | Batteries | | 0398000113 | 0.16000 |
No model field in record. This line was not importedDeck the h | 9.95 | 4.98 | From Khepe | In Stock | Kheper Gam | ELD | 2011-09-24 | http://fee | Extras | Party Game | Adult Part | 8251561074 | 0.29000 |

Remove that version of Easy Populate and install chadderuski's Version 4.

This version is not (yet) in the plugins area, but there is a link to GITHUB. Find the thread for Easy Populate V 4.

I did that and still having same problem uploading file

No model field in record. This line was not importedG-vibe 6 f | | 99.73 | 49.87 | The G-Vibe | In Stock | Fun toys | ELD | 2013-02-04 | http://fee | Vibrators | Luxury | | 5060320510 | 1.2 |
No model field in record. This line was not imported2013 playb | | 17.93 | 8.97 | Enjoy some | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 1847091310 | 0.96 |
No model field in record. This line was not imported2013 playb | | 16.73 | 8.37 | It'll | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 9781554842 | 0.5 |
No model field in record. This line was not importedSex smarts | | 11.17 | 5.59 | This page- | In Stock | | ELD | 2011-09-23 | http://fee | Extras | Books | Cards, Cal | 1847091210 | 0.96 |
No model field in record. This line was not imported2013 olivi | | 16.73 | 8.37 | Fan-favori | OOS | Vivid | ELD | 2012-08-02 | http://fee | Extras | Books | Cards, Cal | 1847091391 | |

using open office tried adding Products_Model collume to file that was a no go????

No model field in record

Easy Populate (regardless of version) requires each product record to have a UNIQUE MODEL NUMBER, because this is used by EP as a reference to populate the database.

You seem not to have given your products UNIQUE MODEL NUMBERS, so EP is not importing anything.

I have a WIKI article on Easy Populate 1.2.5.4. and while some of it is redundant info, much of it remains relevant.

This is a file from a distributor that has 30 to 70,000 products can I show you part of a file to give you more of an idea of the structure , the maybe you can give me an example of how you would do it? :smile:

This is how it's structured now

Product_Number Products_Name Suggested_Retail_Price Wholesale_Price Long_Description Stock_Info Manufacturer Vendor_Code Date_Added Image_1 Category_1 Category_2 Category_3 UPC Weight
CNVELD-1001-0313 2013 ############## - playmate a day daily calendar 17.93 8.97 Enjoy some ############## Playmate eye candy every day with the 2013 ############## Playmate a Day Daily Calendar. Enjoy 365 days of ######## Playmates in provocative positions. You'll be eager to see who the next Playmate is. OOS Vivid ELD 2012-08-02 http://feeds.cnv.com/pimages/CNVELD/1001-0313.JPG Extras Books Cards, Calendars & Stationary 184709131019 0.96

Irrespective of what data your supplier sends you, the file format for upload to zencart using EP must be in accordance with the zencart database tables/fields, and the requirements for loading EP.

At a quick glance, it would appear you have sufficient data in that feed to use in an EP upload.

First may I say thank you for your responses !!!!

I have tried a number of different things and am having no luck......:dontgetit

I think I'm beginning to understand now

The EasyPopulate module has SAMPLE files for you to look at. Open one of these in OpenOffice, and see how it is structured.

Yes got the drift now and had a successful upload of 2,000. products i'll have to tweak a few things to get it all right, but surely have a better understanding of how it works thanks for your patience......Now I cannot get the images for products to show up?

any ideas?

v_products_image
http://feeds.cnv.com/pimages/CNVELD/10004.JPG
http://feeds.cnv.com/pimages/CNVELD/1001-0313.JPG
http://feeds.cnv.com/pimages/CNVELD/1001-0413.JPG
http://feeds.cnv.com/pimages/CNVELD/1001/10/101/1001-1012.JPG
http://feeds.cnv.com/pimages/CNVELD/1001-1113.JPG
http://feeds.cnv.com/pimages/CNVELD/10011.JPG
http://feeds.cnv.com/pimages/CNVELD/10028.JPG

Your supplier is providing a PATH to the images, so you will have to first SCRAPE them off the supplier's site.

You cannot put THEIR PATH into the EP file. Zencart does not work that way. Zencart assumes the images are all on YOUR SERVER.

So... how do you go scrape them?

SEE: http://www.zen-cart.com/showthread.php?204151-Using-external-images&p=1174593#post1174593

Once scraped, you FTP them to the images folder on your server.

type wget -i c:\textfile.txt (replace textfile.txt with the name of the textfile you created)

let it run till it downloads all your images. (They will be saved into the bin folder, because that's where WGET is located, so later you can move them to another folder).

Greetings did all the above wget down loaded and cannot find the folder anywhere not in bin with wget any ideas where this is downloading to?

Ok couldnt get that to work but finally was able to get files from dist andp up loaded them to the server in the images folder in zen pics are not showing up in the cart

this is how i have it srtuctured in spread sheet;

v_products_Image
CNVELD/10004.JPG
CNVELD/1001-0313.JPG
CNVELD/1001-0413.JPG
CNVELD/1001/10/101/1001-1012.JPG
CNVELD/1001-1113.JPG
CNVELD/10011.JPG
CNVELD/10028.JPG
CNVELD/1017.JPG
CNVELD/1018.JPG
CNVELD/10/101/1019.JPG

Shane Anthony:

Ok couldnt get that to work but finally was able to get files from dist andp up loaded them to the server in the images folder in zen pics are not showing up in the cart

this is how i have it srtuctured in spread sheet;

v_products_Image
CNVELD/10004.JPG
CNVELD/1001-0313.JPG
CNVELD/1001-0413.JPG
CNVELD/1001/10/101/1001-1012.JPG
CNVELD/1001-1113.JPG
CNVELD/10011.JPG
CNVELD/10028.JPG
CNVELD/1017.JPG
CNVELD/1018.JPG
CNVELD/10/101/1019.JPG

Each BACKSLASH is telling the PHP that a sub-folder is involved.

If the images are all in the MAIN IMAGES FOLDER, you need to REMOVE the "folder names" (CNVELD/ and CNVELD/10/101/) and ONLY have the image name. (10004.JPG)

ALSO... linux is CaSE SenSiTive... and I see you have .JPG .

If the actual images are .jpg (not .JPG) then you must change the case to lower case.

A GENERAL RULE with linux is to keep all folder and file names lower case.

There are folders and sub folders for the images so i put them in the main images folder for zen there are some many i figured it be easy to manage them instead of just dumping images in the images folder since the data files were structured that way and also they came and work in the folders with JPG I thought about that also when I was trying to figure this all out and still am..:P

Shane Anthony:

There are folders and sub folders for the images so i put them in the main images folder for zen there are some many i figured it be easy to manage them instead of just dumping images in the images folder since the data files were structured that way and also they came and work in the folders with JPG I thought about that also when I was trying to figure this all out and still am..:P

Not fully able to understand what you are trying to say here, but the procedure is relatively simple.

IF you have a LOT of images, it IS BETTER to put them into SUB-folders in your main " images " folder. This makes them easier to manage and makes the site faster too,

SO... let's say you are selling T-shirts.

You have thousands of t-shirt images. One-third are RED, one-third are BLUE, one-third are YELLOW.

You will create subfolders in your main images folder like this:

images
|_red
...|_redshirt1.JPG
...|_redshirt2.JPG
...|_redshirt3.JPG
...|_redshirt4.JPG
|_blue
...|_blueshirt1.JPG
...|_blueshirt2.JPG
...|_blueshirt3.JPG
...|_blueshirt4.JPG
|_yellow
...|_yellowshirt1.JPG
...|_yellowshirt2.JPG
...|_yellowshirt3.JPG
...|_yellowshirt4.JPG

Then, in your SPREADSHEET for Easy Populate, in the v_products_images column you would have:

red/redshirt1.JPG
red/redshirt2.JPG
red/redshirt3.JPG
red/redshirt4.JPG
blue/blueshirt1.JPG
blue/blueshirt2.JPG
blue/blueshirt3.JPG
blue/blueshirt4.JPG
yellow/yellowshirt1.JPG
yellow/yellowshirt2.JPG
yellow/yellowshirt3.JPG
yellow/yellowshirt4.JPG

The above data gets written to the database... and is stored there.

When a product loads into a web page, the PHP structures the FIRST PART of the image path, then gets the database reference for the image's ultimate location and name.

The php will build the IMAGE SOURCE as:

<img src="images/ ... then it fetches what's in the DATABASE to make up the rest of the call... red/redshirt1.JPG

... so the resultant call code is <img src="images/red/redshirt1.JPG" />

(Of course it also puts in things like alt tags too, but I omit them here for clarity.)