Product Sync.
Opencart products: 26
Input products: 100
NEW: 101165199
NEW: 101165299
NEW: 101165399
NEW: 101165499
NEW: 101165599
NEW: 101165699
NEW: 101165799
NEW: 101165899
NEW: 101165999
NEW: 101166099
NEW: 101166199
NEW: 101166299
NEW: 101166399
NEW: 101166499
NEW: 101166599
NEW: 101166699
NEW: 101166799
NEW: 101166899
NEW: 101166999
NEW: 101167099
NEW: 101167199
NEW: 101167299
UPDATING: Galeria W&N 60ml
Product ID: 27386
Image file:
NEW: 101167699
NEW: 101167799
NEW: 101167899
NEW: 101167999
NEW: 101168099
NEW: 101168199
NEW: 101168299
NEW: 101168399
NEW: 101168499
NEW: 101168599
NEW: 101168699
NEW: 101168799
NEW: 101168899
NEW: 101168999
NEW: 101169099
NEW: 101169199
NEW: 101169299
NEW: 101169399
NEW: 101169499
NEW: 101169599
NEW: 101169699
NEW: 101169799
NEW: 101169899
NEW: 101169999
NEW: 101170099
NEW: 101170199
NEW: 101170299
NEW: 101170399
NEW: 101170499
NEW: 101170599
NEW: 101170699
NEW: 101170799
NEW: 101170899
NEW: 101170999
NEW: 101171099
NEW: 101171199
NEW: 101171299
NEW: 101171399
NEW: 101171499
NEW: 101171599
NEW: 101171699
NEW: 101171799
NEW: 101171899
NEW: 101171999
NEW: 101172099
NEW: 101172199
NEW: 101172299
NEW: 101172399
NEW: 101172499
NEW: 101172599
NEW: 101172699
NEW: 101172799
NEW: 101172899
NEW: 101172999
NEW: 101173099
NEW: 101173199
NEW: 101173299
NEW: 101173399
NEW: 101173499
NEW: 101173599
NEW: 101173699
NEW: 101173799
NEW: 101173899
NEW: 101173999
NEW: 101174099
NEW: 101174199
NEW: 101174299
NEW: 101174399
NEW: 101174499
NEW: 101174599
NEW: 101174699
NEW: 101174799
NEW: 101174899
NEW: 101174999
NEW: 101175099
Ok.
Product Option Sync.
Opencart products: 26
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 = 27386
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101167399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1555
UPDATE oc_option_value_description
SET
name = '101167399 - ACRIL W&N GALER 60ML FLECH TINT'
WHERE
option_value_id = 1555
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1555
DELETE FROM oc_product
WHERE
model = '101167399'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1555,
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 '101167499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1556
UPDATE oc_option_value_description
SET
name = '101167499 - ACRIL W&N GALER 60ML PHTALO BLUE'
WHERE
option_value_id = 1556
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1556
DELETE FROM oc_product
WHERE
model = '101167499'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1556,
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 '101167599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1557
UPDATE oc_option_value_description
SET
name = '101167599 - ACRIL W&N GALER 60ML RED OCHRE'
WHERE
option_value_id = 1557
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 379
AND product_id = 27386
AND option_id = 17
AND option_value_id = 1557
DELETE FROM oc_product
WHERE
model = '101167599'
INSERT INTO oc_product_option_value
SET
product_option_id = 379,
product_id = 27386,
option_id = 17,
option_value_id = 1557,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.