Product Sync.
Opencart products: 63
Input products: 100
NEW: 100505099
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: Tinta Acrílica para Artes Decorativas Pébéo Decor
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Acrílica para Artes Decorativas Pébéo Decor - %'
)
Ok.
Product Option Sync.
Opencart products: 64
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 = 27461
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Baunilha'
WHERE
option_value_id = 1391
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Polen'
WHERE
option_value_id = 1392
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Sol'
WHERE
option_value_id = 1393
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Casca de Limão'
WHERE
option_value_id = 1394
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Trigo'
WHERE
option_value_id = 1395
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Amarelo Provença'
WHERE
option_value_id = 1396
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Girassol'
WHERE
option_value_id = 1397
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Abóbora'
WHERE
option_value_id = 1398
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Goiaba'
WHERE
option_value_id = 1399
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Laranja'
WHERE
option_value_id = 1400
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Sorvete'
WHERE
option_value_id = 1401
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Pêssego'
WHERE
option_value_id = 1402
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Vermelho Pekin'
WHERE
option_value_id = 1403
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Geranio'
WHERE
option_value_id = 1404
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Carmim de Granza'
WHERE
option_value_id = 1405
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Sanguino'
WHERE
option_value_id = 1406
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Vermelho Roma'
WHERE
option_value_id = 1407
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Selvagem'
WHERE
option_value_id = 1408
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Cigano'
WHERE
option_value_id = 1409
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Hortense'
WHERE
option_value_id = 1410
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Chá'
WHERE
option_value_id = 1411
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Granito'
WHERE
option_value_id = 1412
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Amora 23'
WHERE
option_value_id = 1413
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Violeta Selvagem'
WHERE
option_value_id = 1414
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Ametista'
WHERE
option_value_id = 1415
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Lavanda'
WHERE
option_value_id = 1416
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Iris'
WHERE
option_value_id = 1417
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Topazio'
WHERE
option_value_id = 1418
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Oceano'
WHERE
option_value_id = 1419
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Pareo'
WHERE
option_value_id = 1420
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Marino'
WHERE
option_value_id = 1421
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Cavaleiro'
WHERE
option_value_id = 1422
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Sagrado'
WHERE
option_value_id = 1423
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Lago'
WHERE
option_value_id = 1424
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Caraíbas'
WHERE
option_value_id = 1425
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Céu'
WHERE
option_value_id = 1426
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Electrico'
WHERE
option_value_id = 1427
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Pato'
WHERE
option_value_id = 1428
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Egeu'
WHERE
option_value_id = 1429
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Torremte'
WHERE
option_value_id = 1430
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Ultramarino'
WHERE
option_value_id = 1431
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Verde Abeto'
WHERE
option_value_id = 1432
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Verde Brilhante'
WHERE
option_value_id = 1433
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Verde Miami'
WHERE
option_value_id = 1434
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Turquesa'
WHERE
option_value_id = 1435
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Bambu'
WHERE
option_value_id = 1436
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Soja'
WHERE
option_value_id = 1437
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
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 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Clorofila'
WHERE
option_value_id = 1438
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 440
AND product_id = 27461
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 = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1438,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.