Product Sync.
Opencart products: 158
Input products: 100
NEW: 102040299
NEW: 102040399
NEW: 102040499
NEW: 102040599
NEW: 102040699
NEW: 102040799
NEW: 102040899
NEW: 102040999
NEW: 102041099
NEW: 102041199
NEW: 102041299
NEW: 102041399
NEW: 102041499
UPDATING: Guache Giotto Lavável 500 ml
Product ID: 27482
Image file:
NEW: 102041699
NEW: 102041799
NEW: 102041899
NEW: 102041999
NEW: 102042099
NEW: 102042199
NEW: 102042299
NEW: 102042399
NEW: 102042499
NEW: 102042599
NEW: 102042699
NEW: 102042799
NEW: 102042899
NEW: 102042999
NEW: 102043099
NEW: 102043199
NEW: 102043299
NEW: 102043399
NEW: 102043499
NEW: 102043599
NEW: 102043699
NEW: 102043799
NEW: 102043899
NEW: 102043999
NEW: 102044099
NEW: 102044199
NEW: 102044299
NEW: 102044399
NEW: 102044499
NEW: 102044599
NEW: 102044699
NEW: 102044799
NEW: 102044899
NEW: 102044999
NEW: 102045099
NEW: 102045199
NEW: 102045299
NEW: 102045399
NEW: 102045499
NEW: 102045599
NEW: 102045699
UPDATING: Guache Giotto Caixa
Product ID: 27435
Image file:
UPDATING: Guache Giotto Frasco 250 ml
Product ID: 27413
Image file:
NEW: 102046699
NEW: 102046799
NEW: 102046899
NEW: 102046999
NEW: 102047099
NEW: 102047199
NEW: 102047299
NEW: 102047399
NEW: 102047499
NEW: 102047599
UPDATING: Guache Pelikan
Product ID: 27446
Image file:
NEW: Tinta Relevo Pébéo para Tecido
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 Pébéo para Tecido - %'
)
NEW: 102050099
NEW: 102050199
Ok.
Product Option Sync.
Opencart products: 159
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 = 27482
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102041599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3623 AS option_value_id,
language_id,
17 AS option_id,
'102041599 - Guache Giotto 500 ml Lavável Magenta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3623
DELETE FROM oc_product
WHERE
model = '102041599'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3623,
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 = 27435
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102045799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1886
UPDATE oc_option_value_description
SET
name = '102045799 - Guache Giotto 25 ml com 6 Cores e Pincel'
WHERE
option_value_id = 1886
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 416
AND product_id = 27435
AND option_id = 17
AND option_value_id = 1886
DELETE FROM oc_product
WHERE
model = '102045799'
INSERT INTO oc_product_option_value
SET
product_option_id = 416,
product_id = 27435,
option_id = 17,
option_value_id = 1886,
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 = 27413
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102045899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1887
UPDATE oc_option_value_description
SET
name = '102045899 - Guache Giotto 250 ml Branco'
WHERE
option_value_id = 1887
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1887
DELETE FROM oc_product
WHERE
model = '102045899'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1887,
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 '102045999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1888
UPDATE oc_option_value_description
SET
name = '102045999 - Guache Giotto 250 ml Amarelo'
WHERE
option_value_id = 1888
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1888
DELETE FROM oc_product
WHERE
model = '102045999'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1888,
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 '102046099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1889
UPDATE oc_option_value_description
SET
name = '102046099 - Guache Giotto 250 ml Vermelho Escuro'
WHERE
option_value_id = 1889
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1889
DELETE FROM oc_product
WHERE
model = '102046099'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1889,
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 '102046199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1890
UPDATE oc_option_value_description
SET
name = '102046199 - Guache Giotto 250 ml Magenta'
WHERE
option_value_id = 1890
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1890
DELETE FROM oc_product
WHERE
model = '102046199'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1890,
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 '102046299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1891
UPDATE oc_option_value_description
SET
name = '102046299 - Guache Giotto 250 ml Verde'
WHERE
option_value_id = 1891
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1891
DELETE FROM oc_product
WHERE
model = '102046299'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1891,
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 '102046399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1892
UPDATE oc_option_value_description
SET
name = '102046399 - Guache Giotto 250 ml Azul Cyan'
WHERE
option_value_id = 1892
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1892
DELETE FROM oc_product
WHERE
model = '102046399'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1892,
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 '102046499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1893
UPDATE oc_option_value_description
SET
name = '102046499 - Guache Giotto 250 ml Preto'
WHERE
option_value_id = 1893
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1893
DELETE FROM oc_product
WHERE
model = '102046499'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1893,
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 '102046599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1894
UPDATE oc_option_value_description
SET
name = '102046599 - Guache Giotto 250 ml Castanho'
WHERE
option_value_id = 1894
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 402
AND product_id = 27413
AND option_id = 17
AND option_value_id = 1894
DELETE FROM oc_product
WHERE
model = '102046599'
INSERT INTO oc_product_option_value
SET
product_option_id = 402,
product_id = 27413,
option_id = 17,
option_value_id = 1894,
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 = 27446
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102047699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1895
UPDATE oc_option_value_description
SET
name = '102047699 - Guache Pelikan 10 ml Castanho'
WHERE
option_value_id = 1895
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 425
AND product_id = 27446
AND option_id = 17
AND option_value_id = 1895
DELETE FROM oc_product
WHERE
model = '102047699'
INSERT INTO oc_product_option_value
SET
product_option_id = 425,
product_id = 27446,
option_id = 17,
option_value_id = 1895,
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 = 27556
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27556,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102047799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3624 AS option_value_id,
language_id,
17 AS option_id,
'102047799 - Setacolor 3D Fluorescente 20 ml Amarelo Esverdeado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3624
DELETE FROM oc_product
WHERE
model = '102047799'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3624,
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 '102047899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3625 AS option_value_id,
language_id,
17 AS option_id,
'102047899 - Setacolor 3D Fluorescente 20 ml Azul Ultramarino Fluorescente' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3625
DELETE FROM oc_product
WHERE
model = '102047899'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3625,
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 '102047999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3626 AS option_value_id,
language_id,
17 AS option_id,
'102047999 - \''Setacolor 3D Glitter 20 ml Prateado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3626
DELETE FROM oc_product
WHERE
model = '102047999'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3626,
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 '102048099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3627 AS option_value_id,
language_id,
17 AS option_id,
'102048099 - \''Setacolor 3D Glitter 20 ml Dourado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3627
DELETE FROM oc_product
WHERE
model = '102048099'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3627,
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 '102048199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3628 AS option_value_id,
language_id,
17 AS option_id,
'102048199 - Setacolor 3D Glitter 20 ml Preto Cintilante' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3628
DELETE FROM oc_product
WHERE
model = '102048199'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3628,
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 '102048299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3629 AS option_value_id,
language_id,
17 AS option_id,
'102048299 - Setacolor 3D Glitter 20 ml Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3629
DELETE FROM oc_product
WHERE
model = '102048299'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3629,
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 '102048399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3630 AS option_value_id,
language_id,
17 AS option_id,
'102048399 - \''Setacolor 3D Glitter 20 ml Violeta' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3630
DELETE FROM oc_product
WHERE
model = '102048399'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3630,
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 '102048499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3631 AS option_value_id,
language_id,
17 AS option_id,
'102048499 - \''Setacolor 3D Glitter 20 ml Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3631
DELETE FROM oc_product
WHERE
model = '102048499'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3631,
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 '102048599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3632 AS option_value_id,
language_id,
17 AS option_id,
'102048599 - Setacolor 3D Glitter 20 ml Azul Oceano' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3632
DELETE FROM oc_product
WHERE
model = '102048599'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3632,
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 '102048699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3633 AS option_value_id,
language_id,
17 AS option_id,
'102048699 - \''Setacolor 3D Glitter 20 ml Iridiscente' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3633
DELETE FROM oc_product
WHERE
model = '102048699'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3633,
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 '102048799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3634 AS option_value_id,
language_id,
17 AS option_id,
'102048799 - \''Setacolor 3D Glitter 20 ml Ouro Rico' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3634
DELETE FROM oc_product
WHERE
model = '102048799'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3634,
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 '102048899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3635 AS option_value_id,
language_id,
17 AS option_id,
'102048899 - \''Setacolor 3D Glitter 20 ml Verde' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3635
DELETE FROM oc_product
WHERE
model = '102048899'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3635,
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 '102048999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3636 AS option_value_id,
language_id,
17 AS option_id,
'102048999 - Setacolor 3D Brodline 20 ml PTO 602' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3636
DELETE FROM oc_product
WHERE
model = '102048999'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3636,
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 '102049099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3637 AS option_value_id,
language_id,
17 AS option_id,
'102049099 - Setacolor 3D Brodline 20 ml BCO 601' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3637
DELETE FROM oc_product
WHERE
model = '102049099'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3637,
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 '102049199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3638 AS option_value_id,
language_id,
17 AS option_id,
'102049199 - Setacolor 3D Brodline 20 ml FUSCHIA 604' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3638
DELETE FROM oc_product
WHERE
model = '102049199'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3638,
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 '102049299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3639 AS option_value_id,
language_id,
17 AS option_id,
'102049299 - Setacolor 3D Brodline 20 ml ANIS 605' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3639
DELETE FROM oc_product
WHERE
model = '102049299'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3639,
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 '102049399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3640 AS option_value_id,
language_id,
17 AS option_id,
'102049399 - Setacolor 3D Brodline 20 ml TURQ 606' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3640
DELETE FROM oc_product
WHERE
model = '102049399'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3640,
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 '102049499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3641 AS option_value_id,
language_id,
17 AS option_id,
'102049499 - Setacolor 3D Brodline 20 ml LAR 603' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3641
DELETE FROM oc_product
WHERE
model = '102049499'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3641,
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 '102049599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3642 AS option_value_id,
language_id,
17 AS option_id,
'102049599 - Setacolor 3D Brodline 20 ml Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3642
DELETE FROM oc_product
WHERE
model = '102049599'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3642,
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 '102049699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3643 AS option_value_id,
language_id,
17 AS option_id,
'102049699 - Setacolor 3D Brodline VERMELHO 613' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3643
DELETE FROM oc_product
WHERE
model = '102049699'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3643,
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 '102049799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3644 AS option_value_id,
language_id,
17 AS option_id,
'102049799 - Setacolor 3D Brodline 20 ml AZL OCEANO 614' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3644
DELETE FROM oc_product
WHERE
model = '102049799'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3644,
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 '102049899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3645 AS option_value_id,
language_id,
17 AS option_id,
'102049899 - Setacolor 3D Metal 20 ml Amarelo Ouro' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3645
DELETE FROM oc_product
WHERE
model = '102049899'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3645,
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 '102049999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3646 AS option_value_id,
language_id,
17 AS option_id,
'102049999 - Setacolor 3D Metal 20 ml Perolado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 493
AND product_id = 27556
AND option_id = 17
AND option_value_id = 3646
DELETE FROM oc_product
WHERE
model = '102049999'
INSERT INTO oc_product_option_value
SET
product_option_id = 493,
product_id = 27556,
option_id = 17,
option_value_id = 3646,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.