Easy Populate 1.2.5.4 support

To get UTF8 support for zen cart you have to do a little tweaking. What code needs to be changed is presented at my blog post

trsplet.com/blog/2008/06/14/php-zen-cart-easy-populate-utf8-podpora-utf8-support

I'm new here, and new to Zen Cart but not new to web designing in general.
I have downloaded Easy Populate and can't seem to get the format correct in Excel.

I have the entire spreadsheet completed, but when i go to upload it in the admin panel, it uploads one product and not even completely for that one product, when i have 1000's of products that should be uploaded. :(

I am attaching the spreadsheet, and would be really grateful if someone could look at it and change the format quickly (I think i may just be saving it wrong).

I don't have many funds available right now, but i'm willing to give large discounts in my new store or $20 or so to whoever can help me out.

Spreadsheet File: http://www.highhobbies.com/AllProducts.csv
CSV File: http://www.highhobbies.com/AllProducts.csv

I have tried for hours, I'm at my last resort here.

If you are trying to help and have any problems, please post here, PM me, or PM me for my email address or AIM screenname and I will be here to help.

Thanks in advance!
-George

When I Uploaded some new products.
I can see it if I search for the products such as:

Adult Bat Girl
http://nothingbutcostumes.com/index....ducts_id=14417

But the directory I put it in...
Either by clicking "New for 08" on top of the listing or
"New for 08" in the Categories Section...

I get a blank Screen....

Link didn't work... Trying again...
http://nothingbutcostumes.com/index.php?main_page=product_info&products_id=14417
Really banging my head on this one... :frusty::frusty::frusty::frusty:

HighHobbies:

I am attaching the spreadsheet, and would be really grateful if someone could look at it and change the format quickly (I think i may just be saving it wrong).

Spreadsheet File: http://www.highhobbies.com/AllProducts.csv
CSV File: http://www.highhobbies.com/AllProducts.csv

Your link is not working - did you find your answer?

jamesdavid:

Does anyone know how to update category description with Easy Populate?

When I make a category with a description in the admin, and export it, Easy Populate doesn't have the description anywhere.

You are correct, EP does not export category descriptions; however, the paid-for version does - EPA. It costs $65 which considering the work involved in this program is certainly warranted!
Buy here - http://www.zencartbuilder.com/index.php?main_page=product_info&cPath=1_6&products_id=1

hduk:

My suppliers provide the descriptions, i just want to be able to paste them into ep and upload without having to manually tweak the formatting. Is there any way of doing this. I have tried several ways but the descriptions all end up on 1 line. The supplied descriptions are in a text format on separate lines.

I ran into this as well - but many of my descriptions are almost dupes. I can't vouch for OO but in Excel, if you put your curser NOT in the cell; but in the Formula MENU line for that cell...it acts more like a text editor. I actually did my typing on a notepad and then pasted it to the Formula MENU cell. Once you get the hang of formatting html it's not that bad - it's exactly the same as you see right here in the Posting Editor!

Here are some things to try:
-paste all your client's descriptions to Word
-edit as you wish with bold etc.
-then File/Save to Web Page and
-View/HTML source to grab the code to paste into Excel as I showed above.

Good luck!

Why am I not able to see my uploaded my datafeed results.

I am using zen 1.3.8a with Easy Populate support for Version 1.2.5.4.
All installed and have NO errors etc . temp folder is cmod 700 and resides -
/xyzsitename/addondomainname/all the zen file and folders
/xyzsitename/addondomainname/temp /

I have been provided with datafeed from 'sensualmystique.com' as 'new datafeed 051308.xls' file format.

So far so good but what do I need to do to populate my shop. Shop is empty (I have deleted all the previous products and categories)

I have tried opening in Excel then saving as CSV text file then re upload under in admin under 'Upload EP File'

then what? I still can not see the products ..nothing has changed. what am I missing ?

Hey Langer, I swap you with a bit of sunshine from Gold Coast ...hehehe

Thanks in advance

