Product Sync.
Opencart products: 164
Input products: 100
NEW: 100525299
NEW: 100525399
NEW: 100525499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100525499 - %'
)
NEW: Gel de Textura Pébéo Brilhante 100 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Gel de Textura Pébéo Brilhante 100 ml - %'
)
UPDATING: Médio para Acrílico Pébéo
Product ID: 27041
Image file:
NEW: 100525899
NEW: Gel de Textura de Areia Pébéo 250 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Gel de Textura de Areia Pébéo 250 ml - %'
)
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
Image file:
NEW: Médio para Óleo Pébeo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Médio para Óleo Pébeo - %'
)
NEW: 100530599
NEW: 100530699
NEW: 100530799
NEW: 100530899
UPDATING: Tinta Vitral Pébéo
Product ID: 27026
Image file:
UPDATING: Tinta Relevo Cerne Pébéo
Product ID: 27043
Image file:
Ok.
Product Option Sync.
Opencart products: 168
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 = 27154
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27154,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2260
UPDATE oc_option_value_description
SET
name = '100525599 - Gel de Textura Pébéo Brilhante 100 ml'
WHERE
option_value_id = 2260
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 299
AND product_id = 27154
AND option_id = 15
AND option_value_id = 2260
DELETE FROM oc_product
WHERE
model = '100525599'
INSERT INTO oc_product_option_value
SET
product_option_id = 299,
product_id = 27154,
option_id = 15,
option_value_id = 2260,
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 = 27041
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2265
UPDATE oc_option_value_description
SET
name = '100525699 - Médio Gel para Acrílico Pébéo Mate 100 ml'
WHERE
option_value_id = 2265
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 108
AND product_id = 27041
AND option_id = 15
AND option_value_id = 2265
DELETE FROM oc_product
WHERE
model = '100525699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 108
AND product_id = 27041
AND option_id = 15
AND option_value_id = 2265
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2266
UPDATE oc_option_value_description
SET
name = '100525799 - Médio para Acrílico Pébéo Aglutinante Brilhante Bindex 250 ml'
WHERE
option_value_id = 2266
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 108
AND product_id = 27041
AND option_id = 15
AND option_value_id = 2266
DELETE FROM oc_product
WHERE
model = '100525799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 2.114,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 108
AND product_id = 27041
AND option_id = 15
AND option_value_id = 2266
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27155
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27155,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2261
UPDATE oc_option_value_description
SET
name = '100525999 - Gel de Textura de Areia Pébéo Amarelo 250 ml'
WHERE
option_value_id = 2261
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 300
AND product_id = 27155
AND option_id = 15
AND option_value_id = 2261
DELETE FROM oc_product
WHERE
model = '100525999'
INSERT INTO oc_product_option_value
SET
product_option_id = 300,
product_id = 27155,
option_id = 15,
option_value_id = 2261,
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 '100526099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2262
UPDATE oc_option_value_description
SET
name = '100526099 - Gel de Textura de Areia Pébéo Vermelho 250 ml'
WHERE
option_value_id = 2262
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 300
AND product_id = 27155
AND option_id = 15
AND option_value_id = 2262
DELETE FROM oc_product
WHERE
model = '100526099'
INSERT INTO oc_product_option_value
SET
product_option_id = 300,
product_id = 27155,
option_id = 15,
option_value_id = 2262,
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 '100526199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2263
UPDATE oc_option_value_description
SET
name = '100526199 - Gel de Textura de Areia Pébéo Preto 250 ml'
WHERE
option_value_id = 2263
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 300
AND product_id = 27155
AND option_id = 15
AND option_value_id = 2263
DELETE FROM oc_product
WHERE
model = '100526199'
INSERT INTO oc_product_option_value
SET
product_option_id = 300,
product_id = 27155,
option_id = 15,
option_value_id = 2263,
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 '100526299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2264
UPDATE oc_option_value_description
SET
name = '100526299 - Gel de Textura de Areia Pébéo Branco 250 ml'
WHERE
option_value_id = 2264
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 300
AND product_id = 27155
AND option_id = 15
AND option_value_id = 2264
DELETE FROM oc_product
WHERE
model = '100526299'
INSERT INTO oc_product_option_value
SET
product_option_id = 300,
product_id = 27155,
option_id = 15,
option_value_id = 2264,
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 = 27030
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2267
UPDATE oc_option_value_description
SET
name = '100526399 - Setacolor Opaco Branco Titânio'
WHERE
option_value_id = 2267
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2267
DELETE FROM oc_product
WHERE
model = '100526399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2267
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2268
UPDATE oc_option_value_description
SET
name = '100526499 - Setacolor Opaco Azul Cobalto'
WHERE
option_value_id = 2268
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2268
DELETE FROM oc_product
WHERE
model = '100526499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2268
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2269
UPDATE oc_option_value_description
SET
name = '100526599 - Setacolor Opaco Laranja'
WHERE
option_value_id = 2269
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2269
DELETE FROM oc_product
WHERE
model = '100526599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2269
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2270
UPDATE oc_option_value_description
SET
name = '100526699 - Setacolor Opaco Amarelo'
WHERE
option_value_id = 2270
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2270
DELETE FROM oc_product
WHERE
model = '100526699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2270
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2271
UPDATE oc_option_value_description
SET
name = '100526799 - Setacolor Opaco Castanho Veludo'
WHERE
option_value_id = 2271
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2271
DELETE FROM oc_product
WHERE
model = '100526799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2271
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2272
UPDATE oc_option_value_description
SET
name = '100526899 - Setacolor Opaco Vermelho Oriental'
WHERE
option_value_id = 2272
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2272
DELETE FROM oc_product
WHERE
model = '100526899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2272
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2273
UPDATE oc_option_value_description
SET
name = '100526999 - Setacolor Opaco Amarelo Limão'
WHERE
option_value_id = 2273
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2273
DELETE FROM oc_product
WHERE
model = '100526999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2273
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2274
UPDATE oc_option_value_description
SET
name = '100527099 - Setacolor Opaco Vermelho Granada'
WHERE
option_value_id = 2274
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2274
DELETE FROM oc_product
WHERE
model = '100527099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2274
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2275
UPDATE oc_option_value_description
SET
name = '100527199 - Setacolor Opaco Preto'
WHERE
option_value_id = 2275
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2275
DELETE FROM oc_product
WHERE
model = '100527199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2275
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2276
UPDATE oc_option_value_description
SET
name = '100527299 - Setacolor Opaco Azul Royal'
WHERE
option_value_id = 2276
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2276
DELETE FROM oc_product
WHERE
model = '100527299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2276
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2277
UPDATE oc_option_value_description
SET
name = '100527399 - Setacolor Opaco Indigo'
WHERE
option_value_id = 2277
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2277
DELETE FROM oc_product
WHERE
model = '100527399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2277
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2278
UPDATE oc_option_value_description
SET
name = '100527499 - Setacolor Opaco Canela'
WHERE
option_value_id = 2278
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2278
DELETE FROM oc_product
WHERE
model = '100527499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2278
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2279
UPDATE oc_option_value_description
SET
name = '100527599 - Setacolor Opaco Verde Primavera'
WHERE
option_value_id = 2279
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2279
DELETE FROM oc_product
WHERE
model = '100527599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2279
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2280
UPDATE oc_option_value_description
SET
name = '100527699 - Setacolor Opaco Sienna'
WHERE
option_value_id = 2280
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2280
DELETE FROM oc_product
WHERE
model = '100527699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2280
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2281
UPDATE oc_option_value_description
SET
name = '100527799 - Setacolor Opaco Vermelhão'
WHERE
option_value_id = 2281
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2281
DELETE FROM oc_product
WHERE
model = '100527799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2281
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2282
UPDATE oc_option_value_description
SET
name = '100527899 - Setacolor Opaco Verde Claro'
WHERE
option_value_id = 2282
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2282
DELETE FROM oc_product
WHERE
model = '100527899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2282
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100527999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2283
UPDATE oc_option_value_description
SET
name = '100527999 - Setacolor Opaco VIOLETA Parma'
WHERE
option_value_id = 2283
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2283
DELETE FROM oc_product
WHERE
model = '100527999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2283
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528099 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3177 AS option_value_id,
language_id,
15 AS option_id,
'100528099 - \''Setacolor Opaco Aniseed' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 3177
DELETE FROM oc_product
WHERE
model = '100528099'
INSERT INTO oc_product_option_value
SET
product_option_id = 97,
product_id = 27030,
option_id = 15,
option_value_id = 3177,
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 '100528199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2285
UPDATE oc_option_value_description
SET
name = '100528199 - Setacolor Opaco Pérola Brilhante'
WHERE
option_value_id = 2285
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2285
DELETE FROM oc_product
WHERE
model = '100528199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2285
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2286
UPDATE oc_option_value_description
SET
name = '100528299 - Setacolor Opaco Ouro Brilhante'
WHERE
option_value_id = 2286
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2286
DELETE FROM oc_product
WHERE
model = '100528299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2286
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2287
UPDATE oc_option_value_description
SET
name = '100528399 - Setacolor Opaco Cobre Brilho'
WHERE
option_value_id = 2287
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2287
DELETE FROM oc_product
WHERE
model = '100528399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2287
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2288
UPDATE oc_option_value_description
SET
name = '100528499 - Setacolor Opaco Cereja'
WHERE
option_value_id = 2288
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2288
DELETE FROM oc_product
WHERE
model = '100528499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2288
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2289
UPDATE oc_option_value_description
SET
name = '100528599 - Setacolor Opaco Sanguine'
WHERE
option_value_id = 2289
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2289
DELETE FROM oc_product
WHERE
model = '100528599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2289
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2290
UPDATE oc_option_value_description
SET
name = '100528699 - Setacolor Opaco Fawn'
WHERE
option_value_id = 2290
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2290
DELETE FROM oc_product
WHERE
model = '100528699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2290
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2291
UPDATE oc_option_value_description
SET
name = '100528799 - Setacolor Opaco Vermelho'
WHERE
option_value_id = 2291
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2291
DELETE FROM oc_product
WHERE
model = '100528799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2291
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2292
UPDATE oc_option_value_description
SET
name = '100528899 - Setacolor Opaco Verde Dourado'
WHERE
option_value_id = 2292
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2292
DELETE FROM oc_product
WHERE
model = '100528899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2292
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100528999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2293
UPDATE oc_option_value_description
SET
name = '100528999 - Setacolor Opaco Azul Oreintal'
WHERE
option_value_id = 2293
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2293
DELETE FROM oc_product
WHERE
model = '100528999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2293
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2294
UPDATE oc_option_value_description
SET
name = '100529099 - Setacolor Opaco Azul Escuro'
WHERE
option_value_id = 2294
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2294
DELETE FROM oc_product
WHERE
model = '100529099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2294
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2295
UPDATE oc_option_value_description
SET
name = '100529199 - Setacolor Opaco Prateado Brilhante'
WHERE
option_value_id = 2295
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2295
DELETE FROM oc_product
WHERE
model = '100529199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2295
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2296
UPDATE oc_option_value_description
SET
name = '100529299 - Setacolor Opaco Verde Canario Brilho'
WHERE
option_value_id = 2296
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2296
DELETE FROM oc_product
WHERE
model = '100529299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2296
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2297
UPDATE oc_option_value_description
SET
name = '100529399 - Setacolor Opaco Laranja Brilho'
WHERE
option_value_id = 2297
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2297
DELETE FROM oc_product
WHERE
model = '100529399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2297
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2298
UPDATE oc_option_value_description
SET
name = '100529499 - Setacolor Opaco Vermelho Oriental Brilhante'
WHERE
option_value_id = 2298
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2298
DELETE FROM oc_product
WHERE
model = '100529499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2298
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2299
UPDATE oc_option_value_description
SET
name = '100529599 - Setacolor Opaco Roxo Brilhante'
WHERE
option_value_id = 2299
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2299
DELETE FROM oc_product
WHERE
model = '100529599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2299
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2300
UPDATE oc_option_value_description
SET
name = '100529699 - Setacolor Opaco Vinho Brilhante'
WHERE
option_value_id = 2300
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2300
DELETE FROM oc_product
WHERE
model = '100529699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2300
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2301
UPDATE oc_option_value_description
SET
name = '100529799 - Setacolor Opaco Violeta Brilhante'
WHERE
option_value_id = 2301
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2301
DELETE FROM oc_product
WHERE
model = '100529799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2301
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2302
UPDATE oc_option_value_description
SET
name = '100529899 - Setacolor Opaco Azul Electrico'
WHERE
option_value_id = 2302
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2302
DELETE FROM oc_product
WHERE
model = '100529899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2302
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100529999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2303
UPDATE oc_option_value_description
SET
name = '100529999 - Setacolor Opaco Bronze Brilho'
WHERE
option_value_id = 2303
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2303
DELETE FROM oc_product
WHERE
model = '100529999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2303
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100530099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2304
UPDATE oc_option_value_description
SET
name = '100530099 - Setacolor Opaco Cinza Brilho'
WHERE
option_value_id = 2304
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2304
DELETE FROM oc_product
WHERE
model = '100530099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2304
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100530199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2305
UPDATE oc_option_value_description
SET
name = '100530199 - Setacolor Opaco Chocolate Brilho'
WHERE
option_value_id = 2305
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2305
DELETE FROM oc_product
WHERE
model = '100530199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2305
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100530299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2306
UPDATE oc_option_value_description
SET
name = '100530299 - Setacolor Opaco Azul Noite Brilho'
WHERE
option_value_id = 2306
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2306
DELETE FROM oc_product
WHERE
model = '100530299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2306
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27156
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27156,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100530399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2307
UPDATE oc_option_value_description
SET
name = '100530399 - Médio Setacolor Pébéo Brilhante'
WHERE
option_value_id = 2307
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 301
AND product_id = 27156
AND option_id = 15
AND option_value_id = 2307
DELETE FROM oc_product
WHERE
model = '100530399'
INSERT INTO oc_product_option_value
SET
product_option_id = 301,
product_id = 27156,
option_id = 15,
option_value_id = 2307,
quantity = 1,
subtract = 1,
price = 2.52,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100530499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2308
UPDATE oc_option_value_description
SET
name = '100530499 - Médio Setacolor Pébéo Espessante Stencil'
WHERE
option_value_id = 2308
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 301
AND product_id = 27156
AND option_id = 15
AND option_value_id = 2308
DELETE FROM oc_product
WHERE
model = '100530499'
INSERT INTO oc_product_option_value
SET
product_option_id = 301,
product_id = 27156,
option_id = 15,
option_value_id = 2308,
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 '100530999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2309
UPDATE oc_option_value_description
SET
name = '100530999 - Médio Setacolor Pébéo Nacarado'
WHERE
option_value_id = 2309
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 301
AND product_id = 27156
AND option_id = 15
AND option_value_id = 2309
DELETE FROM oc_product
WHERE
model = '100530999'
INSERT INTO oc_product_option_value
SET
product_option_id = 301,
product_id = 27156,
option_id = 15,
option_value_id = 2309,
quantity = 1,
subtract = 1,
price = 2.52,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27026
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2310
UPDATE oc_option_value_description
SET
name = '100531099 - Tinta Vitral Pébéo Azul Profundo'
WHERE
option_value_id = 2310
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2310
DELETE FROM oc_product
WHERE
model = '100531099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2310
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2311
UPDATE oc_option_value_description
SET
name = '100531199 - Tinta Vitral Pébéo Castanho'
WHERE
option_value_id = 2311
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2311
DELETE FROM oc_product
WHERE
model = '100531199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2311
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2312
UPDATE oc_option_value_description
SET
name = '100531299 - Tinta Vitral Pébéo Crimson'
WHERE
option_value_id = 2312
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2312
DELETE FROM oc_product
WHERE
model = '100531299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2312
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2313
UPDATE oc_option_value_description
SET
name = '100531399 - Tinta Vitral Pébéo Esmeralda'
WHERE
option_value_id = 2313
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2313
DELETE FROM oc_product
WHERE
model = '100531399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2313
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2314
UPDATE oc_option_value_description
SET
name = '100531499 - Tinta Vitral Pébéo Amarelo'
WHERE
option_value_id = 2314
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2314
DELETE FROM oc_product
WHERE
model = '100531499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2314
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2315
UPDATE oc_option_value_description
SET
name = '100531599 - Tinta Vitral Pébéo Preto'
WHERE
option_value_id = 2315
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2315
DELETE FROM oc_product
WHERE
model = '100531599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2315
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2316
UPDATE oc_option_value_description
SET
name = '100531699 - Tinta Vitral Pébéo Laranja'
WHERE
option_value_id = 2316
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2316
DELETE FROM oc_product
WHERE
model = '100531699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2316
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2317
UPDATE oc_option_value_description
SET
name = '100531799 - Tinta Vitral Pébéo Turquesa'
WHERE
option_value_id = 2317
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2317
DELETE FROM oc_product
WHERE
model = '100531799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2317
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2318
UPDATE oc_option_value_description
SET
name = '100531899 - Tinta Vitral Pébéo Chartreuse'
WHERE
option_value_id = 2318
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2318
DELETE FROM oc_product
WHERE
model = '100531899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2318
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2319
UPDATE oc_option_value_description
SET
name = '100531999 - Tinta Vitral Pébéo Vermelho Violeta'
WHERE
option_value_id = 2319
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2319
DELETE FROM oc_product
WHERE
model = '100531999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2319
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2320
UPDATE oc_option_value_description
SET
name = '100532099 - Tinta Vitral Pébéo Branco'
WHERE
option_value_id = 2320
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2320
DELETE FROM oc_product
WHERE
model = '100532099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2320
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2321
UPDATE oc_option_value_description
SET
name = '100532199 - Tinta Vitral Pébéo Rosa'
WHERE
option_value_id = 2321
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2321
DELETE FROM oc_product
WHERE
model = '100532199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2321
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2322
UPDATE oc_option_value_description
SET
name = '100532299 - Tinta Vitral Pébéo Verde Dourado'
WHERE
option_value_id = 2322
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2322
DELETE FROM oc_product
WHERE
model = '100532299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2322
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2323
UPDATE oc_option_value_description
SET
name = '100532399 - Tinta Vitral Pébéo Limao'
WHERE
option_value_id = 2323
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2323
DELETE FROM oc_product
WHERE
model = '100532399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2323
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2324
UPDATE oc_option_value_description
SET
name = '100532499 - Tinta Vitral Pébéo Violeta'
WHERE
option_value_id = 2324
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2324
DELETE FROM oc_product
WHERE
model = '100532499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2324
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2325
UPDATE oc_option_value_description
SET
name = '100532599 - Tinta Vitral Pébéo Roxo'
WHERE
option_value_id = 2325
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2325
DELETE FROM oc_product
WHERE
model = '100532599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2325
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2326
UPDATE oc_option_value_description
SET
name = '100532699 - Tinta Vitral Pébéo Areia'
WHERE
option_value_id = 2326
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2326
DELETE FROM oc_product
WHERE
model = '100532699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2326
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2327
UPDATE oc_option_value_description
SET
name = '100532799 - Tinta Vitral Pébéo Rosa Velho'
WHERE
option_value_id = 2327
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2327
DELETE FROM oc_product
WHERE
model = '100532799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2327
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2328
UPDATE oc_option_value_description
SET
name = '100532899 - Tinta Vitral Pébéo Salmão'
WHERE
option_value_id = 2328
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2328
DELETE FROM oc_product
WHERE
model = '100532899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2328
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100532999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2329
UPDATE oc_option_value_description
SET
name = '100532999 - Tinta Vitral Pébéo Parma'
WHERE
option_value_id = 2329
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2329
DELETE FROM oc_product
WHERE
model = '100532999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2329
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2330
UPDATE oc_option_value_description
SET
name = '100533099 - Tinta Vitral Pébéo Verde Maçã'
WHERE
option_value_id = 2330
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2330
DELETE FROM oc_product
WHERE
model = '100533099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2330
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2331
UPDATE oc_option_value_description
SET
name = '100533199 - Tinta Vitral Pébéo Verde Escuro'
WHERE
option_value_id = 2331
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2331
DELETE FROM oc_product
WHERE
model = '100533199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2331
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2332
UPDATE oc_option_value_description
SET
name = '100533299 - Tinta Vitral Pébéo Azul Céu'
WHERE
option_value_id = 2332
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2332
DELETE FROM oc_product
WHERE
model = '100533299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2332
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2333
UPDATE oc_option_value_description
SET
name = '100533399 - Tinta Vitral Pébéo Azul Cobalto'
WHERE
option_value_id = 2333
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2333
DELETE FROM oc_product
WHERE
model = '100533399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2333
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2334
UPDATE oc_option_value_description
SET
name = '100533499 - Tinta Vitral Pébéo Dourado'
WHERE
option_value_id = 2334
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2334
DELETE FROM oc_product
WHERE
model = '100533499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2334
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2335
UPDATE oc_option_value_description
SET
name = '100533599 - Tinta Vitral Pébéo Perola'
WHERE
option_value_id = 2335
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2335
DELETE FROM oc_product
WHERE
model = '100533599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2335
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2336
UPDATE oc_option_value_description
SET
name = '100533699 - Tinta Vitral Pébéo Amarelo Opaco Trigo'
WHERE
option_value_id = 2336
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2336
DELETE FROM oc_product
WHERE
model = '100533699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2336
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2337
UPDATE oc_option_value_description
SET
name = '100533799 - Tinta Vitral Pébéo Amarelo Opaco Sol'
WHERE
option_value_id = 2337
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2337
DELETE FROM oc_product
WHERE
model = '100533799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2337
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2338
UPDATE oc_option_value_description
SET
name = '100533899 - Tinta Vitral Pébéo Verde Claro Opaco'
WHERE
option_value_id = 2338
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2338
DELETE FROM oc_product
WHERE
model = '100533899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2338
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100533999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2339
UPDATE oc_option_value_description
SET
name = '100533999 - Tinta Vitral Pébéo Azul Marinho Opaco'
WHERE
option_value_id = 2339
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2339
DELETE FROM oc_product
WHERE
model = '100533999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2339
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2340
UPDATE oc_option_value_description
SET
name = '100534099 - Tinta Vitral Pébéo Azul Opaco'
WHERE
option_value_id = 2340
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2340
DELETE FROM oc_product
WHERE
model = '100534099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2340
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2341
UPDATE oc_option_value_description
SET
name = '100534199 - Tinta Vitral Pébéo Vermelho Opaco'
WHERE
option_value_id = 2341
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2341
DELETE FROM oc_product
WHERE
model = '100534199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2341
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2342
UPDATE oc_option_value_description
SET
name = '100534299 - Tinta Vitral Pébéo Mandaria Opaca'
WHERE
option_value_id = 2342
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2342
DELETE FROM oc_product
WHERE
model = '100534299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2342
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2343
UPDATE oc_option_value_description
SET
name = '100534399 - Tinta Vitral Pébéo Estanho Opaco'
WHERE
option_value_id = 2343
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2343
DELETE FROM oc_product
WHERE
model = '100534399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2343
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2344
UPDATE oc_option_value_description
SET
name = '100534499 - Tinta Vitral Pébéo Ouro Opaco'
WHERE
option_value_id = 2344
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2344
DELETE FROM oc_product
WHERE
model = '100534499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2344
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2345
UPDATE oc_option_value_description
SET
name = '100534599 - Tinta Vitral Pébéo Branco Opaco'
WHERE
option_value_id = 2345
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2345
DELETE FROM oc_product
WHERE
model = '100534599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 94
AND product_id = 27026
AND option_id = 15
AND option_value_id = 2345
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27043
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2346
UPDATE oc_option_value_description
SET
name = '100534699 - Cerne Pébéo Preto'
WHERE
option_value_id = 2346
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2346
DELETE FROM oc_product
WHERE
model = '100534699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2346
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2347
UPDATE oc_option_value_description
SET
name = '100534799 - Cerne Pébéo Vermelho Dourado'
WHERE
option_value_id = 2347
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2347
DELETE FROM oc_product
WHERE
model = '100534799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2347
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2348
UPDATE oc_option_value_description
SET
name = '100534899 - Cerne Pébéo Cobre'
WHERE
option_value_id = 2348
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2348
DELETE FROM oc_product
WHERE
model = '100534899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2348
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2349
UPDATE oc_option_value_description
SET
name = '100534999 - Cerne Pébéo Chumbo'
WHERE
option_value_id = 2349
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2349
DELETE FROM oc_product
WHERE
model = '100534999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2349
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100535099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2350
UPDATE oc_option_value_description
SET
name = '100535099 - Cerne Pébéo Ouro'
WHERE
option_value_id = 2350
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2350
DELETE FROM oc_product
WHERE
model = '100535099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2350
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100535199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2351
UPDATE oc_option_value_description
SET
name = '100535199 - Cerne Pébéo Ouro Rei'
WHERE
option_value_id = 2351
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2351
DELETE FROM oc_product
WHERE
model = '100535199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2351
Ok.