Product Sync.
Opencart products: 31
Input products: 100
NEW: 479205420
NEW: 479206799
NEW: 479299199
NEW: 479299299
NEW: 479299399
NEW: 479300099
NEW: 479300199
NEW: 479300299
NEW: 479501099
NEW: 479501199
NEW: 479501299
NEW: 479501599
UPDATING: Amsterdam 120ml
Product ID: 27385
Image file: Amsterdam 120ml.jpg
NEW: Van Gogh 40ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Van Gogh 40ml - %'
)
NEW: 479806699
NEW: 479806799
NEW: 479806899
NEW: 479806999
NEW: 479807099
NEW: 479807199
NEW: 479807399
NEW: 479807599
NEW: 479807699
NEW: 479808299
NEW: 479808499
NEW: 479808599
NEW: 479808699
NEW: 479808799
NEW: 479808899
NEW: 479808999
NEW: 479809599
NEW: 479809799
NEW: 479809899
NEW: 479809999
UPDATING: Galeria W&N 60ml
Product ID: 27386
Image file:
UPDATING: Galeria W&N 250ml
Product ID: 27392
Image file:
UPDATING: Galeria W&N 500ml
Product ID: 27398
Image file:
NEW: 479819299
NEW: 479819399
NEW: 479819499
NEW: 479820699
NEW: 479821299
Ok.
Product Option Sync.
Opencart products: 32
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 = 27385
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479801999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1331
UPDATE oc_option_value_description
SET
name = '479801999 - ACRIL AMST 120 ML BCO ZINCO 104'
WHERE
option_value_id = 1331
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1331
DELETE FROM oc_product
WHERE
model = '479801999'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1331,
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 '479802299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1211
UPDATE oc_option_value_description
SET
name = '479802299 - ACRIL AMST 120ML AMA NAPOLES ESC 223'
WHERE
option_value_id = 1211
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1211
DELETE FROM oc_product
WHERE
model = '479802299'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1211,
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 '479802399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1212
UPDATE oc_option_value_description
SET
name = '479802399 - ACRIL AMST 120ML AMA NAPOLES AVERMELH 224'
WHERE
option_value_id = 1212
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1212
DELETE FROM oc_product
WHERE
model = '479802399'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1212,
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 '479802699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1213
UPDATE oc_option_value_description
SET
name = '479802699 - ACRIL AMST 120ML AMA AZO CLR 268'
WHERE
option_value_id = 1213
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1213
DELETE FROM oc_product
WHERE
model = '479802699'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1213,
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 '479803499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1214
UPDATE oc_option_value_description
SET
name = '479803499 - ACRIL AMST 120ML VERM NAFTOL ESC 399'
WHERE
option_value_id = 1214
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1214
DELETE FROM oc_product
WHERE
model = '479803499'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1214,
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 '479804399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1215
UPDATE oc_option_value_description
SET
name = '479804399 - ACRIL AMST 120ML AZL PRUSIA FTALO 566'
WHERE
option_value_id = 1215
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1215
DELETE FROM oc_product
WHERE
model = '479804399'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1215,
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 '479804499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1216
UPDATE oc_option_value_description
SET
name = '479804499 - ACRIL AMST 120ML AZL FTALO PRIMARIO 570'
WHERE
option_value_id = 1216
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1216
DELETE FROM oc_product
WHERE
model = '479804499'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1216,
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 '479804599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1217
UPDATE oc_option_value_description
SET
name = '479804599 - ACRIL AMST 120ML VDE AMARELADO 617'
WHERE
option_value_id = 1217
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1217
DELETE FROM oc_product
WHERE
model = '479804599'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1217,
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 '479804799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1218
UPDATE oc_option_value_description
SET
name = '479804799 - ACRIL AMST 120ML PRAT METAL 800'
WHERE
option_value_id = 1218
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1218
DELETE FROM oc_product
WHERE
model = '479804799'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1218,
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1219
UPDATE oc_option_value_description
SET
name = '479804899 - ACRIL AMST 120ML OURO CLR METAL 802'
WHERE
option_value_id = 1219
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1219
DELETE FROM oc_product
WHERE
model = '479804899'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1219,
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479804999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1220
UPDATE oc_option_value_description
SET
name = '479804999 - ACRIL AMST 120ML OURO ESC METAL 803'
WHERE
option_value_id = 1220
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 378
AND product_id = 27385
AND option_id = 17
AND option_value_id = 1220
DELETE FROM oc_product
WHERE
model = '479804999'
INSERT INTO oc_product_option_value
SET
product_option_id = 378,
product_id = 27385,
option_id = 17,
option_value_id = 1220,
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27404
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27404,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479806599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1221
UPDATE oc_option_value_description
SET
name = '479806599 - ACRIL VAN GOGH T9-40ML BCO TITANIO'
WHERE
option_value_id = 1221
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1221
DELETE FROM oc_product
WHERE
model = '479806599'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1221,
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 '479833399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1222
UPDATE oc_option_value_description
SET
name = '479833399 - ACRIL VAN GOGH T9-40ML AMA NAPOLES ESC'
WHERE
option_value_id = 1222
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1222
DELETE FROM oc_product
WHERE
model = '479833399'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1222,
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 '479833499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1223
UPDATE oc_option_value_description
SET
name = '479833499 - ACRIL VAN GOGH T9-40ML AMA NAPOLES AVERMELH'
WHERE
option_value_id = 1223
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1223
DELETE FROM oc_product
WHERE
model = '479833499'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1223,
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 '479833599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1224
UPDATE oc_option_value_description
SET
name = '479833599 - ACRIL VAN GOGH T9-40ML AMA OCRE'
WHERE
option_value_id = 1224
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1224
DELETE FROM oc_product
WHERE
model = '479833599'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1224,
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 '479833699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1225
UPDATE oc_option_value_description
SET
name = '479833699 - ACRIL VAN GOGH T9-40ML AMA OCRE CLR'
WHERE
option_value_id = 1225
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1225
DELETE FROM oc_product
WHERE
model = '479833699'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1225,
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 '479833799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1226
UPDATE oc_option_value_description
SET
name = '479833799 - ACRIL VAN GOGH T9-40ML TERRA SIENA NATURAL'
WHERE
option_value_id = 1226
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1226
DELETE FROM oc_product
WHERE
model = '479833799'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1226,
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 '479833899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1227
UPDATE oc_option_value_description
SET
name = '479833899 - ACRIL VAN GOGH T9-40ML AMA AZO LIMAO'
WHERE
option_value_id = 1227
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1227
DELETE FROM oc_product
WHERE
model = '479833899'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1227,
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 '479833999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1228
UPDATE oc_option_value_description
SET
name = '479833999 - ACRIL VAN GOGH T9-40ML AMA AZO CLR'
WHERE
option_value_id = 1228
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1228
DELETE FROM oc_product
WHERE
model = '479833999'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1228,
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 '479834099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1229
UPDATE oc_option_value_description
SET
name = '479834099 - ACRIL VAN GOGH T9-40ML AMA AZO MEDIO'
WHERE
option_value_id = 1229
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 397
AND product_id = 27404
AND option_id = 17
AND option_value_id = 1229
DELETE FROM oc_product
WHERE
model = '479834099'
INSERT INTO oc_product_option_value
SET
product_option_id = 397,
product_id = 27404,
option_id = 17,
option_value_id = 1229,
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 = 27386
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479810199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1047
UPDATE oc_option_value_description
SET
name = '479810199 - ACRIL W&N GALER 60ML CADM YEL PALE HU'
WHERE
option_value_id = 1047
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1047
DELETE FROM oc_product
WHERE
model = '479810199'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1047,
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 '479810299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1048
UPDATE oc_option_value_description
SET
name = '479810299 - ACRIL W&N GALER 60ML CADMIUM RED HUE'
WHERE
option_value_id = 1048
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1048
DELETE FROM oc_product
WHERE
model = '479810299'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1048,
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 '479810399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1049
UPDATE oc_option_value_description
SET
name = '479810399 - ACRIL W&N GALER 60ML CADM ORANGE HUE'
WHERE
option_value_id = 1049
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1049
DELETE FROM oc_product
WHERE
model = '479810399'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1049,
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 '479810499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1050
UPDATE oc_option_value_description
SET
name = '479810499 - ACRIL W&N GALER 60ML BURNT UMBER'
WHERE
option_value_id = 1050
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1050
DELETE FROM oc_product
WHERE
model = '479810499'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1050,
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 '479810599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1051
UPDATE oc_option_value_description
SET
name = '479810599 - ACRIL W&N GALER 60ML BURNT SIENNA'
WHERE
option_value_id = 1051
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1051
DELETE FROM oc_product
WHERE
model = '479810599'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1051,
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 '479810699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1052
UPDATE oc_option_value_description
SET
name = '479810699 - ACRIL W&N GALER 60ML LEMON YELLOW'
WHERE
option_value_id = 1052
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1052
DELETE FROM oc_product
WHERE
model = '479810699'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1052,
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 '479810799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1053
UPDATE oc_option_value_description
SET
name = '479810799 - ACRIL W&N GALER 60ML PROCESS YELLOW'
WHERE
option_value_id = 1053
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1053
DELETE FROM oc_product
WHERE
model = '479810799'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1053,
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 '479810899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1054
UPDATE oc_option_value_description
SET
name = '479810899 - ACRIL W&N GALER 60ML COBALT BLUE HUE'
WHERE
option_value_id = 1054
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1054
DELETE FROM oc_product
WHERE
model = '479810899'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1054,
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 '479810999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1055
UPDATE oc_option_value_description
SET
name = '479810999 - ACRIL W&N GALER 60ML CERULEAN BLUE HU'
WHERE
option_value_id = 1055
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1055
DELETE FROM oc_product
WHERE
model = '479810999'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1055,
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 '479811099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1056
UPDATE oc_option_value_description
SET
name = '479811099 - ACRIL W&N GALER 60ML CADM YEL MED HUE'
WHERE
option_value_id = 1056
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1056
DELETE FROM oc_product
WHERE
model = '479811099'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1056,
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 '479811199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1057
UPDATE oc_option_value_description
SET
name = '479811199 - ACRIL W&N GALER 60ML CADM YEL DEEP HU'
WHERE
option_value_id = 1057
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1057
DELETE FROM oc_product
WHERE
model = '479811199'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1057,
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 '479811299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1078
UPDATE oc_option_value_description
SET
name = '479811299 - ACRIL W&N GALER 60ML PROCESS CYAN'
WHERE
option_value_id = 1078
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1078
DELETE FROM oc_product
WHERE
model = '479811299'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1078,
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 '479811399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1079
UPDATE oc_option_value_description
SET
name = '479811399 - ACRIL W&N GALER 60ML PROCESS MAGENTA'
WHERE
option_value_id = 1079
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1079
DELETE FROM oc_product
WHERE
model = '479811399'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1079,
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 '479811499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1080
UPDATE oc_option_value_description
SET
name = '479811499 - ACRIL W&N GALER 60ML PHTALO GREEN'
WHERE
option_value_id = 1080
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1080
DELETE FROM oc_product
WHERE
model = '479811499'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1080,
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 '479811599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2127
UPDATE oc_option_value_description
SET
name = '479811599 - ACRIL W&N GALER 60ML NAPLES YELLOW'
WHERE
option_value_id = 2127
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 2127
DELETE FROM oc_product
WHERE
model = '479811599'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 2127,
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 '479811699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1081
UPDATE oc_option_value_description
SET
name = '479811699 - ACRIL W&N GALER 60ML IVORY BLACK'
WHERE
option_value_id = 1081
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1081
DELETE FROM oc_product
WHERE
model = '479811699'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1081,
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 '479811899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1082
UPDATE oc_option_value_description
SET
name = '479811899 - ACRIL W&N GALER 60ML CRIMSON'
WHERE
option_value_id = 1082
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1082
DELETE FROM oc_product
WHERE
model = '479811899'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1082,
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 '479811999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1083
UPDATE oc_option_value_description
SET
name = '479811999 - ACRIL W&N GALER 60ML RAW SIENNA'
WHERE
option_value_id = 1083
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1083
DELETE FROM oc_product
WHERE
model = '479811999'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1083,
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 '479812099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1084
UPDATE oc_option_value_description
SET
name = '479812099 - ACRIL W&N GALER 60ML PAYNES GRAY'
WHERE
option_value_id = 1084
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1084
DELETE FROM oc_product
WHERE
model = '479812099'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1084,
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 '479812199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1036
UPDATE oc_option_value_description
SET
name = '479812199 - ACRIL W&N GALER 60ML SAP GREEN'
WHERE
option_value_id = 1036
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1036
DELETE FROM oc_product
WHERE
model = '479812199'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1036,
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 '479812299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1037
UPDATE oc_option_value_description
SET
name = '479812299 - ACRIL W&N GALER 60ML RAW UMBER'
WHERE
option_value_id = 1037
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1037
DELETE FROM oc_product
WHERE
model = '479812299'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1037,
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 '479812399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1038
UPDATE oc_option_value_description
SET
name = '479812399 - ACRIL W&N GALER 60ML MARS BLACK'
WHERE
option_value_id = 1038
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1038
DELETE FROM oc_product
WHERE
model = '479812399'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1038,
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 '479812499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1039
UPDATE oc_option_value_description
SET
name = '479812499 - ACRIL W&N GALER 60ML TITANIUM WHITE'
WHERE
option_value_id = 1039
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1039
DELETE FROM oc_product
WHERE
model = '479812499'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1039,
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 '479812599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1040
UPDATE oc_option_value_description
SET
name = '479812599 - ACRIL W&N GALER 60ML SILVER'
WHERE
option_value_id = 1040
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1040
DELETE FROM oc_product
WHERE
model = '479812599'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1040,
quantity = 1,
subtract = 1,
price = 0.894,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479812799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1041
UPDATE oc_option_value_description
SET
name = '479812799 - ACRIL W&N GALER 60ML GOLD'
WHERE
option_value_id = 1041
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1041
DELETE FROM oc_product
WHERE
model = '479812799'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1041,
quantity = 1,
subtract = 1,
price = 0.894,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479813199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1042
UPDATE oc_option_value_description
SET
name = '479813199 - ACRIL W&N GALER 60ML ULTRAMARINE'
WHERE
option_value_id = 1042
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1042
DELETE FROM oc_product
WHERE
model = '479813199'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1042,
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 '479813299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1043
UPDATE oc_option_value_description
SET
name = '479813299 - ACRIL W&N GALER 60ML YELLOW OCHRE'
WHERE
option_value_id = 1043
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1043
DELETE FROM oc_product
WHERE
model = '479813299'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1043,
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 '479813399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1044
UPDATE oc_option_value_description
SET
name = '479813399 - ACRIL W&N GALER 60ML WINSOR VIOLET'
WHERE
option_value_id = 1044
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1044
DELETE FROM oc_product
WHERE
model = '479813399'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1044,
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 '479813499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1045
UPDATE oc_option_value_description
SET
name = '479813499 - ACRIL W&N GALER 60ML WINSOR BLUE'
WHERE
option_value_id = 1045
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1045
DELETE FROM oc_product
WHERE
model = '479813499'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1045,
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 '479813599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1046
UPDATE oc_option_value_description
SET
name = '479813599 - ACRIL W&N GALER 60ML VERMILION HUE'
WHERE
option_value_id = 1046
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1046
DELETE FROM oc_product
WHERE
model = '479813599'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1046,
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 '479813699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1162
UPDATE oc_option_value_description
SET
name = '479813699 - ACRIL W&N GALER 60ML PERMAN GREEN LIG'
WHERE
option_value_id = 1162
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1162
DELETE FROM oc_product
WHERE
model = '479813699'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1162,
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 '479813799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1085
UPDATE oc_option_value_description
SET
name = '479813799 - ACRIL W&N GALER 60ML PERMAN GREEN MID'
WHERE
option_value_id = 1085
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1085
DELETE FROM oc_product
WHERE
model = '479813799'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1085,
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 '479813899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1086
UPDATE oc_option_value_description
SET
name = '479813899 - ACRIL W&N GALER 60ML PERMAN GREEN DEE'
WHERE
option_value_id = 1086
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1086
DELETE FROM oc_product
WHERE
model = '479813899'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1086,
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 '479813999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1087
UPDATE oc_option_value_description
SET
name = '479813999 - ACRIL W&N GALER 60ML PERMANENT ROSE'
WHERE
option_value_id = 1087
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1087
DELETE FROM oc_product
WHERE
model = '479813999'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1087,
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 '479814099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1088
UPDATE oc_option_value_description
SET
name = '479814099 - ACRIL W&N GALER 60ML PERMAN MAGENTA'
WHERE
option_value_id = 1088
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1088
DELETE FROM oc_product
WHERE
model = '479814099'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1088,
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 = 27392
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479814999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1190
UPDATE oc_option_value_description
SET
name = '479814999 - ACRIL GALERIA W&N 250ML PERMANENT GREEN 483'
WHERE
option_value_id = 1190
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1190
DELETE FROM oc_product
WHERE
model = '479814999'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1190,
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 '479815299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1191
UPDATE oc_option_value_description
SET
name = '479815299 - ACRIL GALERIA W&N 250ML PROCESS MAG 533'
WHERE
option_value_id = 1191
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1191
DELETE FROM oc_product
WHERE
model = '479815299'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1191,
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 '479815399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1192
UPDATE oc_option_value_description
SET
name = '479815399 - ACRIL GALERIA W&N 250ML PROCESS CYAN 535'
WHERE
option_value_id = 1192
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1192
DELETE FROM oc_product
WHERE
model = '479815399'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1192,
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 '479815499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1193
UPDATE oc_option_value_description
SET
name = '479815499 - ACRIL GALERIA W&N 250ML PROCESS YELL 537'
WHERE
option_value_id = 1193
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1193
DELETE FROM oc_product
WHERE
model = '479815499'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1193,
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 = 27398
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1194
UPDATE oc_option_value_description
SET
name = '479817299 - ACRIL GALERIA W&N 500ML PROCESS YELL 527'
WHERE
option_value_id = 1194
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1194
DELETE FROM oc_product
WHERE
model = '479817299'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1194,
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 '479817399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1195
UPDATE oc_option_value_description
SET
name = '479817399 - ACRIL GALERIA W&N 500ML PROCESS CYAN 535'
WHERE
option_value_id = 1195
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1195
DELETE FROM oc_product
WHERE
model = '479817399'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1195,
quantity = 1,
subtract = 1,
price = 6.26,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1196
UPDATE oc_option_value_description
SET
name = '479817499 - ACRIL GALERIA W&N 500ML PROCESS YELL 527'
WHERE
option_value_id = 1196
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1196
DELETE FROM oc_product
WHERE
model = '479817499'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1196,
quantity = 1,
subtract = 1,
price = 0.732,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479817599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1558
UPDATE oc_option_value_description
SET
name = '479817599 - ACRIL GALERIA W&N 500ML OLIVE PALE 435'
WHERE
option_value_id = 1558
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 391
AND product_id = 27398
AND option_id = 17
AND option_value_id = 1558
DELETE FROM oc_product
WHERE
model = '479817599'
INSERT INTO oc_product_option_value
SET
product_option_id = 391,
product_id = 27398,
option_id = 17,
option_value_id = 1558,
quantity = 1,
subtract = 1,
price = 6.26,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.