EasyPopulate 4.0 Support Thread

[Kevin205]

Thank you for all you are doing.

How hard is it to add yet another field such as UPC/ISBN Product Fields to the scheme of import and export of products in EP4?

A lot of companies are using UPC along with their model number.

[chadderuski]

Thank you for all you are doing.

How hard is it to add yet another field such as UPC/ISBN Product Fields to the scheme of import and export of products in EP4?

A lot of companies are using UPC along with their model number.

Agreed. Hopefully UPC will make it into core.

You can add a field "products_upc" to the products database via phpMyAdmin. Then use the User Defined Product Fields option under Configuration > Easy Populate 4. Just add the name of the field name with no quotes or spaces. You can add multiple name separated by a comma (no spaces):

products_upc,products_price_uom

-chadd

[Kevin205]

I can't figure out what I did wrong?

I exported the "Attrib-Detailed-EP2013Mar07" file and added one line of attribute information to the following fields. I was trying to add an attribute to an existing drop down option

v_products_attributes_id ( did not place any thing here. I figured SQL will generate the ID)
v_products_id (Placed the product ID 229, identical to the existing product ID)
v_products_model (Placed the model #, identical to the existing product #)
v_options_id (placed 8 for option id, matching the existing option id/name)
v_products_options_name (placed the the option name)
v_products_options_type (placed 0 for, thinking this is used for a drop down)
v_options_values_id (added 1 to the highest number of 16 and wrote 17)
v_products_options_values_name (added a new name)
v_options_values_price (added the price)
v_options_values_price v_price_prefix (added a +)
the rest of the fields were unchanged.

The reason why you see all the below error message and not just once, is because I believe I re imported "Attrib-Detailed-EP2013Mar07" about 4 times. I did not place any IDs as I figured program will assign appropriate ids.

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND 
				products_id =  AND 
				options_id = 8 AND 
				options_values_id = 
		' at line 3
When executing:
SELECT * FROM zen_products_attributes 
				WHERE (
				products_attributes_id =  AND 
				products_id =  AND 
				options_id = 8 AND 
				options_values_id = 
				) LIMIT 1
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND 
				products_id = 229 AND 
				options_id = 8 AND 
				options_values_id = ' at line 3
When executing:
SELECT * FROM zen_products_attributes 
				WHERE (
				products_attributes_id =  AND 
				products_id = 229 AND 
				options_id = 8 AND 
				options_values_id = 
				) LIMIT 1
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND 
				products_id = 229 AND 
				options_id = 8 AND 
				options_values_id = ' at line 3
When executing:
SELECT * FROM zen_products_attributes 
				WHERE (
				products_attributes_id =  AND 
				products_id = 229 AND 
				options_id = 8 AND 
				options_values_id = 17
				) LIMIT 1

[Kevin205]

Sorry for re-post on the same issue. I had these questions and forgot to ask.

Can "Attrib-Detailed-EP***.csv" be used the same way as "Attrib-Basic-EP***.csv"?

If yes, would EP4, Zen or SQL comes up with the ID values for the following fields or you have to manually keep adding IDs in "Attrib-Detailed-EP***.csv" before the import?

v_products_attributes_id
v_products_id
v_options_values_id

Also when you get an error as above, does that mean the database tables are corrupted and they have to be reverted back to the backup set?

I know to many questions. Sorry for that. Thanks.

[Kevin205]

Sorry here is another hint.

[chadderuski]

Kevin,

The BASIC import is for ADDING attributes. The DETAIL import only modifies EXISTING attribute information.

You cannot use the DETAILED report to ADD more fields. Note that the first couple columns are actual indexes into the databases: EP finds the indexed value and updates it.

Used properly the BASIC and DETAILED sheets will let you build extremely complex attribute layout, and allow you to edit everything just like the admin.

-chadd

[Kevin205]

Getting errors as such, is the database damaged? Do you think I should go back to previous backup or not necessary?

Thank you.