Product Sync.
Opencart products: 245
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: 27050
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: 27140
Image file:
UPDATING: Guache Giotto Frasco 250 ml
Product ID: 26995
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: 27022
Image file:
UPDATING: Tinta Relevo Pébéo para Tecido
Product ID: 27081
Image file:
NEW: 102050099
NEW: 102050199
Ok.
Product Option Sync.
Opencart products: 245
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 = 27050
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102041599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2568
UPDATE oc_option_value_description
SET
name = '102041599 - Guache Giotto 500 ml Lavável Magenta'
WHERE
option_value_id = 2568
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2568
DELETE FROM oc_product
WHERE
model = '102041599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2568
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27140
AND option_id = 15
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 = 289
AND product_id = 27140
AND option_id = 15
AND option_value_id = 1886
DELETE FROM oc_product
WHERE
model = '102045799'
INSERT INTO oc_product_option_value
SET
product_option_id = 289,
product_id = 27140,
option_id = 15,
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 = 26995
AND option_id = 15
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1887
DELETE FROM oc_product
WHERE
model = '102045899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1887
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1888
DELETE FROM oc_product
WHERE
model = '102045999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1888
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1889
DELETE FROM oc_product
WHERE
model = '102046099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1889
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1890
DELETE FROM oc_product
WHERE
model = '102046199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1890
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1891
DELETE FROM oc_product
WHERE
model = '102046299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1891
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1892
DELETE FROM oc_product
WHERE
model = '102046399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1892
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1893
DELETE FROM oc_product
WHERE
model = '102046499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1893
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 = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1894
DELETE FROM oc_product
WHERE
model = '102046599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 66
AND product_id = 26995
AND option_id = 15
AND option_value_id = 1894
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27022
AND option_id = 15
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 = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1895
DELETE FROM oc_product
WHERE
model = '102047699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1895
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27081
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102047799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2569
UPDATE oc_option_value_description
SET
name = '102047799 - Setacolor 3D Fluorescente 20 ml Amarelo Esverdeado'
WHERE
option_value_id = 2569
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2569
DELETE FROM oc_product
WHERE
model = '102047799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2569
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102047899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2570
UPDATE oc_option_value_description
SET
name = '102047899 - Setacolor 3D Fluorescente 20 ml Azul Ultramarino Fluorescente'
WHERE
option_value_id = 2570
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2570
DELETE FROM oc_product
WHERE
model = '102047899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2570
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102047999 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3211 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3211
DELETE FROM oc_product
WHERE
model = '102047999'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3211,
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 = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3212 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3212
DELETE FROM oc_product
WHERE
model = '102048099'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3212,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2573
UPDATE oc_option_value_description
SET
name = '102048199 - Setacolor 3D Glitter 20 ml Preto Cintilante'
WHERE
option_value_id = 2573
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2573
DELETE FROM oc_product
WHERE
model = '102048199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2573
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102048299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2574
UPDATE oc_option_value_description
SET
name = '102048299 - Setacolor 3D Glitter 20 ml Vermelho'
WHERE
option_value_id = 2574
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2574
DELETE FROM oc_product
WHERE
model = '102048299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2574
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102048399 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3213 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3213
DELETE FROM oc_product
WHERE
model = '102048399'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3213,
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 = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3214 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3214
DELETE FROM oc_product
WHERE
model = '102048499'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3214,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2577
UPDATE oc_option_value_description
SET
name = '102048599 - Setacolor 3D Glitter 20 ml Azul Oceano'
WHERE
option_value_id = 2577
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2577
DELETE FROM oc_product
WHERE
model = '102048599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2577
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102048699 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3215 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3215
DELETE FROM oc_product
WHERE
model = '102048699'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3215,
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 = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3216 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3216
DELETE FROM oc_product
WHERE
model = '102048799'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3216,
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 = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3217 AS option_value_id,
language_id,
15 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 = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 3217
DELETE FROM oc_product
WHERE
model = '102048899'
INSERT INTO oc_product_option_value
SET
product_option_id = 142,
product_id = 27081,
option_id = 15,
option_value_id = 3217,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2581
UPDATE oc_option_value_description
SET
name = '102048999 - Setacolor 3D Brodline 20 ml PTO 602'
WHERE
option_value_id = 2581
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2581
DELETE FROM oc_product
WHERE
model = '102048999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2581
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2582
UPDATE oc_option_value_description
SET
name = '102049099 - Setacolor 3D Brodline 20 ml BCO 601'
WHERE
option_value_id = 2582
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2582
DELETE FROM oc_product
WHERE
model = '102049099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2582
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2583
UPDATE oc_option_value_description
SET
name = '102049199 - Setacolor 3D Brodline 20 ml FUSCHIA 604'
WHERE
option_value_id = 2583
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2583
DELETE FROM oc_product
WHERE
model = '102049199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2583
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2584
UPDATE oc_option_value_description
SET
name = '102049299 - Setacolor 3D Brodline 20 ml ANIS 605'
WHERE
option_value_id = 2584
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2584
DELETE FROM oc_product
WHERE
model = '102049299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2584
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2585
UPDATE oc_option_value_description
SET
name = '102049399 - Setacolor 3D Brodline 20 ml TURQ 606'
WHERE
option_value_id = 2585
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2585
DELETE FROM oc_product
WHERE
model = '102049399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2585
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2586
UPDATE oc_option_value_description
SET
name = '102049499 - Setacolor 3D Brodline 20 ml LAR 603'
WHERE
option_value_id = 2586
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2586
DELETE FROM oc_product
WHERE
model = '102049499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2586
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2587
UPDATE oc_option_value_description
SET
name = '102049599 - Setacolor 3D Brodline 20 ml Amarelo'
WHERE
option_value_id = 2587
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2587
DELETE FROM oc_product
WHERE
model = '102049599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2587
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2588
UPDATE oc_option_value_description
SET
name = '102049699 - Setacolor 3D Brodline VERMELHO 613'
WHERE
option_value_id = 2588
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2588
DELETE FROM oc_product
WHERE
model = '102049699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2588
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2589
UPDATE oc_option_value_description
SET
name = '102049799 - Setacolor 3D Brodline 20 ml AZL OCEANO 614'
WHERE
option_value_id = 2589
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2589
DELETE FROM oc_product
WHERE
model = '102049799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2589
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2590
UPDATE oc_option_value_description
SET
name = '102049899 - Setacolor 3D Metal 20 ml Amarelo Ouro'
WHERE
option_value_id = 2590
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2590
DELETE FROM oc_product
WHERE
model = '102049899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2590
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102049999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2591
UPDATE oc_option_value_description
SET
name = '102049999 - Setacolor 3D Metal 20 ml Perolado'
WHERE
option_value_id = 2591
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2591
DELETE FROM oc_product
WHERE
model = '102049999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 142
AND product_id = 27081
AND option_id = 15
AND option_value_id = 2591
Ok.