EasyPopulate 4.0 Support Thread

Razzinator:

I can download "Full" and turn right around and import it back. But if I open with Calc and save file unedited I get this error msg.

No model field in record. This line was not imported

When you first save a CSV in Open Office, you have to do a SAVE AS, Select TEXT CSV, and be sure to CHECK "Edit filter Settings"....

Click Keep Current Format, Set your Field Delimiter to the COMMA, and Text Delimiter to DOUBLE QUOTE

I believe the defaults are TAB, which is why your import failed.

When the SQL mode was set to strict. There would have a SQL error --> "Incorrect integer value". In most case, the database setting is out of our control. So, suggest chadderuski to modify the code.

su35:

When the SQL mode was set to strict. There would have a SQL error --> "Incorrect integer value". In most case, the database setting is out of our control. So, suggest chadderuski to modify the code.

Su35,

Thanks for the feed back. But could you elaborate more and perhaps give a specific example of this problem?

Thanks,
chadd

version: Easy Populate 4.0.22 - Beta 6-10-2012

if sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" (my.ini)
on the EP4 working page, export a completed products file, and then import it. you will get a error message in the log file as
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
.....
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
....
I think the problem is that some default values for integer had not been set correctly(have not been set, set to empty...).

if sql-mode=
everything is OK.

su35:

version: Easy Populate 4.0.22 - Beta 6-10-2012

if sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" (my.ini)
on the EP4 working page, export a completed products file, and then import it. you will get a error message in the log file as
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
.....
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
....
I think the problem is that some default values for integer had not been set correctly(have not been set, set to empty...).

if sql-mode=
everything is OK.

I've seen something similar to this with IIS ... didsn't know it was because sql mode was strict.

Thanks.

-chadd

Could you set the default values in the code?

su35:

Could you set the default values in the code?

Next release will address this issue.

chadderuski,

Why isn't this in the plugins area??

kobra:

chadderuski,

Why isn't this in the plugins area??

Hey Kobra,

Actually, I'm in the process of putting everything together now, creating a detailed readme file, and some additional work on the code. Hopefully I can submit this within a couple weeks.

-chadd

Just wondering....

Zen cart v1.5.1
Easy Populate 4.0.22 - Beta 6-10-2012

I understand the Model Number, but is there a way to add the "SKU" so that appears not only on the product listing, but within EP and the invoice? I realize there will be template edits... any point in the right direction Gurus?

Thanks for your help,
Chad

Hello, I can change the delimiter "between fields.
I'm having trouble with my management.
thanks

ChadAustin:

Zen cart v1.5.1
Easy Populate 4.0.22 - Beta 6-10-2012

I understand the Model Number, but is there a way to add the "SKU" so that appears not only on the product listing, but within EP and the invoice? I realize there will be template edits... any point in the right direction Gurus?

Thanks for your help,
Chad

Hey ChadAustin,

Not sure what you mean by sku. Zencart has a products_id (internal key) and products_model ... most people would consider that the SKU... perhaps you mean UPC?

-chadd

brancasalvo:

Hello, I can change the delimiter "between fields.
I'm having trouble with my management.
thanks

Bran,

Please read the documentation over, and the first several posts in this thread. That should get you going.

-chadd

When I first installed ZenCart, I loaded the sample data. I would like to get rid of all that data so I have a clean start for Easy Populate 4.0. I opened up phpMyAdmin and looked at each table to see which ones I think I need to clear out. Here's the list I came up with:> zencart_categories

zencart_categories_description
zencart_customers
zencart_customers_info
zencart_group_pricing
zencart_manufacturers
zencart_manufacturers_info
zencart_media_clips
zencart_media_manager
zencart_media_to_products
zencart_media_types
zencart_meta_tags_categories_description
zencart_meta_tags_products_description
zencart_music_genre
zencart_products
zencart_products_attributes
zencart_products_attributes_download
zencart_products_description
zencart_products_discount_quantity
zencart_products_options
zencart_products_options_values
zencart_products_options_values_to_products_options
zencart_products_to_categories
zencart_product_music_extra
zencart_product_types
zencart_product_types_to_category
zencart_record_artists
zencart_record_artists_info
zencart_record_company
zencart_record_company_info
zencart_reviews
zencart_reviews_description
zencart_salemaker_sales
zencart_specialsAre there any tables in there that I don't need to empty and are there any that aren't in the list that I do need to empty. I don't really want to run zc_install because I've also installed a few modules that have database entries, in particular localSalesTaxMod2.5.2.

