Product Sync.
Opencart products: 29
Input products: 100
UPDATING: Amsterdam Spray
Product ID: 27400
Image file: Amsterdam Spray.jpg
NEW: 101645099
NEW: 101645199
NEW: 101645299
NEW: 101645399
NEW: 101645499
NEW: 101645599
NEW: 101645699
NEW: 101645799
NEW: 101645899
NEW: 101645999
NEW: 101646099
NEW: 101646199
NEW: 101646299
NEW: 101646399
NEW: 101646499
NEW: 101646599
NEW: 101646699
NEW: 101646799
NEW: 101646899
NEW: 101646999
NEW: 101647099
NEW: 101647199
NEW: 101647299
NEW: 101647399
NEW: 101647499
NEW: 101647599
NEW: 101647699
NEW: 101647799
NEW: 101647899
NEW: 101647999
NEW: 101648099
NEW: 101648199
NEW: 101648299
NEW: 101648399
NEW: 101648499
NEW: 101648599
NEW: 101648699
NEW: 101648799
NEW: 101648899
NEW: 101648999
NEW: 101649099
NEW: 101649199
NEW: 101649299
NEW: 101649399
NEW: 101649499
NEW: 101649599
NEW: 101649699
NEW: 101649799
NEW: 101649899
NEW: 101649999
NEW: 101650099
NEW: 101650199
NEW: 101650299
NEW: 101650399
NEW: 101650499
NEW: 101650599
NEW: 101650699
NEW: 101650799
NEW: 101650899
NEW: 101650999
NEW: 101651099
NEW: 101651199
NEW: 101651299
NEW: 101651399
Ok.
Product Option Sync.
Opencart products: 29
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 = 27400
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101641499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1779
UPDATE oc_option_value_description
SET
name = '101641499 - ACRIL SPRAY AMST 400ML AMAR NAPOLES AVERM CLARO 292'
WHERE
option_value_id = 1779
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1779
DELETE FROM oc_product
WHERE
model = '101641499'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1779,
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 '101641599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1780
UPDATE oc_option_value_description
SET
name = '101641599 - ACRIL SPRAY AMST 400ML AMAR VERMELHAO 311'
WHERE
option_value_id = 1780
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1780
DELETE FROM oc_product
WHERE
model = '101641599'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1780,
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 '101641699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1781
UPDATE oc_option_value_description
SET
name = '101641699 - ACRIL SPRAY AMST 400ML VERMELHO PYRROLE 315'
WHERE
option_value_id = 1781
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1781
DELETE FROM oc_product
WHERE
model = '101641699'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1781,
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 '101641799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1782
UPDATE oc_option_value_description
SET
name = '101641799 - ACRIL SPRAY AMST 400ML CARMIM 318'
WHERE
option_value_id = 1782
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1782
DELETE FROM oc_product
WHERE
model = '101641799'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1782,
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 '101641899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1783
UPDATE oc_option_value_description
SET
name = '101641899 - ACRIL SPRAY AMST 400ML ROSA CLARO 361'
WHERE
option_value_id = 1783
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1783
DELETE FROM oc_product
WHERE
model = '101641899'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1783,
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 '101641999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1784
UPDATE oc_option_value_description
SET
name = '101641999 - ACRIL SPRAY AMST 400ML ROSA QUINACRIDONA 366'
WHERE
option_value_id = 1784
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1784
DELETE FROM oc_product
WHERE
model = '101641999'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1784,
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 '101642099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1785
UPDATE oc_option_value_description
SET
name = '101642099 - ACRIL SPRAY AMST 400ML MAGENTA PRIM 369'
WHERE
option_value_id = 1785
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1785
DELETE FROM oc_product
WHERE
model = '101642099'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1785,
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 '101642199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1786
UPDATE oc_option_value_description
SET
name = '101642199 - ACRIL SPRAY AMST 400ML ROSA FLUO 384'
WHERE
option_value_id = 1786
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1786
DELETE FROM oc_product
WHERE
model = '101642199'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1786,
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 '101642299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1787
UPDATE oc_option_value_description
SET
name = '101642299 - ACRIL SPRAY AMST 400ML ROSA QUINACRIDONA CLARO 385'
WHERE
option_value_id = 1787
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1787
DELETE FROM oc_product
WHERE
model = '101642299'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1787,
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 '101642399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1788
UPDATE oc_option_value_description
SET
name = '101642399 - ACRIL SPRAY AMST 400ML VERM NAFTOL ESC 399'
WHERE
option_value_id = 1788
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1788
DELETE FROM oc_product
WHERE
model = '101642399'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1788,
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 '101642499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1789
UPDATE oc_option_value_description
SET
name = '101642499 - ACRIL SPRAY AMST 400ML TERRA SOMBRA QUEIM 409'
WHERE
option_value_id = 1789
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1789
DELETE FROM oc_product
WHERE
model = '101642499'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1789,
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 '101642599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1790
UPDATE oc_option_value_description
SET
name = '101642599 - ACRIL SPRAY AMST 400ML TERRA SIENA QUEIMADA 411'
WHERE
option_value_id = 1790
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1790
DELETE FROM oc_product
WHERE
model = '101642599'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1790,
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 '101642699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1791
UPDATE oc_option_value_description
SET
name = '101642699 - ACRIL SPRAY AMST 400ML AZUL ULTRAM 504'
WHERE
option_value_id = 1791
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1791
DELETE FROM oc_product
WHERE
model = '101642699'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1791,
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 '101642799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1792
UPDATE oc_option_value_description
SET
name = '101642799 - ACRIL SPRAY AMST 400ML AZUL REAL 517'
WHERE
option_value_id = 1792
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1792
DELETE FROM oc_product
WHERE
model = '101642799'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1792,
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 '101642899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1793
UPDATE oc_option_value_description
SET
name = '101642899 - ACRIL SPRAY AMST 400ML AZUL TURQ 522'
WHERE
option_value_id = 1793
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1793
DELETE FROM oc_product
WHERE
model = '101642899'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1793,
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 '101642999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1794
UPDATE oc_option_value_description
SET
name = '101642999 - ACRIL SPRAY AMST 400ML AZUL CELESTE CLARO 551'
WHERE
option_value_id = 1794
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1794
DELETE FROM oc_product
WHERE
model = '101642999'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1794,
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 '101643099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1795
UPDATE oc_option_value_description
SET
name = '101643099 - ACRIL SPRAY AMST 400ML AZUL ACINZENTADO 562'
WHERE
option_value_id = 1795
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1795
DELETE FROM oc_product
WHERE
model = '101643099'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1795,
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 '101643199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1796
UPDATE oc_option_value_description
SET
name = '101643199 - ACRIL SPRAY AMST 400ML AZUL BRILHANTE 564'
WHERE
option_value_id = 1796
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1796
DELETE FROM oc_product
WHERE
model = '101643199'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1796,
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 '101643299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1797
UPDATE oc_option_value_description
SET
name = '101643299 - ACRIL SPRAY AMST 400ML AZUL PHTALO 570'
WHERE
option_value_id = 1797
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1797
DELETE FROM oc_product
WHERE
model = '101643299'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1797,
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 '101643399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1798
UPDATE oc_option_value_description
SET
name = '101643399 - ACRIL SPRAY AMST 400ML AZUL CYAN PRIM 572'
WHERE
option_value_id = 1798
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1798
DELETE FROM oc_product
WHERE
model = '101643399'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1798,
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 '101643499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1799
UPDATE oc_option_value_description
SET
name = '101643499 - ACRIL SPRAY AMST 400ML VIOLETA AVERM PERM CL 577'
WHERE
option_value_id = 1799
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1799
DELETE FROM oc_product
WHERE
model = '101643499'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1799,
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 '101643599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1800
UPDATE oc_option_value_description
SET
name = '101643599 - ACRIL SPRAY AMST 400ML VERDE VERONES 615'
WHERE
option_value_id = 1800
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1800
DELETE FROM oc_product
WHERE
model = '101643599'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1800,
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 '101643699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1801
UPDATE oc_option_value_description
SET
name = '101643699 - ACRIL SPRAY AMST 400ML VERDE AMARELADO 617'
WHERE
option_value_id = 1801
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1801
DELETE FROM oc_product
WHERE
model = '101643699'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1801,
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 '101643799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1802
UPDATE oc_option_value_description
SET
name = '101643799 - ACRIL SPRAY AMST 400ML VERDE PERM CLARO 618'
WHERE
option_value_id = 1802
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1802
DELETE FROM oc_product
WHERE
model = '101643799'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1802,
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 '101643899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1803
UPDATE oc_option_value_description
SET
name = '101643899 - ACRIL SPRAY AMST 400ML VERDE PERM ESC 619'
WHERE
option_value_id = 1803
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1803
DELETE FROM oc_product
WHERE
model = '101643899'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1803,
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 '101643999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1804
UPDATE oc_option_value_description
SET
name = '101643999 - ACRIL SPRAY AMST 400ML VERDE AZEITONA CLAR 621'
WHERE
option_value_id = 1804
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1804
DELETE FROM oc_product
WHERE
model = '101643999'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1804,
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 '101644099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1805
UPDATE oc_option_value_description
SET
name = '101644099 - ACRIL SPRAY AMST 400ML VERDE AZEITONA ESC 622'
WHERE
option_value_id = 1805
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1805
DELETE FROM oc_product
WHERE
model = '101644099'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1805,
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 '101644199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1806
UPDATE oc_option_value_description
SET
name = '101644199 - ACRIL SPRAY AMST 400ML VERDE TURQ 661'
WHERE
option_value_id = 1806
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1806
DELETE FROM oc_product
WHERE
model = '101644199'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1806,
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 '101644299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1807
UPDATE oc_option_value_description
SET
name = '101644299 - ACRIL SPRAY AMST 400ML VERDE FLUO 672'
WHERE
option_value_id = 1807
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1807
DELETE FROM oc_product
WHERE
model = '101644299'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1807,
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 '101644399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1808
UPDATE oc_option_value_description
SET
name = '101644399 - ACRIL SPRAY AMST 400ML CINZA NEUTRO 710'
WHERE
option_value_id = 1808
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1808
DELETE FROM oc_product
WHERE
model = '101644399'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1808,
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 '101644499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1809
UPDATE oc_option_value_description
SET
name = '101644499 - ACRIL SPRAY AMST 400ML CINZA QUENTE 718'
WHERE
option_value_id = 1809
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1809
DELETE FROM oc_product
WHERE
model = '101644499'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1809,
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 '101644599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1810
UPDATE oc_option_value_description
SET
name = '101644599 - ACRIL SPRAY AMST 400ML PRETO OXIDO 735'
WHERE
option_value_id = 1810
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1810
DELETE FROM oc_product
WHERE
model = '101644599'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1810,
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 '101644699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1811
UPDATE oc_option_value_description
SET
name = '101644699 - ACRIL SPRAY AMST 400ML PRATA 800'
WHERE
option_value_id = 1811
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1811
DELETE FROM oc_product
WHERE
model = '101644699'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1811,
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 '101644799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1812
UPDATE oc_option_value_description
SET
name = '101644799 - ACRIL SPRAY AMST 400ML OURO CLARO 802'
WHERE
option_value_id = 1812
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1812
DELETE FROM oc_product
WHERE
model = '101644799'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1812,
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 '101644899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1813
UPDATE oc_option_value_description
SET
name = '101644899 - ACRIL SPRAY AMST 400ML OURO ESC 803'
WHERE
option_value_id = 1813
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1813
DELETE FROM oc_product
WHERE
model = '101644899'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1813,
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 '101644999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1814
UPDATE oc_option_value_description
SET
name = '101644999 - ACRIL SPRAY AMST 400ML VIOLETA ULTRAM 507'
WHERE
option_value_id = 1814
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 393
AND product_id = 27400
AND option_id = 17
AND option_value_id = 1814
DELETE FROM oc_product
WHERE
model = '101644999'
INSERT INTO oc_product_option_value
SET
product_option_id = 393,
product_id = 27400,
option_id = 17,
option_value_id = 1814,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.