Product Sync.
Opencart products: 250
Input products: 100
NEW: 102161499
NEW: 102161599
NEW: 102161699
NEW: 102161799
NEW: 102161899
NEW: 102161999
NEW: 102162099
NEW: 102162199
NEW: 102162299
NEW: 102162399
NEW: 102162499
NEW: 102162599
NEW: 102162699
NEW: 102162799
NEW: 102162899
NEW: 102162999
NEW: 102163099
NEW: 102163199
NEW: 102163299
NEW: 102163399
NEW: 102163499
NEW: 102163599
NEW: 102163699
NEW: 102163799
NEW: 102163899
NEW: 102163999
NEW: 102164099
NEW: 102164199
NEW: 102164299
NEW: 102164399
NEW: 102164499
NEW: 102164599
NEW: 102164699
NEW: 102164799
NEW: 102164899
NEW: 102164999
NEW: 102165099
NEW: 102165199
NEW: 102165299
NEW: 102165399
NEW: 102165499
NEW: 102165599
NEW: 102165699
NEW: 102165799
NEW: 102165899
NEW: 102165999
NEW: 102166099
NEW: 102166199
NEW: 102166299
NEW: 102166399
NEW: 102166499
NEW: 102166599
NEW: 102166699
NEW: 102166799
NEW: 102166899
NEW: 102166999
NEW: 102167099
NEW: 102167199
NEW: 102167299
NEW: 102167399
NEW: 102167499
NEW: 102167599
NEW: 102167699
NEW: 102167799
UPDATING: Tela Creatore 3D
Product ID: 27130
Image file:
NEW: 102167999
NEW: 102168199
NEW: 102168299
NEW: 102168399
NEW: 102168499
NEW: 102168599
NEW: 102168699
NEW: 102168799
NEW: 102168899
NEW: 102168999
NEW: 102169099
NEW: 102169199
NEW: 102169299
NEW: 102169399
NEW: 102169499
NEW: 102169599
NEW: 102169699
NEW: 102169799
NEW: 102169899
NEW: 102169999
NEW: 102170099
NEW: 102170199
NEW: 102170299
NEW: 102170399
NEW: 102170499
NEW: 102170599
NEW: 102170699
NEW: 102170799
NEW: 102170899
NEW: 102170999
NEW: 102171099
NEW: 102171199
NEW: 102171299
NEW: 102171399
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 = 27130
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102167899 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3218 AS option_value_id,
language_id,
15 AS option_id,
'102167899 - \''Tela Creatore 3D 50 x 60' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 284
AND product_id = 27130
AND option_id = 15
AND option_value_id = 3218
DELETE FROM oc_product
WHERE
model = '102167899'
INSERT INTO oc_product_option_value
SET
product_option_id = 284,
product_id = 27130,
option_id = 15,
option_value_id = 3218,
quantity = 1,
subtract = 1,
price = 3.374,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102168099 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3219 AS option_value_id,
language_id,
15 AS option_id,
'102168099 - \''Tela Creatore 3D 30 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 284
AND product_id = 27130
AND option_id = 15
AND option_value_id = 3219
DELETE FROM oc_product
WHERE
model = '102168099'
INSERT INTO oc_product_option_value
SET
product_option_id = 284,
product_id = 27130,
option_id = 15,
option_value_id = 3219,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.