EasyPopulate 4.0 Support Thread

hockey2112:

I just updated to the latest version listed above, and my product info is no longer being added to my site. The file uploads fine, and then when I click "Import" next to the file it gives me the "File Import Completed" message, but no products are added to my catalog. Any idea what would cause this?

The only major change I made recently was the installation of my SSL.

--EDIT--
I'm an idiot. It had to do with the file name of the CSV file. I removed the spaces and the & and it now works.

A separate issue... I have Product Category ! and 2 filled out for a few products that should be listed in a subcategory, but all of those products are just getting lumped into the primary category. Any idea what might fix that?

Looks like I was doing the categories the "old" way. They now seem to be working fine when I use a single category column with a "^" between the category names.

Another issue... the products that I just uploaded using the latest EP were now showing "Min: 0 Units: 0" on the product pages and on the category pages. This does not show up on my other products that I had previously added to the site. When I add one of those new products to my cart, it gives me a "Quantity Units errors" message and I cannot proceed.

I had my Product Layout set to not display the amount in stock. I have each product set to Product Qty Minimum: 1 / Product Qty Maximum: 0 / Product Qty Units: 1, and have confirmed that the new products are set up exactly like the old ones. Every one of my products has "1000" in the Products Quantity field.

I downloaded a full EP and it shows that the units and minimum were set to "0", even though they were showing up as 1 and 1 in my zen cart back-end. I changed them all to 1, re-imported, and the issue is resolved.

hockey2112:

A separate issue... I have Product Category ! and 2 filled out for a few products that should be listed in a subcategory, but all of those products are just getting lumped into the primary category. Any idea what might fix that?

Please attach some data... you more than likely have the category specified wrong.

If you have mixed products and categories on the same level, you will need to fix this first, then run Tools > Store Manager "Reset ALL Products Master Categories ID" to be sure you don't have something wrong here.

Also. If you are not making backups with Dr. Byte's MySQL Backup tool prior to importing data, you have no way to easily roll back when something goes wrong. Please see Post #1 in this thread.

-chadd

Hi chadderuski,

I followed your guideline, but the option name and option values do not display. Do you have any other tips?

Thanks for your support and help.

John

chadderuski:

Please try this: Describe in plain English the attribute and attribute values that you want to assign to one product. Note that the product must already exist in your database.

For example: "I have a product widget that I want to assign the attribute Color with values red,green,blue as a dropdown box"

Then your CSV will look like:

hope this helps

John,

Are you following the mandatory naming convention for attribute importing? The basic file must start with "Attrib-Basic-EP" and the detailed with "Attrib-Detailed-EP" (with no quotes in the name).

If you don't use these, the script doesn't know how to handle the file.

Also, if you attach a portion of your basic file that would help.

chadderuski:

John,

Are you following the mandatory naming convention for attribute importing? The basic file must start with "Attrib-Basic-EP" and the detailed with "Attrib-Detailed-EP" (with no quotes in the name).

If you don't use these, the script doesn't know how to handle the file.

Also, if you attach a portion of your basic file that would help.

Yes, I do follow the mandatory naming convention for attribute importing. I tried to attach the file, but I could not upload it. Therefore, I use this link directly from my web folder. Please take a look at it and give me your advice. Thanks so much.

http://theladystuff.com/temp/test.csv

John

johnn196703:

Yes, I do follow the mandatory naming convention for attribute importing. I tried to attach the file, but I could not upload it. Therefore, I use this link directly from my web folder. Please take a look at it and give me your advice. Thanks so much.

http://theladystuff.com/temp/test.csv

John

John,

What name did you give the file? Also, you are attempting to load more columns that the BASIC allows. Please see my example above.

After you load the basic attributes, you can export the detail sheet to modify any of the settings.

-chadd

My sister is our spreadsheet-queen and her results, and from what little I've done myself, show that the basic attributes are working out just fine! So far, so good. And possibly the easiest, simplest attribute importer of all easy populates over the years.

chadderuski:

John,

What name did you give the file? Also, you are attempting to load more columns that the BASIC allows. Please see my example above.

After you load the basic attributes, you can export the detail sheet to modify any of the settings.

-chadd

Hi Chadd,

If I upload the BASIC attributes and import them, I saw the message "None of your products imported, "Skipped All""

