Product Sync.
Opencart products: 19
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: Cotman W&N TB 8ml
Product ID: 27387
Image file:
NEW: 100326599
NEW: 100326699
NEW: 100326799
NEW: 100326899
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: 20
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 = 27387
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 - AGUAR W&N COTMAN 8ML HOOKER.S GREEN DARK'
WHERE
option_value_id = 970
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 380
AND product_id = 27387
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 = 380,
product_id = 27387,
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 = 27391
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27391,
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 - AGUAR ECOLINE TALENS 25-30 ML CZA FRIO'
WHERE
option_value_id = 971
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
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 = 384,
product_id = 27391,
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 - AGUAR ECOLINE TALENS 25-30 ML VDE PASTEL'
WHERE
option_value_id = 974
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
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 = 384,
product_id = 27391,
option_id = 17,
option_value_id = 974,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.