SQL Query Load data into column

[mike14017]

Hi

I have about 1000 items where I want to add the price offset of "1.000" and rather than do each one separately I thought it would be easier to update/insert with an SQL query

Thanks

Mike

[mc12345678]

Hi

I have about 1000 items where I want to add the price offset of "1.000" and rather than do each one separately I thought it would be easier to update/insert with an SQL query

Thanks

Mike

To increase the price offset by 1.000:
In the install sql updates window of the admn enter:

Update products_attributes set attributes_price_factor=attributes_price_factor+1 where options_values_id = 39;