Product Sync.
Opencart products: 217
Input products: 100
NEW: 102530799
NEW: 102530899
NEW: 102530999
NEW: 102531099
NEW: 102531199
NEW: 102531299
NEW: 102531399
NEW: 102531499
NEW: 102531599
NEW: 102531699
NEW: 102531799
NEW: 102531899
NEW: 102531999
NEW: 102532099
NEW: 102532199
NEW: 102532299
NEW: 102532399
NEW: 102532499
NEW: 102532599
NEW: 102532699
NEW: 102532799
NEW: 102532899
NEW: 102532999
NEW: 102533099
NEW: 102533199
NEW: 102533299
NEW: 102533399
NEW: 102533499
NEW: 102533599
NEW: 102533699
NEW: 102533799
NEW: 102533899
NEW: 102533999
NEW: 102534099
NEW: 102534199
NEW: 102534299
NEW: 102534399
NEW: 102534499
NEW: 102534599
NEW: 102534699
NEW: 102534799
NEW: 102534899
NEW: 102534999
NEW: 102535099
NEW: 102535199
NEW: 102535299
NEW: 102535399
NEW: 102535499
NEW: 102535599
NEW: 102535699
NEW: 102535799
NEW: 102535899
NEW: 102535999
NEW: 102536099
NEW: 102536199
NEW: 102536399
NEW: 102536499
NEW: 102536599
NEW: 102536699
NEW: 102536799
NEW: 102536899
NEW: 102536999
NEW: 102537099
NEW: 102537199
NEW: 102537299
NEW: 102537399
NEW: 102537499
UPDATING: Tela Creatore 3D
Product ID: 27421
Image file:
NEW: 102537699
NEW: 102537799
NEW: 102537899
NEW: 102537999
NEW: 102538099
NEW: 102538199
NEW: 102538299
NEW: 102538399
UPDATING: Pincel Talens Aguarela Espatulado S194
Product ID: 27523
Image file:
NEW: 102538599
NEW: 102538699
NEW: 102538799
NEW: 102538899
NEW: 102538999
NEW: 102539099
NEW: 102539199
NEW: 102539299
NEW: 102539399
NEW: 102539499
NEW: 102539599
NEW: 102539699
NEW: 102539799
NEW: 102539899
NEW: 102539999
NEW: 102540099
NEW: 102540199
NEW: 102540299
NEW: 102540399
NEW: 102540499
NEW: 102540599
NEW: 102540699
NEW: 102540799
Ok.
Product Option Sync.
Opencart products: 217
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 '102537599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3752 AS option_value_id,
language_id,
17 AS option_id,
'102537599 - Tela Creatore 3D 70 x 70' 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 = 3752
DELETE FROM oc_product
WHERE
model = '102537599'
INSERT INTO oc_product_option_value
SET
product_option_id = 407,
product_id = 27421,
option_id = 17,
option_value_id = 3752,
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 = 27523
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102538499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3753 AS option_value_id,
language_id,
17 AS option_id,
'102538499 - Pincel Talens Aguarela Espatulado S194 N24' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 479
AND product_id = 27523
AND option_id = 17
AND option_value_id = 3753
DELETE FROM oc_product
WHERE
model = '102538499'
INSERT INTO oc_product_option_value
SET
product_option_id = 479,
product_id = 27523,
option_id = 17,
option_value_id = 3753,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.