I wish this information was included in the readme for the module. I'm sure I'm not the only one who has struggled with this and the thread is so long that it's really hard to find answers to these type questions.

Thanks,
Alisa

Easy Populate is a great module and if I could just figure out how to use it, would make my life a lot easier. I have some programming background, but am used to being the one laying out the fields and deciding what values go in which fields and what the value options are. I see fields with 0 or 1 or 2 in it and I don't know what those values mean. The only field that is clearly explained is the v_products_option_type in Attrib-Basic-EP and Attrib-Detailed-EP.

I've spent the last 2 days trying to figure out which .csv file are needed to add categories & products & meta data to my site and what each field means in each csv file. I finally figured out where the files from my current site were late yesterday [ Tools > Easy Populate 4 ], but am having trouble making sense of them. Is there any documentation to tell me how to set these files up to load product data the way it needs to be loaded?

I wish this information was included in the readme for the module. The only thing I found was an explanation on how to set up Attrib-Basic-EP. The attributes for my products are a little complicated, so I think I will need to use the Attrib-Detailed-EP file, but here again, are both used or one or the other? Also, not sure how to set up any of the other files. Also, I have 2 options that increase the price of an item. Not sure how to make that happen.

here's the list of files I think I need to modify for Easy Populate 4.0:> Attrib-Basic-EP

Attrib-Detailed-EP
Category-EP
CategoryMeta-EP
Featured-EP
FULL-EP
Options-EP
OptVals-EP
PriceBreaks-EP
PriceQty-EP
Values-EPI'm sure I'm not the only one who has struggled with this and the thread is so long that it's really hard to find answers to these type questions.

Thanks,
Alisa

I am using Zen 1.5.1 and installed Easy Populate 4.0 v1.2.5.7. When I click on the Easy Populate under the tools menu I get the following error.

1 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances.

When i click on clicking here i get the error below

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

I get the error regardless of using empty files or after i add a product.

Does anyone have any idea for fixing the error?

jodean:

I am using Zen 1.5.1 and installed Easy Populate 4.0 v1.2.5.7. When I click on the Easy Populate under the tools menu I get the following error.

1 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances.

When i click on clicking here i get the error below

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

I get the error regardless of using empty files or after i add a product.

Does anyone have any idea for fixing the error?

You have the wrong version (it's not EP 4.0) ... this thread is for my version currently only on github:

https://github.com/chaddro/EasyPopulate-4.0

-chadd

This is an awesome contribution bro. Awesome work. Question though....

First I am creating a site and my suppliers are all drop shippers. All the cvs/xls files I'm getting are different, ie names, descriptions, ext ext. I am an amature coder, I created a PHP (page really) that takes the file and edits the fields to create the columns I want. For example the one suppliers cvs file had 4 columns that I needed into 1. Only one column had <HTML> tags so I had to move the data where I wanted it with in the Description and add the <HTML> tags I wanted, lastly save the file as a CVS.

I downloaded the complete products list from my site using Easy Populate. Deleted all the data. Then C&P'ed all the data into the respective fields. Uplaoded it. (after a little messing around) it worked great.

My question for you is: My next step will be to have my custom PHP page create the appropriate cvs file that will upload into Easy Populate in order to update or add new products. What are the fileds I need for sure? Ones I leave out will they get the default value in the database??

Thanks

Trying to import Attributes via the Basic Products Attributes (basic single-line).
Started with:

Revised and added the following record to the excel sheet
v_products_model
50165
v_products_options_type
5
v_products_options_name_1
Color
v_products_options_values_name_1 Pink

When I imported the csv file, not only Color Pink was not attached to Product Model 50165, color Pink was not added as an "Option Values".

What did I do wrong? How else would you add the attributes via EP4?