Product Sync.
Opencart products: 196
Input products: 100

NEW: 102333199

NEW: 102333299

NEW: 102333399

NEW: 102333499

NEW: 102333599

NEW: 102333699

NEW: 102333799

NEW: 102333899

NEW: 102333999

NEW: 102334099

NEW: 102334199

NEW: 102334299

NEW: 102334399

NEW: 102334499

NEW: 102334599

NEW: 102334699

NEW: 102334799

NEW: 102334899

NEW: 102334999

NEW: 102335099

NEW: 102335199

NEW: 102335299

NEW: 102335399

NEW: 102335499

NEW: 102335599

NEW: 102335699

NEW: 102335799

NEW: 102335899

NEW: 102335999

NEW: 102336099

NEW: 102336199

NEW: 102336299

NEW: 102336399

NEW: 102336499

NEW: 102336599

NEW: 102336699

NEW: 102336799

NEW: 102336899

NEW: 102336999

NEW: 102337099

NEW: 102337199

NEW: 102337299

NEW: 102337399

NEW: 102337499

NEW: 102337599

NEW: 102337699

NEW: 102337799

NEW: 102337899

NEW: 102337999

NEW: 102338099

NEW: 102338199

NEW: 102338299

NEW: 102338399

NEW: 102338499

NEW: 102338599

NEW: 102338699

NEW: Bloco Espiral Aguarela Cotman

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Bloco Espiral Aguarela Cotman - %' )
NEW: 102338899

NEW: 102338999

UPDATING: Aguarela Winsor & Newton Cotman Pastilha
Product ID: 27486
Image file:

NEW: 102339199

NEW: 102339299

NEW: 102339399

NEW: 102339499

NEW: 102339599

NEW: 102339699

NEW: 102339799

NEW: 102339899

NEW: 102339999

UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 27419
Image file:

UPDATING: Tela Winsor & Newton
Product ID: 27478
Image file:

UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27452
Image file:

NEW: 102341499

NEW: Bloco Aguarela Cotman 425 grs

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Bloco Aguarela Cotman 425 grs - %' )
NEW: 102341999

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

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE '102342099 - %' )
NEW: Bloco Óleo Winsor & Newton Winton 230 gr

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Bloco Óleo Winsor & Newton Winton 230 gr - %' )
NEW: 102342399

NEW: 102342499

NEW: 102342599

NEW: 102342699

NEW: 102342799

NEW: 102342899

NEW: 102342999

NEW: 102343099

NEW: 102343199

Ok.

Product Option Sync.
Opencart products: 201
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 = 27594 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27594, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102338799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3697 AS option_value_id, language_id, 17 AS option_id, '102338799 - Bloco Espiral Aguarela Cotman 190 grs 255 x 175' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 502 AND product_id = 27594 AND option_id = 17 AND option_value_id = 3697
DELETE FROM oc_product WHERE model = '102338799'
INSERT INTO oc_product_option_value SET product_option_id = 502, product_id = 27594, option_id = 17, option_value_id = 3697, quantity = 1, subtract = 1, price = 0.813, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3698 AS option_value_id, language_id, 17 AS option_id, '102341899 - Bloco Espiral Aguarela Cotman 300 grs 25,4 x 17,8' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 502 AND product_id = 27594 AND option_id = 17 AND option_value_id = 3698
DELETE FROM oc_product WHERE model = '102341899'
INSERT INTO oc_product_option_value SET product_option_id = 502, product_id = 27594, option_id = 17, option_value_id = 3698, 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 = 27486 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102339099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1917
UPDATE oc_option_value_description SET name = '102339099 - Aguarela Winsor & Newton Cotman Pastilha Vermelho Cádmio Pálido HUE 103' WHERE option_value_id = 1917 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 458 AND product_id = 27486 AND option_id = 17 AND option_value_id = 1917
DELETE FROM oc_product WHERE model = '102339099'
INSERT INTO oc_product_option_value SET product_option_id = 458, product_id = 27486, option_id = 17, option_value_id = 1917, 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 = 27419 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1918
UPDATE oc_option_value_description SET name = '102340099 - Acrílico Amsterdam 120 ml Burgundy 075' WHERE option_value_id = 1918 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 406 AND product_id = 27419 AND option_id = 17 AND option_value_id = 1918
DELETE FROM oc_product WHERE model = '102340099'
INSERT INTO oc_product_option_value SET product_option_id = 406, product_id = 27419, option_id = 17, option_value_id = 1918, quantity = 1, subtract = 1, price = 1.504, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1919
UPDATE oc_option_value_description SET name = '102340199 - Acrílico Amsterdam 120 ml Copper 214' WHERE option_value_id = 1919 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 406 AND product_id = 27419 AND option_id = 17 AND option_value_id = 1919
DELETE FROM oc_product WHERE model = '102340199'
INSERT INTO oc_product_option_value SET product_option_id = 406, product_id = 27419, option_id = 17, option_value_id = 1919, quantity = 1, subtract = 1, price = 1.504, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1920
UPDATE oc_option_value_description SET name = '102340299 - Acrílico Amsterdam 120 ml Laranja Fluorescente 257' WHERE option_value_id = 1920 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 406 AND product_id = 27419 AND option_id = 17 AND option_value_id = 1920
DELETE FROM oc_product WHERE model = '102340299'
INSERT INTO oc_product_option_value SET product_option_id = 406, product_id = 27419, option_id = 17, option_value_id = 1920, 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 = 27478 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340499 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3699 AS option_value_id, language_id, 17 AS option_id, '102340499 - Tela Winsor & Newton 13 x 18' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3699
DELETE FROM oc_product WHERE model = '102340499'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3699, 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 '102340599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3700 AS option_value_id, language_id, 17 AS option_id, '102340599 - Tela Winsor & Newton 20 x 25' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3700
DELETE FROM oc_product WHERE model = '102340599'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3700, quantity = 1, subtract = 1, price = 0.488, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340699 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3701 AS option_value_id, language_id, 17 AS option_id, '102340699 - Tela Winsor & Newton 20 x 30' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3701
DELETE FROM oc_product WHERE model = '102340699'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3701, quantity = 1, subtract = 1, price = 1.301, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3702 AS option_value_id, language_id, 17 AS option_id, '102340799 - Tela Winsor & Newton 50 x 100' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3702
DELETE FROM oc_product WHERE model = '102340799'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3702, quantity = 1, subtract = 1, price = 11.626, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3703 AS option_value_id, language_id, 17 AS option_id, '102340899 - Tela Winsor & Newton 50 x 60' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3703
DELETE FROM oc_product WHERE model = '102340899'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3703, quantity = 1, subtract = 1, price = 7.479, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102340999 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3704 AS option_value_id, language_id, 17 AS option_id, '102340999 - Tela Winsor & Newton 70 x 100' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3704
DELETE FROM oc_product WHERE model = '102340999'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3704, quantity = 1, subtract = 1, price = 16.666, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341099 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3705 AS option_value_id, language_id, 17 AS option_id, '102341099 - Tela Winsor & Newton 70 x 80' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3705
DELETE FROM oc_product WHERE model = '102341099'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3705, quantity = 1, subtract = 1, price = 13.211, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341199 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3706 AS option_value_id, language_id, 17 AS option_id, '102341199 - Tela Winsor & Newton 80 x 120' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3706
DELETE FROM oc_product WHERE model = '102341199'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3706, quantity = 1, subtract = 1, price = 21.992, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3707 AS option_value_id, language_id, 17 AS option_id, '102341299 - Tela Winsor & Newton Banda Larga 20 x 50' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 451 AND product_id = 27478 AND option_id = 17 AND option_value_id = 3707
DELETE FROM oc_product WHERE model = '102341299'
INSERT INTO oc_product_option_value SET product_option_id = 451, product_id = 27478, option_id = 17, option_value_id = 3707, quantity = 1, subtract = 1, price = 4.715, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