v_products_model, v_products_options_type, v_products_options_name_1, v_products_options_values_name_1

Please give me more tips. Thanks!

John

johnn196703:

Hi Chadd,
If I upload the BASIC attributes and import them, I saw the message "None of your products imported, "Skipped All""
v_products_model, v_products_options_type, v_products_options_name_1, v_products_options_values_name_1
Please give me more tips. Thanks!
John

John, I'd like to help, but I'm not getting enough information. Please send me a PM with a location of your original CSV file... the one you clicking "Import" on.

Also, you did FIRST import the products to create them? Attributes can only be assigned to Existing products.

-chadd

Hi

Sorry for my english, i'm spanish and write bad
Please, I need help with typical spanish symbols. When I import a CSV file, if exist spanish symbol in the descriptions, then cut the description.
Example: To import "Pequeño horno eléctrico" in the BD only appears "Peque", because the next character only exist in spanish.
I don't know solve it
Thanks, regards

badaboomtech:

Hi
Sorry for my english, i'm spanish and write bad
Please, I need help with typical spanish symbols. When I import a CSV file, if exist spanish symbol in the descriptions, then cut the description.
Example: To import "Pequeño horno eléctrico" in the BD only appears "Peque", because the next character only exist in spanish.
I don't know solve it
Thanks, regards

Hey!
Couple of questions... which version of zencart? which version of EP4? Are you using UTF-8 characters? If so, are your databases set to UTF-8?

Would appreciate it if you could PM me and send a link of the file you are importing. So far from my testing, I have not had any trouble with spanish.

-chadd

i'm so sorry,, but somehow i dont get it and im affraid it the fault of my mac. ( lets hope it is just that)
i get over and over:No model field in record. This line was not imported
No model field in record. This line was not imported
when copieeng back the file i downloaded and added 12 products to..
but yes i DO have product/model

v_products_model" "v_products_type" "v_products_image" "v_products_name_2" "v_products_description_2" "v_products_url_2" "v_products_name_1" "v_products_description_1" "v_products_url_1" "v_products_name_3" "v_products_description_3" "v_products_url_3" "v_products_name_4" "v_products_description_4" "v_products_url_4" "v_specials_price" "v_specials_date_avail" "v_specials_expires_date" "v_products_price" "v_products_weight" "v_product_is_call" "v_products_sort_order" "v_products_quantity_order_min" "v_products_quantity_order_units" "v_products_priced_by_attribute" "v_product_is_always_free_shipping" "v_date_avail" "v_date_added" "v_products_quantity" "v_manufacturers_name" "v_categories_name_2" "v_categories_name_1" "v_categories_name_3" "v_categories_name_4" "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_2" "v_metatags_keywords_2" "v_metatags_description_2" "v_metatags_title_1" "v_metatags_keywords_1" "v_metatags_description_1" "v_metatags_title_3" "v_metatags_keywords_3" "v_metatags_description_3" "v_metatags_title_4" "v_metatags_keywords_4" "v_metatags_description_4"
"AIR1001" "1" "air/qrcode.wit.png" " 100 ML Snowwhite" "<p> <span id=""result_box"" lang=""nl""> etc.....

i don''t get it to be honest....

kernheimer:

i'm so sorry,, but somehow i dont get it and im affraid it the fault of my mac. ( lets hope it is just that)
i get over and over:No model field in record. This line was not imported
No model field in record. This line was not imported
when copieeng back the file i downloaded and added 12 products to..
but yes i DO have product/model

v_products_model" "v_products_type" "v_products_image" "v_products_name_2" "v_products_description_2" "v_products_url_2" "v_products_name_1" "v_products_description_1" "v_products_url_1" "v_products_name_3" "v_products_description_3" "v_products_url_3" "v_products_name_4" "v_products_description_4" "v_products_url_4" "v_specials_price" "v_specials_date_avail" "v_specials_expires_date" "v_products_price" "v_products_weight" "v_product_is_call" "v_products_sort_order" "v_products_quantity_order_min" "v_products_quantity_order_units" "v_products_priced_by_attribute" "v_product_is_always_free_shipping" "v_date_avail" "v_date_added" "v_products_quantity" "v_manufacturers_name" "v_categories_name_2" "v_categories_name_1" "v_categories_name_3" "v_categories_name_4" "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_2" "v_metatags_keywords_2" "v_metatags_description_2" "v_metatags_title_1" "v_metatags_keywords_1" "v_metatags_description_1" "v_metatags_title_3" "v_metatags_keywords_3" "v_metatags_description_3" "v_metatags_title_4" "v_metatags_keywords_4" "v_metatags_description_4"
"AIR1001" "1" "air/qrcode.wit.png" " 100 ML Snowwhite" "<p> <span id=""result_box"" lang=""nl""> etc.....

