Product Sync.
Opencart products: 21
Input products: 100
NEW: 100505199
NEW: 100505299
NEW: 100505399
NEW: 100505499
NEW: 100505599
NEW: 100505699
NEW: 100505799
NEW: 100505899
NEW: 100505999
NEW: 100506099
NEW: 100506199
NEW: 100506299
NEW: 100506399
NEW: 100506499
NEW: 100506599
NEW: 100506699
NEW: 100506799
NEW: 100506899
NEW: 100506999
NEW: 100507099
NEW: 100507199
NEW: 100507299
NEW: 100507399
NEW: 100507499
NEW: 100507599
NEW: 100507699
NEW: 100507799
NEW: 100507899
NEW: 100507999
NEW: 100508099
NEW: 100508199
NEW: 100508299
NEW: 100508399
NEW: 100508499
NEW: 100508599
NEW: 100508699
NEW: 100508799
NEW: 100508899
NEW: 100508999
NEW: 100509099
NEW: 100509199
NEW: 100509299
NEW: 100509399
NEW: 100509499
NEW: 100509599
NEW: 100509699
NEW: 100509799
NEW: 100509899
NEW: 100509999
NEW: 100510099
NEW: 100510199
NEW: Pebeo Deco 59ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pebeo Deco 59ml - %'
)
Ok.
Product Option Sync.
Opencart products: 22
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 = 27393
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27393,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100510299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1391
UPDATE oc_option_value_description
SET
name = '100510299 - ACRILICO PEBEO 59ML BAUNILHA 01'
WHERE
option_value_id = 1391
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1391
DELETE FROM oc_product
WHERE
model = '100510299'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1391,
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 '100510399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1392
UPDATE oc_option_value_description
SET
name = '100510399 - ACRILICO PEBEO 59ML POLEN 02'
WHERE
option_value_id = 1392
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1392
DELETE FROM oc_product
WHERE
model = '100510399'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1392,
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 '100510499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1393
UPDATE oc_option_value_description
SET
name = '100510499 - ACRILICO PEBEO 59ML SOL 03'
WHERE
option_value_id = 1393
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1393
DELETE FROM oc_product
WHERE
model = '100510499'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1393,
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 '100510599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1394
UPDATE oc_option_value_description
SET
name = '100510599 - ACRILICO PEBEO 59ML CASCA DE LIMAO 04'
WHERE
option_value_id = 1394
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1394
DELETE FROM oc_product
WHERE
model = '100510599'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1394,
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 '100510699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1395
UPDATE oc_option_value_description
SET
name = '100510699 - ACRILICO PEBEO 59ML TRIGO 05'
WHERE
option_value_id = 1395
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1395
DELETE FROM oc_product
WHERE
model = '100510699'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1395,
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 '100510799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1396
UPDATE oc_option_value_description
SET
name = '100510799 - ACRILICO PEBEO 59ML AMARELO PROVENCA 06'
WHERE
option_value_id = 1396
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1396
DELETE FROM oc_product
WHERE
model = '100510799'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1396,
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 '100510899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1397
UPDATE oc_option_value_description
SET
name = '100510899 - ACRILICO PEBEO 59ML GIRASSOL 07'
WHERE
option_value_id = 1397
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1397
DELETE FROM oc_product
WHERE
model = '100510899'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1397,
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 '100510999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1398
UPDATE oc_option_value_description
SET
name = '100510999 - ACRILICO PEBEO 59ML ABOBORA 08'
WHERE
option_value_id = 1398
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1398
DELETE FROM oc_product
WHERE
model = '100510999'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1398,
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 '100511099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1399
UPDATE oc_option_value_description
SET
name = '100511099 - ACRILICO PEBEO 59ML GOIABA 09'
WHERE
option_value_id = 1399
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1399
DELETE FROM oc_product
WHERE
model = '100511099'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1399,
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 '100511199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1400
UPDATE oc_option_value_description
SET
name = '100511199 - ACRILICO PEBEO 59ML LARANJA 10'
WHERE
option_value_id = 1400
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1400
DELETE FROM oc_product
WHERE
model = '100511199'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1400,
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 '100511299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1401
UPDATE oc_option_value_description
SET
name = '100511299 - ACRILICO PEBEO 59ML SORVETE 11'
WHERE
option_value_id = 1401
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1401
DELETE FROM oc_product
WHERE
model = '100511299'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1401,
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 '100511399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1402
UPDATE oc_option_value_description
SET
name = '100511399 - ACRILICO PEBEO 59ML PESSEGO 12'
WHERE
option_value_id = 1402
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1402
DELETE FROM oc_product
WHERE
model = '100511399'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1402,
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 '100511499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1403
UPDATE oc_option_value_description
SET
name = '100511499 - ACRILICO PEBEO 59ML ENCARNADO PEKIN 13'
WHERE
option_value_id = 1403
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1403
DELETE FROM oc_product
WHERE
model = '100511499'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1403,
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 '100511599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1404
UPDATE oc_option_value_description
SET
name = '100511599 - ACRILICO PEBEO 59ML GERANIO 14'
WHERE
option_value_id = 1404
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1404
DELETE FROM oc_product
WHERE
model = '100511599'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1404,
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 '100511699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1405
UPDATE oc_option_value_description
SET
name = '100511699 - ACRILICO PEBEO 59ML CARMIN DE GRANZA 15'
WHERE
option_value_id = 1405
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1405
DELETE FROM oc_product
WHERE
model = '100511699'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1405,
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 '100511799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1406
UPDATE oc_option_value_description
SET
name = '100511799 - ACRILICO PEBEO 59ML SANGUINO 16'
WHERE
option_value_id = 1406
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1406
DELETE FROM oc_product
WHERE
model = '100511799'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1406,
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 '100511899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1407
UPDATE oc_option_value_description
SET
name = '100511899 - ACRILICO PEBEO 59ML ENCARNADO ROMA 17'
WHERE
option_value_id = 1407
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1407
DELETE FROM oc_product
WHERE
model = '100511899'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1407,
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 '100511999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1408
UPDATE oc_option_value_description
SET
name = '100511999 - ACRILICO PEBEO 59ML ROSA SELVAGEM 18'
WHERE
option_value_id = 1408
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1408
DELETE FROM oc_product
WHERE
model = '100511999'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1408,
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 '100512099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1409
UPDATE oc_option_value_description
SET
name = '100512099 - ACRILICO PEBEO 59ML ROSA CIGANO 19'
WHERE
option_value_id = 1409
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1409
DELETE FROM oc_product
WHERE
model = '100512099'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1409,
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 '100512199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1410
UPDATE oc_option_value_description
SET
name = '100512199 - ACRILICO PEBEO 59ML ROSA HORTENSE 20'
WHERE
option_value_id = 1410
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1410
DELETE FROM oc_product
WHERE
model = '100512199'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1410,
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 '100512299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1411
UPDATE oc_option_value_description
SET
name = '100512299 - ACRILICO PEBEO 59ML ROSA CHA 21'
WHERE
option_value_id = 1411
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1411
DELETE FROM oc_product
WHERE
model = '100512299'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1411,
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 '100512399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1412
UPDATE oc_option_value_description
SET
name = '100512399 - ACRILICO PEBEO 59ML ROSA GRANITO 22'
WHERE
option_value_id = 1412
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1412
DELETE FROM oc_product
WHERE
model = '100512399'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1412,
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 '100512499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1413
UPDATE oc_option_value_description
SET
name = '100512499 - ACRILICO PEBEO 59ML AMORA 23'
WHERE
option_value_id = 1413
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1413
DELETE FROM oc_product
WHERE
model = '100512499'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1413,
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 '100512599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1414
UPDATE oc_option_value_description
SET
name = '100512599 - ACRILICO PEBEO 59ML VIOLETA SELVAGEM 24'
WHERE
option_value_id = 1414
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1414
DELETE FROM oc_product
WHERE
model = '100512599'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1414,
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 '100512699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1415
UPDATE oc_option_value_description
SET
name = '100512699 - ACRILICO PEBEO 59ML AMETISTA 25'
WHERE
option_value_id = 1415
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1415
DELETE FROM oc_product
WHERE
model = '100512699'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1415,
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 '100512799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1416
UPDATE oc_option_value_description
SET
name = '100512799 - ACRILICO PEBEO 59ML LAVANDA 26'
WHERE
option_value_id = 1416
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1416
DELETE FROM oc_product
WHERE
model = '100512799'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1416,
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 '100512899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1417
UPDATE oc_option_value_description
SET
name = '100512899 - ACRILICO PEBEO 59ML IRIS 27'
WHERE
option_value_id = 1417
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1417
DELETE FROM oc_product
WHERE
model = '100512899'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1417,
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 '100512999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1418
UPDATE oc_option_value_description
SET
name = '100512999 - ACRILICO PEBEO 59ML TOPAZIO 28'
WHERE
option_value_id = 1418
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1418
DELETE FROM oc_product
WHERE
model = '100512999'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1418,
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 '100513099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1419
UPDATE oc_option_value_description
SET
name = '100513099 - ACRILICO PEBEO 59ML AZUL OCEANO 29'
WHERE
option_value_id = 1419
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1419
DELETE FROM oc_product
WHERE
model = '100513099'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1419,
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 '100513199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1420
UPDATE oc_option_value_description
SET
name = '100513199 - ACRILICO PEBEO 59ML AZUL PAREO 30'
WHERE
option_value_id = 1420
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1420
DELETE FROM oc_product
WHERE
model = '100513199'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1420,
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 '100513299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1421
UPDATE oc_option_value_description
SET
name = '100513299 - ACRILICO PEBEO 59ML AZUL MARINO 31'
WHERE
option_value_id = 1421
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1421
DELETE FROM oc_product
WHERE
model = '100513299'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1421,
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 '100513399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1422
UPDATE oc_option_value_description
SET
name = '100513399 - ACRILICO PEBEO 59ML AZUL CAVALEIRO 32'
WHERE
option_value_id = 1422
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1422
DELETE FROM oc_product
WHERE
model = '100513399'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1422,
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 '100513499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1423
UPDATE oc_option_value_description
SET
name = '100513499 - ACRILICO PEBEO 59ML AZUL SAGRADO 33'
WHERE
option_value_id = 1423
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1423
DELETE FROM oc_product
WHERE
model = '100513499'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1423,
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 '100513599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1424
UPDATE oc_option_value_description
SET
name = '100513599 - ACRILICO PEBEO 59ML LAGO 34'
WHERE
option_value_id = 1424
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1424
DELETE FROM oc_product
WHERE
model = '100513599'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1424,
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 '100513699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1425
UPDATE oc_option_value_description
SET
name = '100513699 - ACRILICO PEBEO 59ML AZUL CARAIBAS 35'
WHERE
option_value_id = 1425
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1425
DELETE FROM oc_product
WHERE
model = '100513699'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1425,
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 '100513799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1426
UPDATE oc_option_value_description
SET
name = '100513799 - ACRILICO PEBEO 59ML AZUL CEU 36'
WHERE
option_value_id = 1426
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1426
DELETE FROM oc_product
WHERE
model = '100513799'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1426,
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 '100513899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1427
UPDATE oc_option_value_description
SET
name = '100513899 - ACRILICO PEBEO 59ML AZUL ELECTRICO 37'
WHERE
option_value_id = 1427
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1427
DELETE FROM oc_product
WHERE
model = '100513899'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1427,
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 '100513999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1428
UPDATE oc_option_value_description
SET
name = '100513999 - ACRILICO PEBEO 59ML AZUL PATO 38'
WHERE
option_value_id = 1428
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1428
DELETE FROM oc_product
WHERE
model = '100513999'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1428,
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 '100514099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1429
UPDATE oc_option_value_description
SET
name = '100514099 - ACRILICO PEBEO 59ML AZUL EGEU 39'
WHERE
option_value_id = 1429
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1429
DELETE FROM oc_product
WHERE
model = '100514099'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1429,
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 '100514199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1430
UPDATE oc_option_value_description
SET
name = '100514199 - ACRILICO PEBEO 59ML TORRENTE 40'
WHERE
option_value_id = 1430
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1430
DELETE FROM oc_product
WHERE
model = '100514199'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1430,
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 '100514299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1431
UPDATE oc_option_value_description
SET
name = '100514299 - ACRILICO PEBEO 59ML AZUL ULTRA 41'
WHERE
option_value_id = 1431
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1431
DELETE FROM oc_product
WHERE
model = '100514299'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1431,
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 '100514399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1432
UPDATE oc_option_value_description
SET
name = '100514399 - ACRILICO PEBEO 59ML VERDE ABETO 42'
WHERE
option_value_id = 1432
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1432
DELETE FROM oc_product
WHERE
model = '100514399'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1432,
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 '100514499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1433
UPDATE oc_option_value_description
SET
name = '100514499 - ACRILICO PEBEO 59ML VERDE BRILHANTE 43'
WHERE
option_value_id = 1433
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1433
DELETE FROM oc_product
WHERE
model = '100514499'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1433,
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 '100514599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1434
UPDATE oc_option_value_description
SET
name = '100514599 - ACRILICO PEBEO 59ML VERDE MIAMI 44'
WHERE
option_value_id = 1434
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1434
DELETE FROM oc_product
WHERE
model = '100514599'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1434,
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 '100514699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1435
UPDATE oc_option_value_description
SET
name = '100514699 - ACRILICO PEBEO 59ML TURQUESA 45'
WHERE
option_value_id = 1435
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1435
DELETE FROM oc_product
WHERE
model = '100514699'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1435,
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 '100514799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1436
UPDATE oc_option_value_description
SET
name = '100514799 - ACRILICO PEBEO 59ML BAMBU 46'
WHERE
option_value_id = 1436
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1436
DELETE FROM oc_product
WHERE
model = '100514799'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1436,
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 '100514899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1437
UPDATE oc_option_value_description
SET
name = '100514899 - ACRILICO PEBEO 59ML SOJA 47'
WHERE
option_value_id = 1437
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1437
DELETE FROM oc_product
WHERE
model = '100514899'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1437,
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 '100514999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1438
UPDATE oc_option_value_description
SET
name = '100514999 - ACRILICO PEBEO 59ML CLOROFILA 48'
WHERE
option_value_id = 1438
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1438
DELETE FROM oc_product
WHERE
model = '100514999'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1438,
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 '100515099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1439
UPDATE oc_option_value_description
SET
name = '100515099 - ACRILICO PEBEO 59ML SALVA 49'
WHERE
option_value_id = 1439
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 386
AND product_id = 27393
AND option_id = 17
AND option_value_id = 1439
DELETE FROM oc_product
WHERE
model = '100515099'
INSERT INTO oc_product_option_value
SET
product_option_id = 386,
product_id = 27393,
option_id = 17,
option_value_id = 1439,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.