Product Sync.
Opencart products: 23
Input products: 100

NEW: 100982999

NEW: 100983099

NEW: 100983199

NEW: 100983299

NEW: 100983399

NEW: 100983499

NEW: 100983599

NEW: 100983699

NEW: 100983799

NEW: 100983899

NEW: 100983999

NEW: 100984099

NEW: 100984199

NEW: 100984299

NEW: 100984399

NEW: 100984499

NEW: 100984599

NEW: 100984699

NEW: 100984799

NEW: 100984899

NEW: 100984999

NEW: 100985099

NEW: 100985199

NEW: 100985299

NEW: 100985399

NEW: 100985499

NEW: 100985599

NEW: 100985699

NEW: 100985799

NEW: 100985899

NEW: 100985999

NEW: 100986099

NEW: 100986199

NEW: 100986299

NEW: 100986399

NEW: 100986499

NEW: 100986599

NEW: 100986699

NEW: 100986799

NEW: 100986899

NEW: 100986999

NEW: 100987099

NEW: 100987199

NEW: 100987299

NEW: 100987399

NEW: 100987499

NEW: 100987599

NEW: 100987699

UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:

NEW: 100987899

NEW: 100987999

NEW: 100988099

NEW: 100988199

NEW: 100988299

NEW: 100988399

NEW: 100988499

NEW: 100988599

NEW: 100988699

NEW: 100988799

NEW: 100988899

NEW: 100988999

NEW: 100989099

NEW: 100989199

NEW: Cotman W&N Pastilha

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

