Product Sync.
Opencart products: 12
Input products: 100

NEW: 100030399

NEW: 100030499

NEW: 100030599

NEW: 100030699

NEW: 100030799

NEW: 100030899

NEW: 100030999

NEW: 100031099

NEW: 100031199

NEW: 100031299

NEW: 100031399

NEW: 100031499

NEW: 100031599

NEW: 100031699

NEW: 100031799

NEW: Aguarela Escolar Giotto

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Aguarela Escolar Giotto - %' )
NEW: 100032099

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE '100032099 - %' )
NEW: 100032199

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE '100032199 - %' )
UPDATING: 100032299
Product ID: 27123
Image file:

NEW: 100032399

NEW: 100032499

NEW: 100032599

NEW: 100032699

NEW: 100032799

NEW: Guache Giotto Frasco 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 Frasco 250 ml - %' )
NEW: 100034699

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE '100034699 - %' )
NEW: 100034799

NEW: 100034899

NEW: 100034999

NEW: 100035099

NEW: 100035199

NEW: 100035299

NEW: 100035399

NEW: 100035499

NEW: 100035599

NEW: 100035699

NEW: 100035799

NEW: 100035899

NEW: 100035999

NEW: 100036099

NEW: 100036199

NEW: 100036299

NEW: 100036399

NEW: 100036499

NEW: 100036599

NEW: 100036699

NEW: 100036799

NEW: 100036899

NEW: 100036999

NEW: 100037099

NEW: 100037199

NEW: 100037299

NEW: 100037399

NEW: 100037499

NEW: 100037599

NEW: 100037699

NEW: 100037799

NEW: 100037899

NEW: 100037999

NEW: 100038099

NEW: 100038199

NEW: 100038299

NEW: 100038399

NEW: 100038499

NEW: 100038599

NEW: 100038699

NEW: 100038799

NEW: 100038899

NEW: 100038999

NEW: 100039099

NEW: 100039199

NEW: 100039299

NEW: 100039399

NEW: 100039499

NEW: 100039599

NEW: 100039699

NEW: 100039799

NEW: 100039899

NEW: 100039999

NEW: 100040099

NEW: 100040199

NEW: 100040299

Ok.

