Easy Populate 1.2.5.4 support

[chadderuski]

I have seen this posted elsewhere on this thread but have yet to see an answer. I have uploaded the files for version 1.2.5.5 I am working with zen 1.3.8. I have applied ths sql updates. I have done the installation per the install instructions. I can download the csv file.

I make changes to it and try to upload from hdd and I get no errors but I get no products added. I upload the file via ftp to the tempEP folder and add to db from that directory and get no errors but I get no products added.

I have unique names for the model, but it just doesnt seem to work. what am I doing wrong?

Wil,

Go to Tools -> Store Manager and Run both:
Update ALL Products Price Sorter and
Reset ALL Products Master Categories ID

That should hopefully fix it.

[WilpackPackaging]

Go to Tools -> Store Manager and Run both:
Update ALL Products Price Sorter and
Reset ALL Products Master Categories ID

That should hopefully fix it.

I just tried that and still nothing. No additional products were added.

I tried doing the reset then re-uploading the file and then doing the reset again. Still not working.

[Scrat]

Please read the title of this thread:

Easy Populate support for Version 1.2.5.4 namely Langer's version from Modhole not from ZC's download section.

The problem I am seeing is that with so many versions of EP floating about people are getting all sorts for issues and bugs and not being clear which version they are using.

Would it be an idea to start some new threads with the title of the versions of EP you are using ??

e.g
Easy Populate support for Version 1.2.5.4
Easy Populate support for Version 1.2.5.5.csv.2
Easy Populate support for Version 1.2.5.5
Easy Populate support for osc Version 2.77H

Just a thought

[stlnyc]

I've used EP to get items onto my site. Everything works great.

My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?

[WilpackPackaging]

Please read the title of this thread:

Easy Populate support for Version 1.2.5.4 namely Langer's version from Modhole not from ZC's download section.

The problem I am seeing is that with so many versions of EP floating about people are getting all sorts for issues and bugs and not being clear which version they are using.

Would it be an idea to start some new threads with the title of the versions of EP you are using ??

e.g
Easy Populate support for Version 1.2.5.4
Easy Populate support for Version 1.2.5.5.csv.2
Easy Populate support for Version 1.2.5.5
Easy Populate support for osc Version 2.77H

Just a thought

That is fine and dandy, however, in the download on the zencart site it references THIS THREAD!

[Stuff4Toys]

Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?

I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.

my images are all in images/products/123456.jpg and I have verified they are there.

My csv file looks like this:

v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,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,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,

yet when I upload and import the file I get images/no_picture.gif assigned to each item.

What am I missing?
JOhn ><>

[Stuff4Toys]

I've used EP to get items onto my site. Everything works great.

My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?

As you import into Excel set that column type as TEXT and it will leave it alone. This will not affect your import with the new prices.

[Stuff4Toys]

Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?

I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.

my images are all in images/products/123456.jpg and I have verified they are there.

My csv file looks like this:

v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,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,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,

yet when I upload and import the file I get images/no_picture.gif assigned to each item.

What am I missing?
JOhn ><>

When I export I get

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,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,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,no_picture.gif,"PATRIOTIC PACHYDERM PR","With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,0,"0000-00-00 00:00:00","2009-06-11 15:22:19",999,,Americana,,,,,,,"Taxable Goods",1,0,0,0,0,0,,,
34190,no_picture.gif,"UNITED WE STAND WALL PLAQUE","Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,0,"0000-00-00 00:00:00","2009-06-11 15:22:19",999,,Americana,,,,,,,"Taxable Goods",1,0,0,0,0,0,,,

http://www.dahnkedulcimers.com/
JOhn ><>

[foxmob]

I've used EP to get items onto my site. Everything works great.

My issue is that I use the barcode numbers as the item number and when I download our current inventory to make price changes via EP, both excel and open office removes the zero off of the front of barcodes that then mess up my inventory on the reupload by adding duplicated products. How can I fix this?

in excel: highlight the column(s), then "format cell" -> "number" tab -> custom -> now select the kind of number you'd like to show (i.e., use zeroes for the number of numbers in the UPC - mine all use 12, dvds).

I'm sure you can fiddle with excel and open office settings to default to this too, but I'm not sure how. using "text" should do it, but it didn't seem to work when I tested it.

I'm using office 2007, but it works similarly in earlier versions.

[stlnyc]

I've certainly messed with the format cells option in excel. But that is usually for new spreadsheets. When I open an EP file, it opens to excels default settings with the cells not formatted the way I want, and the beginning zero removed from the barcode.