Product Sync.
Opencart products: 64
Input products: 100
UPDATING: Tinta Acrílica para Artes Decorativas Pébéo Decor
Product ID: 27461
Image file:
NEW: Verniz Pébeo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Verniz Pébeo - %'
)
NEW: 100519099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100519099 - %'
)
NEW: Médio para Vitral Pébeo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Médio para Vitral Pébeo - %'
)
NEW: 100519299
NEW: 100519399
NEW: 100519499
NEW: 100519599
NEW: 100519699
NEW: 100519799
NEW: 100519899
NEW: 100519999
NEW: 100520099
NEW: 100520199
NEW: 100520299
NEW: 100520399
NEW: 100520499
NEW: 100520599
NEW: 100520699
NEW: 100520799
NEW: 100520899
NEW: 100520999
NEW: 100521099
NEW: 100521199
NEW: 100521299
NEW: 100521399
NEW: 100521499
NEW: 100521599
NEW: 100521699
NEW: 100521799
NEW: 100521899
NEW: 100521999
NEW: 100522099
NEW: 100522199
NEW: 100522299
NEW: 100522399
NEW: 100522499
NEW: 100522599
NEW: 100522699
NEW: 100522799
NEW: 100522899
NEW: 100522999
NEW: 100523099
NEW: 100523199
NEW: 100523299
NEW: 100523399
NEW: 100523499
NEW: 100523599
NEW: 100523699
NEW: 100523799
NEW: 100523899
NEW: 100523999
NEW: 100524099
NEW: 100524199
NEW: 100524299
NEW: 100524399
NEW: 100524499
NEW: 100524599
NEW: 100524699
NEW: 100524799
NEW: 100524899
NEW: 100524999
NEW: 100525099
Ok.
Product Option Sync.
Opencart products: 67
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
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100515199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1440
UPDATE oc_option_value_description
SET
name = '100515199 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Java'
WHERE
option_value_id = 1440
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 = 1440
DELETE FROM oc_product
WHERE
model = '100515199'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1440,
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 '100515299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1441
UPDATE oc_option_value_description
SET
name = '100515299 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Organdy'
WHERE
option_value_id = 1441
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 = 1441
DELETE FROM oc_product
WHERE
model = '100515299'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1441,
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 '100515399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1442
UPDATE oc_option_value_description
SET
name = '100515399 - Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Verde Tropical'
WHERE
option_value_id = 1442
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 = 1442
DELETE FROM oc_product
WHERE
model = '100515399'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1442,
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 '100515499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1443
UPDATE oc_option_value_description
SET
name = '100515499 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Verde Pradaria'
WHERE
option_value_id = 1443
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 = 1443
DELETE FROM oc_product
WHERE
model = '100515499'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1443,
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 '100515599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1444
UPDATE oc_option_value_description
SET
name = '100515599 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Roseau'
WHERE
option_value_id = 1444
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 = 1444
DELETE FROM oc_product
WHERE
model = '100515599'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1444,
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 '100515699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1753
UPDATE oc_option_value_description
SET
name = '100515699 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Bosque'
WHERE
option_value_id = 1753
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 = 1753
DELETE FROM oc_product
WHERE
model = '100515699'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1753,
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 '100515799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1448
UPDATE oc_option_value_description
SET
name = '100515799 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Tourterelle'
WHERE
option_value_id = 1448
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 = 1448
DELETE FROM oc_product
WHERE
model = '100515799'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1448,
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 '100515899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1449
UPDATE oc_option_value_description
SET
name = '100515899 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Moka'
WHERE
option_value_id = 1449
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 = 1449
DELETE FROM oc_product
WHERE
model = '100515899'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1449,
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 '100515999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1450
UPDATE oc_option_value_description
SET
name = '100515999 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Siena Queimado'
WHERE
option_value_id = 1450
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 = 1450
DELETE FROM oc_product
WHERE
model = '100515999'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1450,
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 '100516099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1451
UPDATE oc_option_value_description
SET
name = '100516099 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Argila'
WHERE
option_value_id = 1451
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 = 1451
DELETE FROM oc_product
WHERE
model = '100516099'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1451,
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 '100516199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1452
UPDATE oc_option_value_description
SET
name = '100516199 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Couro'
WHERE
option_value_id = 1452
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 = 1452
DELETE FROM oc_product
WHERE
model = '100516199'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1452,
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 '100516299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1453
UPDATE oc_option_value_description
SET
name = '100516299 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Nogal'
WHERE
option_value_id = 1453
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 = 1453
DELETE FROM oc_product
WHERE
model = '100516299'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1453,
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 '100516399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1454
UPDATE oc_option_value_description
SET
name = '100516399 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Açucar Amarelo'
WHERE
option_value_id = 1454
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 = 1454
DELETE FROM oc_product
WHERE
model = '100516399'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1454,
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 '100516499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1455
UPDATE oc_option_value_description
SET
name = '100516499 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Linho'
WHERE
option_value_id = 1455
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 = 1455
DELETE FROM oc_product
WHERE
model = '100516499'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1455,
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 '100516599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1456
UPDATE oc_option_value_description
SET
name = '100516599 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Beige Claro'
WHERE
option_value_id = 1456
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 = 1456
DELETE FROM oc_product
WHERE
model = '100516599'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1456,
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 '100516699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1457
UPDATE oc_option_value_description
SET
name = '100516699 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Carne'
WHERE
option_value_id = 1457
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 = 1457
DELETE FROM oc_product
WHERE
model = '100516699'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1457,
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 '100516799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1458
UPDATE oc_option_value_description
SET
name = '100516799 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Branco Nepal'
WHERE
option_value_id = 1458
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 = 1458
DELETE FROM oc_product
WHERE
model = '100516799'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1458,
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 '100516899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1459
UPDATE oc_option_value_description
SET
name = '100516899 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Plume'
WHERE
option_value_id = 1459
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 = 1459
DELETE FROM oc_product
WHERE
model = '100516899'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1459,
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 '100516999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1460
UPDATE oc_option_value_description
SET
name = '100516999 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Cimento'
WHERE
option_value_id = 1460
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 = 1460
DELETE FROM oc_product
WHERE
model = '100516999'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1460,
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 '100517099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1461
UPDATE oc_option_value_description
SET
name = '100517099 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Preto'
WHERE
option_value_id = 1461
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 = 1461
DELETE FROM oc_product
WHERE
model = '100517099'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1461,
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 '100517199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1462
UPDATE oc_option_value_description
SET
name = '100517199 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Branco'
WHERE
option_value_id = 1462
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 = 1462
DELETE FROM oc_product
WHERE
model = '100517199'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1462,
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 '100517299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1463
UPDATE oc_option_value_description
SET
name = '100517299 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Cinza Mercúrio'
WHERE
option_value_id = 1463
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 = 1463
DELETE FROM oc_product
WHERE
model = '100517299'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1463,
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 '100517399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1464
UPDATE oc_option_value_description
SET
name = '100517399 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Ouro em Pó'
WHERE
option_value_id = 1464
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 = 1464
DELETE FROM oc_product
WHERE
model = '100517399'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1464,
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 '100517499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1465
UPDATE oc_option_value_description
SET
name = '100517499 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Ouro Sol'
WHERE
option_value_id = 1465
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 = 1465
DELETE FROM oc_product
WHERE
model = '100517499'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1465,
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 '100517599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1466
UPDATE oc_option_value_description
SET
name = '100517599 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Ouro Bege'
WHERE
option_value_id = 1466
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 = 1466
DELETE FROM oc_product
WHERE
model = '100517599'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1466,
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 '100517699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1467
UPDATE oc_option_value_description
SET
name = '100517699 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Cobre Canela'
WHERE
option_value_id = 1467
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 = 1467
DELETE FROM oc_product
WHERE
model = '100517699'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1467,
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 '100517799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1468
UPDATE oc_option_value_description
SET
name = '100517799 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Madreperola'
WHERE
option_value_id = 1468
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 = 1468
DELETE FROM oc_product
WHERE
model = '100517799'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1468,
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 '100517899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1469
UPDATE oc_option_value_description
SET
name = '100517899 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Gelo'
WHERE
option_value_id = 1469
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 = 1469
DELETE FROM oc_product
WHERE
model = '100517899'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1469,
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 '100517999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1470
UPDATE oc_option_value_description
SET
name = '100517999 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Menta Vitrificada'
WHERE
option_value_id = 1470
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 = 1470
DELETE FROM oc_product
WHERE
model = '100517999'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1470,
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 '100518099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1471
UPDATE oc_option_value_description
SET
name = '100518099 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Suave'
WHERE
option_value_id = 1471
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 = 1471
DELETE FROM oc_product
WHERE
model = '100518099'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1471,
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 '100518199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1472
UPDATE oc_option_value_description
SET
name = '100518199 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Glicinia'
WHERE
option_value_id = 1472
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 = 1472
DELETE FROM oc_product
WHERE
model = '100518199'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1472,
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 '100518299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1473
UPDATE oc_option_value_description
SET
name = '100518299 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Vermelho Neon'
WHERE
option_value_id = 1473
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 = 1473
DELETE FROM oc_product
WHERE
model = '100518299'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1473,
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 '100518399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1474
UPDATE oc_option_value_description
SET
name = '100518399 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Rosa Garrido'
WHERE
option_value_id = 1474
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 = 1474
DELETE FROM oc_product
WHERE
model = '100518399'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1474,
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 '100518499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1475
UPDATE oc_option_value_description
SET
name = '100518499 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Amarelo Neon'
WHERE
option_value_id = 1475
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 = 1475
DELETE FROM oc_product
WHERE
model = '100518499'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1475,
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 '100518599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1333
UPDATE oc_option_value_description
SET
name = '100518599 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Verde Neon'
WHERE
option_value_id = 1333
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 = 1333
DELETE FROM oc_product
WHERE
model = '100518599'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1333,
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 '100518699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1334
UPDATE oc_option_value_description
SET
name = '100518699 - \''Tinta Acrílica para Artes Decorativas Pébéo Decor 59 ml Azul Neon'
WHERE
option_value_id = 1334
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 = 1334
DELETE FROM oc_product
WHERE
model = '100518699'
INSERT INTO oc_product_option_value
SET
product_option_id = 440,
product_id = 27461,
option_id = 17,
option_value_id = 1334,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27462
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27462,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100518799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3344 AS option_value_id,
language_id,
17 AS option_id,
'100518799 - Verniz Pébéo 59 ml Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 441
AND product_id = 27462
AND option_id = 17
AND option_value_id = 3344
DELETE FROM oc_product
WHERE
model = '100518799'
INSERT INTO oc_product_option_value
SET
product_option_id = 441,
product_id = 27462,
option_id = 17,
option_value_id = 3344,
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 '100518899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3345 AS option_value_id,
language_id,
17 AS option_id,
'100518899 - Verniz Pébéo 59 ml Mate' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 441
AND product_id = 27462
AND option_id = 17
AND option_value_id = 3345
DELETE FROM oc_product
WHERE
model = '100518899'
INSERT INTO oc_product_option_value
SET
product_option_id = 441,
product_id = 27462,
option_id = 17,
option_value_id = 3345,
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 '100518999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3346 AS option_value_id,
language_id,
17 AS option_id,
'100518999 - Verniz Pébeo 59 ml Purpurina' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 441
AND product_id = 27462
AND option_id = 17
AND option_value_id = 3346
DELETE FROM oc_product
WHERE
model = '100518999'
INSERT INTO oc_product_option_value
SET
product_option_id = 441,
product_id = 27462,
option_id = 17,
option_value_id = 3346,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27464
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27464,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100519199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3347 AS option_value_id,
language_id,
17 AS option_id,
'100519199 - Médio Pébéo 59 ml Nacre' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 442
AND product_id = 27464
AND option_id = 17
AND option_value_id = 3347
DELETE FROM oc_product
WHERE
model = '100519199'
INSERT INTO oc_product_option_value
SET
product_option_id = 442,
product_id = 27464,
option_id = 17,
option_value_id = 3347,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.