Product Sync.
Opencart products: 104
Input products: 100
NEW: 101201999
NEW: 101202099
NEW: 101202199
NEW: 101202299
NEW: 101202399
NEW: 101202499
NEW: 101202599
NEW: 101202699
NEW: 101202799
UPDATING: Tinta para Artes Decorativas Pébéo com efeito Prisma
Product ID: 27457
Image file:
NEW: 101203599
NEW: 101203699
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27455
Image file:
NEW: 101205899
NEW: 101205999
NEW: 101206099
NEW: 101206199
NEW: 101206299
NEW: 101206399
NEW: 101206499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101206499 - %'
)
NEW: 101206599
NEW: 101206699
NEW: 101206799
NEW: 101206899
NEW: 101206999
NEW: 101207099
NEW: 101207199
NEW: 101207299
NEW: 101207399
NEW: 101207499
NEW: 101207599
NEW: 101207699
NEW: 101207799
NEW: 101207899
NEW: 101207999
NEW: 101208099
NEW: 101208199
NEW: 101208299
NEW: 101208399
NEW: 101208499
NEW: 101208599
NEW: 101208699
NEW: 101208799
NEW: 101208899
NEW: 101208999
NEW: 101209099
NEW: 101209199
NEW: 101209299
NEW: 101209399
NEW: 101209499
NEW: 101209599
NEW: 101209699
NEW: 101209799
NEW: 101209899
NEW: 101209999
NEW: 101210099
NEW: 101210199
NEW: Médio Gel para Acrílico Extra Forte Talens
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 Gel para Acrílico Extra Forte Talens - %'
)
UPDATING: Aguarela Líquida Ecoline
Product ID: 27449
Image file:
NEW: 101210699
NEW: 101210799
NEW: 101210899
NEW: 101210999
NEW: 101211099
NEW: 101211199
NEW: Pincel Derwent com Reservatório de Água
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Derwent com Reservatório de Água - %'
)
NEW: 101211499
NEW: 101211599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101211599 - %'
)
NEW: 101211699
NEW: 101211799
NEW: 101211899
Ok.
Product Option Sync.
Opencart products: 108
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 = 27457
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101202899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3496 AS option_value_id,
language_id,
17 AS option_id,
'101202899 - Tinta Pébéo Prisma 45 ml Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3496
DELETE FROM oc_product
WHERE
model = '101202899'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3496,
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 '101202999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3497 AS option_value_id,
language_id,
17 AS option_id,
'101202999 - Tinta Pébéo Prisma 45 ml Amarelo Sol' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3497
DELETE FROM oc_product
WHERE
model = '101202999'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3497,
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 '101203099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3498 AS option_value_id,
language_id,
17 AS option_id,
'101203099 - Tinta Pébéo Prisma 45 ml Botao de Ouro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3498
DELETE FROM oc_product
WHERE
model = '101203099'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3498,
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 '101203199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3499 AS option_value_id,
language_id,
17 AS option_id,
'101203199 - Tinta Pébéo Prisma 45 ml Lar Mandarine' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3499
DELETE FROM oc_product
WHERE
model = '101203199'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3499,
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 '101203299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3500 AS option_value_id,
language_id,
17 AS option_id,
'101203299 - Tinta Pébéo Prisma 45 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3500
DELETE FROM oc_product
WHERE
model = '101203299'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3500,
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 '101203399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3501 AS option_value_id,
language_id,
17 AS option_id,
'101203399 - Tinta Pébéo Prisma 45 ml Vermelho Ingles' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3501
DELETE FROM oc_product
WHERE
model = '101203399'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3501,
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 '101203499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3502 AS option_value_id,
language_id,
17 AS option_id,
'101203499 - Tinta Pébéo Prisma 45 ml Cereja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3502
DELETE FROM oc_product
WHERE
model = '101203499'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3502,
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 '101203799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3503 AS option_value_id,
language_id,
17 AS option_id,
'101203799 - Tinta Pébéo Prisma 45 ml Rosa Gelado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3503
DELETE FROM oc_product
WHERE
model = '101203799'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3503,
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 '101203899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3504 AS option_value_id,
language_id,
17 AS option_id,
'101203899 - Tinta Pébéo Prisma 45 ml Rosa Velho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3504
DELETE FROM oc_product
WHERE
model = '101203899'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3504,
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 '101203999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3505 AS option_value_id,
language_id,
17 AS option_id,
'101203999 - Tinta Pébéo Prisma 45 ml Rosa Azulado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3505
DELETE FROM oc_product
WHERE
model = '101203999'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3505,
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 '101204099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3506 AS option_value_id,
language_id,
17 AS option_id,
'101204099 - Tinta Pébéo Prisma 45 ml Violeta Nacarado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3506
DELETE FROM oc_product
WHERE
model = '101204099'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3506,
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 '101204199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3507 AS option_value_id,
language_id,
17 AS option_id,
'101204199 - Tinta Pébéo Prisma 45 ml Roxo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3507
DELETE FROM oc_product
WHERE
model = '101204199'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3507,
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 '101204299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3508 AS option_value_id,
language_id,
17 AS option_id,
'101204299 - Tinta Pébéo Prisma 45 ml Azul Cinza' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3508
DELETE FROM oc_product
WHERE
model = '101204299'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3508,
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 '101204399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3509 AS option_value_id,
language_id,
17 AS option_id,
'101204399 - Tinta Pébéo Prisma 45 ml Azul Noite' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3509
DELETE FROM oc_product
WHERE
model = '101204399'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3509,
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 '101204599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3510 AS option_value_id,
language_id,
17 AS option_id,
'101204599 - Tinta Pébéo Prisma 45 ml Azul Caribe' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3510
DELETE FROM oc_product
WHERE
model = '101204599'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3510,
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 '101204699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3511 AS option_value_id,
language_id,
17 AS option_id,
'101204699 - Tinta Pébéo Prisma 45 ml Turquesa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3511
DELETE FROM oc_product
WHERE
model = '101204699'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3511,
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 '101204799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3512 AS option_value_id,
language_id,
17 AS option_id,
'101204799 - Tinta Pébéo Prisma 45 ml Verde Amendoa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3512
DELETE FROM oc_product
WHERE
model = '101204799'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3512,
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 '101204899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3513 AS option_value_id,
language_id,
17 AS option_id,
'101204899 - Tinta Pébéo Prisma 45 ml Esmeralda' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3513
DELETE FROM oc_product
WHERE
model = '101204899'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3513,
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 '101204999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3514 AS option_value_id,
language_id,
17 AS option_id,
'101204999 - Tinta Pébéo Prisma 45 ml Verde Nacarado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3514
DELETE FROM oc_product
WHERE
model = '101204999'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3514,
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 '101205099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3515 AS option_value_id,
language_id,
17 AS option_id,
'101205099 - Tinta Pébéo Prisma 45 ml Verde Folha' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3515
DELETE FROM oc_product
WHERE
model = '101205099'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3515,
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 '101205199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3516 AS option_value_id,
language_id,
17 AS option_id,
'101205199 - Tinta Pébéo Prisma 45 ml Verde Dourado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3516
DELETE FROM oc_product
WHERE
model = '101205199'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3516,
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 '101205299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3517 AS option_value_id,
language_id,
17 AS option_id,
'101205299 - Tinta Pébéo Prisma 45 ml Verde Ocre' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3517
DELETE FROM oc_product
WHERE
model = '101205299'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3517,
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 '101205399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3518 AS option_value_id,
language_id,
17 AS option_id,
'101205399 - Tinta Pébéo Prisma 45 ml Canela' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3518
DELETE FROM oc_product
WHERE
model = '101205399'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3518,
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 '101205499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3519 AS option_value_id,
language_id,
17 AS option_id,
'101205499 - Tinta Pébéo Prisma 45 ml Ouro Velho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3519
DELETE FROM oc_product
WHERE
model = '101205499'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3519,
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 '101205599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3520 AS option_value_id,
language_id,
17 AS option_id,
'101205599 - Tinta Pébéo Prisma 45 ml Castanho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3520
DELETE FROM oc_product
WHERE
model = '101205599'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3520,
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 '101205699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3521 AS option_value_id,
language_id,
17 AS option_id,
'101205699 - Tinta Pébéo Prisma 45 ml Cinza' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3521
DELETE FROM oc_product
WHERE
model = '101205699'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3521,
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 '101205799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3522 AS option_value_id,
language_id,
17 AS option_id,
'101205799 - Tinta Pébéo Prisma 45 ml Onix' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3522
DELETE FROM oc_product
WHERE
model = '101205799'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3522,
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 '101204499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3523 AS option_value_id,
language_id,
17 AS option_id,
'101204499 - Setacolor Opaco Azul Turquesa' 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 = 3523
DELETE FROM oc_product
WHERE
model = '101204499'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3523,
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 = 27503
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27503,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101210299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3524 AS option_value_id,
language_id,
17 AS option_id,
'101210299 - Médio Gel para Acrílico Extra Forte Talens Mate 1 lt' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 466
AND product_id = 27503
AND option_id = 17
AND option_value_id = 3524
DELETE FROM oc_product
WHERE
model = '101210299'
INSERT INTO oc_product_option_value
SET
product_option_id = 466,
product_id = 27503,
option_id = 17,
option_value_id = 3524,
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 '101210399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3525 AS option_value_id,
language_id,
17 AS option_id,
'101210399 - Médio Gel para Acrílico Forte Talens 015 Brilhante 1 Lt' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 466
AND product_id = 27503
AND option_id = 17
AND option_value_id = 3525
DELETE FROM oc_product
WHERE
model = '101210399'
INSERT INTO oc_product_option_value
SET
product_option_id = 466,
product_id = 27503,
option_id = 17,
option_value_id = 3525,
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 = 27449
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101210499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1526
UPDATE oc_option_value_description
SET
name = '101210499 - Aguarela Ecoline Talens 25 - 30 ml Verde Bronze 657'
WHERE
option_value_id = 1526
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 1526
DELETE FROM oc_product
WHERE
model = '101210499'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 1526,
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 '101210599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1527
UPDATE oc_option_value_description
SET
name = '101210599 - Aguarela Ecoline Talens 25 - 30 ml Vermelho Pastel 381'
WHERE
option_value_id = 1527
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 1527
DELETE FROM oc_product
WHERE
model = '101210599'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 1527,
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 = 27504
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27504,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101211299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101211299.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3526 AS option_value_id,
language_id,
17 AS option_id,
'101211299 - Pincel Derwent com Reservatório de Água Espatulado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 467
AND product_id = 27504
AND option_id = 17
AND option_value_id = 3526
DELETE FROM oc_product
WHERE
model = '101211299'
INSERT INTO oc_product_option_value
SET
product_option_id = 467,
product_id = 27504,
option_id = 17,
option_value_id = 3526,
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 '101211399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101211399.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3527 AS option_value_id,
language_id,
17 AS option_id,
'101211399 - Pincel Derwent com Reservatório de Água PK3' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 467
AND product_id = 27504
AND option_id = 17
AND option_value_id = 3527
DELETE FROM oc_product
WHERE
model = '101211399'
INSERT INTO oc_product_option_value
SET
product_option_id = 467,
product_id = 27504,
option_id = 17,
option_value_id = 3527,
quantity = 1,
subtract = 1,
price = 7.48,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.