Product Sync.
Opencart products: 185
Input products: 100
NEW: 101070699
NEW: 101070799
NEW: 101070899
NEW: 101070999
NEW: 101071099
NEW: 101071199
NEW: 101071299
NEW: 101071399
NEW: 101071499
NEW: 101071599
NEW: 101071699
NEW: 101071799
NEW: 101071899
NEW: 101071999
NEW: 101072099
NEW: 101072199
NEW: 101072299
NEW: 101072399
NEW: 101072499
NEW: 101072599
NEW: 101072699
NEW: 101072799
NEW: 101072899
NEW: 101072999
NEW: 101073099
NEW: 101073199
NEW: 101073299
NEW: 101073399
NEW: 101073499
NEW: 101073599
NEW: 101073699
NEW: 101073799
NEW: 101073899
NEW: 101073999
NEW: 101074099
UPDATING: Tela Art Creation
Product ID: 27035
Image file:
NEW: 101074299
NEW: 101074399
NEW: 101074499
NEW: 101074599
UPDATING: Tela Winsor & Newton
Product ID: 27164
Image file:
UPDATING: Tinta Acrílica Talens Amsterdam 500 ml
Product ID: 27056
Image file:
NEW: 101075699
NEW: 101075799
NEW: 101075899
NEW: 101075999
NEW: 101076099
NEW: 101076199
NEW: 101076299
NEW: 101076399
NEW: 101076499
NEW: 101076599
NEW: 101076699
NEW: 101076799
NEW: 101076899
NEW: 101076999
NEW: 101077099
NEW: 101077199
NEW: 101077299
NEW: 101077399
NEW: 101077499
NEW: 101077599
NEW: 101077699
NEW: 101077799
NEW: 101077899
NEW: 101077999
NEW: 101078099
NEW: 101078199
NEW: 101078299
NEW: 101078399
NEW: 101078499
NEW: 101078599
NEW: 101078699
NEW: 101078799
NEW: 101078899
NEW: 101078999
NEW: 101079099
NEW: 101079199
NEW: 101079299
NEW: 101079399
NEW: 101079499
NEW: 101079599
NEW: 101079699
NEW: 101079799
NEW: 101079899
NEW: 101079999
NEW: 101080099
NEW: 101080199
NEW: 101080299
NEW: 101080399
NEW: 101080499
NEW: 101080599
Ok.
Product Option Sync.
Opencart products: 185
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 = 27035
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2397
UPDATE oc_option_value_description
SET
name = '101074199 - Tela Art Creation 40 x 40'
WHERE
option_value_id = 2397
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 102
AND product_id = 27035
AND option_id = 15
AND option_value_id = 2397
DELETE FROM oc_product
WHERE
model = '101074199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 102
AND product_id = 27035
AND option_id = 15
AND option_value_id = 2397
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 '101074699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2398
UPDATE oc_option_value_description
SET
name = '101074699 - Tela Winsor & Newton 100 x 100'
WHERE
option_value_id = 2398
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 = 2398
DELETE FROM oc_product
WHERE
model = '101074699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2398,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27056
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074799 - %'
UPDATE oc_option_value
SET
image = 'catalog/101074799.jpg'
WHERE
option_value_id = 1546
UPDATE oc_option_value_description
SET
name = '101074799 - Acrílico Amsterdam 500 ml Branco Titânio'
WHERE
option_value_id = 1546
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1546
DELETE FROM oc_product
WHERE
model = '101074799'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1546
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074899 - %'
UPDATE oc_option_value
SET
image = 'catalog/101074899.jpg'
WHERE
option_value_id = 1547
UPDATE oc_option_value_description
SET
name = '101074899 - Acrílico Amsterdam 500 ml Preto Lampada'
WHERE
option_value_id = 1547
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1547
DELETE FROM oc_product
WHERE
model = '101074899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1547
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074999 - %'
UPDATE oc_option_value
SET
image = 'catalog/101074999.jpg'
WHERE
option_value_id = 1548
UPDATE oc_option_value_description
SET
name = '101074999 - Acrílico Amsterdam 500 ml Amarelo Primário'
WHERE
option_value_id = 1548
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1548
DELETE FROM oc_product
WHERE
model = '101074999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1548
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101075099 - %'
UPDATE oc_option_value
SET
image = 'catalog/101075099.jpg'
WHERE
option_value_id = 1549
UPDATE oc_option_value_description
SET
name = '101075099 - Acrílico Amsterdam 500 ml Vermelhão'
WHERE
option_value_id = 1549
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1549
DELETE FROM oc_product
WHERE
model = '101075099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1549
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101075199 - %'
UPDATE oc_option_value
SET
image = 'catalog/101075199.jpg'
WHERE
option_value_id = 1550
UPDATE oc_option_value_description
SET
name = '101075199 - Acrílico Amsterdam 500 ml Vermelho Naftol Médio'
WHERE
option_value_id = 1550
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1550
DELETE FROM oc_product
WHERE
model = '101075199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1550
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101075299 - %'
UPDATE oc_option_value
SET
image = 'catalog/101075299.jpg'
WHERE
option_value_id = 1551
UPDATE oc_option_value_description
SET
name = '101075299 - Acrílico Amsterdam 500 ml Terra Siena Queimada'
WHERE
option_value_id = 1551
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1551
DELETE FROM oc_product
WHERE
model = '101075299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1551
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101075399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101075399.jpg'
WHERE
option_value_id = 1552
UPDATE oc_option_value_description
SET
name = '101075399 - Acrílico Amsterdam 500 ml Azul Ultramar Violeta'
WHERE
option_value_id = 1552
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1552
DELETE FROM oc_product
WHERE
model = '101075399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1552
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101075499 - %'
UPDATE oc_option_value
SET
image = 'catalog/101075499.jpg'
WHERE
option_value_id = 1553
UPDATE oc_option_value_description
SET
name = '101075499 - Acrílico Amsterdam 500 ml Verde Permanente Claro'
WHERE
option_value_id = 1553
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1553
DELETE FROM oc_product
WHERE
model = '101075499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1553
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101075599 - %'
UPDATE oc_option_value
SET
image = 'catalog/101075599.jpg'
WHERE
option_value_id = 1554
UPDATE oc_option_value_description
SET
name = '101075599 - Acrílico Amsterdam 500 ml Azul Cian Primário'
WHERE
option_value_id = 1554
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1554
DELETE FROM oc_product
WHERE
model = '101075599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 121
AND product_id = 27056
AND option_id = 15
AND option_value_id = 1554
Ok.