It shouldn't be comma separated values, but tab separated, just making sure cause you said CSV, and the file extension txt.

After placing the file in the temp dir, go to easypopulate in the admin panel and paste the name of the file in the text field to get the file from the temp dir and click the import to db button.

Hope that helps.

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?

oavs: I re-read your message and I seem to undertand that the txt file you got wasn't generated with EasyPopulate. If so, you should get one generated by it and then copy the data under the columns it has, that way you make sure you're working with the right format.

How do one get generate by Easy Populate?

As I said I have the new datafeed 051308.xls on my machine locally. What is next? It is tab separated text file saved from Excel.

I am also not interested in The Froogle feeder any any other feeders. I just want my datafeed to work on my own shopping site.

In my datafeed file that was sent to me from the supplier I have the following headings. What do I do with them? Do I need to change any one of them?

ITEM ID CATEGORIES TITLE FULL SIZE IMAGE01 FULL SIZE IMAGE02 FULL SIZE IMAGE03 THUMBNAIL IMAGE01 THUMBNAIL IMAGE02 THUMBNAIL IMAGE03 DETAILS META_KEYWORDS META_DESCRIPTION QUANTITY REMAINING WHOLESALE PRICE ON SALE PRICE WEIGHT SKU COLOR SIZE

oavs:

In my datafeed file that was sent to me from the supplier I have the following headings. What do I do with them? Do I need to change any one of them?

EP is not that easy to use, but once you get the hang of it, it does make life easy.
With that... becuse your database is empty, exporting an EP file wont help you much. In the zip file you should have an temp directory. The dir has a txt file called Full-EP2005Aug31-0404.txt this is the basic dump file that EP uses. It has the full header.

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight 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_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

EP will not make categories from the txt file. You need to make categories in Zen cart before you try to install you products. If you don't and you have categories in your txt file that are not in your cart... good luck finding your products.

EP uses the model number to create products in your cart...

Use EP headings and copy your vendor products under the ones that match.. once done, save as a Tab Delimited text file.. not a CSV file.

Remember... EP wont make categories, use v_status 1 = active, 0 = in-active, 9 = delete product, all lines need an ending word of EOREOR.

davewest, I believe it does create the categories that you mention if they aren't the db already. I think I did a test that showed me that.

oavs, you can do a simple test with a single product first, with a new category, and see what happens.

I am sorry but I am totally lost. I have zipped one of my datafeed and one of the sample datafeed came with the EP. If you can do two lines for me please so I know what to do with the rest.

So close yet so difficult. You think read me would be little more clearer about the most crucial part. Installing running it fine yet I can not use the thingy so little help would be much appreciated.

Thanking you in advance.

PS I can't see my zip file on the forum..where did it go?

Sorry about this but here is the zip again.

Looks like uploads not working. Here is the small sample of my datafeed. If someone could put it in a EP format so I 'll know what to do with the rest. Thank you.

