Product Sync.
Opencart products: 201
Input products: 100
NEW: 101343399
NEW: 101343499
NEW: 101343599
NEW: 101343699
NEW: 101343799
NEW: 101343899
NEW: 101343999
NEW: 101344099
NEW: 101344199
NEW: 101344299
NEW: 101344399
NEW: 101344499
NEW: 101344599
NEW: 101344699
NEW: 101344799
NEW: 101344899
NEW: 101344999
NEW: 101345099
NEW: 101345199
NEW: 101345299
NEW: 101345399
NEW: 101345499
NEW: 101345599
NEW: 101345699
NEW: 101345799
NEW: 101345899
NEW: 101345999
NEW: 101346099
NEW: 101346199
NEW: 101346299
NEW: 101346399
NEW: 101346499
NEW: 101346599
NEW: 101346699
NEW: 101346799
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
Image file:
NEW: 101346999
NEW: 101347099
NEW: 101347199
NEW: 101347299
NEW: 101347399
NEW: 101347499
NEW: 101347599
NEW: 101347699
NEW: 101347799
NEW: 101347899
NEW: 101347999
NEW: 101348099
NEW: 101348199
NEW: 101348299
NEW: 101348399
NEW: 101348499
NEW: 101348599
NEW: 101348699
NEW: 101348799
NEW: 101348899
NEW: 101348999
NEW: 101349099
NEW: 101349199
NEW: 101349299
NEW: 101349399
NEW: 101349499
NEW: 101349599
NEW: 101349699
NEW: 101349799
NEW: 101349899
NEW: 101349999
NEW: 101350099
NEW: 101350199
NEW: 101350299
NEW: 101350399
NEW: 101350499
NEW: 101350599
NEW: 101350699
NEW: 101350799
NEW: 101350899
NEW: 101350999
UPDATING: Cera Pébéo Gedeo para Dourar
Product ID: 27149
Image file:
NEW: 101351199
NEW: 101351299
NEW: 101351399
NEW: 101351499
NEW: 101351599
NEW: 101351699
NEW: 101351799
NEW: 101351899
NEW: 101351999
NEW: 101352099
NEW: 101352199
NEW: 101352299
NEW: 101352399
NEW: 101352499
NEW: 101352599
NEW: 101352699
NEW: 101352799
NEW: 101352899
NEW: 101352999
NEW: 101353099
NEW: 101353199
NEW: 101353299
Ok.
Product Option Sync.
Opencart products: 201
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 = 27030
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101346899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2461
UPDATE oc_option_value_description
SET
name = '101346899 - Setacolor Opaco Azul Pérola'
WHERE
option_value_id = 2461
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2461
DELETE FROM oc_product
WHERE
model = '101346899'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2461
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27149
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101351099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2462
UPDATE oc_option_value_description
SET
name = '101351099 - Cera Pébéo Gedeo para Dourar 30 ml Ouro Antigo'
WHERE
option_value_id = 2462
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 296
AND product_id = 27149
AND option_id = 15
AND option_value_id = 2462
DELETE FROM oc_product
WHERE
model = '101351099'
INSERT INTO oc_product_option_value
SET
product_option_id = 296,
product_id = 27149,
option_id = 15,
option_value_id = 2462,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.