Product Sync.
Opencart products: 31
Input products: 100
NEW: 102139899
NEW: 102139999
NEW: 102140099
NEW: 102140199
NEW: 102140299
NEW: 102140399
NEW: 102140499
NEW: 102140599
NEW: 102140699
NEW: 102140799
NEW: 102140899
NEW: 102140999
NEW: 102141099
NEW: 102141199
NEW: 102141299
NEW: 102141399
UPDATING: PEBEO XL 37ML
Product ID: 27401
Image file: PEBEO XL 37ML.jpg
NEW: 102142099
NEW: 102142199
NEW: 102142299
NEW: 102142399
NEW: 102142499
NEW: 102142599
NEW: 102142699
NEW: 102142799
NEW: 102142899
NEW: 102142999
NEW: 102143099
NEW: 102143199
NEW: 102143299
NEW: 102143399
NEW: 102143499
NEW: 102143599
NEW: 102143699
NEW: 102143799
NEW: 102143899
NEW: 102143999
NEW: 102144099
NEW: 102144199
NEW: 102144299
NEW: 102144399
NEW: 102144499
NEW: 102144599
NEW: 102144699
NEW: 102144799
NEW: 102144899
NEW: 102144999
NEW: 102145099
NEW: 102145199
NEW: 102145299
NEW: 102145399
NEW: 102145499
NEW: 102145599
NEW: 102145699
NEW: 102145799
NEW: 102145899
NEW: 102145999
NEW: 102146099
NEW: 102146199
NEW: 102146299
NEW: 102146399
NEW: 102146499
NEW: 102146599
NEW: 102146699
NEW: 102146799
NEW: 102146899
NEW: 102146999
UPDATING: Pebeo Artist 37ml
Product ID: 27399
Image file: Pebeo Artist 37ml.jpg
Ok.
Product Option Sync.
Opencart products: 31
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 = 27401
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102141499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1896
UPDATE oc_option_value_description
SET
name = '102141499 - OLEO PEBEO XL 37ML BCO VIVO 040'
WHERE
option_value_id = 1896
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 394
AND product_id = 27401
AND option_id = 17
AND option_value_id = 1896
DELETE FROM oc_product
WHERE
model = '102141499'
INSERT INTO oc_product_option_value
SET
product_option_id = 394,
product_id = 27401,
option_id = 17,
option_value_id = 1896,
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 '102141599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1897
UPDATE oc_option_value_description
SET
name = '102141599 - OLEO PEBEO XL 37ML MARFIM 065'
WHERE
option_value_id = 1897
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 394
AND product_id = 27401
AND option_id = 17
AND option_value_id = 1897
DELETE FROM oc_product
WHERE
model = '102141599'
INSERT INTO oc_product_option_value
SET
product_option_id = 394,
product_id = 27401,
option_id = 17,
option_value_id = 1897,
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 '102141699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1898
UPDATE oc_option_value_description
SET
name = '102141699 - OLEO PEBEO XL 37ML VIOL AZL IRIDISC 361'
WHERE
option_value_id = 1898
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 394
AND product_id = 27401
AND option_id = 17
AND option_value_id = 1898
DELETE FROM oc_product
WHERE
model = '102141699'
INSERT INTO oc_product_option_value
SET
product_option_id = 394,
product_id = 27401,
option_id = 17,
option_value_id = 1898,
quantity = 1,
subtract = 1,
price = 0.74,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102141799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1899
UPDATE oc_option_value_description
SET
name = '102141799 - OLEO PEBEO XL 37ML AZL VIOL IRIDISC 362'
WHERE
option_value_id = 1899
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 394
AND product_id = 27401
AND option_id = 17
AND option_value_id = 1899
DELETE FROM oc_product
WHERE
model = '102141799'
INSERT INTO oc_product_option_value
SET
product_option_id = 394,
product_id = 27401,
option_id = 17,
option_value_id = 1899,
quantity = 1,
subtract = 1,
price = 0.74,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102141899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1900
UPDATE oc_option_value_description
SET
name = '102141899 - OLEO PEBEO XL 37ML BCO TITANIUM 025'
WHERE
option_value_id = 1900
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 394
AND product_id = 27401
AND option_id = 17
AND option_value_id = 1900
DELETE FROM oc_product
WHERE
model = '102141899'
INSERT INTO oc_product_option_value
SET
product_option_id = 394,
product_id = 27401,
option_id = 17,
option_value_id = 1900,
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 '102141999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1901
UPDATE oc_option_value_description
SET
name = '102141999 - OLEO PEBEO XL 37ML ROSA VIVO 027'
WHERE
option_value_id = 1901
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 394
AND product_id = 27401
AND option_id = 17
AND option_value_id = 1901
DELETE FROM oc_product
WHERE
model = '102141999'
INSERT INTO oc_product_option_value
SET
product_option_id = 394,
product_id = 27401,
option_id = 17,
option_value_id = 1901,
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 = 27399
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102147099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1630
UPDATE oc_option_value_description
SET
name = '102147099 - ACRIL PEBEO ARTIST 37 ML S1 AMA OCRE 106'
WHERE
option_value_id = 1630
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1630
DELETE FROM oc_product
WHERE
model = '102147099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1630,
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 '102147199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1631
UPDATE oc_option_value_description
SET
name = '102147199 - ACRIL PEBEO ARTIST 37 ML S1 UMBRA QUEIMADA 108'
WHERE
option_value_id = 1631
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1631
DELETE FROM oc_product
WHERE
model = '102147199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1631,
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 '102147299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1632
UPDATE oc_option_value_description
SET
name = '102147299 - ACRIL PEBEO ARTIST 37 ML S1 UMBRA 109'
WHERE
option_value_id = 1632
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1632
DELETE FROM oc_product
WHERE
model = '102147299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1632,
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 '102147399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1633
UPDATE oc_option_value_description
SET
name = '102147399 - ACRIL PEBEO ARTIST 37 ML S1 OCRE VERM 112'
WHERE
option_value_id = 1633
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1633
DELETE FROM oc_product
WHERE
model = '102147399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1633,
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 '102147499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1634
UPDATE oc_option_value_description
SET
name = '102147499 - ACRIL PEBEO ARTIST 37 ML S1 TERRA QUEIM 113'
WHERE
option_value_id = 1634
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1634
DELETE FROM oc_product
WHERE
model = '102147499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1634,
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 '102147599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1635
UPDATE oc_option_value_description
SET
name = '102147599 - ACRIL PEBEO ARTIST 37 ML S1 TERRA 114'
WHERE
option_value_id = 1635
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1635
DELETE FROM oc_product
WHERE
model = '102147599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1635,
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 '102147699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1588
UPDATE oc_option_value_description
SET
name = '102147699 - ACRIL PEBEO ARTIST 37 ML S1 BCO TITANIUM 118'
WHERE
option_value_id = 1588
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1588
DELETE FROM oc_product
WHERE
model = '102147699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1588,
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 '102147799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1589
UPDATE oc_option_value_description
SET
name = '102147799 - ACRIL PEBEO ARTIST 37 ML S1 CZA VELUDO 120'
WHERE
option_value_id = 1589
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1589
DELETE FROM oc_product
WHERE
model = '102147799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1589,
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 '102147899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1590
UPDATE oc_option_value_description
SET
name = '102147899 - ACRIL PEBEO ARTIST 37 ML S1 PTO MARTE 126'
WHERE
option_value_id = 1590
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1590
DELETE FROM oc_product
WHERE
model = '102147899'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1590,
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 '102147999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1591
UPDATE oc_option_value_description
SET
name = '102147999 - ACRIL PEBEO ARTIST 37 ML S1 PTO GRAFITE 134'
WHERE
option_value_id = 1591
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1591
DELETE FROM oc_product
WHERE
model = '102147999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1591,
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 '102148099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1592
UPDATE oc_option_value_description
SET
name = '102148099 - ACRIL PEBEO ARTIST 37 ML S2 AZL ULTRAM ESC 201'
WHERE
option_value_id = 1592
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1592
DELETE FROM oc_product
WHERE
model = '102148099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1592,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1593
UPDATE oc_option_value_description
SET
name = '102148199 - ACRIL PEBEO ARTIST 37 ML S2 AZL ORIENTAL 203'
WHERE
option_value_id = 1593
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1593
DELETE FROM oc_product
WHERE
model = '102148199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1593,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1594
UPDATE oc_option_value_description
SET
name = '102148299 - ACRIL PEBEO ARTIST 37 ML S2 AZL AZURE 205'
WHERE
option_value_id = 1594
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1594
DELETE FROM oc_product
WHERE
model = '102148299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1594,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1595
UPDATE oc_option_value_description
SET
name = '102148399 - ACRIL PEBEO ARTIST 37 ML S2 TURQUESA 207'
WHERE
option_value_id = 1595
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1595
DELETE FROM oc_product
WHERE
model = '102148399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1595,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1653
UPDATE oc_option_value_description
SET
name = '102148499 - ACRIL PEBEO ARTIST 37 ML S2 AMA NAPOLES 211'
WHERE
option_value_id = 1653
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1653
DELETE FROM oc_product
WHERE
model = '102148499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1653,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1654
UPDATE oc_option_value_description
SET
name = '102148599 - ACRIL PEBEO ARTIST 37 ML S2 VDE ESMER FITAL 219'
WHERE
option_value_id = 1654
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1654
DELETE FROM oc_product
WHERE
model = '102148599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1654,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1655
UPDATE oc_option_value_description
SET
name = '102148699 - ACRIL PEBEO ARTIST 37 ML S2 VDE VERONA 220'
WHERE
option_value_id = 1655
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1655
DELETE FROM oc_product
WHERE
model = '102148699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1655,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1656
UPDATE oc_option_value_description
SET
name = '102148799 - ACRIL PEBEO ARTIST 37 ML S2 VDE HOOKERS 221'
WHERE
option_value_id = 1656
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1656
DELETE FROM oc_product
WHERE
model = '102148799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1656,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1657
UPDATE oc_option_value_description
SET
name = '102148899 - ACRIL PEBEO ARTIST 37 ML S2 AZL INDIGO 222'
WHERE
option_value_id = 1657
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1657
DELETE FROM oc_product
WHERE
model = '102148899'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1657,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102148999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1658
UPDATE oc_option_value_description
SET
name = '102148999 - ACRIL PEBEO ARTIST 37 ML S2 VDE VIVO 223'
WHERE
option_value_id = 1658
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1658
DELETE FROM oc_product
WHERE
model = '102148999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1658,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1659
UPDATE oc_option_value_description
SET
name = '102149099 - ACRIL PEBEO ARTIST 37 ML S2 VDE CLR 224'
WHERE
option_value_id = 1659
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1659
DELETE FROM oc_product
WHERE
model = '102149099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1659,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1660
UPDATE oc_option_value_description
SET
name = '102149199 - ACRIL PEBEO ARTIST 37 ML S2 AZL CIANO PERM 227'
WHERE
option_value_id = 1660
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1660
DELETE FROM oc_product
WHERE
model = '102149199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1660,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1636
UPDATE oc_option_value_description
SET
name = '102149299 - ACRIL PEBEO ARTIST 37 ML S2 CZA PAYNE 229'
WHERE
option_value_id = 1636
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1636
DELETE FROM oc_product
WHERE
model = '102149299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1636,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1637
UPDATE oc_option_value_description
SET
name = '102149399 - ACRIL PEBEO ARTIST 37 ML S2 VDE OXIDO CROM 232'
WHERE
option_value_id = 1637
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1637
DELETE FROM oc_product
WHERE
model = '102149399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1637,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1638
UPDATE oc_option_value_description
SET
name = '102149499 - ACRIL PEBEO ARTIST 37 ML S2 AZL FITALO 239'
WHERE
option_value_id = 1638
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1638
DELETE FROM oc_product
WHERE
model = '102149499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1638,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1639
UPDATE oc_option_value_description
SET
name = '102149599 - ACRIL PEBEO ARTIST 37 ML S2 ROSA RETRATO 249'
WHERE
option_value_id = 1639
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1639
DELETE FROM oc_product
WHERE
model = '102149599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1639,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1640
UPDATE oc_option_value_description
SET
name = '102149699 - ACRIL PEBEO ARTIST 37 ML S2 AMA HANSA CLR 252'
WHERE
option_value_id = 1640
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1640
DELETE FROM oc_product
WHERE
model = '102149699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1640,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1641
UPDATE oc_option_value_description
SET
name = '102149799 - ACRIL PEBEO ARTIST 37 ML S2 AMA HANSA DOUR 253'
WHERE
option_value_id = 1641
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 392
AND product_id = 27399
AND option_id = 17
AND option_value_id = 1641
DELETE FROM oc_product
WHERE
model = '102149799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1641,
quantity = 1,
subtract = 1,
price = 0.976,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.