Product Sync.
Opencart products: 211
Input products: 100
NEW: 101626099
NEW: 101626199
NEW: 101626299
NEW: 101626399
NEW: 101626499
NEW: 101626599
NEW: 101626699
NEW: 101626799
NEW: 101626899
NEW: 101626999
NEW: 101627099
NEW: 101627199
NEW: 101627299
NEW: 101627399
NEW: 101627499
NEW: 101627599
NEW: 101627699
NEW: 101627799
NEW: 101627899
NEW: 101627999
NEW: 101628099
NEW: 101628199
NEW: 101628299
NEW: 101628399
NEW: 101628499
NEW: 101628599
NEW: 101628699
NEW: 101628799
NEW: 101628899
NEW: 101628999
NEW: 101629099
NEW: 101629199
NEW: 101629299
NEW: 101629399
NEW: 101629499
NEW: 101629599
NEW: 101629699
NEW: 101629799
UPDATING: Tela Creatore 3D
Product ID: 27130
Image file:
NEW: 101629999
NEW: 101630099
NEW: 101630199
NEW: 101630299
NEW: 101630399
NEW: 101630499
NEW: 101630599
NEW: 101630699
NEW: 101630799
NEW: 101630899
NEW: 101630999
NEW: 101631099
NEW: 101631199
NEW: 101631299
NEW: 101631399
NEW: 101631499
NEW: 101631599
NEW: 101631699
NEW: 101631799
NEW: 101631899
NEW: 101631999
NEW: 101632099
NEW: 101632199
NEW: 101632299
NEW: 101632399
NEW: 101632499
NEW: 101632599
NEW: 101632699
NEW: 101632799
NEW: 101632899
NEW: 101632999
NEW: 101633099
NEW: 101633199
NEW: 101633299
NEW: 101633399
NEW: 101633499
NEW: 101633599
NEW: 101633699
NEW: 101633799
NEW: 101633899
NEW: 101633999
NEW: 101634099
NEW: 101634199
NEW: 101634299
NEW: 101634399
NEW: 101634499
NEW: 101634599
NEW: 101634699
NEW: 101634799
NEW: 101634899
NEW: 101634999
NEW: 101635099
NEW: 101635199
NEW: 101635299
NEW: 101635399
NEW: 101635499
NEW: 101635599
NEW: 101635699
NEW: 101635799
NEW: 101635899
NEW: 101635999
Ok.
Product Option Sync.
Opencart products: 211
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 '101629899 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3186 AS option_value_id,
language_id,
15 AS option_id,
'101629899 - \''Tela Creatore 3D 60 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 = 3186
DELETE FROM oc_product
WHERE
model = '101629899'
INSERT INTO oc_product_option_value
SET
product_option_id = 284,
product_id = 27130,
option_id = 15,
option_value_id = 3186,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.