Product Sync.
Opencart products: 50
Input products: 100
NEW: 100323399
NEW: 100323499
NEW: 100323599
NEW: 100323699
NEW: 100323799
NEW: 100323899
NEW: 100323999
NEW: 100324099
NEW: 100324199
NEW: 100324299
NEW: 100324399
NEW: 100324499
NEW: 100324599
NEW: 100324699
NEW: 100324799
NEW: 100324899
NEW: 100324999
NEW: 100325099
NEW: 100325199
NEW: 100325299
NEW: 100325399
NEW: 100325499
NEW: 100325599
NEW: 100325699
NEW: 100325799
NEW: 100325899
NEW: 100325999
NEW: 100326099
NEW: 100326199
NEW: 100326299
NEW: 100326399
UPDATING: Aguarela Winsor & Newton Cotman Tubo ou Pastilha
Product ID: 27434
Image file:
NEW: 100326599
NEW: 100326699
NEW: 100326799
NEW: Verniz Amsterdam para Óleo e para Acrílico
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Verniz Amsterdam para Óleo e para Acrílico - %'
)
NEW: Aguarela Líquida Ecoline
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Aguarela Líquida Ecoline - %'
)
NEW: 100327199
NEW: 100327299
NEW: 100327399
NEW: 100327499
NEW: 100327599
NEW: 100327699
NEW: 100327799
NEW: 100327899
NEW: 100327999
NEW: 100328099
NEW: 100328199
NEW: 100328299
NEW: 100328399
NEW: 100328499
NEW: 100328599
NEW: 100328699
NEW: 100328799
NEW: 100328899
NEW: 100328999
NEW: 100329099
NEW: 100329199
NEW: 100329299
NEW: 100329399
NEW: 100329499
NEW: 100329599
NEW: 100329699
NEW: 100329799
NEW: 100329899
NEW: 100329999
NEW: 100330099
NEW: 100330199
NEW: 100330299
NEW: 100330399
NEW: 100330499
NEW: 100330599
NEW: 100330699
NEW: 100330799
NEW: 100330899
NEW: 100330999
NEW: 100331099
NEW: 100331199
NEW: 100331299
NEW: 100331399
NEW: 100331499
NEW: 100331599
NEW: 100331699
NEW: 100331799
NEW: 100331899
NEW: 100331999
NEW: 100332099
NEW: 100332199
NEW: 100332299
NEW: 100332399
NEW: 100332499
NEW: 100332599
NEW: 100332699
NEW: 100332799
NEW: 100332899
NEW: 100332999
NEW: 100333099
NEW: 100333199
NEW: 100333299
Ok.
Product Option Sync.
Opencart products: 52
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 = 27434
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100326499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 970
UPDATE oc_option_value_description
SET
name = '100326499 - Aguarela Winsor & Newton Cotman 8 ml Verde Hookers Escuro'
WHERE
option_value_id = 970
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 415
AND product_id = 27434
AND option_id = 17
AND option_value_id = 970
DELETE FROM oc_product
WHERE
model = '100326499'
INSERT INTO oc_product_option_value
SET
product_option_id = 415,
product_id = 27434,
option_id = 17,
option_value_id = 970,
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 = 27448
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27448,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100326899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/100326899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3271 AS option_value_id,
language_id,
17 AS option_id,
'100326899 - Verniz Amsterdam para Óleo e para Acrílico Mate 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 427
AND product_id = 27448
AND option_id = 17
AND option_value_id = 3271
DELETE FROM oc_product
WHERE
model = '100326899'
INSERT INTO oc_product_option_value
SET
product_option_id = 427,
product_id = 27448,
option_id = 17,
option_value_id = 3271,
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 = 27449
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27449,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100326999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 971
UPDATE oc_option_value_description
SET
name = '100326999 - Aguarela Ecoline Talens 25 - 30 ml Cinza Frio 717'
WHERE
option_value_id = 971
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 971
DELETE FROM oc_product
WHERE
model = '100326999'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 971,
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 '100327099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 974
UPDATE oc_option_value_description
SET
name = '100327099 - Aguarela Ecoline Talens 25 - 30 ml Verde Pastel 666'
WHERE
option_value_id = 974
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 974
DELETE FROM oc_product
WHERE
model = '100327099'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 974,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.