Product Sync.
Opencart products: 31
Input products: 100

NEW: 455045899

NEW: 455045999

UPDATING: Van Gogh 20ml
Product ID: 27402
Image file: Van Gogh 20ml.png

NEW: 455053399

NEW: 455053999

NEW: 455054399

NEW: 455054699

NEW: 455108599

NEW: 455108699

NEW: 455108799

NEW: 455109399

NEW: 455109499

NEW: 455109699

NEW: 455109799

NEW: 455109899

NEW: 455150699

NEW: 455151099

NEW: 455151399

NEW: 455152699

NEW: 455153099

NEW: 455154099

NEW: 455154499

NEW: 455154599

NEW: 455154799

NEW: 455154899

NEW: 455162599

NEW: 455162699

NEW: 455162799

NEW: 455162899

NEW: 455162999

NEW: 455163099

NEW: 455163199

NEW: 455163299

NEW: 455163499

NEW: 455165099

NEW: 455165199

NEW: 455165299

NEW: 456029899

NEW: 456030099

NEW: 456031699

NEW: 456033699

NEW: 456038299

NEW: 456038499

NEW: 456038699

NEW: 456038799

NEW: 456038899

NEW: 456038999

NEW: 456039099

NEW: 456039199

NEW: 456039899

NEW: 456040899

NEW: 456090199

NEW: 456091599

NEW: 456091899

NEW: 456091999

NEW: 456092099

NEW: 456092199

NEW: 456100699

NEW: 456100999

NEW: 456102498

NEW: 456102499

NEW: 456103599

NEW: 456105199

NEW: 456107099

NEW: 456107399

NEW: 456107499

NEW: 456107599

NEW: 456107999

NEW: 456108399

NEW: 456108499

NEW: 456108599

NEW: 456108699

NEW: 456108799

NEW: 456108899

NEW: 456108999

NEW: 456109099

NEW: 456109199

NEW: 456113398

NEW: 456114598

Ok.

