Printable View
Are you looking to display and explanation for a product's attribute? For example Product Material: Plastic. The plastic part which displays text only can be set and defined by Option Name Manger>Option Type, Read Only? That displays text, for that attribute.Quote:
Originally Posted by philip937
Downloaded Easy Populate CSV
Why would this be happening?
Everything fine but when I try to Upload the EPFile the revised changes back into the admin panel I am getting a time out issue?
Sorry not sure I follow what's you've said here.Quote:
Originally Posted by Kevin205
Quote:
Originally Posted by philip937
What do you mean and what are you trying to display?
Quote:
Originally Posted by philip937
Can you confirm which version of EP you are using? This thread is for EasyPopulate 4.0 ... which shows in the title and tool pages as 'Easy Populate 4' ...Quote:
Originally Posted by haredo
Chad,
Sorry I posted in the wrong support thread ....
Hello Chad – What is the best way and what do you recommend, when it comes to merging prices for price by attributes?
When you have the following scenario:
Product A is priced by size attribute
Product Name > Size Attribute Name > Size Attribute Price
Product A > Size 1 > $5.00
Product A > Size 2 > $10.00
Product A > Size 3 > $20.00
Product A > Size 4 > $30.00
Obviously you would have to first import all attributes for different products, to table using via Basic Products Attributes (basic single-line), but how do you add / merge prices to Detailed Products Attributes (detailed multi-line) to update their corresponding prices
Is there a method that you use?
While trying to import attribute size, with values similar to 1'-8" x 3'-7", via Attrib-Basic-EP_02_Size_OO.csv, I am getting the following error. Data is prepared in Excel (.xls). I have tried both excel .csv and Open Office .csv. Both produce similar errors. Any ideas?
How else can this formatted?
How many records can be in a .csv file?
I am getting the following errors:
Quote:
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 '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
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 '" x 3'-7"',
'1')' at line 9
When executing:
INSERT INTO zen_products_options_values
(products_options_values_id,
language_id,
products_options_values_name,
products_options_values_sort_order)
VALUES (
'108',
'1',
'1'-8" x 3'-7"',
'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 '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
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 '" x 3'-7"'' at line 10
When executing:
SELECT
a.products_options_id,
a.products_options_values_id,
b.products_options_values_id,
b.products_options_values_name
FROM zen_products_options_values_to_products_options as a, zen_products_options_values as b
WHERE
a.products_options_id = '1' AND
a.products_options_values_id = b.products_options_values_id AND
b.products_options_values_name = '1'-8" x 3'-7"'
This is how it's saved:Quote:
Originally Posted by chadderuski
Field delimiter: '
Text delimiter: ""
Attachment 12438
While importing the following:
v_products_model,v_products_options_type,v_products_options_name_1,v_products_op tions_values_name_1
1-GREEN-TOM,2,Size:,"1'-8"" x 3'-7"""
1-GREEN-TOM,2,Size:,"2'-3"" x 3'-6"""
1-GREEN-TOM,2,Size:,"2'-3"" x 1'-6"""
1-GREEN-TOM,2,Size:,"3'-11"" x 3'-7"""
1-GREEN-TOM,2,Size:,"1'-3"" x 3'-6"""
1-GREEN-TOM,2,Size:,"4'-7"" x 2'-6"""
1-GREEN-TOM,2,Size:,"3'-10"" x 3'-10"""
1-GREEN-TOM,2,Size:,"3'-6"" x 2'"
I am getting also getting the following warning right after the import on top of the admin page.
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
I look at it the .csv file with "Notepad++", and there are no tabs in the file / records.Quote:
Finished Processing Import File
Updated records: 6
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 2855256
Memory Peak: 2911048
Execution Time: 0.1918740272522 seconds.