Product Option Sync.
Opencart products: 24
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 = 27391 AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100987799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 985
UPDATE oc_option_value_description SET name = '100987799 - AGUAR ECOLINE TALENS 25-30 ML ULTRAMAR DEEP 506' WHERE option_value_id = 985 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 384 AND product_id = 27391 AND option_id = 17 AND option_value_id = 985
DELETE FROM oc_product WHERE model = '100987799'
INSERT INTO oc_product_option_value SET product_option_id = 384, product_id = 27391, option_id = 17, option_value_id = 985, 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 = 27395 AND option_id = 17
INSERT INTO oc_product_option SET product_id = 27395, option_id = 17, value = '', required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description WHERE name LIKE '100989299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 980
UPDATE oc_option_value_description SET name = '100989299 - AGUAR W&N COTMAN PASTILHA ALIZARIN CRIMSON HUE 003' WHERE option_value_id = 980 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 980
DELETE FROM oc_product WHERE model = '100989299'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 980, 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 '100989399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 981
UPDATE oc_option_value_description SET name = '100989399 - AGUAR W&N COTMAN PASTILHA BURNT SIENNA 074' WHERE option_value_id = 981 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 981
DELETE FROM oc_product WHERE model = '100989399'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 981, 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 '100989499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 982
UPDATE oc_option_value_description SET name = '100989499 - AGUAR W&N COTMAN PASTILHA BURNT UMBER 076' WHERE option_value_id = 982 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 982
DELETE FROM oc_product WHERE model = '100989499'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 982, 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 '100989599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 983
UPDATE oc_option_value_description SET name = '100989599 - AGUAR W&N COTMAN PASTILHA CADMIUM ORANGE HUE 090' WHERE option_value_id = 983 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 983
DELETE FROM oc_product WHERE model = '100989599'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 983, 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 '100989699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 984
UPDATE oc_option_value_description SET name = '100989699 - AGUAR W&N COTMAN PASTILHA CADMIUM RED HUE 095' WHERE option_value_id = 984 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 984
DELETE FROM oc_product WHERE model = '100989699'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 984, 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 '100989799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 975
UPDATE oc_option_value_description SET name = '100989799 - AGUAR W&N COTMAN PASTILHA CADMIUM RED DEEP HUE 098' WHERE option_value_id = 975 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 975
DELETE FROM oc_product WHERE model = '100989799'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 975, 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 '100989899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 976
UPDATE oc_option_value_description SET name = '100989899 - AGUAR W&N COTMAN PASTILHA CADMIUM YELLOW HUE 109' WHERE option_value_id = 976 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 976
DELETE FROM oc_product WHERE model = '100989899'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 976, 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 '100989999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 977
UPDATE oc_option_value_description SET name = '100989999 - AGUAR W&N COTMAN PASTILHA CADMIUM YELLOW PALE HUE 119' WHERE option_value_id = 977 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 977
DELETE FROM oc_product WHERE model = '100989999'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 977, 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 '100990099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 978
UPDATE oc_option_value_description SET name = '100990099 - AGUAR W&N COTMAN PASTILHA CERULEAN PALE HUE 139' WHERE option_value_id = 978 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 978
DELETE FROM oc_product WHERE model = '100990099'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 978, 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 '100990199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 979
UPDATE oc_option_value_description SET name = '100990199 - AGUAR W&N COTMAN PASTILHA CHINESE WHITE 150' WHERE option_value_id = 979 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 979
DELETE FROM oc_product WHERE model = '100990199'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 979, 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 '100990299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 986
UPDATE oc_option_value_description SET name = '100990299 - AGUAR W&N COTMAN PASTILHA COBALT BLUE HUE 179' WHERE option_value_id = 986 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 986
DELETE FROM oc_product WHERE model = '100990299'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 986, 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 '100990399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 987
UPDATE oc_option_value_description SET name = '100990399 - AGUAR W&N COTMAN PASTILHA DIOXAZINE VIOLET 231' WHERE option_value_id = 987 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 987
DELETE FROM oc_product WHERE model = '100990399'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 987, 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 '100990499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 988
UPDATE oc_option_value_description SET name = '100990499 - AGUAR W&N COTMAN PASTILHA EMERALD 235' WHERE option_value_id = 988 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 988
DELETE FROM oc_product WHERE model = '100990499'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 988, 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 '100990599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 989
UPDATE oc_option_value_description SET name = '100990599 - AGUAR W&N COTMAN PASTILHA GAMBOGE HUE 266' WHERE option_value_id = 989 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 989
DELETE FROM oc_product WHERE model = '100990599'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 989, 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 '100990699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 990
UPDATE oc_option_value_description SET name = '100990699 - AGUAR W&N COTMAN PASTILHA HOKERS GREEN DARK 312' WHERE option_value_id = 990 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 990
DELETE FROM oc_product WHERE model = '100990699'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 990, 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 '100990799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 991
UPDATE oc_option_value_description SET name = '100990799 - AGUAR W&N COTMAN PASTILHA HOOKERS GREEN LIGHT 314' WHERE option_value_id = 991 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 991
DELETE FROM oc_product WHERE model = '100990799'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 991, 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 '100990899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 992
UPDATE oc_option_value_description SET name = '100990899 - AGUAR W&N COTMAN PASTILHA INDIAN RED 317' WHERE option_value_id = 992 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 992
DELETE FROM oc_product WHERE model = '100990899'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 992, 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 '100990999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 993
UPDATE oc_option_value_description SET name = '100990999 - AGUAR W&N COTMAN PASTILHA INDIGO 322' WHERE option_value_id = 993 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 993
DELETE FROM oc_product WHERE model = '100990999'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 993, 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 '100991099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 994
UPDATE oc_option_value_description SET name = '100991099 - AGUAR W&N COTMAN PASTILHA INTENSE BLUE 327' WHERE option_value_id = 994 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 994
DELETE FROM oc_product WHERE model = '100991099'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 994, 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 '100991199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 995
UPDATE oc_option_value_description SET name = '100991199 - AGUAR W&N COTMAN PASTILHA INTENSE GREEN 329' WHERE option_value_id = 995 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 995
DELETE FROM oc_product WHERE model = '100991199'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 995, 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 '100991299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 996
UPDATE oc_option_value_description SET name = '100991299 - AGUAR W&N COTMAN PASTILHA IVORY BLACK 331' WHERE option_value_id = 996 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 996
DELETE FROM oc_product WHERE model = '100991299'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 996, 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 '100991399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 997
UPDATE oc_option_value_description SET name = '100991399 - AGUAR W&N COTMAN PASTILHA LAMP BLACK 337' WHERE option_value_id = 997 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 997
DELETE FROM oc_product WHERE model = '100991399'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 997, 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 '100991499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 998
UPDATE oc_option_value_description SET name = '100991499 - AGUAR W&N COTMAN PASTILHA LEMON YELLOW HUE 346' WHERE option_value_id = 998 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 998
DELETE FROM oc_product WHERE model = '100991499'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 998, 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 '100991599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 999
UPDATE oc_option_value_description SET name = '100991599 - AGUAR W&N COTMAN PASTILHA LIGHT RED 362' WHERE option_value_id = 999 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 999
DELETE FROM oc_product WHERE model = '100991599'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 999, 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 '100991699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1000
UPDATE oc_option_value_description SET name = '100991699 - AGUAR W&N COTMAN PASTILHA MAUVE 398' WHERE option_value_id = 1000 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1000
DELETE FROM oc_product WHERE model = '100991699'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1000, 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 '100991799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1001
UPDATE oc_option_value_description SET name = '100991799 - AGUAR W&N COTMAN PASTILHA PAYNES GRAY 465' WHERE option_value_id = 1001 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1001
DELETE FROM oc_product WHERE model = '100991799'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1001, 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 '100991899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1002
UPDATE oc_option_value_description SET name = '100991899 - AGUAR W&N COTMAN PASTILHA PERMANENT ROSE 502' WHERE option_value_id = 1002 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1002
DELETE FROM oc_product WHERE model = '100991899'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1002, 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 '100991999 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1003
UPDATE oc_option_value_description SET name = '100991999 - AGUAR W&N COTMAN PASTILHA PRUSSIAN BLUE 538' WHERE option_value_id = 1003 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1003
DELETE FROM oc_product WHERE model = '100991999'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1003, 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 '100992099 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1004
UPDATE oc_option_value_description SET name = '100992099 - AGUAR W&N COTMAN PASTILHA PURPLE LAKE 544' WHERE option_value_id = 1004 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1004
DELETE FROM oc_product WHERE model = '100992099'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1004, 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 '100992199 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1005
UPDATE oc_option_value_description SET name = '100992199 - AGUAR W&N COTMAN PASTILHA RAW SIENNA 552' WHERE option_value_id = 1005 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1005
DELETE FROM oc_product WHERE model = '100992199'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1005, 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 '100992299 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1006
UPDATE oc_option_value_description SET name = '100992299 - AGUAR W&N COTMAN PASTILHA RAW UMBER 554' WHERE option_value_id = 1006 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1006
DELETE FROM oc_product WHERE model = '100992299'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1006, 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 '100992399 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1007
UPDATE oc_option_value_description SET name = '100992399 - AGUAR W&N COTMAN PASTILHA ROSE MADDER HUE 580' WHERE option_value_id = 1007 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1007
DELETE FROM oc_product WHERE model = '100992399'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1007, 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 '100992499 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1008
UPDATE oc_option_value_description SET name = '100992499 - AGUAR W&N COTMAN PASTILHA SAP GREEN 599' WHERE option_value_id = 1008 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1008
DELETE FROM oc_product WHERE model = '100992499'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1008, 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 '100992599 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1009
UPDATE oc_option_value_description SET name = '100992599 - AGUAR W&N COTMAN PASTILHA SEPIA 609' WHERE option_value_id = 1009 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1009
DELETE FROM oc_product WHERE model = '100992599'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1009, 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 '100992699 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1010
UPDATE oc_option_value_description SET name = '100992699 - AGUAR W&N COTMAN PASTILHA TURQUOISE 654' WHERE option_value_id = 1010 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1010
DELETE FROM oc_product WHERE model = '100992699'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1010, 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 '100992799 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1522
UPDATE oc_option_value_description SET name = '100992799 - AGUAR W&N COTMAN PASTILHA ULTRAMARINE 660' WHERE option_value_id = 1522 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1522
DELETE FROM oc_product WHERE model = '100992799'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1522, 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 '100992899 - %'
UPDATE oc_option_value SET image = NULL WHERE option_value_id = 1523
UPDATE oc_option_value_description SET name = '100992899 - AGUAR W&N COTMAN PASTILHA VANDYKE BROWN 676' WHERE option_value_id = 1523 SELECT DISTINCT product_option_value_id FROM oc_product_option_value WHERE product_option_id = 388 AND product_id = 27395 AND option_id = 17 AND option_value_id = 1523
DELETE FROM oc_product WHERE model = '100992899'
INSERT INTO oc_product_option_value SET product_option_id = 388, product_id = 27395, option_id = 17, option_value_id = 1523, quantity = 1, subtract = 1, price = 0, price_prefix = '+', points = 0, points_prefix = '+', weight = 0, weight_prefix = '+'

Ok.