Product Option Sync.
Opencart products: 31
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 = 27402 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '455049399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2105
UPDATE oc_option_value_description SET name = '455049399 - OLEO V GOG T7-20ML S1 AMARELO NAPOLES VERMELHO' WHERE option_value_id = 2105 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2105
DELETE FROM oc_product WHERE model = '455049399'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2105, 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 '455049499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2106
UPDATE oc_option_value_description SET name = '455049499 - OLEO V GOG T7-20ML S1 AMARELO AZO LIMAO' WHERE option_value_id = 2106 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2106
DELETE FROM oc_product WHERE model = '455049499'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2106, 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 '455049599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2107
UPDATE oc_option_value_description SET name = '455049599 - OLEO V GOG T7-20ML S1 AMA AZO CLARO' WHERE option_value_id = 2107 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2107
DELETE FROM oc_product WHERE model = '455049599'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2107, 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 '455049699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2108
UPDATE oc_option_value_description SET name = '455049699 - OLEO V GOG T7-20ML S1 AMARELO AZO MEDIO' WHERE option_value_id = 2108 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2108
DELETE FROM oc_product WHERE model = '455049699'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2108, 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 '455049799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2109
UPDATE oc_option_value_description SET name = '455049799 - OLEO V GOG T7-20ML S1 AMARELO AZO ESC' WHERE option_value_id = 2109 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2109
DELETE FROM oc_product WHERE model = '455049799'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2109, 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 '455049899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2110
UPDATE oc_option_value_description SET name = '455049899 - OLEO V GOG T7-20ML S1 ALARDO AZO' WHERE option_value_id = 2110 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2110
DELETE FROM oc_product WHERE model = '455049899'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2110, 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 '455049999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2111
UPDATE oc_option_value_description SET name = '455049999 - OLEO V GOG T7-20ML S1 VERMELHO AZO CLARO' WHERE option_value_id = 2111 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2111
DELETE FROM oc_product WHERE model = '455049999'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2111, 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 '455050099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2112
UPDATE oc_option_value_description SET name = '455050099 - OLEO V GOG T7-20ML S1 VERMELHO AZO ESC' WHERE option_value_id = 2112 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2112
DELETE FROM oc_product WHERE model = '455050099'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2112, 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 '455050199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2113
UPDATE oc_option_value_description SET name = '455050199 - OLEO V GOG T7-20ML S1 LACA GRANZA CLARA' WHERE option_value_id = 2113 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2113
DELETE FROM oc_product WHERE model = '455050199'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2113, 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 '455050399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2114
UPDATE oc_option_value_description SET name = '455050399 - OLEO V GOG T7-20ML S1 VERMELHO AZO MEDIO' WHERE option_value_id = 2114 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2114
DELETE FROM oc_product WHERE model = '455050399'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2114, 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 '455050499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2115
UPDATE oc_option_value_description SET name = '455050499 - OLEO V GOG T7-20ML S1 AZUL ULTRAMAR' WHERE option_value_id = 2115 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2115
DELETE FROM oc_product WHERE model = '455050499'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2115, 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 '455050599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2116
UPDATE oc_option_value_description SET name = '455050599 - OLEO V GOG T7-20ML S1 AZUL PRUSIA' WHERE option_value_id = 2116 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2116
DELETE FROM oc_product WHERE model = '455050599'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2116, 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 '455050899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2117
UPDATE oc_option_value_description SET name = '455050899 - OLEO V GOG T7-20ML S1 AZUL DE SEVRES' WHERE option_value_id = 2117 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2117
DELETE FROM oc_product WHERE model = '455050899'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2117, 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 '455051499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2118
UPDATE oc_option_value_description SET name = '455051499 - OLEO V GOG T7-20ML S1 BRANCO TITANIO (LINAZA)' WHERE option_value_id = 2118 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2118
DELETE FROM oc_product WHERE model = '455051499'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2118, 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 '455051599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2119
UPDATE oc_option_value_description SET name = '455051599 - OLEO V GOG T7-20ML S1 ROSA QUINACRIDONA' WHERE option_value_id = 2119 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2119
DELETE FROM oc_product WHERE model = '455051599'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2119, 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 '455051699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2120
UPDATE oc_option_value_description SET name = '455051699 - OLEO V GOG T7-20ML S1 VIOLETA' WHERE option_value_id = 2120 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2120
DELETE FROM oc_product WHERE model = '455051699'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2120, 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 '455051799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2121
UPDATE oc_option_value_description SET name = '455051799 - OLEO V GOG T7-20ML S1 VERDE PERM. MEDIO' WHERE option_value_id = 2121 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2121
DELETE FROM oc_product WHERE model = '455051799'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2121, 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 '455052099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2122
UPDATE oc_option_value_description SET name = '455052099 - OLEO V GOG T7-20ML S2 AMARILLO CADMIO CLARO' WHERE option_value_id = 2122 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2122
DELETE FROM oc_product WHERE model = '455052099'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2122, quantity = 1, subtract = 1, price = 2.277, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '455052399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2123
UPDATE oc_option_value_description SET name = '455052399 - OLEO V GOG T7-20ML S2 AMARELO CADMIO MEDIO' WHERE option_value_id = 2123 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2123
DELETE FROM oc_product WHERE model = '455052399'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2123, quantity = 1, subtract = 1, price = 2.277, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '455052699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2124
UPDATE oc_option_value_description SET name = '455052699 - OLEO V GOG T7-20ML S2 VERMELHO CADMIO MEDIO' WHERE option_value_id = 2124 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2124
DELETE FROM oc_product WHERE model = '455052699'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2124, quantity = 1, subtract = 1, price = 2.277, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '455052799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2125
UPDATE oc_option_value_description SET name = '455052799 - OLEO V GOG T7-20ML S2 VERMELHO PERM' WHERE option_value_id = 2125 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2125
DELETE FROM oc_product WHERE model = '455052799'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2125, quantity = 1, subtract = 1, price = 2.277, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '455052899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2126
UPDATE oc_option_value_description SET name = '455052899 - OLEO V GOG T7-20ML S2 AZUL COBALTO' WHERE option_value_id = 2126 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 395 AND product_id = 27402 AND option_id = 17 AND option_value_id = 2126
DELETE FROM oc_product WHERE model = '455052899'
INSERT INTO oc_product_option_value SET product_option_id = 395, product_id = 27402, option_id = 17, option_value_id = 2126, quantity = 1, subtract = 1, price = 2.277, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.