Product Option Sync.
Opencart products: 17
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 = 27410 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27410, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100031899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1713
UPDATE oc_option_value_description SET name = '100031899 - Aguarela Giotto com 12' WHERE option_value_id = 1713 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 401 AND product_id = 27410 AND option_id = 17 AND option_value_id = 1713
DELETE FROM oc_product WHERE model = '100031899'
INSERT INTO oc_product_option_value SET product_option_id = 401, product_id = 27410, option_id = 17, option_value_id = 1713, 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 '100031999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1714
UPDATE oc_option_value_description SET name = '100031999 - Aguarela Giotto com 24' WHERE option_value_id = 1714 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 401 AND product_id = 27410 AND option_id = 17 AND option_value_id = 1714
DELETE FROM oc_product WHERE model = '100031999'
INSERT INTO oc_product_option_value SET product_option_id = 401, product_id = 27410, option_id = 17, option_value_id = 1714, quantity = 1, subtract = 1, price = 2.601, 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
INSERT INTO oc_product_option SET product_id = 27413, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100032899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1715
UPDATE oc_option_value_description SET name = '100032899 - Guache Giotto Fluorescente 250 ml Amarelo' WHERE option_value_id = 1715 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 = 1715
DELETE FROM oc_product WHERE model = '100032899'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1715, 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 '100032999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1716
UPDATE oc_option_value_description SET name = '100032999 - Guache Giotto Fluorescente 250 ml Verde' WHERE option_value_id = 1716 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 = 1716
DELETE FROM oc_product WHERE model = '100032999'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1716, 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 '100033099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1717
UPDATE oc_option_value_description SET name = '100033099 - Guache Giotto Fluorescente 250 ml Laranja' WHERE option_value_id = 1717 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 = 1717
DELETE FROM oc_product WHERE model = '100033099'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1717, 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 '100033199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1718
UPDATE oc_option_value_description SET name = '100033199 - Guache Giotto Fluorescente 250 ml Rosa' WHERE option_value_id = 1718 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 = 1718
DELETE FROM oc_product WHERE model = '100033199'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1718, 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 '100033299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1719
UPDATE oc_option_value_description SET name = '100033299 - Guache Giotto Fluorescente 250 ml Ouro' WHERE option_value_id = 1719 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 = 1719
DELETE FROM oc_product WHERE model = '100033299'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1719, 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 '100033399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1720
UPDATE oc_option_value_description SET name = '100033399 - Guache Giotto Glitter 250 ml Prata' WHERE option_value_id = 1720 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 = 1720
DELETE FROM oc_product WHERE model = '100033399'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1720, 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 '100033499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1721
UPDATE oc_option_value_description SET name = '100033499 - Guache Giotto Fluorescente 250 ml Magenta' WHERE option_value_id = 1721 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 = 1721
DELETE FROM oc_product WHERE model = '100033499'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1721, 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 '100033599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1722
UPDATE oc_option_value_description SET name = '100033599 - Guache Giotto Fluorescente 250 ml Azul' WHERE option_value_id = 1722 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 = 1722
DELETE FROM oc_product WHERE model = '100033599'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1722, 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 '100033699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1723
UPDATE oc_option_value_description SET name = '100033699 - Guache Giotto Fluorescente 250 ml Verde' WHERE option_value_id = 1723 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 = 1723
DELETE FROM oc_product WHERE model = '100033699'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1723, 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 '100033799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1724
UPDATE oc_option_value_description SET name = '100033799 - Guache Giotto Fluorescente 250 ml Vermelho' WHERE option_value_id = 1724 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 = 1724
DELETE FROM oc_product WHERE model = '100033799'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1724, 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 '100033899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1725
UPDATE oc_option_value_description SET name = '100033899 - Guache Giotto Fluorescente 250 ml Bronze' WHERE option_value_id = 1725 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 = 1725
DELETE FROM oc_product WHERE model = '100033899'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1725, 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 '100033999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1726
UPDATE oc_option_value_description SET name = '100033999 - Guache Giotto Fluorescente 250 ml Azul Escuro' WHERE option_value_id = 1726 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 = 1726
DELETE FROM oc_product WHERE model = '100033999'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1726, 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 '100034099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1727
UPDATE oc_option_value_description SET name = '100034099 - Guache Giotto Metal 250 ml Ouro' WHERE option_value_id = 1727 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 = 1727
DELETE FROM oc_product WHERE model = '100034099'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1727, 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 '100034199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1728
UPDATE oc_option_value_description SET name = '100034199 - Guache Giotto Metal 250 ml Prata' WHERE option_value_id = 1728 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 = 1728
DELETE FROM oc_product WHERE model = '100034199'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1728, 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 '100034299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3236 AS option_value_id, language_id, 17 AS option_id, '100034299 - Guache Giotto Metal 250 ml Branco' AS name FROM oc_language
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 = 3236
DELETE FROM oc_product WHERE model = '100034299'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 3236, 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 '100034399 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3237 AS option_value_id, language_id, 17 AS option_id, '100034399 - Guache Giotto Metal 250 ml Magenta' AS name FROM oc_language
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 = 3237
DELETE FROM oc_product WHERE model = '100034399'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 3237, 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 '100034499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1729
UPDATE oc_option_value_description SET name = '100034499 - Guache Giotto 250 ml Verde Pérola' WHERE option_value_id = 1729 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 = 1729
DELETE FROM oc_product WHERE model = '100034499'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 1729, 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 '100034599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3238 AS option_value_id, language_id, 17 AS option_id, '100034599 - Guache Giotto 250 ml Azul Pérola' AS name FROM oc_language
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 = 3238
DELETE FROM oc_product WHERE model = '100034599'
INSERT INTO oc_product_option_value SET product_option_id = 402, product_id = 27413, option_id = 17, option_value_id = 3238, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.