Product Sync.
Opencart products: 250
Input products: 100
NEW: 102171599
NEW: 102171699
NEW: 102171799
NEW: 102171899
NEW: 102171999
NEW: 102172099
NEW: 102172199
NEW: 102172299
NEW: 102172399
NEW: 102172499
NEW: 102172599
NEW: 102172699
NEW: 102172799
NEW: 102172899
NEW: 102172999
NEW: 102173099
UPDATING: Trincha Talens Sintética S370
Product ID: 27201
Image file:
NEW: 102173299
NEW: 102173399
NEW: 102173499
NEW: 102173599
NEW: 102173699
NEW: 102173799
NEW: 102173899
NEW: 102173999
NEW: 102174099
NEW: 102174199
NEW: 102174299
NEW: 102174399
NEW: 102174499
NEW: 102174599
NEW: 102174699
NEW: 102174799
NEW: 102174899
NEW: 102174999
NEW: 102175099
NEW: 102175199
NEW: 102175299
NEW: 102175399
NEW: 102175499
NEW: 102175599
NEW: 102175699
NEW: 102175799
NEW: 102175899
NEW: 102175999
NEW: 102176099
NEW: 102176199
NEW: 102176299
NEW: 102176399
NEW: 102176499
NEW: 102176599
NEW: 102176699
NEW: 102176799
NEW: 102176899
NEW: 102176999
NEW: 102177099
NEW: 102177199
NEW: 102177299
NEW: 102177399
NEW: 102177499
NEW: 102177599
NEW: 102177699
NEW: 102177799
NEW: 102177899
NEW: 102177999
NEW: 102178099
NEW: 102178199
NEW: 102178299
NEW: 102178399
NEW: 102178499
NEW: 102178599
NEW: 102178699
NEW: 102178799
NEW: 102178899
NEW: 102178999
NEW: 102179099
NEW: 102179199
NEW: 102179299
NEW: 102179399
NEW: 102179499
NEW: 102179599
NEW: 102179699
NEW: 102179799
NEW: 102179899
NEW: 102179999
NEW: 102180099
NEW: 102180199
NEW: 102180299
NEW: 102180399
NEW: 102180499
NEW: 102180599
NEW: 102180699
NEW: 102180799
NEW: 102180899
NEW: 102180999
NEW: 102181099
NEW: 102181199
NEW: 102181299
NEW: 102181399
NEW: 102181499
Ok.
Product Option Sync.
Opencart products: 250
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 = 27201
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102173199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2625
UPDATE oc_option_value_description
SET
name = '102173199 - Trincha Talens Sintética S370 N2'
WHERE
option_value_id = 2625
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 322
AND product_id = 27201
AND option_id = 15
AND option_value_id = 2625
DELETE FROM oc_product
WHERE
model = '102173199'
INSERT INTO oc_product_option_value
SET
product_option_id = 322,
product_id = 27201,
option_id = 15,
option_value_id = 2625,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.