ITEM_ID CATEGORIES TITLE IMAGE THUMBNAIL OVERVIEW DETAILS META_KEYWORDS META_DESCRIPTION QUANTITY_REMAINING QUANTITY_SOLD RETAIL_PRICE YOUR_PRICE SALE_PRICE FIXED_SHIPPING WEIGHT SHIP_SEPARATE LENGTH WIDTH HEIGHT MAX_PER_BOX CHARGE_SHIP CHARGE_TAX IS_NEW IS_FEATURED AVAILABLE_TO VIEWABLE MANUFACTURER VENDOR SKU COLOR SIZE COLORSIZE
1 39->0|36->4|32->0|1->0 80067 - Beautiful soft cup babydoll edged with lac 80067.jpg Thumb_80067.jpg Beautiful soft cup babydoll edged with lace trim. BABYDOLLS BABYDOLLS BABYDOLLS - Beautiful soft cup babydoll edged with 503 0 10.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80067 Light Pink S->M->L
2 36->2|36->3|32->0|1->0 80083 - Sheer net and lace babydoll with shirred l 80083.jpg Thumb_80083.jpg Sheer net and lace babydoll with shirred lace and BABYDOLLS BABYDOLLS BABYDOLLS - Sheer net and lace babydoll with shirr 792 0 12 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80083 Red/Black One Size->XL
3 36->2|1->0 80085 - Marabou feathers babydoll. Adjustable str 80085.jpg Thumb_80085.jpg Marabou feathers babydoll. Adjustable straps and BABYDOLLS BABYDOLLS BABYDOLLS - Marabou feathers babydoll. Adjustable 946 0 12.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80085 Black One Size->XL
4 40->0|36->1|36->3|31->0|1->0 80070 - 2 piece lace babydoll with satin bow and m 80070.jpg Thumb_80070.jpg 2 piece lace babydoll with satin bow and matching BABYDOLLS&return;&newline;&return;&newline;[SOLD_O BABYDOLLS BABYDOLLS - 2 piece lace babydoll with satin bow a 1710 0 12.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80070 Red / One Size->Red / XL->White / XL
5 36->2|1->0 80038 - Sheer underwire ruffled babydoll and match 80038.jpg Thumb_80038.jpg Sheer underwire ruffled babydoll and matching thon BABYDOLLS BABYDOLLS BABYDOLLS - Sheer underwire ruffled babydoll and m 883 0 13 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80038 Black S->M->L->XL
6 40->0|36->1|36->2|36->3|36->4|32->0|31->0|1->0 80042 - Stretch lace and chiffon babydoll with mat 80042.jpg Thumb_80042.jpg Stretch lace and chiffon babydoll with matching th BABYDOLLS BABYDOLLS BABYDOLLS - Stretch lace and chiffon babydoll with 1414 0 13.75 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80042 White / L->White / XL->Red / S->Red / M->Red / L->Red / XL->Black / S->Black / M->Black / L->Black
7 36->2|1->0 80043 - Floral embroidery underwire babydoll with 80043.jpg Thumb_80043.jpg Floral embroidery underwire babydoll with cup stra BABYDOLLS BABYDOLLS BABYDOLLS - Floral embroidery underwire babydoll w 960 0 14.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80043 Black S->M->L->XL
8 40->0|36->4|36->5|32->0|1->0 80040 - Cross dye stretch lace underwire babydoll 80040.jpg Thumb_80040.jpg Cross dye stretch lace underwire babydoll with sid BABYDOLLS BABYDOLLS BABYDOLLS - Cross dye stretch lace underwire babyd 1696 0 14.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80040 Mint->Light Pink S->M->L->XL
9 39->0|36->1|1->0 80069 - Sheer babydoll trimmed with ruffles and bo 80069.jpg Thumb_80069.jpg Sheer babydoll trimmed with ruffles and bows. Pan BABYDOLLS BABYDOLLS BABYDOLLS - Sheer babydoll trimmed with ruffles an 601 0 14.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80069 Pink S->M->L->1X/2X->3X/4X
10 32->0|25->0|1->0|36->4 80046 - Soft nylon embroidered netting babydoll ha 80046.jpg Thumb_80046.jpg Soft nylon embroidered netting babydoll has satin BABYDOLLS BABYDOLLS BABYDOLLS - Soft nylon embroidered netting babydol 1565 0 15.25 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80046 Pink S->M->L->XL
11 36->2|36->3|32->0|1->0 80077 - Knit chiffon babydoll with tattoo lace cup 80077.jpg Thumb_80077.jpg Knit chiffon babydoll with tattoo lace cups. Inclu BABYDOLLS BABYDOLLS BABYDOLLS - Knit chiffon babydoll with tattoo lace 1884 0 16.25 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80077 Black/Red S->M->L->XL
12 36->2|36->4|1->0 80050 - Stretch satin soft cup babydoll with lace 80050.jpg Thumb_80050.jpg Stretch satin soft cup babydoll with lace trim. In BABYDOLLS BABYDOLLS BABYDOLLS - Stretch satin soft cup babydoll with l 1641 0 16.25 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80050 Pink/Black S->M
13 25->0|1->0|36->2 80048 - Chiffon cowl neck babydoll with rhinestone 80048.jpg Thumb_80048.jpg Chiffon cowl neck babydoll with rhinestone halter BABYDOLLS BABYDOLLS BABYDOLLS - Chiffon cowl neck babydoll with rhines 0 0 18.75 0 0 2 0 0 0 0 0 Yes No Yes Yes No 80048 Black M
14 36->3|32->0|25->0|1->0 80071 - ######## sheer net babydoll with slightly padd 80071.jpg Thumb_80071.jpg ######## sheer net babydoll with slightly padded cups BABYDOLLS BABYDOLLS BABYDOLLS - ######## sheer net babydoll with slightly 0 0 17 0 0 2 0 0 0 0 0 Yes No Yes Yes No 80071 Red S->L->XL
15 36->3|32->0|25->0|1->0 80068 - Sheer net underwire babydoll with cute ost 80068.jpg Thumb_80068.jpg Sheer net underwire babydoll with cute ostrich fea BABYDOLLS BABYDOLLS BABYDOLLS - Sheer net underwire babydoll with cute 0 0 17 0 0 2 0 0 0 0 0 Yes No Yes Yes No 80068 Red XL
16 32->0|25->0|1->0|36->4 80041 - Charmeuse and matching lace babydoll with 80041.jpg Thumb_80041.jpg Charmeuse and matching lace babydoll with ######## sid BABYDOLLS BABYDOLLS BABYDOLLS - Charmeuse and matching lace babydoll w 1647 0 18 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80041 Pink S->M->L->XL
17 32->0|25->0|1->0|36->3 80100 - 2 piece babydoll with satin bow and matchi 80100.jpg Thumb_80100.jpg 2 piece babydoll with satin bow and matching thong BABYDOLLS BABYDOLLS BABYDOLLS - 2 piece babydoll with satin bow and ma 1967 0 20.5 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80100 Red One Size->XL
18 32->0|25->0|1->0|36->4|36->2 80029 - Pink stripe microfiber, open back&co 80029.jpg Thumb_80029.jpg Pink stripe microfiber, open back, und BABYDOLLS BABYDOLLS BABYDOLLS - Pink stripe microfiber, open bac 1638 0 21.75 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80029 Black/Pink S->M->L->XL
19 36->1|1->0 80049 - Microfiber underwire babydoll with stretch 80049.jpg Thumb_80049.jpg Microfiber underwire babydoll with stretch lace cu BABYDOLLS BABYDOLLS BABYDOLLS - Microfiber underwire babydoll with str 903 0 21.75 0 0 2 0 0 0 0 0 Yes No Yes Yes Yes 80049 White S->M->L->XL

Ive installed Image Handler 2 and Easy Populate. Both are working fine but now when I go to my Admin/ Categories Products, none are displayed.

If I use Easy Populate I can import products and they appear in my store front, but not in my admin.
james

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?

Anguz:

davewest, I believe it does create the categories that you mention if they aren't the db already. I think I did a test that showed me that.

oavs, you can do a simple test with a single product first, with a new category, and see what happens.

EPA will create, EP wont. There is a difference between the two, I'm using the free one EP. That's what I fond. I'm using it update, add and delete products.

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.

jamesdavid:

Ive installed Image Handler 2 and Easy Populate. Both are working fine but now when I go to my Admin/ Categories Products, none are displayed.

If I use Easy Populate I can import products and they appear in my store front, but not in my admin.
james

When i install my site live i get this;

Warning: require(includes/modules/category_product_listing.php) [function.require]: failed to open stream: No such file or directory in /home1/clearmag/public_html/admin/categories.php on line 639

Fatal error: require() [function.require]: Failed opening required 'includes/modules/category_product_listing.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home1/clearmag/public_html/admin/categories.php on line 639