Product Sync.
Opencart products: 31
Input products: 100
UPDATING: Pebeo Artist 37ml
Product ID: 27399
Image file: Pebeo Artist 37ml.jpg
NEW: 102154199
NEW: 102154299
NEW: 102154399
NEW: 102154499
NEW: 102154599
NEW: 102154699
NEW: 102154799
NEW: 102154899
NEW: 102154999
NEW: 102155099
NEW: 102155199
NEW: 102155299
NEW: 102155399
NEW: 102155499
NEW: 102155799
NEW: 102155899
NEW: 102155999
NEW: 102156099
NEW: 102156199
NEW: 102156299
NEW: 102156399
NEW: 102156499
NEW: 102156599
NEW: 102156699
NEW: 102156799
NEW: 102156899
NEW: 102156999
NEW: 102157099
NEW: 102157199
NEW: 102157299
NEW: 102157399
NEW: 102157499
NEW: 102157599
NEW: 102157699
NEW: 102157799
NEW: 102157899
NEW: 102157999
NEW: 102158099
NEW: 102158199
NEW: 102158299
NEW: 102158399
NEW: 102158499
NEW: 102158599
NEW: 102158699
NEW: 102158799
NEW: 102158899
NEW: 102158999
NEW: 102159099
NEW: 102159199
NEW: 102159299
NEW: 102159399
NEW: 102159499
NEW: 102159599
NEW: 102159699
NEW: 102159799
NEW: 102159899
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 = 27399
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102149999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1643
UPDATE oc_option_value_description
SET
name = '102149999 - ACRIL PEBEO ARTIST 37 ML S2 AMA ALAR HANSA 255'
WHERE
option_value_id = 1643
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 = 1643
DELETE FROM oc_product
WHERE
model = '102149999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1643,
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 '102150099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1644
UPDATE oc_option_value_description
SET
name = '102150099 - ACRIL PEBEO ARTIST 37 ML S2 SEPIA 260'
WHERE
option_value_id = 1644
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 = 1644
DELETE FROM oc_product
WHERE
model = '102150099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1644,
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 '102150199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1596
UPDATE oc_option_value_description
SET
name = '102150199 - ACRIL PEBEO ARTIST 37 ML S2 ROSA QUINA 262'
WHERE
option_value_id = 1596
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 = 1596
DELETE FROM oc_product
WHERE
model = '102150199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1596,
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 '102150299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1597
UPDATE oc_option_value_description
SET
name = '102150299 - ACRIL PEBEO ARTIST 37 ML S2 AZL ACO 265'
WHERE
option_value_id = 1597
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 = 1597
DELETE FROM oc_product
WHERE
model = '102150299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1597,
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 '102150399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1598
UPDATE oc_option_value_description
SET
name = '102150399 - ACRIL PEBEO ARTIST37 ML S3 VIOL PEM 300'
WHERE
option_value_id = 1598
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 = 1598
DELETE FROM oc_product
WHERE
model = '102150399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1598,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102150499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1599
UPDATE oc_option_value_description
SET
name = '102150499 - ACRIL PEBEO ARTIST37 ML S3 AMA CAD MEDIO 301'
WHERE
option_value_id = 1599
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 = 1599
DELETE FROM oc_product
WHERE
model = '102150499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1599,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102150599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1600
UPDATE oc_option_value_description
SET
name = '102150599 - ACRIL PEBEO ARTIST37 ML S3 VIOL COBAL CLR 302'
WHERE
option_value_id = 1600
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 = 1600
DELETE FROM oc_product
WHERE
model = '102150599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1600,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102150699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1601
UPDATE oc_option_value_description
SET
name = '102150699 - ACRIL PEBEO ARTIST37 ML S3 AMA CAD LIMAO 304'
WHERE
option_value_id = 1601
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 = 1601
DELETE FROM oc_product
WHERE
model = '102150699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1601,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102150799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1602
UPDATE oc_option_value_description
SET
name = '102150799 - ACRIL PEBEO ARTIST37 ML S3 AMA CAD CLR 305'
WHERE
option_value_id = 1602
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 = 1602
DELETE FROM oc_product
WHERE
model = '102150799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1602,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102150899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1603
UPDATE oc_option_value_description
SET
name = '102150899 - ACRIL PEBEO ARTIST37 ML S3 AMA CAD ESC 306'
WHERE
option_value_id = 1603
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 = 1603
DELETE FROM oc_product
WHERE
model = '102150899'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1603,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102150999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1902
UPDATE oc_option_value_description
SET
name = '102150999 - ACRIL PEBEO ARTIST37 ML S3 VERMELAO 307'
WHERE
option_value_id = 1902
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 = 1902
DELETE FROM oc_product
WHERE
model = '102150999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1902,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1612
UPDATE oc_option_value_description
SET
name = '102151099 - ACRIL PEBEO ARTIST37 ML S3 VERM NAFTOL CLR 308'
WHERE
option_value_id = 1612
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 = 1612
DELETE FROM oc_product
WHERE
model = '102151099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1612,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1613
UPDATE oc_option_value_description
SET
name = '102151199 - ACRIL PEBEO ARTIST37 ML S3 CARMIM NAFTOL 309'
WHERE
option_value_id = 1613
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 = 1613
DELETE FROM oc_product
WHERE
model = '102151199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1613,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1614
UPDATE oc_option_value_description
SET
name = '102151299 - ACRIL PEBEO ARTIST37 ML S3 AZL COSMOS 310'
WHERE
option_value_id = 1614
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 = 1614
DELETE FROM oc_product
WHERE
model = '102151299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1614,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1615
UPDATE oc_option_value_description
SET
name = '102151399 - ACRIL PEBEO ARTIST37 ML S3 VIOL COBAL ESC 317'
WHERE
option_value_id = 1615
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 = 1615
DELETE FROM oc_product
WHERE
model = '102151399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1615,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1616
UPDATE oc_option_value_description
SET
name = '102151499 - ACRIL PEBEO ARTIST37 ML S3 VDE CAD ESC 318'
WHERE
option_value_id = 1616
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 = 1616
DELETE FROM oc_product
WHERE
model = '102151499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1616,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1617
UPDATE oc_option_value_description
SET
name = '102151599 - ACRIL PEBEO ARTIST37 ML S3 VDE CAD CLR 320'
WHERE
option_value_id = 1617
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 = 1617
DELETE FROM oc_product
WHERE
model = '102151599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1617,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1618
UPDATE oc_option_value_description
SET
name = '102151699 - ACRIL PEBEO ARTIST37 ML S3 AZL REAL 340'
WHERE
option_value_id = 1618
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 = 1618
DELETE FROM oc_product
WHERE
model = '102151699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1618,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1619
UPDATE oc_option_value_description
SET
name = '102151799 - ACRIL PEBEO ARTIST37 ML S3 PEROLA IRIDESC 350'
WHERE
option_value_id = 1619
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 = 1619
DELETE FROM oc_product
WHERE
model = '102151799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1619,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1620
UPDATE oc_option_value_description
SET
name = '102151899 - ACRIL PEBEO ARTIST37 ML S3 PRAT IRIDESC 351'
WHERE
option_value_id = 1620
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 = 1620
DELETE FROM oc_product
WHERE
model = '102151899'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1620,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102151999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1645
UPDATE oc_option_value_description
SET
name = '102151999 - ACRIL PEBEO ARTIST37 ML S3 DOUR IRIDESC 352'
WHERE
option_value_id = 1645
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 = 1645
DELETE FROM oc_product
WHERE
model = '102151999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1645,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1646
UPDATE oc_option_value_description
SET
name = '102152099 - ACRIL PEBEO ARTIST37 ML S3 OURO VERM IRID 353'
WHERE
option_value_id = 1646
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 = 1646
DELETE FROM oc_product
WHERE
model = '102152099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1646,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1647
UPDATE oc_option_value_description
SET
name = '102152199 - ACRIL PEBEO ARTIST37 ML S3 BRONZE IRID 354'
WHERE
option_value_id = 1647
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 = 1647
DELETE FROM oc_product
WHERE
model = '102152199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1647,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1648
UPDATE oc_option_value_description
SET
name = '102152299 - ACRIL PEBEO ARTIST37 ML S3 COBRE IRID 355'
WHERE
option_value_id = 1648
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 = 1648
DELETE FROM oc_product
WHERE
model = '102152299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1648,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1649
UPDATE oc_option_value_description
SET
name = '102152399 - ACRIL PEBEO ARTIST37 ML S3 AMA PRIM 356'
WHERE
option_value_id = 1649
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 = 1649
DELETE FROM oc_product
WHERE
model = '102152399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1649,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1650
UPDATE oc_option_value_description
SET
name = '102152499 - ACRIL PEBEO ARTIST37 ML S3 DYNA LAR AMA 357'
WHERE
option_value_id = 1650
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 = 1650
DELETE FROM oc_product
WHERE
model = '102152499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1650,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1651
UPDATE oc_option_value_description
SET
name = '102152599 - ACRIL PEBEO ARTIST37 ML S3 DYNA FUSCIA AZL 359'
WHERE
option_value_id = 1651
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 = 1651
DELETE FROM oc_product
WHERE
model = '102152599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1651,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1652
UPDATE oc_option_value_description
SET
name = '102152699 - ACRIL PEBEO ARTIST37 ML S3 DYNA AZL VIOL 360'
WHERE
option_value_id = 1652
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 = 1652
DELETE FROM oc_product
WHERE
model = '102152699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1652,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1661
UPDATE oc_option_value_description
SET
name = '102152799 - ACRIL PEBEO ARTIST37 ML S3 DYNA VDE AZL 362'
WHERE
option_value_id = 1661
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 = 1661
DELETE FROM oc_product
WHERE
model = '102152799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1661,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1662
UPDATE oc_option_value_description
SET
name = '102152899 - ACRIL PEBEO ARTIST37 ML S3 DYNA VDE AMA 363'
WHERE
option_value_id = 1662
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 = 1662
DELETE FROM oc_product
WHERE
model = '102152899'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1662,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102152999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1663
UPDATE oc_option_value_description
SET
name = '102152999 - ACRIL PEBEO ARTIST37 ML S3 DYNA AMA VDE 364'
WHERE
option_value_id = 1663
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 = 1663
DELETE FROM oc_product
WHERE
model = '102152999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1663,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1664
UPDATE oc_option_value_description
SET
name = '102153099 - ACRIL PEBEO ARTIST37 ML S3 DYNA DOUR VDE 365'
WHERE
option_value_id = 1664
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 = 1664
DELETE FROM oc_product
WHERE
model = '102153099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1664,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1665
UPDATE oc_option_value_description
SET
name = '102153199 - ACRIL PEBEO ARTIST37 ML S3 DYNA PTO AZL 366'
WHERE
option_value_id = 1665
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 = 1665
DELETE FROM oc_product
WHERE
model = '102153199'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1665,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1666
UPDATE oc_option_value_description
SET
name = '102153299 - ACRIL PEBEO ARTIST37 ML S4 GRENA QUINA 400'
WHERE
option_value_id = 1666
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 = 1666
DELETE FROM oc_product
WHERE
model = '102153299'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1666,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1667
UPDATE oc_option_value_description
SET
name = '102153399 - ACRIL PEBEO ARTIST37 ML S4 LAR CADMIUM 402'
WHERE
option_value_id = 1667
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 = 1667
DELETE FROM oc_product
WHERE
model = '102153399'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1667,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1668
UPDATE oc_option_value_description
SET
name = '102153499 - ACRIL PEBEO ARTIST37 ML S4 CARMESIM ALIZ 405'
WHERE
option_value_id = 1668
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 = 1668
DELETE FROM oc_product
WHERE
model = '102153499'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1668,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1621
UPDATE oc_option_value_description
SET
name = '102153599 - ACRIL PEBEO ARTIST37 ML S4 VERM ESCARL QUINA 406'
WHERE
option_value_id = 1621
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 = 1621
DELETE FROM oc_product
WHERE
model = '102153599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1621,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1622
UPDATE oc_option_value_description
SET
name = '102153699 - ACRIL PEBEO ARTIST37 ML S4 AMA ALAR CADM 407'
WHERE
option_value_id = 1622
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 = 1622
DELETE FROM oc_product
WHERE
model = '102153699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1622,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1623
UPDATE oc_option_value_description
SET
name = '102153799 - ACRIL PEBEO ARTIST37 ML S4 VIOL THIOINDIGO 408'
WHERE
option_value_id = 1623
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 = 1623
DELETE FROM oc_product
WHERE
model = '102153799'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1623,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1624
UPDATE oc_option_value_description
SET
name = '102153899 - ACRIL PEBEO ARTIST37 ML S5 AZL COBALTO 502'
WHERE
option_value_id = 1624
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 = 1624
DELETE FROM oc_product
WHERE
model = '102153899'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1624,
quantity = 1,
subtract = 1,
price = 3.008,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102153999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1625
UPDATE oc_option_value_description
SET
name = '102153999 - ACRIL PEBEO ARTIST37 ML S5 VERM CAD CLR 513'
WHERE
option_value_id = 1625
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 = 1625
DELETE FROM oc_product
WHERE
model = '102153999'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1625,
quantity = 1,
subtract = 1,
price = 3.008,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102154099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1626
UPDATE oc_option_value_description
SET
name = '102154099 - ACRIL PEBEO ARTIST37 ML S5 VERM CAD ESC 514'
WHERE
option_value_id = 1626
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 = 1626
DELETE FROM oc_product
WHERE
model = '102154099'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1626,
quantity = 1,
subtract = 1,
price = 3.008,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102155599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1628
UPDATE oc_option_value_description
SET
name = '102155599 - ACRIL PEBEO ARTIST37 ML S4 GREEN GOLD 429'
WHERE
option_value_id = 1628
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 = 1628
DELETE FROM oc_product
WHERE
model = '102155599'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1628,
quantity = 1,
subtract = 1,
price = 2.439,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102155699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1629
UPDATE oc_option_value_description
SET
name = '102155699 - ACRIL PEBEO ARTIST37 ML S3 AZL VDE DYNA 361'
WHERE
option_value_id = 1629
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 = 1629
DELETE FROM oc_product
WHERE
model = '102155699'
INSERT INTO oc_product_option_value
SET
product_option_id = 392,
product_id = 27399,
option_id = 17,
option_value_id = 1629,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.