Product Sync.
Opencart products: 344
Input products: 100
UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 26999
Image file:
UPDATING: Tinta Acrílica Talens Van Gogh 40 ml
Product ID: 27108
Image file: Tinta Acrílica Talens Van Gogh 40 ml.jpg
NEW: 479806699
NEW: 479806799
NEW: 479806899
NEW: 479806999
NEW: 479807099
NEW: 479807199
NEW: 479807399
NEW: 479807599
NEW: 479807699
NEW: 479808299
NEW: 479808499
NEW: 479808599
NEW: 479808699
NEW: 479808799
NEW: 479808899
NEW: 479808999
NEW: 479809599
NEW: 479809799
NEW: 479809899
NEW: 479809999
UPDATING: Tinta Acrílica Winsor & Newton 60 ml
Product ID: 27009
Image file:
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27027
Image file:
UPDATING: Tinta Acrílica Winsor & Newton 500 ml
Product ID: 27065
Image file:
UPDATING: Tinta da China Winsor & Newton
Product ID: 27049
Image file:
Ok.
Product Option Sync.
Opencart products: 344
Input products: 100
SELECT option_id FROM oc_option_description
WHERE
NAME = 'Opção'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 26999
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479802699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479802699.jpg'
WHERE
option_value_id = 1213
UPDATE oc_option_value_description
SET
name = '479802699 - Acrílico Amsterdam 120 ml Amarelo Aço Claro 268'
WHERE
option_value_id = 1213
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1213
DELETE FROM oc_product
WHERE
model = '479802699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1213
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479803499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479803499.jpg'
WHERE
option_value_id = 1214
UPDATE oc_option_value_description
SET
name = '479803499 - Acrílico Amsterdam 120 ml Vermelho Naftol Escuro 399'
WHERE
option_value_id = 1214
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1214
DELETE FROM oc_product
WHERE
model = '479803499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1214
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479804399.jpg'
WHERE
option_value_id = 1215
UPDATE oc_option_value_description
SET
name = '479804399 - Acrílico Amsterdam 120 ml Azul Prussia Ftalo 566'
WHERE
option_value_id = 1215
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1215
DELETE FROM oc_product
WHERE
model = '479804399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1215
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479804499.jpg'
WHERE
option_value_id = 1216
UPDATE oc_option_value_description
SET
name = '479804499 - Acrílico Amsterdam 120 ml Azul Ftalo Primario 570'
WHERE
option_value_id = 1216
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1216
DELETE FROM oc_product
WHERE
model = '479804499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1216
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479804599.jpg'
WHERE
option_value_id = 1217
UPDATE oc_option_value_description
SET
name = '479804599 - Acrílico Amsterdam 120 ml Verde Amarelado 617'
WHERE
option_value_id = 1217
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1217
DELETE FROM oc_product
WHERE
model = '479804599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1217
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804799 - %'
UPDATE oc_option_value
SET
image = 'catalog/479804799.jpg'
WHERE
option_value_id = 1218
UPDATE oc_option_value_description
SET
name = '479804799 - Acrílico Amsterdam 120 ml Prata Metal 800'
WHERE
option_value_id = 1218
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1218
DELETE FROM oc_product
WHERE
model = '479804799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1218
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1219
UPDATE oc_option_value_description
SET
name = '479804899 - Acrílico Amsterdam 120 ml Ouro Claro Metal 802'
WHERE
option_value_id = 1219
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1219
DELETE FROM oc_product
WHERE
model = '479804899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1219
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1220
UPDATE oc_option_value_description
SET
name = '479804999 - Acrílico Amsterdam 120 ml Ouro Escuro Metal 803'
WHERE
option_value_id = 1220
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1220
DELETE FROM oc_product
WHERE
model = '479804999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1220
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27108
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479806599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479806599.jpg'
WHERE
option_value_id = 1221
UPDATE oc_option_value_description
SET
name = '479806599 - Acrílico Van Gogh T9 - 40 ml Branco Titânio'
WHERE
option_value_id = 1221
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1221
DELETE FROM oc_product
WHERE
model = '479806599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1221
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833399.jpg'
WHERE
option_value_id = 1222
UPDATE oc_option_value_description
SET
name = '479833399 - Acrílico Van Gogh T9 - 40 ml Amarelo Napoles Escuro'
WHERE
option_value_id = 1222
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1222
DELETE FROM oc_product
WHERE
model = '479833399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1222
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833499.jpg'
WHERE
option_value_id = 1223
UPDATE oc_option_value_description
SET
name = '479833499 - Acrílico Van Gogh T9 - 40 ml Amarelo Nápoles Avermelhado'
WHERE
option_value_id = 1223
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1223
DELETE FROM oc_product
WHERE
model = '479833499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1223
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833599.jpg'
WHERE
option_value_id = 1224
UPDATE oc_option_value_description
SET
name = '479833599 - Acrílico Van Gogh T9 - 40 ml Amarelo Ocre'
WHERE
option_value_id = 1224
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1224
DELETE FROM oc_product
WHERE
model = '479833599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1224
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833699.jpg'
WHERE
option_value_id = 1225
UPDATE oc_option_value_description
SET
name = '479833699 - Acrílico Van Gogh T9 - 40 ml Amarelo Ocre Claro'
WHERE
option_value_id = 1225
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1225
DELETE FROM oc_product
WHERE
model = '479833699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1225
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833799 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833799.jpg'
WHERE
option_value_id = 1226
UPDATE oc_option_value_description
SET
name = '479833799 - Acrílico Van Gogh T9 - 40 ml Terra Siena Natural'
WHERE
option_value_id = 1226
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1226
DELETE FROM oc_product
WHERE
model = '479833799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1226
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833899 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833899.jpg'
WHERE
option_value_id = 1227
UPDATE oc_option_value_description
SET
name = '479833899 - Acrílico Van Gogh T9 - 40 ml Amarelo Azo Limão'
WHERE
option_value_id = 1227
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1227
DELETE FROM oc_product
WHERE
model = '479833899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1227
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479833999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479833999.jpg'
WHERE
option_value_id = 1228
UPDATE oc_option_value_description
SET
name = '479833999 - Acrílico Van Gogh T9 - 40 ml Amarelo Azo Claro'
WHERE
option_value_id = 1228
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1228
DELETE FROM oc_product
WHERE
model = '479833999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1228
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834099 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834099.jpg'
WHERE
option_value_id = 1229
UPDATE oc_option_value_description
SET
name = '479834099 - Acrílico Van Gogh T9 - 40 ml Amarelo Azo Médio'
WHERE
option_value_id = 1229
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1229
DELETE FROM oc_product
WHERE
model = '479834099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1229
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834199.jpg'
WHERE
option_value_id = 1230
UPDATE oc_option_value_description
SET
name = '479834199 - Acrílico Van Gogh T9 - 40 ml Amarelo Azo Escuro'
WHERE
option_value_id = 1230
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1230
DELETE FROM oc_product
WHERE
model = '479834199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1230
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834299.jpg'
WHERE
option_value_id = 1231
UPDATE oc_option_value_description
SET
name = '479834299 - Acrílico Van Gogh T9 - 40 ml Laranja Azo'
WHERE
option_value_id = 1231
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1231
DELETE FROM oc_product
WHERE
model = '479834299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1231
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834399.jpg'
WHERE
option_value_id = 1232
UPDATE oc_option_value_description
SET
name = '479834399 - Acrílico Van Gogh T9 - 40 ml Vermelhão'
WHERE
option_value_id = 1232
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1232
DELETE FROM oc_product
WHERE
model = '479834399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1232
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834499.jpg'
WHERE
option_value_id = 1233
UPDATE oc_option_value_description
SET
name = '479834499 - Acrílico Van Gogh T9 - 40 ml Carmim'
WHERE
option_value_id = 1233
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1233
DELETE FROM oc_product
WHERE
model = '479834499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1233
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834599.jpg'
WHERE
option_value_id = 1234
UPDATE oc_option_value_description
SET
name = '479834599 - Acrílico Van Gogh T9 - 40 ml Carmim Escuro'
WHERE
option_value_id = 1234
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1234
DELETE FROM oc_product
WHERE
model = '479834599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1234
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834699.jpg'
WHERE
option_value_id = 1235
UPDATE oc_option_value_description
SET
name = '479834699 - Acrílico Van Gogh T9 - 40 ml Permanent Madder Lake'
WHERE
option_value_id = 1235
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1235
DELETE FROM oc_product
WHERE
model = '479834699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1235
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1236
UPDATE oc_option_value_description
SET
name = '479834799 - Acrílico Van Gogh T9 - 40 ml Vermelho Inglés'
WHERE
option_value_id = 1236
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1236
DELETE FROM oc_product
WHERE
model = '479834799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1236
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834899 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834899.jpg'
WHERE
option_value_id = 1237
UPDATE oc_option_value_description
SET
name = '479834899 - Acrílico Van Gogh T9 - 40 ml Rosa Quinacridona'
WHERE
option_value_id = 1237
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1237
DELETE FROM oc_product
WHERE
model = '479834899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1237
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479834999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479834999.jpg'
WHERE
option_value_id = 1238
UPDATE oc_option_value_description
SET
name = '479834999 - Acrílico Van Gogh T9 - 40 ml Vermelho Naphtol Médio'
WHERE
option_value_id = 1238
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1238
DELETE FROM oc_product
WHERE
model = '479834999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1238
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835099 - %'
UPDATE oc_option_value
SET
image = 'catalog/479835099.jpg'
WHERE
option_value_id = 1239
UPDATE oc_option_value_description
SET
name = '479835099 - Acrílico Van Gogh T9 - 40 ml Vermelho Naphtol Claro'
WHERE
option_value_id = 1239
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1239
DELETE FROM oc_product
WHERE
model = '479835099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1239
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479835199.jpg'
WHERE
option_value_id = 1240
UPDATE oc_option_value_description
SET
name = '479835199 - Acrílico Van Gogh T9 - 40 ml Castanho Van Dyke'
WHERE
option_value_id = 1240
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1240
DELETE FROM oc_product
WHERE
model = '479835199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1240
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479835299.jpg'
WHERE
option_value_id = 1241
UPDATE oc_option_value_description
SET
name = '479835299 - Acrílico Van Gogh T9 - 40 ml Terra Sombra Natural'
WHERE
option_value_id = 1241
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1241
DELETE FROM oc_product
WHERE
model = '479835299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1241
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479835399.jpg'
WHERE
option_value_id = 1242
UPDATE oc_option_value_description
SET
name = '479835399 - Acrílico Van Gogh T9 - 40 ml Terra Sombra Queimada'
WHERE
option_value_id = 1242
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1242
DELETE FROM oc_product
WHERE
model = '479835399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1242
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479835499.jpg'
WHERE
option_value_id = 1243
UPDATE oc_option_value_description
SET
name = '479835499 - Acrílico Van Gogh T9 - 40 ml Terra Sienna Queimada'
WHERE
option_value_id = 1243
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1243
DELETE FROM oc_product
WHERE
model = '479835499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1243
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479835599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479835599.jpg'
WHERE
option_value_id = 1244
UPDATE oc_option_value_description
SET
name = '479835599 - Acrílico Van Gogh T9 - 40 ml Ultramarino'
WHERE
option_value_id = 1244
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1244
DELETE FROM oc_product
WHERE
model = '479835599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 165
AND product_id = 27108
AND option_id = 15
AND option_value_id = 1244
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810199.jpg'
WHERE
option_value_id = 1047
UPDATE oc_option_value_description
SET
name = '479810199 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Cádmio Pálido Hue'
WHERE
option_value_id = 1047
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1047
DELETE FROM oc_product
WHERE
model = '479810199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1047,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810299.jpg'
WHERE
option_value_id = 1048
UPDATE oc_option_value_description
SET
name = '479810299 - Acrílico Winsor & Newton Galeria 60 ml Vermelho Cádmio Hue'
WHERE
option_value_id = 1048
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1048
DELETE FROM oc_product
WHERE
model = '479810299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1048,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810399.jpg'
WHERE
option_value_id = 1049
UPDATE oc_option_value_description
SET
name = '479810399 - Acrílico Winsor & Newton Galeria 60 ml Laranja Cádmio Hue'
WHERE
option_value_id = 1049
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1049
DELETE FROM oc_product
WHERE
model = '479810399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1049,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810499.jpg'
WHERE
option_value_id = 1050
UPDATE oc_option_value_description
SET
name = '479810499 - Acrílico Winsor & Newton Galeria 60 ml Terra Sombra Queimada'
WHERE
option_value_id = 1050
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1050
DELETE FROM oc_product
WHERE
model = '479810499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1050,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810599.jpg'
WHERE
option_value_id = 1051
UPDATE oc_option_value_description
SET
name = '479810599 - Acrílico Winsor & Newton Galeria 60 ml Terra Siena Queimada'
WHERE
option_value_id = 1051
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1051
DELETE FROM oc_product
WHERE
model = '479810599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1051,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810699.jpg'
WHERE
option_value_id = 1052
UPDATE oc_option_value_description
SET
name = '479810699 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Limão'
WHERE
option_value_id = 1052
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1052
DELETE FROM oc_product
WHERE
model = '479810699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1052,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810799 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810799.jpg'
WHERE
option_value_id = 1053
UPDATE oc_option_value_description
SET
name = '479810799 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Processo'
WHERE
option_value_id = 1053
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1053
DELETE FROM oc_product
WHERE
model = '479810799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1053,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810899 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810899.jpg'
WHERE
option_value_id = 1054
UPDATE oc_option_value_description
SET
name = '479810899 - Acrílico Winsor & Newton Galeria 60 ml Azul Cobalto HUE'
WHERE
option_value_id = 1054
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1054
DELETE FROM oc_product
WHERE
model = '479810899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1054,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479810999.jpg'
WHERE
option_value_id = 1055
UPDATE oc_option_value_description
SET
name = '479810999 - Acrílico Winsor & Newton Galeria 60 ml Azul Ceruleo HUE'
WHERE
option_value_id = 1055
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1055
DELETE FROM oc_product
WHERE
model = '479810999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1055,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811099 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811099.jpg'
WHERE
option_value_id = 1056
UPDATE oc_option_value_description
SET
name = '479811099 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Cádmino Médio Hue'
WHERE
option_value_id = 1056
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1056
DELETE FROM oc_product
WHERE
model = '479811099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1056,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811199.jpg'
WHERE
option_value_id = 1057
UPDATE oc_option_value_description
SET
name = '479811199 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Cádmio Escuro Hue'
WHERE
option_value_id = 1057
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1057
DELETE FROM oc_product
WHERE
model = '479811199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1057,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1078
UPDATE oc_option_value_description
SET
name = '479811299 - Acrílico Winsor & Newton Galeria 60 ml Azul Primário'
WHERE
option_value_id = 1078
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1078
DELETE FROM oc_product
WHERE
model = '479811299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1078,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811399.jpg'
WHERE
option_value_id = 1079
UPDATE oc_option_value_description
SET
name = '479811399 - Acrílico Winsor & Newton Galeria 60 ml Magenta Processo'
WHERE
option_value_id = 1079
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1079
DELETE FROM oc_product
WHERE
model = '479811399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1079,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811499.jpg'
WHERE
option_value_id = 1080
UPDATE oc_option_value_description
SET
name = '479811499 - Acrílico Winsor & Newton Galeria 60 ml Vede Phtalo'
WHERE
option_value_id = 1080
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1080
DELETE FROM oc_product
WHERE
model = '479811499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1080,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811599.jpg'
WHERE
option_value_id = 2127
UPDATE oc_option_value_description
SET
name = '479811599 - Acrílico Winsor & Newton Galeria 60 ml Amarelo de Napoles'
WHERE
option_value_id = 2127
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2127
DELETE FROM oc_product
WHERE
model = '479811599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2127,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811699.jpg'
WHERE
option_value_id = 1081
UPDATE oc_option_value_description
SET
name = '479811699 - Acrílico Winsor & Newton Galeria 60 ml Preto Marfim'
WHERE
option_value_id = 1081
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1081
DELETE FROM oc_product
WHERE
model = '479811699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1081,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811899 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811899.jpg'
WHERE
option_value_id = 1082
UPDATE oc_option_value_description
SET
name = '479811899 - Acrílico Winsor & Newton Galeria 60 ml Carmim'
WHERE
option_value_id = 1082
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1082
DELETE FROM oc_product
WHERE
model = '479811899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1082,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479811999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479811999.jpg'
WHERE
option_value_id = 1083
UPDATE oc_option_value_description
SET
name = '479811999 - Acrílico Winsor & Newton Galeria 60 ml Terra Siena Natural'
WHERE
option_value_id = 1083
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1083
DELETE FROM oc_product
WHERE
model = '479811999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1083,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812099 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812099.jpg'
WHERE
option_value_id = 1084
UPDATE oc_option_value_description
SET
name = '479812099 - Acrílico Winsor & Newton Galeria 60 ml Cinzento de Payne'
WHERE
option_value_id = 1084
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1084
DELETE FROM oc_product
WHERE
model = '479812099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1084,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812199.jpg'
WHERE
option_value_id = 1036
UPDATE oc_option_value_description
SET
name = '479812199 - Acrílico Winsor & Newton Galeria 60 ml Verde Sap'
WHERE
option_value_id = 1036
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1036
DELETE FROM oc_product
WHERE
model = '479812199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1036,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812299.jpg'
WHERE
option_value_id = 1037
UPDATE oc_option_value_description
SET
name = '479812299 - Acrílico Winsor & Newton Galeria 60 ml Terra Sombra Natural'
WHERE
option_value_id = 1037
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1037
DELETE FROM oc_product
WHERE
model = '479812299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1037,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812399.jpg'
WHERE
option_value_id = 1038
UPDATE oc_option_value_description
SET
name = '479812399 - Acrílico Winsor & Newton Galeria 60 ml Preto de Marte'
WHERE
option_value_id = 1038
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1038
DELETE FROM oc_product
WHERE
model = '479812399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1038,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812499.jpg'
WHERE
option_value_id = 1039
UPDATE oc_option_value_description
SET
name = '479812499 - Acrílico Winsor & Newton Galeria 60 ml Branco Titânio'
WHERE
option_value_id = 1039
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1039
DELETE FROM oc_product
WHERE
model = '479812499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1039,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812599.jpg'
WHERE
option_value_id = 1040
UPDATE oc_option_value_description
SET
name = '479812599 - Acrílico Winsor & Newton Galeria 60 ml Prata'
WHERE
option_value_id = 1040
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1040
DELETE FROM oc_product
WHERE
model = '479812599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1040,
quantity = 1,
subtract = 1,
price = 1.056,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812799 - %'
UPDATE oc_option_value
SET
image = 'catalog/479812799.jpg'
WHERE
option_value_id = 1041
UPDATE oc_option_value_description
SET
name = '479812799 - Acrílico Winsor & Newton Galeria 60 ml Ouro'
WHERE
option_value_id = 1041
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1041
DELETE FROM oc_product
WHERE
model = '479812799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1041,
quantity = 1,
subtract = 1,
price = 1.056,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813199.jpg'
WHERE
option_value_id = 1042
UPDATE oc_option_value_description
SET
name = '479813199 - Acrílico Winsor & Newton Galeria 60 ml Ultramarino'
WHERE
option_value_id = 1042
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1042
DELETE FROM oc_product
WHERE
model = '479813199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1042,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813299.jpg'
WHERE
option_value_id = 1043
UPDATE oc_option_value_description
SET
name = '479813299 - Acrílico Winsor & Newton Galeria 60 ml Amarelo Ocre'
WHERE
option_value_id = 1043
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1043
DELETE FROM oc_product
WHERE
model = '479813299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1043,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813399.jpg'
WHERE
option_value_id = 1044
UPDATE oc_option_value_description
SET
name = '479813399 - Acrílico Winsor & Newton Galeria 60 ml Violeta Winsor'
WHERE
option_value_id = 1044
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1044
DELETE FROM oc_product
WHERE
model = '479813399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1044,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813499.jpg'
WHERE
option_value_id = 1045
UPDATE oc_option_value_description
SET
name = '479813499 - Acrílico Winsor & Newton Galeria 60 ml Azul Winsor'
WHERE
option_value_id = 1045
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1045
DELETE FROM oc_product
WHERE
model = '479813499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1045,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813599.jpg'
WHERE
option_value_id = 1046
UPDATE oc_option_value_description
SET
name = '479813599 - Acrílico Winsor & Newton Galeria 60 ml Vermelhão HUE'
WHERE
option_value_id = 1046
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1046
DELETE FROM oc_product
WHERE
model = '479813599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1046,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813699.jpg'
WHERE
option_value_id = 1162
UPDATE oc_option_value_description
SET
name = '479813699 - Acrílico Winsor & Newton Galeria 60 ml Verde Claro Permanente'
WHERE
option_value_id = 1162
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1162
DELETE FROM oc_product
WHERE
model = '479813699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1162,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813799 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813799.jpg'
WHERE
option_value_id = 1085
UPDATE oc_option_value_description
SET
name = '479813799 - Acrílico Winsor & Newton Galeria 60 ml Verde Médio Permanente'
WHERE
option_value_id = 1085
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1085
DELETE FROM oc_product
WHERE
model = '479813799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1085,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813899 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813899.jpg'
WHERE
option_value_id = 1086
UPDATE oc_option_value_description
SET
name = '479813899 - Acrílico Winsor & Newton Galeria 60 ml Verde Escuro Permanente'
WHERE
option_value_id = 1086
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1086
DELETE FROM oc_product
WHERE
model = '479813899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1086,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479813999.jpg'
WHERE
option_value_id = 1087
UPDATE oc_option_value_description
SET
name = '479813999 - Acrílico Winsor & Newton Galeria 60 ml Rosa Permanente'
WHERE
option_value_id = 1087
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1087
DELETE FROM oc_product
WHERE
model = '479813999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1087,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479814099 - %'
UPDATE oc_option_value
SET
image = 'catalog/479814099.jpg'
WHERE
option_value_id = 1088
UPDATE oc_option_value_description
SET
name = '479814099 - Acrílico Winsor & Newton Galeria 60 ml Magenta Permanente'
WHERE
option_value_id = 1088
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1088
DELETE FROM oc_product
WHERE
model = '479814099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1088,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479814999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479814999.jpg'
WHERE
option_value_id = 1190
UPDATE oc_option_value_description
SET
name = '479814999 - Acrílico Winsor & Newton Galeria 250 ml Verde Permanente (483)'
WHERE
option_value_id = 1190
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1190
DELETE FROM oc_product
WHERE
model = '479814999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1190,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479815299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479815299.jpg'
WHERE
option_value_id = 1191
UPDATE oc_option_value_description
SET
name = '479815299 - Acrílico Winsor & Newton Galeria 250 ml Magenta Primário (533)'
WHERE
option_value_id = 1191
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1191
DELETE FROM oc_product
WHERE
model = '479815299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1191,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479815399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479815399.jpg'
WHERE
option_value_id = 1192
UPDATE oc_option_value_description
SET
name = '479815399 - Acrílico Winsor & Newton Galeria 250 ml Azul Primário (535)'
WHERE
option_value_id = 1192
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1192
DELETE FROM oc_product
WHERE
model = '479815399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1192,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479815499 - %'
UPDATE oc_option_value
SET
image = 'catalog/479815499.jpg'
WHERE
option_value_id = 1193
UPDATE oc_option_value_description
SET
name = '479815499 - Acrílico Winsor & Newton Galeria 250 ml Amarelo Processo (537)'
WHERE
option_value_id = 1193
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1193
DELETE FROM oc_product
WHERE
model = '479815499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1193,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479817299.jpg'
WHERE
option_value_id = 1194
UPDATE oc_option_value_description
SET
name = '479817299 - Acrílico Winsor & Newton Galeria 500 ml Amarelo Processo 527'
WHERE
option_value_id = 1194
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1194
DELETE FROM oc_product
WHERE
model = '479817299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1194,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817399 - %'
UPDATE oc_option_value
SET
image = 'catalog/479817399.jpg'
WHERE
option_value_id = 1195
UPDATE oc_option_value_description
SET
name = '479817399 - Acrílico Winsor & Newton Galeria 500 ml Azul Primário (535)'
WHERE
option_value_id = 1195
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1195
DELETE FROM oc_product
WHERE
model = '479817399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1195,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1196
UPDATE oc_option_value_description
SET
name = '479817499 - Acrílico Winsor & Newton Galeria 500 ml PROCESS YELL 527'
WHERE
option_value_id = 1196
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1196
DELETE FROM oc_product
WHERE
model = '479817499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1196,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817599 - %'
UPDATE oc_option_value
SET
image = 'catalog/479817599.jpg'
WHERE
option_value_id = 1558
UPDATE oc_option_value_description
SET
name = '479817599 - Acrílico Winsor & Newton Galeria 500 ml Verde Azeitona Pálido (435)'
WHERE
option_value_id = 1558
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1558
DELETE FROM oc_product
WHERE
model = '479817599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1558,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479819299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2891
UPDATE oc_option_value_description
SET
name = '479819299 - Tinta da China Winsor & Newton Black Indian Ink 14 ml'
WHERE
option_value_id = 2891
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2891
DELETE FROM oc_product
WHERE
model = '479819299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2891,
quantity = 1,
subtract = 1,
price = 0.082,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479819399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2892
UPDATE oc_option_value_description
SET
name = '479819399 - Tinta da China Winsor & Newton Liquid Indian Ink 14 ml'
WHERE
option_value_id = 2892
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2892
DELETE FROM oc_product
WHERE
model = '479819399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2892,
quantity = 1,
subtract = 1,
price = 0.082,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479819499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2893
UPDATE oc_option_value_description
SET
name = '479819499 - Tinta da China Winsor & Newton Ouro 14 ml'
WHERE
option_value_id = 2893
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2893
DELETE FROM oc_product
WHERE
model = '479819499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2893,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479820699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2894
UPDATE oc_option_value_description
SET
name = '479820699 - Tinta da China Winsor & Newton Preto 500 ml'
WHERE
option_value_id = 2894
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2894
DELETE FROM oc_product
WHERE
model = '479820699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2894,
quantity = 1,
subtract = 1,
price = 0.082,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479821299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479821299.jpg'
WHERE
option_value_id = 2895
UPDATE oc_option_value_description
SET
name = '479821299 - Tinta da China Winsor & Newton Azul 14 ml'
WHERE
option_value_id = 2895
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2895
DELETE FROM oc_product
WHERE
model = '479821299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2895,
quantity = 1,
subtract = 1,
price = 0.082,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.