Product Sync.
Opencart products: 208
Input products: 100
NEW: 102434299
NEW: 102434399
NEW: 102434499
NEW: 102434599
NEW: 102434699
NEW: 102434799
NEW: 102434899
NEW: 102434999
NEW: 102435099
NEW: 102435199
NEW: 102435299
NEW: 102435399
NEW: 102435499
NEW: 102435599
NEW: 102435699
NEW: 102435799
NEW: 102435899
NEW: 102435999
NEW: 102436099
NEW: 102436199
NEW: 102436299
NEW: 102436399
NEW: 102436499
NEW: 102436599
NEW: 102436699
NEW: 102436799
NEW: 102436899
NEW: 102436999
NEW: 102437099
NEW: 102437199
NEW: 102437299
NEW: 102437399
NEW: 102437499
NEW: 102437599
NEW: 102437699
NEW: 102437799
NEW: 102437899
NEW: 102437999
NEW: 102438099
NEW: 102438199
NEW: 102438299
NEW: 102438399
NEW: 102438499
NEW: 102438599
NEW: 102438699
NEW: 102438799
NEW: 102438899
NEW: 102438999
NEW: 102439099
NEW: 102439199
NEW: 102439299
NEW: 102439399
NEW: 102439499
NEW: 102439599
NEW: 102439699
NEW: 102439799
NEW: 102439899
NEW: 102439999
NEW: 102440099
NEW: 102440199
NEW: 102440299
NEW: 102440399
NEW: 102440499
NEW: 102440599
NEW: 102440699
NEW: 102440799
NEW: 102440899
NEW: 102440999
NEW: 102441099
NEW: 102441199
NEW: 102441299
NEW: 102441599
NEW: 102441699
NEW: 102441799
NEW: 102441899
NEW: 102441999
NEW: 102442099
NEW: 102442199
NEW: 102442299
NEW: 102442399
NEW: 102442499
NEW: 102442599
NEW: 102442699
NEW: 102442799
NEW: 102442899
NEW: 102442999
NEW: 102443099
NEW: 102443199
NEW: 102443299
NEW: 102443399
NEW: 102443499
UPDATING: Tela Creatore 3D
Product ID: 27421
Image file:
NEW: 102443699
NEW: 102443799
NEW: 102443899
NEW: 102443999
NEW: 102444099
NEW: 102444199
NEW: 102444299
NEW: 102444399
Ok.
Product Option Sync.
Opencart products: 208
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 = 27421
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102443599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3737 AS option_value_id,
language_id,
17 AS option_id,
'102443599 - \''Tela Creatore 3D 70 x100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 407
AND product_id = 27421
AND option_id = 17
AND option_value_id = 3737
DELETE FROM oc_product
WHERE
model = '102443599'
INSERT INTO oc_product_option_value
SET
product_option_id = 407,
product_id = 27421,
option_id = 17,
option_value_id = 3737,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.