Product Sync.
Opencart products: 30
Input products: 100
NEW: 400401799
NEW: 400401899
NEW: 400401999
NEW: 400406699
NEW: 400406799
NEW: 400407899
NEW: 400511899
NEW: 400521699
NEW: 400523899
NEW: 400525799
NEW: 400532699
NEW: 400532899
NEW: 400533399
NEW: 400537399
NEW: 400547499
NEW: 400547799
NEW: 400600899
NEW: 400601999
NEW: 400602099
NEW: 400602199
NEW: 400602299
NEW: 400603099
NEW: 400603199
NEW: 400604899
NEW: 400604999
NEW: 400605099
NEW: 400605199
NEW: 400605299
NEW: 400605999
NEW: 400800899
NEW: 400803699
UPDATING: Escolar
Product ID: 27383
Image file: Escolar.jpg
NEW: 400804687
UPDATING: Cotman W&N TB 8ml
Product ID: 27387
Image file:
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 400833399
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 400944499
NEW: 400944599
NEW: 400944699
NEW: 400944799
NEW: 400944899
NEW: 400944999
NEW: 400945099
Ok.
Product Option Sync.
Opencart products: 30
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 = 27383
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '400804224 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1936
UPDATE oc_option_value_description
SET
name = '400804224 - CONJ AGUAR JOVI C/12 CORES'
WHERE
option_value_id = 1936
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 376
AND product_id = 27383
AND option_id = 17
AND option_value_id = 1936
DELETE FROM oc_product
WHERE
model = '400804224'
INSERT INTO oc_product_option_value
SET
product_option_id = 376,
product_id = 27383,
option_id = 17,
option_value_id = 1936,
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 = 27387
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '400806199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 911
UPDATE oc_option_value_description
SET
name = '400806199 - AGUAR W&N COTMAN 8ML DIOXAZINE VIOLET'
WHERE
option_value_id = 911
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 911
DELETE FROM oc_product
WHERE
model = '400806199'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 911,
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 '400806299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 912
UPDATE oc_option_value_description
SET
name = '400806299 - AGUAR W&N COTMAN 8ML ALIZAR CRIMSO HUE 003'
WHERE
option_value_id = 912
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 912
DELETE FROM oc_product
WHERE
model = '400806299'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 912,
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 '400806399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 913
UPDATE oc_option_value_description
SET
name = '400806399 - AGUAR W&N COTMAN 8ML CHINESE WHITE 150'
WHERE
option_value_id = 913
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 913
DELETE FROM oc_product
WHERE
model = '400806399'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 913,
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 '400806499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 914
UPDATE oc_option_value_description
SET
name = '400806499 - AGUAR W&N COTMAN 8ML CADM RED PALE HUE 103'
WHERE
option_value_id = 914
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 914
DELETE FROM oc_product
WHERE
model = '400806499'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 914,
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 '400806599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 915
UPDATE oc_option_value_description
SET
name = '400806599 - AGUAR W&N COTMAN 8ML CADM RED DEEP HUE 098'
WHERE
option_value_id = 915
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 915
DELETE FROM oc_product
WHERE
model = '400806599'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 915,
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 '400806699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 916
UPDATE oc_option_value_description
SET
name = '400806699 - AGUAR W&N COTMAN 8ML CADMIU ORANGE HUE 090'
WHERE
option_value_id = 916
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 916
DELETE FROM oc_product
WHERE
model = '400806699'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 916,
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 '400806799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 917
UPDATE oc_option_value_description
SET
name = '400806799 - AGUAR W&N COTMAN 8ML BURNT UMBER'
WHERE
option_value_id = 917
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 917
DELETE FROM oc_product
WHERE
model = '400806799'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 917,
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 '400806899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 918
UPDATE oc_option_value_description
SET
name = '400806899 - AGUAR W&N COTMAN 8ML BURNT SIENNA 074'
WHERE
option_value_id = 918
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 918
DELETE FROM oc_product
WHERE
model = '400806899'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 918,
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 '400806999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 919
UPDATE oc_option_value_description
SET
name = '400806999 - AGUAR W&N COTMAN 8ML VANDYKE BROWN 676'
WHERE
option_value_id = 919
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 919
DELETE FROM oc_product
WHERE
model = '400806999'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 919,
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 '400807099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 964
UPDATE oc_option_value_description
SET
name = '400807099 - AGUAR W&N COTMAN 8ML INTENSE BLUE 327'
WHERE
option_value_id = 964
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 964
DELETE FROM oc_product
WHERE
model = '400807099'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 964,
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 '400807199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 920
UPDATE oc_option_value_description
SET
name = '400807199 - AGUAR W&N COTMAN 8ML CERULEAN BLUE HUE 139'
WHERE
option_value_id = 920
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 920
DELETE FROM oc_product
WHERE
model = '400807199'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 920,
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 '400807399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 966
UPDATE oc_option_value_description
SET
name = '400807399 - AGUAR W&N COTMAN 8ML ESMERALD'
WHERE
option_value_id = 966
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 966
DELETE FROM oc_product
WHERE
model = '400807399'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 966,
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 '400807499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 921
UPDATE oc_option_value_description
SET
name = '400807499 - AGUAR W&N COTMAN 8ML COBALT BLUE HUE 179'
WHERE
option_value_id = 921
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 921
DELETE FROM oc_product
WHERE
model = '400807499'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 921,
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 '400807599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 969
UPDATE oc_option_value_description
SET
name = '400807599 - AGUAR W&N COTMAN 8ML INDIAN RED 317'
WHERE
option_value_id = 969
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 969
DELETE FROM oc_product
WHERE
model = '400807599'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 969,
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 '400807699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 922
UPDATE oc_option_value_description
SET
name = '400807699 - AGUAR W&N COTMAN 8ML INDIGO'
WHERE
option_value_id = 922
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 922
DELETE FROM oc_product
WHERE
model = '400807699'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 922,
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 '400807799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 923
UPDATE oc_option_value_description
SET
name = '400807799 - AGUAR W&N COTMAN 8ML GAMBOGE HUE 266'
WHERE
option_value_id = 923
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 923
DELETE FROM oc_product
WHERE
model = '400807799'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 923,
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 '400807899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 924
UPDATE oc_option_value_description
SET
name = '400807899 - AGUAR W&N COTMAN 8ML HOOKER.S GREEN LIGHT 314'
WHERE
option_value_id = 924
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 924
DELETE FROM oc_product
WHERE
model = '400807899'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 924,
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 '400807999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 965
UPDATE oc_option_value_description
SET
name = '400807999 - AGUAR W&N COTMAN 8ML INTENSE GREEN'
WHERE
option_value_id = 965
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 965
DELETE FROM oc_product
WHERE
model = '400807999'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 965,
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 '400808099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 925
UPDATE oc_option_value_description
SET
name = '400808099 - AGUAR W&N COTMAN 8ML IVORY BLACK 331'
WHERE
option_value_id = 925
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 925
DELETE FROM oc_product
WHERE
model = '400808099'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 925,
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 '400808199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 926
UPDATE oc_option_value_description
SET
name = '400808199 - AGUAR W&N COTMAN 8ML LEMON YELLOW HUE 346'
WHERE
option_value_id = 926
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 926
DELETE FROM oc_product
WHERE
model = '400808199'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 926,
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 '400808299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 927
UPDATE oc_option_value_description
SET
name = '400808299 - AGUAR W&N COTMAN 8ML PERMANENT ROSE'
WHERE
option_value_id = 927
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 927
DELETE FROM oc_product
WHERE
model = '400808299'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 927,
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 '400808399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 928
UPDATE oc_option_value_description
SET
name = '400808399 - AGUAR W&N COTMAN 8ML PURPLE LAKE'
WHERE
option_value_id = 928
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 928
DELETE FROM oc_product
WHERE
model = '400808399'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 928,
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 '400808599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 929
UPDATE oc_option_value_description
SET
name = '400808599 - AGUAR W&N COTMAN 8ML PRUSSIAN BLUE 538'
WHERE
option_value_id = 929
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 929
DELETE FROM oc_product
WHERE
model = '400808599'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 929,
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 '400808699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 930
UPDATE oc_option_value_description
SET
name = '400808699 - AGUAR W&N COTMAN 8ML PAYNES GRAY 465'
WHERE
option_value_id = 930
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 930
DELETE FROM oc_product
WHERE
model = '400808699'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 930,
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 '400808799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 931
UPDATE oc_option_value_description
SET
name = '400808799 - AGUAR W&N COTMAN 8ML YELLOW OCHRE 744'
WHERE
option_value_id = 931
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 931
DELETE FROM oc_product
WHERE
model = '400808799'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 931,
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 '400808899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 968
UPDATE oc_option_value_description
SET
name = '400808899 - AGUAR W&N COTMAN 8ML VIRIDIAN HUE 696'
WHERE
option_value_id = 968
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 968
DELETE FROM oc_product
WHERE
model = '400808899'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 968,
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 '400808999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 963
UPDATE oc_option_value_description
SET
name = '400808999 - AGUAR W&N COTMAN 8ML RAW UMBER 554'
WHERE
option_value_id = 963
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 963
DELETE FROM oc_product
WHERE
model = '400808999'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 963,
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 '400809099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 967
UPDATE oc_option_value_description
SET
name = '400809099 - AGUAR W&N COTMAN 8ML LIGHT RED'
WHERE
option_value_id = 967
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 967
DELETE FROM oc_product
WHERE
model = '400809099'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 967,
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 '400809199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 932
UPDATE oc_option_value_description
SET
name = '400809199 - AGUAR W&N COTMAN 8ML SAP GREEN 599'
WHERE
option_value_id = 932
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 932
DELETE FROM oc_product
WHERE
model = '400809199'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 932,
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 '400809299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 961
UPDATE oc_option_value_description
SET
name = '400809299 - AGUAR W&N COTMAN 8ML ROSE MADDER'
WHERE
option_value_id = 961
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 961
DELETE FROM oc_product
WHERE
model = '400809299'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 961,
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 '400809399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 933
UPDATE oc_option_value_description
SET
name = '400809399 - AGUAR W&N COTMAN 8ML ULTRAMARINE 660'
WHERE
option_value_id = 933
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 933
DELETE FROM oc_product
WHERE
model = '400809399'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 933,
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 '400809499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 934
UPDATE oc_option_value_description
SET
name = '400809499 - AGUAR W&N COTMAN 8ML SEPIA 609'
WHERE
option_value_id = 934
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 934
DELETE FROM oc_product
WHERE
model = '400809499'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 934,
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 '400809599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 935
UPDATE oc_option_value_description
SET
name = '400809599 - AGUAR W&N COTMAN 8ML TURQUOISE 654'
WHERE
option_value_id = 935
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 935
DELETE FROM oc_product
WHERE
model = '400809599'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 935,
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 '400809699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 936
UPDATE oc_option_value_description
SET
name = '400809699 - AGUAR W&N COTMAN 8ML RAW SIENNA'
WHERE
option_value_id = 936
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 936
DELETE FROM oc_product
WHERE
model = '400809699'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 936,
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 '400809799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 937
UPDATE oc_option_value_description
SET
name = '400809799 - AGUAR W&N COTMAN 8ML LAMP BLACK'
WHERE
option_value_id = 937
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 937
DELETE FROM oc_product
WHERE
model = '400809799'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 937,
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 '400809899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 938
UPDATE oc_option_value_description
SET
name = '400809899 - AGUAR W&N COTMAN 8ML CADM YELLOW HUE 109'
WHERE
option_value_id = 938
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 938
DELETE FROM oc_product
WHERE
model = '400809899'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 938,
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 '400809999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 939
UPDATE oc_option_value_description
SET
name = '400809999 - AGUAR W&N COTMAN 8ML CADM YEL PALE HUE 119'
WHERE
option_value_id = 939
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 939
DELETE FROM oc_product
WHERE
model = '400809999'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 939,
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 '400810099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 940
UPDATE oc_option_value_description
SET
name = '400810099 - AGUAR W&N COTMAN 8ML CADMIUM RED HUE 095'
WHERE
option_value_id = 940
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
AND option_id = 17
AND option_value_id = 940
DELETE FROM oc_product
WHERE
model = '400810099'
INSERT INTO oc_product_option_value
SET
product_option_id = 380,
product_id = 27387,
option_id = 17,
option_value_id = 940,
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 = 27391
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '400821899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 944
UPDATE oc_option_value_description
SET
name = '400821899 - AGUAR ECOLINE TALENS 25-30 ML AMA ESC'
WHERE
option_value_id = 944
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 = 944
DELETE FROM oc_product
WHERE
model = '400821899'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 944,
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 '400821999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 945
UPDATE oc_option_value_description
SET
name = '400821999 - AGUAR ECOLINE TALENS 25-30 ML AMA LIMAO'
WHERE
option_value_id = 945
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 = 945
DELETE FROM oc_product
WHERE
model = '400821999'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 945,
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 '400822899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 946
UPDATE oc_option_value_description
SET
name = '400822899 - AGUAR ECOLINE TALENS 25-30 ML VERMILION 311'
WHERE
option_value_id = 946
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 = 946
DELETE FROM oc_product
WHERE
model = '400822899'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 946,
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 '400822999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 947
UPDATE oc_option_value_description
SET
name = '400822999 - AGUAR ECOLINE TALENS 25-30 ML CARMIN 318'
WHERE
option_value_id = 947
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 = 947
DELETE FROM oc_product
WHERE
model = '400822999'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 947,
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 '400823099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 948
UPDATE oc_option_value_description
SET
name = '400823099 - AGUAR ECOLINE TALENS 25-30 ML ESCARLATE 334'
WHERE
option_value_id = 948
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 = 948
DELETE FROM oc_product
WHERE
model = '400823099'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 948,
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 '400823199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 949
UPDATE oc_option_value_description
SET
name = '400823199 - AGUAR ECOLINE TALENS 25-30 ML MAGENTA 337'
WHERE
option_value_id = 949
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 = 949
DELETE FROM oc_product
WHERE
model = '400823199'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 949,
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 '400823699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 950
UPDATE oc_option_value_description
SET
name = '400823699 - AGUAR ECOLINE TALENS 25-30 ML TERRA SIENA TOST'
WHERE
option_value_id = 950
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 = 950
DELETE FROM oc_product
WHERE
model = '400823699'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 950,
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 '400823799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 951
UPDATE oc_option_value_description
SET
name = '400823799 - AGUAR ECOLINE TALENS 25-30 ML SEPIA'
WHERE
option_value_id = 951
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 = 951
DELETE FROM oc_product
WHERE
model = '400823799'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 951,
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 '400823899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 952
UPDATE oc_option_value_description
SET
name = '400823899 - AGUAR ECOLINE TALENS 25-30 ML CASTANHO AVERMELH'
WHERE
option_value_id = 952
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 = 952
DELETE FROM oc_product
WHERE
model = '400823899'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 952,
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 '400823999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 953
UPDATE oc_option_value_description
SET
name = '400823999 - AGUAR ECOLINE TALENS 25-30 ML ULTRAMAR CLR'
WHERE
option_value_id = 953
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 = 953
DELETE FROM oc_product
WHERE
model = '400823999'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 953,
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 '400824199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 954
UPDATE oc_option_value_description
SET
name = '400824199 - AGUAR ECOLINE TALENS 25-30 ML ULTRAMAR VIOL'
WHERE
option_value_id = 954
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 = 954
DELETE FROM oc_product
WHERE
model = '400824199'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 954,
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 '400824399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 955
UPDATE oc_option_value_description
SET
name = '400824399 - AGUAR ECOLINE TALENS 25-30 ML AZL TURQ'
WHERE
option_value_id = 955
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 = 955
DELETE FROM oc_product
WHERE
model = '400824399'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 955,
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 '400824499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 956
UPDATE oc_option_value_description
SET
name = '400824499 - AGUAR ECOLINE TALENS 25-30 ML VIOL AVERMELH'
WHERE
option_value_id = 956
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 = 956
DELETE FROM oc_product
WHERE
model = '400824499'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 956,
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 '400824699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 957
UPDATE oc_option_value_description
SET
name = '400824699 - AGUAR ECOLINE TALENS 25-30 ML AZL CEU'
WHERE
option_value_id = 957
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 = 957
DELETE FROM oc_product
WHERE
model = '400824699'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 957,
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 '400825199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 958
UPDATE oc_option_value_description
SET
name = '400825199 - AGUAR ECOLINE TALENS 25-30 ML VDE ESC'
WHERE
option_value_id = 958
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 = 958
DELETE FROM oc_product
WHERE
model = '400825199'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 958,
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 '400825699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 959
UPDATE oc_option_value_description
SET
name = '400825699 - AGUAR ECOLINE TALENS 25-30 ML VDE PRIMAVERA'
WHERE
option_value_id = 959
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 = 959
DELETE FROM oc_product
WHERE
model = '400825699'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 959,
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 '400825999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 960
UPDATE oc_option_value_description
SET
name = '400825999 - AGUAR ECOLINE TALENS 25-30 ML NEGRO'
WHERE
option_value_id = 960
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 = 960
DELETE FROM oc_product
WHERE
model = '400825999'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 960,
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 = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '400833499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1937
UPDATE oc_option_value_description
SET
name = '400833499 - CXA AGUAR W&N COTMAN POCKET PLUS C/12 PAST'
WHERE
option_value_id = 1937
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1937
DELETE FROM oc_product
WHERE
model = '400833499'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1937,
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 '400833599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1938
UPDATE oc_option_value_description
SET
name = '400833599 - CX AGUAR W&N COTMAN FIELD PLUS SET C/12 PAST'
WHERE
option_value_id = 1938
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1938
DELETE FROM oc_product
WHERE
model = '400833599'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1938,
quantity = 1,
subtract = 1,
price = 24.634,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '400833699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1939
UPDATE oc_option_value_description
SET
name = '400833699 - CXA AGUAR W&N COTMAN HALF/TUBE 16 PAST + 3 TUB'
WHERE
option_value_id = 1939
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1939
DELETE FROM oc_product
WHERE
model = '400833699'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1939,
quantity = 1,
subtract = 1,
price = 21.707,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '400834299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1940
UPDATE oc_option_value_description
SET
name = '400834299 - CXA AGUAR W&N COTMAN MINI PLUS C/8 PAST + PINCEL'
WHERE
option_value_id = 1940
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1940
DELETE FROM oc_product
WHERE
model = '400834299'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1940,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.