Product Sync.
Opencart products: 7
Input products: 100

NEW: 100000099

NEW: 100000199

NEW: 100000299

NEW: 100000399

NEW: 100000499

NEW: 100000599

NEW: 100000699

NEW: 100000799

NEW: 100000899

NEW: 100000999

NEW: 100001099

NEW: 100001199

NEW: 100001299

NEW: 100001399

NEW: 100001499

NEW: 100001599

NEW: 100001699

NEW: 100001799

NEW: 100001899

NEW: 100001999

NEW: 100002099

NEW: 100002199

NEW: 100002299

NEW: 100002399

NEW: 100002499

NEW: 100002599

NEW: 100002699

NEW: 100002799

NEW: 100002899

NEW: 100002999

NEW: 100003099

NEW: 100003199

NEW: 100003299

NEW: 100003399

NEW: 100003499

NEW: 100003599

NEW: 100003699

NEW: 100003799

NEW: 100003899

NEW: 100003999

NEW: 100004099

NEW: 100004199

NEW: 100004299

NEW: 100004399

NEW: 100004499

NEW: 100004599

NEW: 100004699

NEW: 100004799

NEW: 100004899

NEW: 100004999

NEW: 100005099

NEW: 100005199

NEW: 100005299

NEW: 100005399

NEW: 100005499

NEW: 100005599

NEW: 100005699

NEW: 100005799

NEW: 100005899

NEW: 100005999

NEW: 100006099

NEW: 100006199

NEW: 100006299

NEW: 100006399

NEW: 100006499

NEW: 100006599

NEW: 100006699

NEW: 100006799

NEW: 100006899

NEW: 100006999

NEW: 100007099

NEW: 100007199

NEW: 100007299

NEW: 100007399

NEW: 100007499

NEW: 100007599

NEW: Tinta Acrílica Winsor & Newton 120 ml

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 Winsor & Newton 120 ml - %' )
Ok.

