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.