Product Sync.
Opencart products: 201
Input products: 100

NEW: 102343399

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

UPDATING: Tinta da China Winsor & Newton
Product ID: 27479
Image file:

NEW: 102343899

NEW: 102344099

NEW: 102344299

NEW: 102344699

NEW: 102344899

NEW: 102344999

NEW: 102345099

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

NEW: 102345299

NEW: 102345399

NEW: 102345499

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

NEW: 102345699

NEW: 102345799

NEW: 102345899

NEW: 102345999

NEW: 102346099

NEW: 102346199

NEW: 102346299

NEW: 102346399

NEW: Espátula Pintura

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Espátula Pintura - %' )
NEW: 102347499

NEW: 102347599

NEW: 102347699

NEW: 102347799

NEW: 102347899

NEW: 102347999

NEW: 102348099

NEW: 102348199

NEW: 102348299

NEW: 102348399

NEW: 102348499

NEW: 102348599

NEW: 102348699

NEW: 102348799

NEW: 102348899

NEW: 102348999

NEW: 102349099

NEW: 102349199

NEW: 102349299

NEW: 102349399

NEW: 102349499

NEW: 102349599

NEW: 102349699

NEW: 102349799

NEW: 102349899

NEW: 102349999

NEW: 102350099

NEW: 102350199

NEW: 102350299

NEW: 102350399

NEW: 102350499

NEW: 102350599

NEW: 102350699

NEW: 102350799

NEW: 102350899

NEW: 102350999

NEW: 102351099

NEW: 102351199

NEW: 102351299

NEW: 102351399

NEW: 102351499

NEW: 102351599

NEW: 102351699

NEW: 102351799

NEW: 102351899

NEW: 102351999

NEW: 102352099

NEW: 102352199

NEW: 102352299

NEW: 102352399

NEW: 102352499

NEW: 102352599

NEW: 102352699

NEW: 102352799

NEW: 102352899

NEW: 102352999

NEW: 102353099

NEW: 102353199

NEW: 102353299

Ok.

Product Option Sync.
Opencart products: 205
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 = 27479 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102343599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3713 AS option_value_id, language_id, 17 AS option_id, '102343599 - Tinta da China Winsor & Newton Vermelho Escuro 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3713
DELETE FROM oc_product WHERE model = '102343599'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3713, 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 '102343699 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3714 AS option_value_id, language_id, 17 AS option_id, '102343699 - Tinta da China Winsor & Newton Amarelo Canário 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3714
DELETE FROM oc_product WHERE model = '102343699'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3714, 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 '102343799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3715 AS option_value_id, language_id, 17 AS option_id, '102343799 - Tinta da China Winsor & Newton Carmim 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3715
DELETE FROM oc_product WHERE model = '102343799'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3715, 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 '102343999 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3716 AS option_value_id, language_id, 17 AS option_id, '102343999 - Tinta da China Winsor & Newton Castanho Nut 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3716
DELETE FROM oc_product WHERE model = '102343999'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3716, 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 '102344199 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3717 AS option_value_id, language_id, 17 AS option_id, '102344199 - Tinta da China Winsor & Newton Vermelho Tijolo 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3717
DELETE FROM oc_product WHERE model = '102344199'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3717, 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 '102344399 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3718 AS option_value_id, language_id, 17 AS option_id, '102344399 - Tinta da China Winsor & Newton Scralet 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3718
DELETE FROM oc_product WHERE model = '102344399'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3718, 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 '102344499 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3719 AS option_value_id, language_id, 17 AS option_id, '102344499 - Tinta da China Winsor & Newton Laranja 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3719
DELETE FROM oc_product WHERE model = '102344499'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3719, 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 '102344599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3720 AS option_value_id, language_id, 17 AS option_id, '102344599 - Tinta da China Winsor & Newton Verde Brilhante 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3720
DELETE FROM oc_product WHERE model = '102344599'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3720, 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 '102344799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3721 AS option_value_id, language_id, 17 AS option_id, '102344799 - Tinta da China Winsor & Newton Prata 14 ml' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 452 AND product_id = 27479 AND option_id = 17 AND option_value_id = 3721
DELETE FROM oc_product WHERE model = '102344799'
INSERT INTO oc_product_option_value SET product_option_id = 452, product_id = 27479, option_id = 17, option_value_id = 3721, 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 = 27602 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27602, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '102346499 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3722 AS option_value_id, language_id, 17 AS option_id, '102346499 - Espátula Pintura N25' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3722
DELETE FROM oc_product WHERE model = '102346499'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3722, 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 '102346599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3723 AS option_value_id, language_id, 17 AS option_id, '102346599 - Espátula Pintura N29' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3723
DELETE FROM oc_product WHERE model = '102346599'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3723, 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 '102346699 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3724 AS option_value_id, language_id, 17 AS option_id, '102346699 - Espátula Pintura N30' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3724
DELETE FROM oc_product WHERE model = '102346699'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3724, 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 '102346799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3725 AS option_value_id, language_id, 17 AS option_id, '102346799 - Espátula Pintura N27' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3725
DELETE FROM oc_product WHERE model = '102346799'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3725, 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 '102346899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3726 AS option_value_id, language_id, 17 AS option_id, '102346899 - Espátula Pintura N20' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3726
DELETE FROM oc_product WHERE model = '102346899'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3726, 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 '102346999 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3727 AS option_value_id, language_id, 17 AS option_id, '102346999 - Espátula Pintura N22' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3727
DELETE FROM oc_product WHERE model = '102346999'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3727, 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 '102347099 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3728 AS option_value_id, language_id, 17 AS option_id, '102347099 - Espátula Pintura N28' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3728
DELETE FROM oc_product WHERE model = '102347099'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3728, 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 '102347199 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3729 AS option_value_id, language_id, 17 AS option_id, '102347199 - Espátula Pintura N21' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3729
DELETE FROM oc_product WHERE model = '102347199'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3729, 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 '102347299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3730 AS option_value_id, language_id, 17 AS option_id, '102347299 - Espátula Pintura N2' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3730
DELETE FROM oc_product WHERE model = '102347299'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3730, 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 '102347399 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3731 AS option_value_id, language_id, 17 AS option_id, '102347399 - Espátula Pintura N26' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 505 AND product_id = 27602 AND option_id = 17 AND option_value_id = 3731
DELETE FROM oc_product WHERE model = '102347399'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3731, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.