Product Sync.
Opencart products: 89
Input products: 100
UPDATING: Aguarela Winsor & Newton Cotman Pastilha
Product ID: 27486
Image file:
NEW: 100993199
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27452
Image file:
NEW: 100993499
NEW: 100993599
NEW: 100993699
NEW: 100993799
NEW: 100993899
NEW: 100993999
NEW: 100994099
NEW: 100994199
NEW: 100994299
NEW: 100994399
NEW: 100994499
NEW: 100994599
NEW: 100994699
NEW: 100994799
NEW: 100994899
NEW: 100994999
NEW: 100995099
NEW: 100995199
NEW: 100995299
NEW: 100995399
NEW: 100995499
NEW: 100995599
NEW: 100995699
NEW: 100995799
NEW: 100995899
NEW: 100995999
NEW: 100996099
NEW: 100996199
NEW: 100996299
NEW: 100996399
NEW: 100996499
NEW: 100996599
NEW: 100996699
NEW: 100996799
NEW: 100996899
NEW: 100996999
NEW: 100997099
NEW: 100997199
NEW: 100997299
NEW: 100997399
NEW: 100997499
NEW: 100997599
NEW: 100997699
NEW: 100997799
NEW: 100997899
NEW: 100997999
NEW: 100998099
NEW: 100998199
NEW: 100998299
NEW: 100998399
NEW: 100998499
NEW: 100998599
NEW: 100998699
NEW: 100998799
NEW: 100998899
NEW: 100998999
NEW: 100999099
NEW: 100999199
NEW: 100999299
NEW: 100999399
NEW: 100999499
NEW: 100999599
NEW: 100999699
NEW: 100999799
NEW: 100999899
Ok.
Product Option Sync.
Opencart products: 89
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 = 27486
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100989999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 977
UPDATE oc_option_value_description
SET
name = '100989999 - Aguarela Winsor & Newton Cotman Pastilha Amarelo Cádmio Pálido HUE 119'
WHERE
option_value_id = 977
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 977
DELETE FROM oc_product
WHERE
model = '100989999'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 977,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 978
UPDATE oc_option_value_description
SET
name = '100990099 - Aguarela Winsor & Newton Cotman Pastilha Azul Cerúleo Pálido HUE 139'
WHERE
option_value_id = 978
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 978
DELETE FROM oc_product
WHERE
model = '100990099'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 978,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 979
UPDATE oc_option_value_description
SET
name = '100990199 - Aguarela Winsor & Newton Cotman Pastilha Branco da China 150'
WHERE
option_value_id = 979
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 979
DELETE FROM oc_product
WHERE
model = '100990199'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 979,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 986
UPDATE oc_option_value_description
SET
name = '100990299 - Aguarela Winsor & Newton Cotman Pastilha Azul Cobalto HUE 179'
WHERE
option_value_id = 986
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 986
DELETE FROM oc_product
WHERE
model = '100990299'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 986,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 987
UPDATE oc_option_value_description
SET
name = '100990399 - Aguarela Winsor & Newton Cotman Pastilha Violeta Diox 231'
WHERE
option_value_id = 987
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 987
DELETE FROM oc_product
WHERE
model = '100990399'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 987,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 988
UPDATE oc_option_value_description
SET
name = '100990499 - Aguarela Winsor & Newton Cotman Pastilha Esmeralda 235'
WHERE
option_value_id = 988
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 988
DELETE FROM oc_product
WHERE
model = '100990499'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 988,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 989
UPDATE oc_option_value_description
SET
name = '100990599 - Aguarela Winsor & Newton Cotman Pastilha Gamboge HUE 266'
WHERE
option_value_id = 989
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 989
DELETE FROM oc_product
WHERE
model = '100990599'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 989,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 990
UPDATE oc_option_value_description
SET
name = '100990699 - Aguarela Winsor & Newton Cotman Pastilha Verde Hookers Escuro 312'
WHERE
option_value_id = 990
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 990
DELETE FROM oc_product
WHERE
model = '100990699'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 990,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 991
UPDATE oc_option_value_description
SET
name = '100990799 - Aguarela Winsor & Newton Cotman Pastilha Verde Hookers Claro 314'
WHERE
option_value_id = 991
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 991
DELETE FROM oc_product
WHERE
model = '100990799'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 991,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 992
UPDATE oc_option_value_description
SET
name = '100990899 - Aguarela Winsor & Newton Cotman Pastilha Vermelho Indio 317'
WHERE
option_value_id = 992
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 992
DELETE FROM oc_product
WHERE
model = '100990899'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 992,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100990999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 993
UPDATE oc_option_value_description
SET
name = '100990999 - Aguarela Winsor & Newton Cotman Pastilha Indigo 322'
WHERE
option_value_id = 993
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 993
DELETE FROM oc_product
WHERE
model = '100990999'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 993,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 994
UPDATE oc_option_value_description
SET
name = '100991099 - Aguarela Winsor & Newton Cotman Pastilha Azul Intenso 327'
WHERE
option_value_id = 994
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 994
DELETE FROM oc_product
WHERE
model = '100991099'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 994,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 995
UPDATE oc_option_value_description
SET
name = '100991199 - Aguarela Winsor & Newton Cotman Pastilha Verde Intenso 329'
WHERE
option_value_id = 995
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 995
DELETE FROM oc_product
WHERE
model = '100991199'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 995,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 996
UPDATE oc_option_value_description
SET
name = '100991299 - Aguarela Winsor & Newton Cotman Pastilha Preto Marfim 331'
WHERE
option_value_id = 996
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 996
DELETE FROM oc_product
WHERE
model = '100991299'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 996,
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 '100991399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 997
UPDATE oc_option_value_description
SET
name = '100991399 - Aguarela Winsor & Newton Cotman Pastilha Preto Fumo 337'
WHERE
option_value_id = 997
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 997
DELETE FROM oc_product
WHERE
model = '100991399'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 997,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 998
UPDATE oc_option_value_description
SET
name = '100991499 - Aguarela Winsor & Newton Cotman Pastilha Amarelo Limão HUE 346'
WHERE
option_value_id = 998
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 998
DELETE FROM oc_product
WHERE
model = '100991499'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 998,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 999
UPDATE oc_option_value_description
SET
name = '100991599 - Aguarela Winsor & Newton Cotman Pastilha Vermelho Claro 362'
WHERE
option_value_id = 999
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 999
DELETE FROM oc_product
WHERE
model = '100991599'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 999,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1000
UPDATE oc_option_value_description
SET
name = '100991699 - Aguarela Winsor & Newton Cotman Pastilha Malva 398'
WHERE
option_value_id = 1000
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1000
DELETE FROM oc_product
WHERE
model = '100991699'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1000,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1001
UPDATE oc_option_value_description
SET
name = '100991799 - Aguarela Winsor & Newton Cotman Pastilha Cinzento de Paynes 465'
WHERE
option_value_id = 1001
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1001
DELETE FROM oc_product
WHERE
model = '100991799'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1001,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1002
UPDATE oc_option_value_description
SET
name = '100991899 - Aguarela Winsor & Newton Cotman Pastilha Rosa Permanente 502'
WHERE
option_value_id = 1002
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1002
DELETE FROM oc_product
WHERE
model = '100991899'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1002,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100991999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1003
UPDATE oc_option_value_description
SET
name = '100991999 - Aguarela Winsor & Newton Cotman Pastilha Azul Prússia 538'
WHERE
option_value_id = 1003
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1003
DELETE FROM oc_product
WHERE
model = '100991999'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1003,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1004
UPDATE oc_option_value_description
SET
name = '100992099 - Aguarela Winsor & Newton Cotman Pastilha Laca Púrpura 544'
WHERE
option_value_id = 1004
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1004
DELETE FROM oc_product
WHERE
model = '100992099'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1004,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1005
UPDATE oc_option_value_description
SET
name = '100992199 - Aguarela Winsor & Newton Cotman Pastilha Siena Natural 552'
WHERE
option_value_id = 1005
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1005
DELETE FROM oc_product
WHERE
model = '100992199'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1005,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1006
UPDATE oc_option_value_description
SET
name = '100992299 - Aguarela Winsor & Newton Cotman Pastilha Terra Sombra Natural 554'
WHERE
option_value_id = 1006
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1006
DELETE FROM oc_product
WHERE
model = '100992299'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1006,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1007
UPDATE oc_option_value_description
SET
name = '100992399 - Aguarela Winsor & Newton Cotman Pastilha Rosa Granza HUE 580'
WHERE
option_value_id = 1007
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1007
DELETE FROM oc_product
WHERE
model = '100992399'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1007,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1008
UPDATE oc_option_value_description
SET
name = '100992499 - Aguarela Winsor & Newton Cotman Pastilha Verde Sap 599'
WHERE
option_value_id = 1008
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1008
DELETE FROM oc_product
WHERE
model = '100992499'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1008,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1009
UPDATE oc_option_value_description
SET
name = '100992599 - Aguarela Winsor & Newton Cotman Pastilha Sepia 609'
WHERE
option_value_id = 1009
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1009
DELETE FROM oc_product
WHERE
model = '100992599'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1009,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1010
UPDATE oc_option_value_description
SET
name = '100992699 - Aguarela Winsor & Newton Cotman Pastilha Turquesa 654'
WHERE
option_value_id = 1010
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1010
DELETE FROM oc_product
WHERE
model = '100992699'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1010,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1522
UPDATE oc_option_value_description
SET
name = '100992799 - Aguarela Winsor & Newton Cotman Pastilha Ultramarino 660'
WHERE
option_value_id = 1522
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1522
DELETE FROM oc_product
WHERE
model = '100992799'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1522,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1523
UPDATE oc_option_value_description
SET
name = '100992899 - Aguarela Winsor & Newton Cotman Pastilha Castanho Van Dyke 676'
WHERE
option_value_id = 1523
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1523
DELETE FROM oc_product
WHERE
model = '100992899'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1523,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100992999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1524
UPDATE oc_option_value_description
SET
name = '100992999 - Aguarela Winsor & Newton Cotman Pastilha Viridian HUE 696'
WHERE
option_value_id = 1524
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1524
DELETE FROM oc_product
WHERE
model = '100992999'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1524,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100993099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1525
UPDATE oc_option_value_description
SET
name = '100993099 - Aguarela Winsor & Newton Cotman Pastilha Amarelo Ocre 744'
WHERE
option_value_id = 1525
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 458
AND product_id = 27486
AND option_id = 17
AND option_value_id = 1525
DELETE FROM oc_product
WHERE
model = '100993099'
INSERT INTO oc_product_option_value
SET
product_option_id = 458,
product_id = 27486,
option_id = 17,
option_value_id = 1525,
quantity = 1,
subtract = 1,
price = 0.041,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27452
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100993299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100993299.jpg'
WHERE
option_value_id = 1514
UPDATE oc_option_value_description
SET
name = '100993299 - Acrílico Winsor & Newton Galeria 250 ml Branco Titânio (644)'
WHERE
option_value_id = 1514
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1514
DELETE FROM oc_product
WHERE
model = '100993299'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1514,
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 '100993399 - %'
UPDATE oc_option_value
SET
image = 'catalog/100993399.jpg'
WHERE
option_value_id = 1515
UPDATE oc_option_value_description
SET
name = '100993399 - Acrílico Winsor & Newton Galeria 250 ml Preto de Marte (386)'
WHERE
option_value_id = 1515
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1515
DELETE FROM oc_product
WHERE
model = '100993399'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1515,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.