Printable View
And also following is the result from the upload.
Import Results
.
.
.
UPDATED! - Model: 50165 | 5 | Color | Pink |
.
.
.
Finished processing the the import file
Updated records: 13
New Imported records: 0
Errors Detected: 0
Warnings Detected:0
.
.
.
I think I found out where the problem started from.
After reading the "attribute_types.txt" in the mod, I realized I had changed the name of the csv file to "test.csv".
In the read me, it is stated that Basic Attribute Import file name must begin with "Attrib-Basic-EP" plus any other text you want
As soon as I changed the file name it updated the attribute.
NEW ATTRIBUTE! - Model: 50165, Option: Color, Values: Pink
Questions:
Was this the only thing I did wrong?
Does this rule apply to all other imports for EP4?
Kevin: You should be on the right track now. Some imports have file naming conventions because they act as switches to what the import script does.
This applies to category, attribute and pricing sheets. I have not yet put a restriction on the full sheet, but that may come...
Thank you for all you are doing.
How hard is it to add yet another field such as UPC/ISBN, to the scheme of import and export of products in EP4?
A lot companies are using UPC along with their model number.
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.Quote:
Originally Posted by Kevin205
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
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.
Code: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
Sorry for re-post on the same issue. I had these questions and forgot to ask. :D
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.
Sorry here is another hint.
Attachment 12102
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