Product Sync.
Opencart products: 179
Input products: 100
NEW: 100878899
NEW: 100878999
NEW: 100879099
NEW: 100879199
NEW: 100879299
NEW: 100879399
NEW: 100879499
NEW: 100879599
NEW: 100879699
NEW: 100879799
NEW: 100879899
NEW: 100879999
NEW: 100880099
NEW: 100880199
NEW: 100880299
NEW: 100880399
NEW: 100880499
NEW: 100880599
NEW: 100880699
NEW: 100880799
NEW: 100880899
NEW: 100880999
NEW: 100881099
NEW: 100881199
NEW: 100881299
NEW: 100881399
NEW: 100881499
NEW: 100881599
NEW: 100881699
NEW: 100881799
NEW: 100881899
NEW: 100881999
NEW: 100882099
NEW: 100882199
NEW: 100882299
NEW: 100882399
NEW: 100882499
NEW: 100882599
NEW: 100882699
NEW: 100882799
NEW: 100882899
NEW: 100882999
NEW: 100883099
NEW: 100883199
NEW: 100883299
NEW: 100883399
NEW: 100883499
NEW: 100883599
NEW: 100883699
NEW: 100883799
NEW: 100883899
NEW: 100883999
NEW: 100884099
NEW: 100884199
NEW: 100884299
NEW: 100884399
NEW: 100884499
NEW: 100884599
NEW: 100884699
NEW: 100884799
NEW: 100884899
NEW: 100884999
NEW: 100885099
NEW: 100885199
NEW: 100885299
NEW: 100885399
NEW: 100885499
NEW: 100885599
NEW: 100885699
NEW: 100885799
NEW: 100885899
NEW: 100885999
NEW: 100886099
NEW: 100886199
NEW: 100886299
NEW: 100886399
NEW: 100886499
NEW: 100886599
NEW: 100886699
NEW: 100886799
NEW: 100886899
NEW: 100886999
NEW: 100887099
NEW: 100887199
NEW: 100887299
NEW: 100887399
NEW: 100887499
NEW: 100887599
NEW: 100887699
UPDATING: Tela Winsor & Newton
Product ID: 27164
Image file:
NEW: 100887899
NEW: 100887999
NEW: 100888099
NEW: 100888199
NEW: 100888299
NEW: 100888399
NEW: 100888499
NEW: 100888599
NEW: 100888699
NEW: 100888799
Ok.
Product Option Sync.
Opencart products: 179
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100887799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2383
UPDATE oc_option_value_description
SET
name = '100887799 - Tela Winsor & Newton Banda Larga 50 x 100'
WHERE
option_value_id = 2383
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2383
DELETE FROM oc_product
WHERE
model = '100887799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2383,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.