Product Sync.
Opencart products: 211
Input products: 100
NEW: 101636199
NEW: 101636299
NEW: 101636399
NEW: 101636499
NEW: 101636599
NEW: 101636699
NEW: 101636799
NEW: 101636899
NEW: 101636999
NEW: 101637099
NEW: 101637199
NEW: 101637299
NEW: 101637399
NEW: 101637499
NEW: 101637599
NEW: 101637699
NEW: 101637799
NEW: 101637899
NEW: 101637999
NEW: 101638099
NEW: 101638199
NEW: 101638299
NEW: 101638399
NEW: 101638499
NEW: 101638599
NEW: 101638699
NEW: 101638799
NEW: 101638899
NEW: 101638999
NEW: 101639099
NEW: 101639199
NEW: 101639299
NEW: 101639399
NEW: 101639499
NEW: 101639599
NEW: 101639699
NEW: 101639799
NEW: 101639899
NEW: 101639999
NEW: 101640099
NEW: 101640199
NEW: 101640299
NEW: \''Spray de Tinta Acrílica Talens Amsterdam
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '\''Spray de Tinta Acrílica Talens Amsterdam - %'
)
NEW: 101640499
NEW: 101645099
NEW: 101645199
NEW: 101645299
NEW: 101645399
NEW: 101645499
NEW: 101645599
NEW: 101645699
NEW: 101645799
NEW: 101645899
NEW: 101645999
NEW: 101646099
Ok.
Product Option Sync.
Opencart products: 211
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101640399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101640399.jpg'
WHERE
option_value_id = 1770
UPDATE oc_option_value_description
SET
name = '101640399 - Spray Acrílico Amsterdam 400 ml Branco Titânio 105'
WHERE
option_value_id = 1770
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1770
DELETE FROM oc_product
WHERE
model = '101640399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1770,
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 '101640599 - %'
UPDATE oc_option_value
SET
image = 'catalog/101640599.jpg'
WHERE
option_value_id = 1771
UPDATE oc_option_value_description
SET
name = '101640599 - Spray Acrílico Amsterdam 400 ml Amarelo Nápoles Escuro 223'
WHERE
option_value_id = 1771
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1771
DELETE FROM oc_product
WHERE
model = '101640599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1771,
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 '101640699 - %'
UPDATE oc_option_value
SET
image = 'catalog/101640699.jpg'
WHERE
option_value_id = 1772
UPDATE oc_option_value_description
SET
name = '101640699 - Spray Acrílico Amsterdam 400 ml Ocre Amarelo 227'
WHERE
option_value_id = 1772
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1772
DELETE FROM oc_product
WHERE
model = '101640699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1772,
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 '101640799 - %'
UPDATE oc_option_value
SET
image = 'catalog/101640799.jpg'
WHERE
option_value_id = 1773
UPDATE oc_option_value_description
SET
name = '101640799 - Spray Acrílico Amsterdam 400 ml Terra Siena Natural 234'
WHERE
option_value_id = 1773
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1773
DELETE FROM oc_product
WHERE
model = '101640799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1773,
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 '101640899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1774
UPDATE oc_option_value_description
SET
name = '101640899 - Spray Acrílico Amsterdam 400 ml Amarelo Fluorescente 256'
WHERE
option_value_id = 1774
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1774
DELETE FROM oc_product
WHERE
model = '101640899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1774,
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 '101640999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1775
UPDATE oc_option_value_description
SET
name = '101640999 - Spray Acrílico Amsterdam 400 ml Laranja Fluorescente 257'
WHERE
option_value_id = 1775
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1775
DELETE FROM oc_product
WHERE
model = '101640999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1775,
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 '101641099 - %'
UPDATE oc_option_value
SET
image = 'catalog/101641099.jpg'
WHERE
option_value_id = 1776
UPDATE oc_option_value_description
SET
name = '101641099 - Spray Acrílico Amsterdam 400 ml Amarelo Aço limão 267'
WHERE
option_value_id = 1776
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1776
DELETE FROM oc_product
WHERE
model = '101641099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1776,
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 '101641199 - %'
UPDATE oc_option_value
SET
image = 'catalog/101641199.jpg'
WHERE
option_value_id = 1777
UPDATE oc_option_value_description
SET
name = '101641199 - Spray Acrílico Amsterdam 400 ml Amarelo Aço Escuro 270'
WHERE
option_value_id = 1777
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1777
DELETE FROM oc_product
WHERE
model = '101641199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1777,
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 '101641299 - %'
UPDATE oc_option_value
SET
image = 'catalog/101641299.jpg'
WHERE
option_value_id = 1778
UPDATE oc_option_value_description
SET
name = '101641299 - Spray Acrílico Amsterdam 400 ml Amarelo Primário 275'
WHERE
option_value_id = 1778
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1778
DELETE FROM oc_product
WHERE
model = '101641299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1778,
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 '101641399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101641399.jpg'
WHERE
option_value_id = 2487
UPDATE oc_option_value_description
SET
name = '101641399 - Spray Acrílico Amsterdam 400 ml Alaranjado Aço 276'
WHERE
option_value_id = 2487
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2487
DELETE FROM oc_product
WHERE
model = '101641399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2487,
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 '101641499 - %'
UPDATE oc_option_value
SET
image = 'catalog/101641499.jpg'
WHERE
option_value_id = 1779
UPDATE oc_option_value_description
SET
name = '101641499 - Spray Acrílico Amsterdam 400 ml Amarelo Napoles Avermalhado Claro 292'
WHERE
option_value_id = 1779
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1779
DELETE FROM oc_product
WHERE
model = '101641499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101641599.jpg'
WHERE
option_value_id = 1780
UPDATE oc_option_value_description
SET
name = '101641599 - Spray Acrílico Amsterdam 400 ml Vermelhão 311'
WHERE
option_value_id = 1780
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1780
DELETE FROM oc_product
WHERE
model = '101641599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101641699.jpg'
WHERE
option_value_id = 1781
UPDATE oc_option_value_description
SET
name = '101641699 - Spray Acrílico Amsterdam 400 ml Vermelho Pyrrole 315'
WHERE
option_value_id = 1781
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1781
DELETE FROM oc_product
WHERE
model = '101641699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101641799.jpg'
WHERE
option_value_id = 1782
UPDATE oc_option_value_description
SET
name = '101641799 - Spray Acrílico Amsterdam 400 ml Carmin 318'
WHERE
option_value_id = 1782
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1782
DELETE FROM oc_product
WHERE
model = '101641799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101641899.jpg'
WHERE
option_value_id = 1783
UPDATE oc_option_value_description
SET
name = '101641899 - Spray Acrílico Amsterdam 400 ml Rosa Claro 361'
WHERE
option_value_id = 1783
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1783
DELETE FROM oc_product
WHERE
model = '101641899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101641999.jpg'
WHERE
option_value_id = 1784
UPDATE oc_option_value_description
SET
name = '101641999 - Spray Acrílico Amsterdam 400 ml Rosa Quinacridona 366'
WHERE
option_value_id = 1784
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1784
DELETE FROM oc_product
WHERE
model = '101641999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642099.jpg'
WHERE
option_value_id = 1785
UPDATE oc_option_value_description
SET
name = '101642099 - Spray Acrílico Amsterdam 400 ml Magenta Primário 369'
WHERE
option_value_id = 1785
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1785
DELETE FROM oc_product
WHERE
model = '101642099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 - Spray Acrílico Amsterdam 400 ml Rosa Fluorescente 384'
WHERE
option_value_id = 1786
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1786
DELETE FROM oc_product
WHERE
model = '101642199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642299.jpg'
WHERE
option_value_id = 1787
UPDATE oc_option_value_description
SET
name = '101642299 - Spray Acrílico Amsterdam 400 ml Rosa Quinacridona Claro 385'
WHERE
option_value_id = 1787
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1787
DELETE FROM oc_product
WHERE
model = '101642299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642399.jpg'
WHERE
option_value_id = 1788
UPDATE oc_option_value_description
SET
name = '101642399 - Spray Acrílico Amsterdam 400 ml Vermelho Naftol Escuro 399'
WHERE
option_value_id = 1788
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1788
DELETE FROM oc_product
WHERE
model = '101642399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642499.jpg'
WHERE
option_value_id = 1789
UPDATE oc_option_value_description
SET
name = '101642499 - Spray Acrílico Amsterdam 400 ml Terra Sombra Queimada 409'
WHERE
option_value_id = 1789
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1789
DELETE FROM oc_product
WHERE
model = '101642499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642599.jpg'
WHERE
option_value_id = 1790
UPDATE oc_option_value_description
SET
name = '101642599 - Spray Acrílico Amsterdam 400 ml Terra Siena Queimada 411'
WHERE
option_value_id = 1790
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1790
DELETE FROM oc_product
WHERE
model = '101642599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642699.jpg'
WHERE
option_value_id = 1791
UPDATE oc_option_value_description
SET
name = '101642699 - Spray Acrílico Amsterdam 400 ml Azul Ultramarino 504'
WHERE
option_value_id = 1791
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1791
DELETE FROM oc_product
WHERE
model = '101642699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642799.jpg'
WHERE
option_value_id = 1792
UPDATE oc_option_value_description
SET
name = '101642799 - Spray Acrílico Amsterdam 400 ml Azul Real 517'
WHERE
option_value_id = 1792
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1792
DELETE FROM oc_product
WHERE
model = '101642799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642899.jpg'
WHERE
option_value_id = 1793
UPDATE oc_option_value_description
SET
name = '101642899 - Spray Acrílico Amsterdam 400 ml Azul Turquesa 522'
WHERE
option_value_id = 1793
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1793
DELETE FROM oc_product
WHERE
model = '101642899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101642999.jpg'
WHERE
option_value_id = 1794
UPDATE oc_option_value_description
SET
name = '101642999 - Spray Acrílico Amsterdam 400 ml Azul Celeste Claro 551'
WHERE
option_value_id = 1794
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1794
DELETE FROM oc_product
WHERE
model = '101642999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643099.jpg'
WHERE
option_value_id = 1795
UPDATE oc_option_value_description
SET
name = '101643099 - Spray Acrílico Amsterdam 400 ml Azul Acinzentado 562'
WHERE
option_value_id = 1795
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1795
DELETE FROM oc_product
WHERE
model = '101643099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643199.jpg'
WHERE
option_value_id = 1796
UPDATE oc_option_value_description
SET
name = '101643199 - Spray Acrílico Amsterdam 400 ml Azul Brilhante 564'
WHERE
option_value_id = 1796
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1796
DELETE FROM oc_product
WHERE
model = '101643199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643299.jpg'
WHERE
option_value_id = 1797
UPDATE oc_option_value_description
SET
name = '101643299 - Spray Acrílico Amsterdam 400 ml Azul Ftalo 570'
WHERE
option_value_id = 1797
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1797
DELETE FROM oc_product
WHERE
model = '101643299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643399.jpg'
WHERE
option_value_id = 1798
UPDATE oc_option_value_description
SET
name = '101643399 - Spray Acrílico Amsterdam 400 ml Azul Cian Primário 572'
WHERE
option_value_id = 1798
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1798
DELETE FROM oc_product
WHERE
model = '101643399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643499.jpg'
WHERE
option_value_id = 1799
UPDATE oc_option_value_description
SET
name = '101643499 - Spray Acrílico Amsterdam 400 ml Violeta Avermelhado Permanente Claro 577'
WHERE
option_value_id = 1799
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1799
DELETE FROM oc_product
WHERE
model = '101643499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643599.jpg'
WHERE
option_value_id = 1800
UPDATE oc_option_value_description
SET
name = '101643599 - Spray Acrílico Amsterdam 400 ml Verde Veronês 615'
WHERE
option_value_id = 1800
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1800
DELETE FROM oc_product
WHERE
model = '101643599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643699.jpg'
WHERE
option_value_id = 1801
UPDATE oc_option_value_description
SET
name = '101643699 - Spray Acrílico Amsterdam 400 ml Verde Amarelado 617'
WHERE
option_value_id = 1801
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1801
DELETE FROM oc_product
WHERE
model = '101643699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643799.jpg'
WHERE
option_value_id = 1802
UPDATE oc_option_value_description
SET
name = '101643799 - Spray Acrílico Amsterdam 400 ml Verde Permanente Claro 618'
WHERE
option_value_id = 1802
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1802
DELETE FROM oc_product
WHERE
model = '101643799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643899.jpg'
WHERE
option_value_id = 1803
UPDATE oc_option_value_description
SET
name = '101643899 - Spray Acrílico Amsterdam 400 ml Verde Permanente escuro 619'
WHERE
option_value_id = 1803
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1803
DELETE FROM oc_product
WHERE
model = '101643899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101643999.jpg'
WHERE
option_value_id = 1804
UPDATE oc_option_value_description
SET
name = '101643999 - Spray Acrílico Amsterdam 400 ml Verde Azeitona Claro 621'
WHERE
option_value_id = 1804
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1804
DELETE FROM oc_product
WHERE
model = '101643999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644099.jpg'
WHERE
option_value_id = 1805
UPDATE oc_option_value_description
SET
name = '101644099 - Spray Acrílico Amsterdam 400 ml Verde Azeitona Escuro 622'
WHERE
option_value_id = 1805
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1805
DELETE FROM oc_product
WHERE
model = '101644099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644199.jpg'
WHERE
option_value_id = 1806
UPDATE oc_option_value_description
SET
name = '101644199 - Spray Acrílico Amsterdam 400 ml Verde Turquesa 661'
WHERE
option_value_id = 1806
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1806
DELETE FROM oc_product
WHERE
model = '101644199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 - Spray Acrílico Amsterdam 400 ml Verde Fluorescente 672'
WHERE
option_value_id = 1807
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1807
DELETE FROM oc_product
WHERE
model = '101644299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644399.jpg'
WHERE
option_value_id = 1808
UPDATE oc_option_value_description
SET
name = '101644399 - Spray Acrílico Amsterdam 400 ml Cinzento Neutro 710'
WHERE
option_value_id = 1808
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1808
DELETE FROM oc_product
WHERE
model = '101644399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644499.jpg'
WHERE
option_value_id = 1809
UPDATE oc_option_value_description
SET
name = '101644499 - Spray Acrílico Amsterdam 400 ml Cinzento Quente 718'
WHERE
option_value_id = 1809
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1809
DELETE FROM oc_product
WHERE
model = '101644499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644599.jpg'
WHERE
option_value_id = 1810
UPDATE oc_option_value_description
SET
name = '101644599 - Spray Acrílico Amsterdam 400 ml Preto Óxido 735'
WHERE
option_value_id = 1810
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1810
DELETE FROM oc_product
WHERE
model = '101644599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644699.jpg'
WHERE
option_value_id = 1811
UPDATE oc_option_value_description
SET
name = '101644699 - Spray Acrílico Amsterdam 400 ml Prata 800'
WHERE
option_value_id = 1811
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1811
DELETE FROM oc_product
WHERE
model = '101644699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 - Spray Acrílico Amsterdam 400 ml Ouro Claro 802'
WHERE
option_value_id = 1812
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1812
DELETE FROM oc_product
WHERE
model = '101644799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 - Spray Acrílico Amsterdam 400 ml Ouro Escuro 803'
WHERE
option_value_id = 1813
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1813
DELETE FROM oc_product
WHERE
model = '101644899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 'catalog/101644999.jpg'
WHERE
option_value_id = 1814
UPDATE oc_option_value_description
SET
name = '101644999 - Spray Acrílico Amsterdam 400 ml Violeta Ultramarino 507'
WHERE
option_value_id = 1814
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 1814
DELETE FROM oc_product
WHERE
model = '101644999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1814,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.