Product Sync.
Opencart products: 37
Input products: 100

NEW: 100212199

NEW: 100212299

NEW: 100212399

NEW: 100212499

NEW: 100212599

NEW: 100212699

NEW: 100212799

NEW: 100212899

NEW: 100212999

NEW: 100213099

NEW: 100213199

NEW: 100213299

NEW: 100213399

NEW: 100213499

NEW: 100213599

NEW: 100213699

NEW: 100213799

NEW: 100213899

NEW: 100213999

NEW: 100214099

NEW: 100214199

NEW: 100214299

NEW: 100214399

NEW: 100214499

NEW: 100214599

NEW: 100214699

NEW: 100214799

NEW: 100214899

NEW: 100214999

NEW: 100215099

NEW: 100215199

NEW: 100215299

NEW: 100215399

NEW: 100215499

NEW: 100215599

NEW: 100215699

NEW: 100215799

NEW: 100215899

NEW: 100215999

NEW: Guache Giotto Caixa

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Guache Giotto Caixa - %' )
NEW: 100216199

NEW: 100216299

NEW: 100216399

NEW: 100216499

NEW: 100216599

NEW: 100216699

NEW: 100216799

NEW: 100216899

NEW: 100216999

NEW: 100217099

NEW: 100217199

NEW: 100217299

NEW: 100217399

NEW: 100217499

NEW: 100217599

NEW: 100217699

NEW: Guache Giotto 500 ml

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Guache Giotto 500 ml - %' )
NEW: 100218099

NEW: Guache Giotto 1000 ml

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Guache Giotto 1000 ml - %' )
NEW: 100218999

NEW: 100219099

NEW: Guache Giotto Bebé 250 ml

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Guache Giotto Bebé 250 ml - %' )
UPDATING: Guache Giotto Frasco 250 ml
Product ID: 27413
Image file:

NEW: 100219699

NEW: 100219899

NEW: 100219999

NEW: 100220099

NEW: 100220199

NEW: 100220299

NEW: 100220399

NEW: 100220499

NEW: 100220599

NEW: 100220699

NEW: 100220799

NEW: 100220899

NEW: 100220999

NEW: 100221099

NEW: 100221199

NEW: 100221299

NEW: 100221399

NEW: 100221499

NEW: 100221599

NEW: 100221699

NEW: 100221799

NEW: 100221899

NEW: 100221999

NEW: 100222099

Ok.

