Product Sync.
Opencart products: 8
Input products: 100

NEW: 100000099

NEW: 100000199

NEW: 100000299

NEW: 100000399

NEW: 100000499

NEW: 100000599

NEW: 100000699

NEW: 100000799

NEW: 100000899

NEW: 100000999

NEW: PASTA ARQ A4 PP PERS ELBA

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'PASTA ARQ A4 PP PERS ELBA - %' )
NEW: 100001199

NEW: 100001299

NEW: 100001399

NEW: 100001499

NEW: 100001599

NEW: 100001699

NEW: 100001799

NEW: 100001899

NEW: 100001999

NEW: 100002099

NEW: 100002199

NEW: 100002299

NEW: 100002399

NEW: 100002499

NEW: 100002599

NEW: 100002699

NEW: 100002799

NEW: 100002899

NEW: 100002999

NEW: 100003099

NEW: 100003199

NEW: 100003299

NEW: 100003399

NEW: 100003499

NEW: 100003599

NEW: 100003699

NEW: 100003799

NEW: 100003899

NEW: 100003999

NEW: 100004099

NEW: 100004199

NEW: 100004299

NEW: 100004399

NEW: 100004499

NEW: 100004599

NEW: 100004699

NEW: 100004799

NEW: 100004899

NEW: 100004999

NEW: 100005099

NEW: 100005199

NEW: 100005299

NEW: 100005399

NEW: 100005499

NEW: 100005599

NEW: 100005699

NEW: 100005799

NEW: 100005899

NEW: 100005999

NEW: 100006099

NEW: 100006199

NEW: 100006299

NEW: 100006399

NEW: 100006499

NEW: 100006599

NEW: 100006699

NEW: 100006799

NEW: 100006899

NEW: 100006999

NEW: 100007099

NEW: 100007199

NEW: 100007299

NEW: 100007399

NEW: 100007499

NEW: 100007599

NEW: Galeria W&N 120ml

DELETE FROM oc_product_option_value WHERE option_value_id = ( SELECT MAX(option_value_id) FROM oc_option_value_description WHERE name LIKE 'Galeria W&N 120ml - %' )
Ok.

Product Option Sync.
Opencart products: 10
Input products: 100