SELECT product_option_id FROM oc_product_option WHERE product_id = 27452 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1921
UPDATE oc_option_value_description SET name = '102341399 - Acrílico Winsor & Newton Galeria 250 ml Preto Fumo (337)' WHERE option_value_id = 1921 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 431 AND product_id = 27452 AND option_id = 17 AND option_value_id = 1921
DELETE FROM oc_product WHERE model = '102341399'
INSERT INTO oc_product_option_value SET product_option_id = 431, product_id = 27452, option_id = 17, option_value_id = 1921, 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 = 27595 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27595, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3708 AS option_value_id, language_id, 17 AS option_id, '102341599 - Bloco Aguarela Cotman 425 grs 40,6 x 30,5' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 503 AND product_id = 27595 AND option_id = 17 AND option_value_id = 3708
DELETE FROM oc_product WHERE model = '102341599'
INSERT INTO oc_product_option_value SET product_option_id = 503, product_id = 27595, option_id = 17, option_value_id = 3708, quantity = 1, subtract = 1, price = 13.293, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341699 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3709 AS option_value_id, language_id, 17 AS option_id, '102341699 - Bloco Aguarela Cotman 425 grs 30,5 x 22,9' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 503 AND product_id = 27595 AND option_id = 17 AND option_value_id = 3709
DELETE FROM oc_product WHERE model = '102341699'
INSERT INTO oc_product_option_value SET product_option_id = 503, product_id = 27595, option_id = 17, option_value_id = 3709, quantity = 1, subtract = 1, price = 4.025, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102341799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3710 AS option_value_id, language_id, 17 AS option_id, '102341799 - Bloco Aguarela Cotman 425 grs 20,3 x 12,7' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 503 AND product_id = 27595 AND option_id = 17 AND option_value_id = 3710
DELETE FROM oc_product WHERE model = '102341799'
INSERT INTO oc_product_option_value SET product_option_id = 503, product_id = 27595, option_id = 17, option_value_id = 3710, 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 = 27598 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27598, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102342199 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3711 AS option_value_id, language_id, 17 AS option_id, '102342199 - Bloco Óleo Winsor & Newton Winton 230 gr 29,7 x 21' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 504 AND product_id = 27598 AND option_id = 17 AND option_value_id = 3711
DELETE FROM oc_product WHERE model = '102342199'
INSERT INTO oc_product_option_value SET product_option_id = 504, product_id = 27598, option_id = 17, option_value_id = 3711, 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 '102342299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3712 AS option_value_id, language_id, 17 AS option_id, '102342299 - Bloco Óleo Winsor & Newton Winton 230 gr 40,5 x 30,5' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 504 AND product_id = 27598 AND option_id = 17 AND option_value_id = 3712
DELETE FROM oc_product WHERE model = '102342299'
INSERT INTO oc_product_option_value SET product_option_id = 504, product_id = 27598, option_id = 17, option_value_id = 3712, quantity = 1, subtract = 1, price = 4.553, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.