Product Sync.
Opencart products: 113
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: 27455
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: 27456
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: 113
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 = 27455
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101346899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3536 AS option_value_id,
language_id,
17 AS option_id,
'101346899 - Setacolor Opaco Azul Pérola' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3536
DELETE FROM oc_product
WHERE
model = '101346899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3536,
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 = 27456
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101351099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3537 AS option_value_id,
language_id,
17 AS option_id,
'101351099 - Cera Pébéo Gedeo para Dourar 30 ml Ouro Antigo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 435
AND product_id = 27456
AND option_id = 17
AND option_value_id = 3537
DELETE FROM oc_product
WHERE
model = '101351099'
INSERT INTO oc_product_option_value
SET
product_option_id = 435,
product_id = 27456,
option_id = 17,
option_value_id = 3537,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.