Product Sync.
Opencart products: 330
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: 27280
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: 332
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 = 27280 AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '430600299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2841
UPDATE oc_option_value_description SET name = '430600299 - Espátula Pintura N1' WHERE option_value_id = 2841 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2841
DELETE FROM oc_product WHERE model = '430600299'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2841, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2843
UPDATE oc_option_value_description SET name = '430600799 - Espátula Pintura N3' WHERE option_value_id = 2843 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2843
DELETE FROM oc_product WHERE model = '430600799'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2843, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2844
UPDATE oc_option_value_description SET name = '430600899 - Espátula Pintura N4' WHERE option_value_id = 2844 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2844
DELETE FROM oc_product WHERE model = '430600899'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2844, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2845
UPDATE oc_option_value_description SET name = '430600999 - Espátula Pintura N5' WHERE option_value_id = 2845 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2845
DELETE FROM oc_product WHERE model = '430600999'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2845, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2846
UPDATE oc_option_value_description SET name = '430601099 - Espátula Pintura N6' WHERE option_value_id = 2846 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2846
DELETE FROM oc_product WHERE model = '430601099'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2846, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2847
UPDATE oc_option_value_description SET name = '430601399 - Espátula Pintura N9' WHERE option_value_id = 2847 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2847
DELETE FROM oc_product WHERE model = '430601399'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2847, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2848
UPDATE oc_option_value_description SET name = '430601499 - Espátula Pintura N10' WHERE option_value_id = 2848 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2848
DELETE FROM oc_product WHERE model = '430601499'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2848, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2849
UPDATE oc_option_value_description SET name = '430601599 - Espátula Pintura N11' WHERE option_value_id = 2849 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2849
DELETE FROM oc_product WHERE model = '430601599'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2849, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2850
UPDATE oc_option_value_description SET name = '430601699 - Espátula Pintura N12' WHERE option_value_id = 2850 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2850
DELETE FROM oc_product WHERE model = '430601699'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2850, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2851
UPDATE oc_option_value_description SET name = '430601799 - Espátula Pintura N13' WHERE option_value_id = 2851 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2851
DELETE FROM oc_product WHERE model = '430601799'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2851, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2852
UPDATE oc_option_value_description SET name = '430601899 - Espátula Pintura N14' WHERE option_value_id = 2852 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2852
DELETE FROM oc_product WHERE model = '430601899'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2852, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2853
UPDATE oc_option_value_description SET name = '430601999 - Espátula Pintura N15' WHERE option_value_id = 2853 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2853
DELETE FROM oc_product WHERE model = '430601999'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2853, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2854
UPDATE oc_option_value_description SET name = '430602099 - Espátula Pintura N16' WHERE option_value_id = 2854 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2854
DELETE FROM oc_product WHERE model = '430602099'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2854, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2855
UPDATE oc_option_value_description SET name = '430602199 - Espátula Pintura N17' WHERE option_value_id = 2855 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2855
DELETE FROM oc_product WHERE model = '430602199'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2855, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2856
UPDATE oc_option_value_description SET name = '430602299 - Espátula Pintura N18' WHERE option_value_id = 2856 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2856
DELETE FROM oc_product WHERE model = '430602299'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2856, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2857
UPDATE oc_option_value_description SET name = '430602399 - Espátula Pintura N19' WHERE option_value_id = 2857 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2857
DELETE FROM oc_product WHERE model = '430602399'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2857, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2858
UPDATE oc_option_value_description SET name = '430602799 - Espátula Pintura N23' WHERE option_value_id = 2858 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2858
DELETE FROM oc_product WHERE model = '430602799'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2858, 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 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 2859
UPDATE oc_option_value_description SET name = '430602899 - Espátula Pintura N24' WHERE option_value_id = 2859 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 342 AND product_id = 27280 AND option_id = 15 AND option_value_id = 2859
DELETE FROM oc_product WHERE model = '430602899'
INSERT INTO oc_product_option_value SET product_option_id = 342, product_id = 27280, option_id = 15, option_value_id = 2859, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.