I tried this - the install was no problem (thanks for the detailed howto) but the SQL code seems to be missing the product id.
Here's the output:
Code:
SELECT count(*) FROM xcart_product_options WHERE productid='' AND optclass='Color'
UPDATE xcart_product_options SET optclass='Color', opttext='Color', options='Black\r\nRed\r\nRoyal Blue' WHERE productid=''
My csv file:
Code:
1, Color, Black\r\nRed\r\nRoyal Blue
I also tried with semicolons but to no avail...