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.