Product Option Sync.
Opencart products: 41
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 = 27435 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27435, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100216099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1734
UPDATE oc_option_value_description SET name = '100216099 - Guache Giotto com 6' WHERE option_value_id = 1734 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 416 AND product_id = 27435 AND option_id = 17 AND option_value_id = 1734
DELETE FROM oc_product WHERE model = '100216099'
INSERT INTO oc_product_option_value SET product_option_id = 416, product_id = 27435, option_id = 17, option_value_id = 1734, 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 = 27436 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27436, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100217799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1564
UPDATE oc_option_value_description SET name = '100217799 - Guache Acrílico Giotto 500 ml Azul Cyan' WHERE option_value_id = 1564 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1564
DELETE FROM oc_product WHERE model = '100217799'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1564, 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 '100217899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1565
UPDATE oc_option_value_description SET name = '100217899 - Guache Acrílico Giotto 500 ml Magenta' WHERE option_value_id = 1565 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1565
DELETE FROM oc_product WHERE model = '100217899'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1565, 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 '100217999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1566
UPDATE oc_option_value_description SET name = '100217999 - Guache Acrílico Giotto 500 ml Castanho' WHERE option_value_id = 1566 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1566
DELETE FROM oc_product WHERE model = '100217999'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1566, 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 '100218199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1568
UPDATE oc_option_value_description SET name = '100218199 - Guache Acrílico Giotto 500 ml Preto' WHERE option_value_id = 1568 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1568
DELETE FROM oc_product WHERE model = '100218199'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1568, 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 '100218299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1571
UPDATE oc_option_value_description SET name = '100218299 - Guache Acrílico Giotto 500 ml Branco' WHERE option_value_id = 1571 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1571
DELETE FROM oc_product WHERE model = '100218299'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1571, 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 '100218399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1572
UPDATE oc_option_value_description SET name = '100218399 - Guache Acrílico Giotto 500 ml Amarelo' WHERE option_value_id = 1572 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1572
DELETE FROM oc_product WHERE model = '100218399'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1572, 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 '100218499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1573
UPDATE oc_option_value_description SET name = '100218499 - Guache Acrílico Giotto 500 ml Verde' WHERE option_value_id = 1573 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 417 AND product_id = 27436 AND option_id = 17 AND option_value_id = 1573
DELETE FROM oc_product WHERE model = '100218499'
INSERT INTO oc_product_option_value SET product_option_id = 417, product_id = 27436, option_id = 17, option_value_id = 1573, 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 = 27437 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27437, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100218599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3254 AS option_value_id, language_id, 17 AS option_id, '100218599 - Guache Giotto 1000 ml Magenta' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 418 AND product_id = 27437 AND option_id = 17 AND option_value_id = 3254
DELETE FROM oc_product WHERE model = '100218599'
INSERT INTO oc_product_option_value SET product_option_id = 418, product_id = 27437, option_id = 17, option_value_id = 3254, 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 '100218699 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3255 AS option_value_id, language_id, 17 AS option_id, '100218699 - Guache Giotto 1000 ml Azul Ultramarino' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 418 AND product_id = 27437 AND option_id = 17 AND option_value_id = 3255
DELETE FROM oc_product WHERE model = '100218699'
INSERT INTO oc_product_option_value SET product_option_id = 418, product_id = 27437, option_id = 17, option_value_id = 3255, 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 '100218799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3256 AS option_value_id, language_id, 17 AS option_id, '100218799 - Guache Giotto 1000 ml Laranja' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 418 AND product_id = 27437 AND option_id = 17 AND option_value_id = 3256
DELETE FROM oc_product WHERE model = '100218799'
INSERT INTO oc_product_option_value SET product_option_id = 418, product_id = 27437, option_id = 17, option_value_id = 3256, 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 '100218899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3257 AS option_value_id, language_id, 17 AS option_id, '100218899 - Guache Giotto 1000 ml Violeta' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 418 AND product_id = 27437 AND option_id = 17 AND option_value_id = 3257
DELETE FROM oc_product WHERE model = '100218899'
INSERT INTO oc_product_option_value SET product_option_id = 418, product_id = 27437, option_id = 17, option_value_id = 3257, 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 = 27438 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27438, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100219199 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3258 AS option_value_id, language_id, 17 AS option_id, '100219199 - Guache Giotto Bebé 250 ml Castanho' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 419 AND product_id = 27438 AND option_id = 17 AND option_value_id = 3258
DELETE FROM oc_product WHERE model = '100219199'
INSERT INTO oc_product_option_value SET product_option_id = 419, product_id = 27438, option_id = 17, option_value_id = 3258, 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 '100219299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3259 AS option_value_id, language_id, 17 AS option_id, '100219299 - Guache Giotto Bebé 250 ml Vermelho' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 419 AND product_id = 27438 AND option_id = 17 AND option_value_id = 3259
DELETE FROM oc_product WHERE model = '100219299'
INSERT INTO oc_product_option_value SET product_option_id = 419, product_id = 27438, option_id = 17, option_value_id = 3259, 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 '100219399 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3260 AS option_value_id, language_id, 17 AS option_id, '100219399 - Guache Giotto Bebé 250 ml Azul Cyan' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 419 AND product_id = 27438 AND option_id = 17 AND option_value_id = 3260
DELETE FROM oc_product WHERE model = '100219399'
INSERT INTO oc_product_option_value SET product_option_id = 419, product_id = 27438, option_id = 17, option_value_id = 3260, 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 = 27413 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100219499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1735
UPDATE oc_option_value_description SET name = '100219499 - Guache Acrilico Giotto 250 ml Prata' WHERE option_value_id = 1735 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 402 AND product_id = 27413 AND option_id = 17 AND option_value_id = 1735
DELETE FROM oc_product WHERE model = '100219499'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1735, 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 '100219599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1736
UPDATE oc_option_value_description SET name = '100219599 - Guache Acrilico Giotto 250 ml Magenta' WHERE option_value_id = 1736 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 402 AND product_id = 27413 AND option_id = 17 AND option_value_id = 1736
DELETE FROM oc_product WHERE model = '100219599'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1736, 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 '100219799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1737
UPDATE oc_option_value_description SET name = '100219799 - Guache Giotto 250 ml Ouro Pérola' WHERE option_value_id = 1737 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 402 AND product_id = 27413 AND option_id = 17 AND option_value_id = 1737
DELETE FROM oc_product WHERE model = '100219799'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1737, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.