SELECT option_id FROM oc_option_description WHERE NAME = 'Opção'
INSERT INTO oc_option SET type = 'multiple', sort_order = 0
INSERT INTO oc_option_description SELECT 17 AS option_id, language_id, 'Opção'AS name FROM oc_language
SELECT product_option_id FROM oc_product_option WHERE product_id = 27380 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27380, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100001099 - %'
INSERT INTO oc_option_value SET option_id = 17, image = '', sort_order = 0
INSERT INTO oc_option_value_description SELECT 3232 AS option_value_id, language_id, 17 AS option_id, '100001099 - PASTA ARQ A4 PP PERS ELBA 15MM VDE' AS name FROM oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 373 AND product_id = 27380 AND option_id = 17 AND option_value_id = 3232
DELETE FROM oc_product WHERE model = '100001099'
INSERT INTO oc_product_option_value SET product_option_id = 373, product_id = 27380, option_id = 17, option_value_id = 3232, 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 = 27381 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27381, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100007699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1018
UPDATE oc_option_value_description SET name = '100007699 - ACRIL GALER 120ML BUFF TITANIUM' WHERE option_value_id = 1018 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1018
DELETE FROM oc_product WHERE model = '100007699'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1018, 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 '100007799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1019
UPDATE oc_option_value_description SET name = '100007799 - ACRIL GALER 120ML BURNT SIENNA' WHERE option_value_id = 1019 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1019
DELETE FROM oc_product WHERE model = '100007799'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1019, 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 '100007899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1020
UPDATE oc_option_value_description SET name = '100007899 - ACRIL GALER 120ML BURNT UMBER' WHERE option_value_id = 1020 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1020
DELETE FROM oc_product WHERE model = '100007899'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1020, 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 '100007999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1021
UPDATE oc_option_value_description SET name = '100007999 - ACRIL GALER 120ML CADMIUM ORANGE HUE' WHERE option_value_id = 1021 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1021
DELETE FROM oc_product WHERE model = '100007999'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1021, 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 '100008099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1022
UPDATE oc_option_value_description SET name = '100008099 - ACRIL GALER 120ML CADMIUM RED HUE' WHERE option_value_id = 1022 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1022
DELETE FROM oc_product WHERE model = '100008099'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1022, 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 '100008199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1023
UPDATE oc_option_value_description SET name = '100008199 - ACRIL GALER 120ML CADMIUM YELLOW PALE HUE' WHERE option_value_id = 1023 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1023
DELETE FROM oc_product WHERE model = '100008199'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1023, 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 '100008299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1024
UPDATE oc_option_value_description SET name = '100008299 - ACRIL GALER 120ML CADMIUM YELLOW DEEP HUE' WHERE option_value_id = 1024 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1024
DELETE FROM oc_product WHERE model = '100008299'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1024, 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 '100008399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1025
UPDATE oc_option_value_description SET name = '100008399 - ACRIL GALER 120ML CADMIUM YELLOW MEDIUM HUE' WHERE option_value_id = 1025 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1025
DELETE FROM oc_product WHERE model = '100008399'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1025, 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 '100008499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1026
UPDATE oc_option_value_description SET name = '100008499 - ACRIL GALER 120ML CERULEAN BLUE HUE' WHERE option_value_id = 1026 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1026
DELETE FROM oc_product WHERE model = '100008499'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1026, 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 '100008599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1027
UPDATE oc_option_value_description SET name = '100008599 - ACRIL GALER 120ML COBALT BLUE HUE' WHERE option_value_id = 1027 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1027
DELETE FROM oc_product WHERE model = '100008599'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1027, 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 '100008699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1028
UPDATE oc_option_value_description SET name = '100008699 - ACRIL GALER 120ML CRIMSON' WHERE option_value_id = 1028 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1028
DELETE FROM oc_product WHERE model = '100008699'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1028, 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 '100008799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1029
UPDATE oc_option_value_description SET name = '100008799 - ACRIL GALER 120ML DEEP TURQUOISE' WHERE option_value_id = 1029 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1029
DELETE FROM oc_product WHERE model = '100008799'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1029, 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 '100008899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1030
UPDATE oc_option_value_description SET name = '100008899 - ACRIL GALER 120ML IVORY BLACK' WHERE option_value_id = 1030 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1030
DELETE FROM oc_product WHERE model = '100008899'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1030, 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 '100008999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1031
UPDATE oc_option_value_description SET name = '100008999 - ACRIL GALER 120ML LEMON YELLOW 346' WHERE option_value_id = 1031 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1031
DELETE FROM oc_product WHERE model = '100008999'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1031, 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 '100009099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1032
UPDATE oc_option_value_description SET name = '100009099 - ACRIL GALER 120ML MARS BLACK Test' WHERE option_value_id = 1032 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1032
DELETE FROM oc_product WHERE model = '100009099'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1032, 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 '100009199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1033
UPDATE oc_option_value_description SET name = '100009199 - ACRIL GALER 120ML MIXING WHITE 415' WHERE option_value_id = 1033 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1033
DELETE FROM oc_product WHERE model = '100009199'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1033, 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 '100009299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1034
UPDATE oc_option_value_description SET name = '100009299 - ACRIL GALER 120ML NAPLES YELLOW' WHERE option_value_id = 1034 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1034
DELETE FROM oc_product WHERE model = '100009299'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1034, 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 '100009399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1035
UPDATE oc_option_value_description SET name = '100009399 - ACRIL GALER 120ML PALE TERRACOTTA' WHERE option_value_id = 1035 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1035
DELETE FROM oc_product WHERE model = '100009399'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1035, 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 '100009499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1073
UPDATE oc_option_value_description SET name = '100009499 - ACRIL GALER 120ML POWDER BLUE' WHERE option_value_id = 1073 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1073
DELETE FROM oc_product WHERE model = '100009499'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1073, 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 '100009599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1074
UPDATE oc_option_value_description SET name = '100009599 - ACRIL GALER 120ML OLIVE GREEN' WHERE option_value_id = 1074 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1074
DELETE FROM oc_product WHERE model = '100009599'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1074, 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 '100009699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1075
UPDATE oc_option_value_description SET name = '100009699 - ACRIL GALER 120ML OPERA ROSE' WHERE option_value_id = 1075 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1075
DELETE FROM oc_product WHERE model = '100009699'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1075, 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 '100009799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1076
UPDATE oc_option_value_description SET name = '100009799 - ACRIL GALER 120ML PAYNES GRAY' WHERE option_value_id = 1076 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1076
DELETE FROM oc_product WHERE model = '100009799'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1076, 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 '100009899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1077
UPDATE oc_option_value_description SET name = '100009899 - ACRIL GALER 120ML PERM ALIZ CRIMSON' WHERE option_value_id = 1077 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1077
DELETE FROM oc_product WHERE model = '100009899'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1077, 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 '100009999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1135
UPDATE oc_option_value_description SET name = '100009999 - ACRIL GALER 120ML PERMANENT GREEN LIGHT' WHERE option_value_id = 1135 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 374 AND product_id = 27381 AND option_id = 17 AND option_value_id = 1135
DELETE FROM oc_product WHERE model = '100009999'
INSERT INTO oc_product_option_value SET product_option_id = 374, product_id = 27381, option_id = 17, option_value_id = 1135, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.