View Single Post
  #12  
Old 11-12-2003, 09:16 PM
  BoomBoomBap's Avatar 
BoomBoomBap BoomBoomBap is offline
 

Senior Member
  
Join Date: Nov 2002
Location: San Francisco
Posts: 184
 

Default

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...
__________________
Site 1 > XCART LIVE 3.4.12

Site 2 > XCART LIVE 4.0.17
Reply With Quote