i don''t get it to be honest....

How many languages do you have installed?

Your file doesn't look correct. Simplify things by going into Configuration -> Easy Populate 4 and set "Enable Products Meta Data" to False (0).

And I need a section of that entire file. Patching in the forum without attaching the file doesn't help at all. For all I know, you left off category names, or
you did category names wrong for multilingual sites. If you don't want to attached a file to the forum, send me a PM with a link to a file somewhere.

I'll not be able to help you otherwise. There are just too many variables!

Chadd

PS: Just so you know, I'm also on a Mac :p

Chad,

We installed Easy Populate 4.0.19 - Beta 1-28-2012 first. Later we installed Numinix version of Google Feeder. The Google Feeder added the UPC, ISBN, EAN, ASIN, Wholesale Price, MSRP Price, and Condition to the product database. When I added v_products_upc to my excel spreadsheet it does not add the UPC code to my product. I'm just trying to see if I can get one product to update before trying my entire inventory. Does the install of easy populate have to occur after the Google Feeder? If not, How do I get the UPC code to add to the database?

Thanks,
Kevin

sw1138lr:

Chad,

We installed Easy Populate 4.0.19 - Beta 1-28-2012 first. Later we installed Numinix version of Google Feeder. The Google Feeder added the UPC, ISBN, EAN, ASIN, Wholesale Price, MSRP Price, and Condition to the product database. When I added v_products_upc to my excel spreadsheet it does not add the UPC code to my product. I'm just trying to see if I can get one product to update before trying my entire inventory. Does the install of easy populate have to occur after the Google Feeder? If not, How do I get the UPC code to add to the database?

Thanks,
Kevin

Hi Kevin,

Update to the latest version of EP 4.0.22 - Beta 6-10-2012 now at github. I added support for User Defined Products Fields. You'll be able to add your field names in the configuration sections, then export/import with the appropriate column headers.

-chadd

Thanks Chadd,

We installed the new version EP 4.0.22 - But the Admin "Easy Populate 4" does not show any new fields. According to what I read it should have a new field with true and false. I also updated by spreadsheet with the column name of v_products_upc - no success. So I changed it to products_upc - no success. On the Tools menu - it does show TRUE next to UPC. Did we install something wrong?

Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: TRUE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: TRUE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE

Just to let you know I've used easy populate to upload over 6,000 products with success. I just can't get the UPC to upload.

Chadd,

We fixed the issue with the UPC - one of the directories didn't get uploaded to the site.

I was under the impression the ADMIN was also suppose change. I don't see any additional options listed in the ADMIN. Can you help with this?

Uploads Directory EPUploads/
Upload File Date Format m-d-y
Default Raw Time 09:00:00
Upload/Download Prices Include Tax false
Verbose Feedback true
Make Zero Qty Products Inactive false
Smart Tags Replacement of Newlines true
Advanced Smart Tags false
Debug Logging true
Maximum Quantity Discounts 3
Split On Number of Records 8000
Script Execution Time 60
Convert Curly Quotes, etc. 0

Thanks
Kevin

sw1138lr:

Thanks Chadd,

We installed the new version EP 4.0.22 - But the Admin "Easy Populate 4" does not show any new fields. According to what I read it should have a new field with true and false. I also updated by spreadsheet with the column name of v_products_upc - no success. So I changed it to products_upc - no success. On the Tools menu - it does show TRUE next to UPC. Did we install something wrong?

Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: TRUE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: TRUE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE

Just to let you know I've used easy populate to upload over 6,000 products with success. I just can't get the UPC to upload.

You need to go to Tools -> Easy Populate 4 and click Un-Install, then click Install again to load the new configuration variables...

Chadd,

That fixed my issue.

Thanks for helping me.
Kevin

sw1138lr:

Chadd,

That fixed my issue.

Thanks for helping me.
Kevin

Glad to help!