Product Sync.
Opencart products: 127
Input products: 100
NEW: 100000099
NEW: 100000199
NEW: 100000299
NEW: 100000399
NEW: 100000499
NEW: 100000599
NEW: 100000699
NEW: 100000799
NEW: 100000899
NEW: 100000999
NEW: 100001099
NEW: 100001199
NEW: 100001299
NEW: 100001399
NEW: 100001499
NEW: 100001599
NEW: 100001699
NEW: 100001799
NEW: 100001899
NEW: 100001999
NEW: 100002099
NEW: 100002199
NEW: 100002299
NEW: 100002399
NEW: 100002499
NEW: 100002599
NEW: 100002699
NEW: 100002799
NEW: 100002899
NEW: 100002999
NEW: 100003099
NEW: 100003199
NEW: 100003299
NEW: 100003399
NEW: 100003499
NEW: 100003599
NEW: 100003699
NEW: 100003799
NEW: 100003899
NEW: 100003999
NEW: 100004099
NEW: 100004199
NEW: 100004299
NEW: 100004399
NEW: 100004499
NEW: 100004599
NEW: 100004699
NEW: 100004799
NEW: 100004899
NEW: 100004999
NEW: 100005099
NEW: 100005199
NEW: 100005299
NEW: 100005399
NEW: 100005499
NEW: 100005599
NEW: 100005699
NEW: 100005799
NEW: 100005899
NEW: 100005999
NEW: 100006099
NEW: 100006199
NEW: 100006299
NEW: 100006399
NEW: 100006499
NEW: 100006599
NEW: 100006699
NEW: 100006799
NEW: 100006899
NEW: 100006999
NEW: 100007099
NEW: 100007199
NEW: 100007299
NEW: 100007399
NEW: 100007499
NEW: 100007599
UPDATING: Tinta Acrílica Winsor & Newton 120 ml
Product ID: 26989
Image file:
Ok.
Product Option Sync.
Opencart products: 127
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 '100007699 - %'
UPDATE oc_option_value
SET
image = 'catalog/100007699.jpg'
WHERE
option_value_id = 1018
UPDATE oc_option_value_description
SET
name = '100007699 - \''Acrílico Winsor & Newton Galeria 120 ml Titanio Buff'
WHERE
option_value_id = 1018
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 = 1018
DELETE FROM oc_product
WHERE
model = '100007699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1018,
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 '100007799 - %'
UPDATE oc_option_value
SET
image = 'catalog/100007799.jpg'
WHERE
option_value_id = 1019
UPDATE oc_option_value_description
SET
name = '100007799 - \''Acrílico Winsor & Newton Galeria 120 ml Terra Siena Queimada'
WHERE
option_value_id = 1019
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 = 1019
DELETE FROM oc_product
WHERE
model = '100007799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1019,
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 '100007899 - %'
UPDATE oc_option_value
SET
image = 'catalog/100007899.jpg'
WHERE
option_value_id = 1020
UPDATE oc_option_value_description
SET
name = '100007899 - \''Acrílico Winsor & Newton Galeria 120 ml Terra Sombra Queimada'
WHERE
option_value_id = 1020
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 = 1020
DELETE FROM oc_product
WHERE
model = '100007899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1020,
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 '100007999 - %'
UPDATE oc_option_value
SET
image = 'catalog/100007999.jpg'
WHERE
option_value_id = 1021
UPDATE oc_option_value_description
SET
name = '100007999 - \''Acrílico Winsor & Newton Galeria 120 ml Laranja Cádmio Hue'
WHERE
option_value_id = 1021
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 = 1021
DELETE FROM oc_product
WHERE
model = '100007999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1021,
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 '100008099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1022
UPDATE oc_option_value_description
SET
name = '100008099 - \''Acrílico Winsor & Newton Galeria 120 ml Vermelho Cádmio Hue'
WHERE
option_value_id = 1022
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 = 1022
DELETE FROM oc_product
WHERE
model = '100008099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1022,
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 '100008199 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008199.jpg'
WHERE
option_value_id = 1023
UPDATE oc_option_value_description
SET
name = '100008199 - \''Acrílico Winsor & Newton Galeria 120 ml Amarelo Cádmio Pálido HUE'
WHERE
option_value_id = 1023
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 = 1023
DELETE FROM oc_product
WHERE
model = '100008199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1023,
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 '100008299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008299.jpg'
WHERE
option_value_id = 1024
UPDATE oc_option_value_description
SET
name = '100008299 - \''Acrílico Winsor & Newton Galeria 120 ml Amarelo Cádmio Escuro HUE'
WHERE
option_value_id = 1024
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 = 1024
DELETE FROM oc_product
WHERE
model = '100008299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1024,
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 '100008399 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008399.jpg'
WHERE
option_value_id = 1025
UPDATE oc_option_value_description
SET
name = '100008399 - \''Acrílico Winsor & Newton Galeria 120 ml Amarelo Cádmio Médio HUE'
WHERE
option_value_id = 1025
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 = 1025
DELETE FROM oc_product
WHERE
model = '100008399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1025,
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 '100008499 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008499.jpg'
WHERE
option_value_id = 1026
UPDATE oc_option_value_description
SET
name = '100008499 - \''Acrílico Winsor & Newton Galeria 120 ml Azul Ceruleo HUE'
WHERE
option_value_id = 1026
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 = 1026
DELETE FROM oc_product
WHERE
model = '100008499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1026,
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 '100008599 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008599.jpg'
WHERE
option_value_id = 1027
UPDATE oc_option_value_description
SET
name = '100008599 - \''Acrílico Winsor & Newton Galeria 120 ml Azul Cobalto HUE'
WHERE
option_value_id = 1027
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 = 1027
DELETE FROM oc_product
WHERE
model = '100008599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1027,
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 '100008699 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008699.jpg'
WHERE
option_value_id = 1028
UPDATE oc_option_value_description
SET
name = '100008699 - Acrílico Winsor & Newton Galeria 120 ml Carmim'
WHERE
option_value_id = 1028
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 = 1028
DELETE FROM oc_product
WHERE
model = '100008699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1028,
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 '100008799 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008799.jpg'
WHERE
option_value_id = 1029
UPDATE oc_option_value_description
SET
name = '100008799 - Acrílico Winsor & Newton Galeria 120 ml Turquesa Profundo'
WHERE
option_value_id = 1029
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 = 1029
DELETE FROM oc_product
WHERE
model = '100008799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1029,
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 '100008899 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008899.jpg'
WHERE
option_value_id = 1030
UPDATE oc_option_value_description
SET
name = '100008899 - Acrílico Winsor & Newton Galeria 120 ml Preto Marfim'
WHERE
option_value_id = 1030
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 = 1030
DELETE FROM oc_product
WHERE
model = '100008899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1030,
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 '100008999 - %'
UPDATE oc_option_value
SET
image = 'catalog/100008999.jpg'
WHERE
option_value_id = 1031
UPDATE oc_option_value_description
SET
name = '100008999 - Acrílico Winsor & Newton Galeria 120 ml Amarelo Limão'
WHERE
option_value_id = 1031
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 = 1031
DELETE FROM oc_product
WHERE
model = '100008999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1031,
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 '100009099 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009099.jpg'
WHERE
option_value_id = 1032
UPDATE oc_option_value_description
SET
name = '100009099 - Acrílico Winsor & Newton Galeria 120 ml Preto de Marte'
WHERE
option_value_id = 1032
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 = 1032
DELETE FROM oc_product
WHERE
model = '100009099'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1032,
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 '100009199 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009199.jpg'
WHERE
option_value_id = 1033
UPDATE oc_option_value_description
SET
name = '100009199 - Acrílico Winsor & Newton Galeria 120 ml Branco Mistura'
WHERE
option_value_id = 1033
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 = 1033
DELETE FROM oc_product
WHERE
model = '100009199'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1033,
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 '100009299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009299.jpg'
WHERE
option_value_id = 1034
UPDATE oc_option_value_description
SET
name = '100009299 - Acrílico Winsor & Newton Galeria 120 ml Amarelo Nápoles'
WHERE
option_value_id = 1034
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 = 1034
DELETE FROM oc_product
WHERE
model = '100009299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1034,
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 '100009399 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009399.jpg'
WHERE
option_value_id = 1035
UPDATE oc_option_value_description
SET
name = '100009399 - Acrílico Winsor & Newton Galeria 120 ml Terracota Pálido'
WHERE
option_value_id = 1035
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 = 1035
DELETE FROM oc_product
WHERE
model = '100009399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1035,
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 '100009499 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009499.jpg'
WHERE
option_value_id = 1073
UPDATE oc_option_value_description
SET
name = '100009499 - Acrílico Winsor & Newton Galeria 120 ml Azul Polvo'
WHERE
option_value_id = 1073
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 = 1073
DELETE FROM oc_product
WHERE
model = '100009499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1073,
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 '100009599 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009599.jpg'
WHERE
option_value_id = 1074
UPDATE oc_option_value_description
SET
name = '100009599 - Acrílico Winsor & Newton Galeria 120 ml Verde Azeitona'
WHERE
option_value_id = 1074
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 = 1074
DELETE FROM oc_product
WHERE
model = '100009599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1074,
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 '100009699 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009699.jpg'
WHERE
option_value_id = 1075
UPDATE oc_option_value_description
SET
name = '100009699 - Acrílico Winsor & Newton Galeria 120 ml Rosa Ópera'
WHERE
option_value_id = 1075
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 = 1075
DELETE FROM oc_product
WHERE
model = '100009699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1075,
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 '100009799 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009799.jpg'
WHERE
option_value_id = 1076
UPDATE oc_option_value_description
SET
name = '100009799 - Acrílico Winsor & Newton Galeria 120 ml Cinzento de Payne'
WHERE
option_value_id = 1076
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 = 1076
DELETE FROM oc_product
WHERE
model = '100009799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1076,
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 '100009899 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009899.jpg'
WHERE
option_value_id = 1077
UPDATE oc_option_value_description
SET
name = '100009899 - Acrílico Winsor & Newton Galeria 120 ml Carmim d\''Alizarina Permanente'
WHERE
option_value_id = 1077
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 = 1077
DELETE FROM oc_product
WHERE
model = '100009899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1077,
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 '100009999 - %'
UPDATE oc_option_value
SET
image = 'catalog/100009999.jpg'
WHERE
option_value_id = 1135
UPDATE oc_option_value_description
SET
name = '100009999 - Acrílico Winsor & Newton Galeria 120 ml Verde Brilhante Permanente'
WHERE
option_value_id = 1135
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 = 1135
DELETE FROM oc_product
WHERE
model = '100009999'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1135,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.