Product Sync.
Opencart products: 94
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: 27460
Image file:
NEW: 101074299
NEW: 101074399
NEW: 101074499
NEW: 101074599
UPDATING: Tela Winsor & Newton
Product ID: 27478
Image file:
NEW: Tinta Acrílica Talens Amsterdam 500 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Acrílica Talens Amsterdam 500 ml - %'
)
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: 95
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 = 27460
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3478 AS option_value_id,
language_id,
17 AS option_id,
'101074199 - Tela Art Creation 40 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 439
AND product_id = 27460
AND option_id = 17
AND option_value_id = 3478
DELETE FROM oc_product
WHERE
model = '101074199'
INSERT INTO oc_product_option_value
SET
product_option_id = 439,
product_id = 27460,
option_id = 17,
option_value_id = 3478,
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 = 27478
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101074699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3479 AS option_value_id,
language_id,
17 AS option_id,
'101074699 - Tela Winsor & Newton 100 x 100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3479
DELETE FROM oc_product
WHERE
model = '101074699'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3479,
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 = 27492
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27492,
option_id = 17,
value = '',
required = 1
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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1546
DELETE FROM oc_product
WHERE
model = '101074799'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1546,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1547
DELETE FROM oc_product
WHERE
model = '101074899'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1547,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1548
DELETE FROM oc_product
WHERE
model = '101074999'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1548,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1549
DELETE FROM oc_product
WHERE
model = '101075099'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1549,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1550
DELETE FROM oc_product
WHERE
model = '101075199'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1550,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1551
DELETE FROM oc_product
WHERE
model = '101075299'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1551,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1552
DELETE FROM oc_product
WHERE
model = '101075399'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1552,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1553
DELETE FROM oc_product
WHERE
model = '101075499'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1553,
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 '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 = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1554
DELETE FROM oc_product
WHERE
model = '101075599'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1554,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.