Product Option Sync.
Opencart products: 8
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 = 27405 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27405, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100007699 - %'
UPDATE oc_option_value SET image = 'catalog/100007699.jpg' WHERE option_value_id = 1018
UPDATE oc_option_value_description SET name = '100007699 - \''Acrílico Winsor & Newton Galeria 120 ml Titanio Buff' WHERE option_value_id = 1018 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1018
DELETE FROM oc_product WHERE model = '100007699'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1018, 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 '100007799 - %'
UPDATE oc_option_value SET image = 'catalog/100007799.jpg' WHERE option_value_id = 1019
UPDATE oc_option_value_description SET name = '100007799 - \''Acrílico Winsor & Newton Galeria 120 ml Terra Siena Queimada' WHERE option_value_id = 1019 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1019
DELETE FROM oc_product WHERE model = '100007799'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1019, 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 '100007899 - %'
UPDATE oc_option_value SET image = 'catalog/100007899.jpg' WHERE option_value_id = 1020
UPDATE oc_option_value_description SET name = '100007899 - \''Acrílico Winsor & Newton Galeria 120 ml Terra Sombra Queimada' WHERE option_value_id = 1020 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1020
DELETE FROM oc_product WHERE model = '100007899'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1020, 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 '100007999 - %'
UPDATE oc_option_value SET image = 'catalog/100007999.jpg' WHERE option_value_id = 1021
UPDATE oc_option_value_description SET name = '100007999 - \''Acrílico Winsor & Newton Galeria 120 ml Laranja Cádmio Hue' WHERE option_value_id = 1021 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1021
DELETE FROM oc_product WHERE model = '100007999'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1021, 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 '100008099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1022
UPDATE oc_option_value_description SET name = '100008099 - \''Acrílico Winsor & Newton Galeria 120 ml Vermelho Cádmio Hue' WHERE option_value_id = 1022 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1022
DELETE FROM oc_product WHERE model = '100008099'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1022, 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 '100008199 - %'
UPDATE oc_option_value SET image = 'catalog/100008199.jpg' WHERE option_value_id = 1023
UPDATE oc_option_value_description SET name = '100008199 - \''Acrílico Winsor & Newton Galeria 120 ml Amarelo Cádmio Pálido HUE' WHERE option_value_id = 1023 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1023
DELETE FROM oc_product WHERE model = '100008199'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1023, 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 '100008299 - %'
UPDATE oc_option_value SET image = 'catalog/100008299.jpg' WHERE option_value_id = 1024
UPDATE oc_option_value_description SET name = '100008299 - \''Acrílico Winsor & Newton Galeria 120 ml Amarelo Cádmio Escuro HUE' WHERE option_value_id = 1024 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1024
DELETE FROM oc_product WHERE model = '100008299'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1024, 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 '100008399 - %'
UPDATE oc_option_value SET image = 'catalog/100008399.jpg' WHERE option_value_id = 1025
UPDATE oc_option_value_description SET name = '100008399 - \''Acrílico Winsor & Newton Galeria 120 ml Amarelo Cádmio Médio HUE' WHERE option_value_id = 1025 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1025
DELETE FROM oc_product WHERE model = '100008399'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1025, 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 '100008499 - %'
UPDATE oc_option_value SET image = 'catalog/100008499.jpg' WHERE option_value_id = 1026
UPDATE oc_option_value_description SET name = '100008499 - \''Acrílico Winsor & Newton Galeria 120 ml Azul Ceruleo HUE' WHERE option_value_id = 1026 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1026
DELETE FROM oc_product WHERE model = '100008499'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1026, 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 '100008599 - %'
UPDATE oc_option_value SET image = 'catalog/100008599.jpg' WHERE option_value_id = 1027
UPDATE oc_option_value_description SET name = '100008599 - \''Acrílico Winsor & Newton Galeria 120 ml Azul Cobalto HUE' WHERE option_value_id = 1027 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1027
DELETE FROM oc_product WHERE model = '100008599'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1027, 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 '100008699 - %'
UPDATE oc_option_value SET image = 'catalog/100008699.jpg' WHERE option_value_id = 1028
UPDATE oc_option_value_description SET name = '100008699 - Acrílico Winsor & Newton Galeria 120 ml Carmim' WHERE option_value_id = 1028 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1028
DELETE FROM oc_product WHERE model = '100008699'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1028, 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 '100008799 - %'
UPDATE oc_option_value SET image = 'catalog/100008799.jpg' WHERE option_value_id = 1029
UPDATE oc_option_value_description SET name = '100008799 - Acrílico Winsor & Newton Galeria 120 ml Turquesa Profundo' WHERE option_value_id = 1029 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1029
DELETE FROM oc_product WHERE model = '100008799'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1029, 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 '100008899 - %'
UPDATE oc_option_value SET image = 'catalog/100008899.jpg' WHERE option_value_id = 1030
UPDATE oc_option_value_description SET name = '100008899 - Acrílico Winsor & Newton Galeria 120 ml Preto Marfim' WHERE option_value_id = 1030 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1030
DELETE FROM oc_product WHERE model = '100008899'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1030, 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 '100008999 - %'
UPDATE oc_option_value SET image = 'catalog/100008999.jpg' WHERE option_value_id = 1031
UPDATE oc_option_value_description SET name = '100008999 - Acrílico Winsor & Newton Galeria 120 ml Amarelo Limão' WHERE option_value_id = 1031 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1031
DELETE FROM oc_product WHERE model = '100008999'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1031, 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 '100009099 - %'
UPDATE oc_option_value SET image = 'catalog/100009099.jpg' WHERE option_value_id = 1032
UPDATE oc_option_value_description SET name = '100009099 - Acrílico Winsor & Newton Galeria 120 ml Preto de Marte' WHERE option_value_id = 1032 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1032
DELETE FROM oc_product WHERE model = '100009099'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1032, 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 '100009199 - %'
UPDATE oc_option_value SET image = 'catalog/100009199.jpg' WHERE option_value_id = 1033
UPDATE oc_option_value_description SET name = '100009199 - Acrílico Winsor & Newton Galeria 120 ml Branco Mistura' WHERE option_value_id = 1033 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1033
DELETE FROM oc_product WHERE model = '100009199'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1033, 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 '100009299 - %'
UPDATE oc_option_value SET image = 'catalog/100009299.jpg' WHERE option_value_id = 1034
UPDATE oc_option_value_description SET name = '100009299 - Acrílico Winsor & Newton Galeria 120 ml Amarelo Nápoles' WHERE option_value_id = 1034 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1034
DELETE FROM oc_product WHERE model = '100009299'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1034, 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 '100009399 - %'
UPDATE oc_option_value SET image = 'catalog/100009399.jpg' WHERE option_value_id = 1035
UPDATE oc_option_value_description SET name = '100009399 - Acrílico Winsor & Newton Galeria 120 ml Terracota Pálido' WHERE option_value_id = 1035 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1035
DELETE FROM oc_product WHERE model = '100009399'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1035, 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 '100009499 - %'
UPDATE oc_option_value SET image = 'catalog/100009499.jpg' WHERE option_value_id = 1073
UPDATE oc_option_value_description SET name = '100009499 - Acrílico Winsor & Newton Galeria 120 ml Azul Polvo' WHERE option_value_id = 1073 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1073
DELETE FROM oc_product WHERE model = '100009499'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1073, 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 '100009599 - %'
UPDATE oc_option_value SET image = 'catalog/100009599.jpg' WHERE option_value_id = 1074
UPDATE oc_option_value_description SET name = '100009599 - Acrílico Winsor & Newton Galeria 120 ml Verde Azeitona' WHERE option_value_id = 1074 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1074
DELETE FROM oc_product WHERE model = '100009599'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1074, 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 '100009699 - %'
UPDATE oc_option_value SET image = 'catalog/100009699.jpg' WHERE option_value_id = 1075
UPDATE oc_option_value_description SET name = '100009699 - Acrílico Winsor & Newton Galeria 120 ml Rosa Ópera' WHERE option_value_id = 1075 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1075
DELETE FROM oc_product WHERE model = '100009699'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1075, 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 '100009799 - %'
UPDATE oc_option_value SET image = 'catalog/100009799.jpg' WHERE option_value_id = 1076
UPDATE oc_option_value_description SET name = '100009799 - Acrílico Winsor & Newton Galeria 120 ml Cinzento de Payne' WHERE option_value_id = 1076 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1076
DELETE FROM oc_product WHERE model = '100009799'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1076, 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 '100009899 - %'
UPDATE oc_option_value SET image = 'catalog/100009899.jpg' WHERE option_value_id = 1077
UPDATE oc_option_value_description SET name = '100009899 - Acrílico Winsor & Newton Galeria 120 ml Carmim d\''Alizarina Permanente' WHERE option_value_id = 1077 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1077
DELETE FROM oc_product WHERE model = '100009899'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1077, 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 '100009999 - %'
UPDATE oc_option_value SET image = 'catalog/100009999.jpg' WHERE option_value_id = 1135
UPDATE oc_option_value_description SET name = '100009999 - Acrílico Winsor & Newton Galeria 120 ml Verde Brilhante Permanente' WHERE option_value_id = 1135 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 398 AND product_id = 27405 AND option_id = 17 AND option_value_id = 1135
DELETE FROM oc_product WHERE model = '100009999'
INSERT INTO oc_product_option_value SET product_option_id = 398, product_id = 27405, option_id = 17, option_value_id = 1135, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.