Product Sync.
Opencart products: 67
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 - %'
)
NEW: Médio para Acrílico Pébéo
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 Acrílico Pébéo - %'
)
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: 27455
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: 27451
Image file:
NEW: Tinta Relevo Cerne Pébéo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Relevo Cerne Pébéo - %'
)
Ok.
Product Option Sync.
Opencart products: 73
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 = 27466
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27466,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3348 AS option_value_id,
language_id,
17 AS option_id,
'100525599 - Gel de Textura Pébéo Brilhante 100 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 443
AND product_id = 27466
AND option_id = 17
AND option_value_id = 3348
DELETE FROM oc_product
WHERE
model = '100525599'
INSERT INTO oc_product_option_value
SET
product_option_id = 443,
product_id = 27466,
option_id = 17,
option_value_id = 3348,
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 = 27467
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27467,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3349 AS option_value_id,
language_id,
17 AS option_id,
'100525699 - Médio Gel para Acrílico Pébéo Mate 100 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 444
AND product_id = 27467
AND option_id = 17
AND option_value_id = 3349
DELETE FROM oc_product
WHERE
model = '100525699'
INSERT INTO oc_product_option_value
SET
product_option_id = 444,
product_id = 27467,
option_id = 17,
option_value_id = 3349,
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 '100525799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3350 AS option_value_id,
language_id,
17 AS option_id,
'100525799 - Médio para Acrílico Pébéo Aglutinante Brilhante Bindex 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 444
AND product_id = 27467
AND option_id = 17
AND option_value_id = 3350
DELETE FROM oc_product
WHERE
model = '100525799'
INSERT INTO oc_product_option_value
SET
product_option_id = 444,
product_id = 27467,
option_id = 17,
option_value_id = 3350,
quantity = 1,
subtract = 1,
price = 2.114,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27468
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27468,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100525999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3351 AS option_value_id,
language_id,
17 AS option_id,
'100525999 - Gel de Textura de Areia Pébéo Amarelo 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 445
AND product_id = 27468
AND option_id = 17
AND option_value_id = 3351
DELETE FROM oc_product
WHERE
model = '100525999'
INSERT INTO oc_product_option_value
SET
product_option_id = 445,
product_id = 27468,
option_id = 17,
option_value_id = 3351,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3352 AS option_value_id,
language_id,
17 AS option_id,
'100526099 - Gel de Textura de Areia Pébéo Vermelho 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 445
AND product_id = 27468
AND option_id = 17
AND option_value_id = 3352
DELETE FROM oc_product
WHERE
model = '100526099'
INSERT INTO oc_product_option_value
SET
product_option_id = 445,
product_id = 27468,
option_id = 17,
option_value_id = 3352,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3353 AS option_value_id,
language_id,
17 AS option_id,
'100526199 - Gel de Textura de Areia Pébéo Preto 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 445
AND product_id = 27468
AND option_id = 17
AND option_value_id = 3353
DELETE FROM oc_product
WHERE
model = '100526199'
INSERT INTO oc_product_option_value
SET
product_option_id = 445,
product_id = 27468,
option_id = 17,
option_value_id = 3353,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3354 AS option_value_id,
language_id,
17 AS option_id,
'100526299 - Gel de Textura de Areia Pébéo Branco 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 445
AND product_id = 27468
AND option_id = 17
AND option_value_id = 3354
DELETE FROM oc_product
WHERE
model = '100526299'
INSERT INTO oc_product_option_value
SET
product_option_id = 445,
product_id = 27468,
option_id = 17,
option_value_id = 3354,
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 = 27455
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100526399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3355 AS option_value_id,
language_id,
17 AS option_id,
'100526399 - Setacolor Opaco Branco Titânio' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3355
DELETE FROM oc_product
WHERE
model = '100526399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3355,
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 '100526499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3356 AS option_value_id,
language_id,
17 AS option_id,
'100526499 - Setacolor Opaco Azul Cobalto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3356
DELETE FROM oc_product
WHERE
model = '100526499'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3356,
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 '100526599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3357 AS option_value_id,
language_id,
17 AS option_id,
'100526599 - Setacolor Opaco Laranja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3357
DELETE FROM oc_product
WHERE
model = '100526599'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3357,
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 '100526699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3358 AS option_value_id,
language_id,
17 AS option_id,
'100526699 - Setacolor Opaco Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3358
DELETE FROM oc_product
WHERE
model = '100526699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3358,
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 '100526799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3359 AS option_value_id,
language_id,
17 AS option_id,
'100526799 - Setacolor Opaco Castanho Veludo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3359
DELETE FROM oc_product
WHERE
model = '100526799'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3359,
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 '100526899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3360 AS option_value_id,
language_id,
17 AS option_id,
'100526899 - Setacolor Opaco Vermelho Oriental' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3360
DELETE FROM oc_product
WHERE
model = '100526899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3360,
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 '100526999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3361 AS option_value_id,
language_id,
17 AS option_id,
'100526999 - Setacolor Opaco Amarelo Limão' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3361
DELETE FROM oc_product
WHERE
model = '100526999'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3361,
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 '100527099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3362 AS option_value_id,
language_id,
17 AS option_id,
'100527099 - Setacolor Opaco Vermelho Granada' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3362
DELETE FROM oc_product
WHERE
model = '100527099'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3362,
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 '100527199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3363 AS option_value_id,
language_id,
17 AS option_id,
'100527199 - Setacolor Opaco Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3363
DELETE FROM oc_product
WHERE
model = '100527199'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3363,
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 '100527299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3364 AS option_value_id,
language_id,
17 AS option_id,
'100527299 - Setacolor Opaco Azul Royal' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3364
DELETE FROM oc_product
WHERE
model = '100527299'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3364,
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 '100527399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3365 AS option_value_id,
language_id,
17 AS option_id,
'100527399 - Setacolor Opaco Indigo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3365
DELETE FROM oc_product
WHERE
model = '100527399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3365,
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 '100527499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3366 AS option_value_id,
language_id,
17 AS option_id,
'100527499 - Setacolor Opaco Canela' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3366
DELETE FROM oc_product
WHERE
model = '100527499'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3366,
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 '100527599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3367 AS option_value_id,
language_id,
17 AS option_id,
'100527599 - Setacolor Opaco Verde Primavera' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3367
DELETE FROM oc_product
WHERE
model = '100527599'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3367,
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 '100527699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3368 AS option_value_id,
language_id,
17 AS option_id,
'100527699 - Setacolor Opaco Sienna' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3368
DELETE FROM oc_product
WHERE
model = '100527699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3368,
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 '100527799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3369 AS option_value_id,
language_id,
17 AS option_id,
'100527799 - Setacolor Opaco Vermelhão' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3369
DELETE FROM oc_product
WHERE
model = '100527799'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3369,
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 '100527899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3370 AS option_value_id,
language_id,
17 AS option_id,
'100527899 - Setacolor Opaco Verde Claro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3370
DELETE FROM oc_product
WHERE
model = '100527899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3370,
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 '100527999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3371 AS option_value_id,
language_id,
17 AS option_id,
'100527999 - Setacolor Opaco VIOLETA Parma' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3371
DELETE FROM oc_product
WHERE
model = '100527999'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3371,
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 '100528099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3372 AS option_value_id,
language_id,
17 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 = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3372
DELETE FROM oc_product
WHERE
model = '100528099'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3372,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3373 AS option_value_id,
language_id,
17 AS option_id,
'100528199 - Setacolor Opaco Pérola Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3373
DELETE FROM oc_product
WHERE
model = '100528199'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3373,
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 '100528299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3374 AS option_value_id,
language_id,
17 AS option_id,
'100528299 - Setacolor Opaco Ouro Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3374
DELETE FROM oc_product
WHERE
model = '100528299'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3374,
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 '100528399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3375 AS option_value_id,
language_id,
17 AS option_id,
'100528399 - Setacolor Opaco Cobre Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3375
DELETE FROM oc_product
WHERE
model = '100528399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3375,
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 '100528499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3376 AS option_value_id,
language_id,
17 AS option_id,
'100528499 - Setacolor Opaco Cereja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3376
DELETE FROM oc_product
WHERE
model = '100528499'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3376,
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 '100528599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3377 AS option_value_id,
language_id,
17 AS option_id,
'100528599 - Setacolor Opaco Sanguine' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3377
DELETE FROM oc_product
WHERE
model = '100528599'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3377,
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 '100528699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3378 AS option_value_id,
language_id,
17 AS option_id,
'100528699 - Setacolor Opaco Fawn' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3378
DELETE FROM oc_product
WHERE
model = '100528699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3378,
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 '100528799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3379 AS option_value_id,
language_id,
17 AS option_id,
'100528799 - Setacolor Opaco Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3379
DELETE FROM oc_product
WHERE
model = '100528799'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3379,
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 '100528899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3380 AS option_value_id,
language_id,
17 AS option_id,
'100528899 - Setacolor Opaco Verde Dourado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3380
DELETE FROM oc_product
WHERE
model = '100528899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3380,
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 '100528999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3381 AS option_value_id,
language_id,
17 AS option_id,
'100528999 - Setacolor Opaco Azul Oreintal' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3381
DELETE FROM oc_product
WHERE
model = '100528999'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3381,
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 '100529099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3382 AS option_value_id,
language_id,
17 AS option_id,
'100529099 - Setacolor Opaco Azul Escuro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3382
DELETE FROM oc_product
WHERE
model = '100529099'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3382,
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 '100529199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3383 AS option_value_id,
language_id,
17 AS option_id,
'100529199 - Setacolor Opaco Prateado Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3383
DELETE FROM oc_product
WHERE
model = '100529199'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3383,
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 '100529299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3384 AS option_value_id,
language_id,
17 AS option_id,
'100529299 - Setacolor Opaco Verde Canario Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3384
DELETE FROM oc_product
WHERE
model = '100529299'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3384,
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 '100529399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3385 AS option_value_id,
language_id,
17 AS option_id,
'100529399 - Setacolor Opaco Laranja Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3385
DELETE FROM oc_product
WHERE
model = '100529399'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3385,
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 '100529499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3386 AS option_value_id,
language_id,
17 AS option_id,
'100529499 - Setacolor Opaco Vermelho Oriental Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3386
DELETE FROM oc_product
WHERE
model = '100529499'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3386,
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 '100529599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3387 AS option_value_id,
language_id,
17 AS option_id,
'100529599 - Setacolor Opaco Roxo Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3387
DELETE FROM oc_product
WHERE
model = '100529599'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3387,
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 '100529699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3388 AS option_value_id,
language_id,
17 AS option_id,
'100529699 - Setacolor Opaco Vinho Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3388
DELETE FROM oc_product
WHERE
model = '100529699'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3388,
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 '100529799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3389 AS option_value_id,
language_id,
17 AS option_id,
'100529799 - Setacolor Opaco Violeta Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3389
DELETE FROM oc_product
WHERE
model = '100529799'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3389,
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 '100529899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3390 AS option_value_id,
language_id,
17 AS option_id,
'100529899 - Setacolor Opaco Azul Electrico' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3390
DELETE FROM oc_product
WHERE
model = '100529899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3390,
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 '100529999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3391 AS option_value_id,
language_id,
17 AS option_id,
'100529999 - Setacolor Opaco Bronze Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3391
DELETE FROM oc_product
WHERE
model = '100529999'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3391,
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 '100530099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3392 AS option_value_id,
language_id,
17 AS option_id,
'100530099 - Setacolor Opaco Cinza Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3392
DELETE FROM oc_product
WHERE
model = '100530099'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3392,
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 '100530199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3393 AS option_value_id,
language_id,
17 AS option_id,
'100530199 - Setacolor Opaco Chocolate Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3393
DELETE FROM oc_product
WHERE
model = '100530199'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3393,
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 '100530299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3394 AS option_value_id,
language_id,
17 AS option_id,
'100530299 - Setacolor Opaco Azul Noite Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3394
DELETE FROM oc_product
WHERE
model = '100530299'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3394,
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 = 27469
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27469,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100530399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3395 AS option_value_id,
language_id,
17 AS option_id,
'100530399 - Médio Setacolor Pébéo Brilhante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 446
AND product_id = 27469
AND option_id = 17
AND option_value_id = 3395
DELETE FROM oc_product
WHERE
model = '100530399'
INSERT INTO oc_product_option_value
SET
product_option_id = 446,
product_id = 27469,
option_id = 17,
option_value_id = 3395,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3396 AS option_value_id,
language_id,
17 AS option_id,
'100530499 - Médio Setacolor Pébéo Espessante Stencil' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 446
AND product_id = 27469
AND option_id = 17
AND option_value_id = 3396
DELETE FROM oc_product
WHERE
model = '100530499'
INSERT INTO oc_product_option_value
SET
product_option_id = 446,
product_id = 27469,
option_id = 17,
option_value_id = 3396,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3397 AS option_value_id,
language_id,
17 AS option_id,
'100530999 - Médio Setacolor Pébéo Nacarado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 446
AND product_id = 27469
AND option_id = 17
AND option_value_id = 3397
DELETE FROM oc_product
WHERE
model = '100530999'
INSERT INTO oc_product_option_value
SET
product_option_id = 446,
product_id = 27469,
option_id = 17,
option_value_id = 3397,
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 = 27451
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100531099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3398 AS option_value_id,
language_id,
17 AS option_id,
'100531099 - Tinta Vitral Pébéo Azul Profundo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3398
DELETE FROM oc_product
WHERE
model = '100531099'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3398,
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 '100531199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3399 AS option_value_id,
language_id,
17 AS option_id,
'100531199 - Tinta Vitral Pébéo Castanho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3399
DELETE FROM oc_product
WHERE
model = '100531199'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3399,
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 '100531299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3400 AS option_value_id,
language_id,
17 AS option_id,
'100531299 - Tinta Vitral Pébéo Crimson' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3400
DELETE FROM oc_product
WHERE
model = '100531299'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3400,
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 '100531399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3401 AS option_value_id,
language_id,
17 AS option_id,
'100531399 - Tinta Vitral Pébéo Esmeralda' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3401
DELETE FROM oc_product
WHERE
model = '100531399'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3401,
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 '100531499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3402 AS option_value_id,
language_id,
17 AS option_id,
'100531499 - Tinta Vitral Pébéo Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3402
DELETE FROM oc_product
WHERE
model = '100531499'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3402,
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 '100531599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3403 AS option_value_id,
language_id,
17 AS option_id,
'100531599 - Tinta Vitral Pébéo Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3403
DELETE FROM oc_product
WHERE
model = '100531599'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3403,
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 '100531699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3404 AS option_value_id,
language_id,
17 AS option_id,
'100531699 - Tinta Vitral Pébéo Laranja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3404
DELETE FROM oc_product
WHERE
model = '100531699'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3404,
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 '100531799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3405 AS option_value_id,
language_id,
17 AS option_id,
'100531799 - Tinta Vitral Pébéo Turquesa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3405
DELETE FROM oc_product
WHERE
model = '100531799'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3405,
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 '100531899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3406 AS option_value_id,
language_id,
17 AS option_id,
'100531899 - Tinta Vitral Pébéo Chartreuse' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3406
DELETE FROM oc_product
WHERE
model = '100531899'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3406,
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 '100531999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3407 AS option_value_id,
language_id,
17 AS option_id,
'100531999 - Tinta Vitral Pébéo Vermelho Violeta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3407
DELETE FROM oc_product
WHERE
model = '100531999'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3407,
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 '100532099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3408 AS option_value_id,
language_id,
17 AS option_id,
'100532099 - Tinta Vitral Pébéo Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3408
DELETE FROM oc_product
WHERE
model = '100532099'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3408,
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 '100532199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3409 AS option_value_id,
language_id,
17 AS option_id,
'100532199 - Tinta Vitral Pébéo Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3409
DELETE FROM oc_product
WHERE
model = '100532199'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3409,
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 '100532299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3410 AS option_value_id,
language_id,
17 AS option_id,
'100532299 - Tinta Vitral Pébéo Verde Dourado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3410
DELETE FROM oc_product
WHERE
model = '100532299'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3410,
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 '100532399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3411 AS option_value_id,
language_id,
17 AS option_id,
'100532399 - Tinta Vitral Pébéo Limao' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3411
DELETE FROM oc_product
WHERE
model = '100532399'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3411,
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 '100532499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3412 AS option_value_id,
language_id,
17 AS option_id,
'100532499 - Tinta Vitral Pébéo Violeta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3412
DELETE FROM oc_product
WHERE
model = '100532499'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3412,
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 '100532599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3413 AS option_value_id,
language_id,
17 AS option_id,
'100532599 - Tinta Vitral Pébéo Roxo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3413
DELETE FROM oc_product
WHERE
model = '100532599'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3413,
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 '100532699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3414 AS option_value_id,
language_id,
17 AS option_id,
'100532699 - Tinta Vitral Pébéo Areia' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3414
DELETE FROM oc_product
WHERE
model = '100532699'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3414,
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 '100532799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3415 AS option_value_id,
language_id,
17 AS option_id,
'100532799 - Tinta Vitral Pébéo Rosa Velho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3415
DELETE FROM oc_product
WHERE
model = '100532799'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3415,
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 '100532899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3416 AS option_value_id,
language_id,
17 AS option_id,
'100532899 - Tinta Vitral Pébéo Salmão' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3416
DELETE FROM oc_product
WHERE
model = '100532899'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3416,
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 '100532999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3417 AS option_value_id,
language_id,
17 AS option_id,
'100532999 - Tinta Vitral Pébéo Parma' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3417
DELETE FROM oc_product
WHERE
model = '100532999'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3417,
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 '100533099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3418 AS option_value_id,
language_id,
17 AS option_id,
'100533099 - Tinta Vitral Pébéo Verde Maçã' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3418
DELETE FROM oc_product
WHERE
model = '100533099'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3418,
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 '100533199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3419 AS option_value_id,
language_id,
17 AS option_id,
'100533199 - Tinta Vitral Pébéo Verde Escuro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3419
DELETE FROM oc_product
WHERE
model = '100533199'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3419,
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 '100533299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3420 AS option_value_id,
language_id,
17 AS option_id,
'100533299 - Tinta Vitral Pébéo Azul Céu' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3420
DELETE FROM oc_product
WHERE
model = '100533299'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3420,
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 '100533399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3421 AS option_value_id,
language_id,
17 AS option_id,
'100533399 - Tinta Vitral Pébéo Azul Cobalto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3421
DELETE FROM oc_product
WHERE
model = '100533399'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3421,
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 '100533499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3422 AS option_value_id,
language_id,
17 AS option_id,
'100533499 - Tinta Vitral Pébéo Dourado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3422
DELETE FROM oc_product
WHERE
model = '100533499'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3422,
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 '100533599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3423 AS option_value_id,
language_id,
17 AS option_id,
'100533599 - Tinta Vitral Pébéo Perola' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3423
DELETE FROM oc_product
WHERE
model = '100533599'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3423,
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 '100533699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3424 AS option_value_id,
language_id,
17 AS option_id,
'100533699 - Tinta Vitral Pébéo Amarelo Opaco Trigo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3424
DELETE FROM oc_product
WHERE
model = '100533699'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3424,
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 '100533799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3425 AS option_value_id,
language_id,
17 AS option_id,
'100533799 - Tinta Vitral Pébéo Amarelo Opaco Sol' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3425
DELETE FROM oc_product
WHERE
model = '100533799'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3425,
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 '100533899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3426 AS option_value_id,
language_id,
17 AS option_id,
'100533899 - Tinta Vitral Pébéo Verde Claro Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3426
DELETE FROM oc_product
WHERE
model = '100533899'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3426,
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 '100533999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3427 AS option_value_id,
language_id,
17 AS option_id,
'100533999 - Tinta Vitral Pébéo Azul Marinho Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3427
DELETE FROM oc_product
WHERE
model = '100533999'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3427,
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 '100534099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3428 AS option_value_id,
language_id,
17 AS option_id,
'100534099 - Tinta Vitral Pébéo Azul Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3428
DELETE FROM oc_product
WHERE
model = '100534099'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3428,
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 '100534199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3429 AS option_value_id,
language_id,
17 AS option_id,
'100534199 - Tinta Vitral Pébéo Vermelho Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3429
DELETE FROM oc_product
WHERE
model = '100534199'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3429,
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 '100534299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3430 AS option_value_id,
language_id,
17 AS option_id,
'100534299 - Tinta Vitral Pébéo Mandaria Opaca' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3430
DELETE FROM oc_product
WHERE
model = '100534299'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3430,
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 '100534399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3431 AS option_value_id,
language_id,
17 AS option_id,
'100534399 - Tinta Vitral Pébéo Estanho Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3431
DELETE FROM oc_product
WHERE
model = '100534399'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3431,
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 '100534499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3432 AS option_value_id,
language_id,
17 AS option_id,
'100534499 - Tinta Vitral Pébéo Ouro Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3432
DELETE FROM oc_product
WHERE
model = '100534499'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3432,
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 '100534599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3433 AS option_value_id,
language_id,
17 AS option_id,
'100534599 - Tinta Vitral Pébéo Branco Opaco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 430
AND product_id = 27451
AND option_id = 17
AND option_value_id = 3433
DELETE FROM oc_product
WHERE
model = '100534599'
INSERT INTO oc_product_option_value
SET
product_option_id = 430,
product_id = 27451,
option_id = 17,
option_value_id = 3433,
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 = 27470
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27470,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100534699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3434 AS option_value_id,
language_id,
17 AS option_id,
'100534699 - Cerne Pébéo Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3434
DELETE FROM oc_product
WHERE
model = '100534699'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3434,
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 '100534799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3435 AS option_value_id,
language_id,
17 AS option_id,
'100534799 - Cerne Pébéo Vermelho Dourado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3435
DELETE FROM oc_product
WHERE
model = '100534799'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3435,
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 '100534899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3436 AS option_value_id,
language_id,
17 AS option_id,
'100534899 - Cerne Pébéo Cobre' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3436
DELETE FROM oc_product
WHERE
model = '100534899'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3436,
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 '100534999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3437 AS option_value_id,
language_id,
17 AS option_id,
'100534999 - Cerne Pébéo Chumbo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3437
DELETE FROM oc_product
WHERE
model = '100534999'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3437,
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 '100535099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3438 AS option_value_id,
language_id,
17 AS option_id,
'100535099 - Cerne Pébéo Ouro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3438
DELETE FROM oc_product
WHERE
model = '100535099'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3438,
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 '100535199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3439 AS option_value_id,
language_id,
17 AS option_id,
'100535199 - Cerne Pébéo Ouro Rei' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3439
DELETE FROM oc_product
WHERE
model = '100535199'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3439,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.