Product Sync.
Opencart products: 244
Input products: 100

NEW: 426021699

NEW: 426022099

NEW: 426023799

NEW: 426024199

NEW: 426024799

NEW: 426027299

NEW: 426309099

NEW: 427000199

NEW: 427040099

NEW: 427201899

NEW: 427202399

NEW: 427202699

NEW: 427440099

NEW: 427450099

NEW: 427450199

NEW: 427470099

NEW: 427498799

NEW: 427660099

NEW: 427735099

NEW: 428600199

NEW: 429100299

NEW: 429100699

NEW: 429101199

NEW: 429700499

NEW: 429700599

NEW: 429701299

NEW: 429701399

NEW: 429701699

NEW: 429701799

NEW: 429701899

NEW: 429701999

NEW: 429702299

NEW: 429702399

NEW: 429703299

NEW: 430102499

NEW: 430102599

NEW: 430103399

NEW: 430103499

NEW: 430103599

NEW: 430103799

NEW: 430103899

NEW: 430103999

NEW: 430104099

NEW: 430104199

NEW: 430104299

NEW: 430104399

NEW: 430104499

NEW: 430104599

NEW: 430104799

NEW: 430104899

NEW: 430104999

NEW: 430105099

NEW: 430105199

NEW: 430105299

NEW: 430105399

NEW: 430105699

NEW: 430105899

NEW: 430106199

NEW: 430106399

NEW: 430106499

NEW: 430106599

NEW: 430106699

NEW: 430106999

NEW: 430107499

NEW: 430107899

NEW: 430108299

NEW: 430108399

NEW: 430108899

NEW: 430109199

NEW: 430109399

NEW: 430109499

NEW: 430109899

NEW: 430109999

NEW: 430110099

UPDATING: Espátula Pintura
Product ID: 27602
Image file:

NEW: 430600399

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

NEW: 430602999

NEW: 430603299

NEW: 431117899

NEW: 431117999

NEW: 431418999

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

Ok.

Product Option Sync.
Opencart products: 246
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 = 27602 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '430600299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3860 AS option_value_id, language_id, 17 AS option_id, '430600299 - Espátula Pintura N1' 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 = 3860
DELETE FROM oc_product WHERE model = '430600299'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3860, 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 '430600799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3861 AS option_value_id, language_id, 17 AS option_id, '430600799 - Espátula Pintura N3' 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 = 3861
DELETE FROM oc_product WHERE model = '430600799'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3861, 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 '430600899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3862 AS option_value_id, language_id, 17 AS option_id, '430600899 - Espátula Pintura N4' 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 = 3862
DELETE FROM oc_product WHERE model = '430600899'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3862, 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 '430600999 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3863 AS option_value_id, language_id, 17 AS option_id, '430600999 - Espátula Pintura N5' 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 = 3863
DELETE FROM oc_product WHERE model = '430600999'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3863, 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 '430601099 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3864 AS option_value_id, language_id, 17 AS option_id, '430601099 - Espátula Pintura N6' 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 = 3864
DELETE FROM oc_product WHERE model = '430601099'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3864, 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 '430601399 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3865 AS option_value_id, language_id, 17 AS option_id, '430601399 - Espátula Pintura N9' 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 = 3865
DELETE FROM oc_product WHERE model = '430601399'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3865, 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 '430601499 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3866 AS option_value_id, language_id, 17 AS option_id, '430601499 - Espátula Pintura N10' 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 = 3866
DELETE FROM oc_product WHERE model = '430601499'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3866, 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 '430601599 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3867 AS option_value_id, language_id, 17 AS option_id, '430601599 - Espátula Pintura N11' 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 = 3867
DELETE FROM oc_product WHERE model = '430601599'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3867, 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 '430601699 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3868 AS option_value_id, language_id, 17 AS option_id, '430601699 - Espátula Pintura N12' 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 = 3868
DELETE FROM oc_product WHERE model = '430601699'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3868, 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 '430601799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3869 AS option_value_id, language_id, 17 AS option_id, '430601799 - Espátula Pintura N13' 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 = 3869
DELETE FROM oc_product WHERE model = '430601799'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3869, 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 '430601899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3870 AS option_value_id, language_id, 17 AS option_id, '430601899 - Espátula Pintura N14' 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 = 3870
DELETE FROM oc_product WHERE model = '430601899'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3870, 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 '430601999 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3871 AS option_value_id, language_id, 17 AS option_id, '430601999 - Espátula Pintura N15' 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 = 3871
DELETE FROM oc_product WHERE model = '430601999'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3871, 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 '430602099 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3872 AS option_value_id, language_id, 17 AS option_id, '430602099 - Espátula Pintura N16' 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 = 3872
DELETE FROM oc_product WHERE model = '430602099'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3872, 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 '430602199 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3873 AS option_value_id, language_id, 17 AS option_id, '430602199 - Espátula Pintura N17' 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 = 3873
DELETE FROM oc_product WHERE model = '430602199'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3873, 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 '430602299 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3874 AS option_value_id, language_id, 17 AS option_id, '430602299 - Espátula Pintura N18' 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 = 3874
DELETE FROM oc_product WHERE model = '430602299'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3874, 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 '430602399 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3875 AS option_value_id, language_id, 17 AS option_id, '430602399 - Espátula Pintura N19' 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 = 3875
DELETE FROM oc_product WHERE model = '430602399'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3875, 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 '430602799 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3876 AS option_value_id, language_id, 17 AS option_id, '430602799 - Espátula Pintura N23' 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 = 3876
DELETE FROM oc_product WHERE model = '430602799'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3876, 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 '430602899 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3877 AS option_value_id, language_id, 17 AS option_id, '430602899 - Espátula Pintura N24' 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 = 3877
DELETE FROM oc_product WHERE model = '430602899'
INSERT INTO oc_product_option_value SET product_option_id = 505, product_id = 27602, option_id = 17, option_value_id = 3877, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.