Product Sync.
Opencart products: 194
Input products: 100
NEW: 102323099
NEW: 102323199
NEW: 102323299
NEW: 102323399
NEW: 102323499
NEW: 102323599
NEW: 102323699
NEW: 102323799
NEW: 102323899
NEW: 102323999
NEW: 102324099
NEW: 102324199
NEW: 102324299
NEW: 102324399
NEW: 102324499
NEW: 102324599
NEW: 102324699
NEW: 102324799
NEW: 102324899
NEW: 102324999
NEW: 102325099
NEW: 102325199
NEW: 102325299
NEW: 102325399
NEW: 102325499
NEW: 102325599
NEW: 102325699
NEW: 102325799
NEW: 102325899
NEW: 102325999
NEW: 102326099
NEW: 102326199
NEW: 102326299
NEW: 102326399
NEW: 102326499
NEW: 102326599
NEW: 102326699
NEW: 102326799
UPDATING: Tela Creatore Premium
Product ID: 27433
Image file:
NEW: 102326999
NEW: 102327099
NEW: 102327199
NEW: 102327299
NEW: 102327399
NEW: 102327499
NEW: 102327599
NEW: 102327699
NEW: 102327799
NEW: 102327899
NEW: 102327999
NEW: 102328099
NEW: 102328199
NEW: 102328299
NEW: 102328399
NEW: 102328499
NEW: 102328599
NEW: 102328699
NEW: 102328799
NEW: 102328899
NEW: 102328999
NEW: 102329099
NEW: 102329199
NEW: 102329299
NEW: 102329399
NEW: 102329499
NEW: 102329599
NEW: 102329699
NEW: 102329799
NEW: 102329899
NEW: 102329999
NEW: 102330099
NEW: 102330199
NEW: 102330299
NEW: 102330399
NEW: 102330499
NEW: 102330599
NEW: 102330699
NEW: 102330799
NEW: 102330899
NEW: 102330999
NEW: 102331099
NEW: 102331199
NEW: 102331299
NEW: 102331399
NEW: 102331499
NEW: 102331599
NEW: Cavalete Trident de Mesa 14022
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Trident de Mesa 14022 - %'
)
NEW: 102331799
NEW: 102331899
NEW: 102331999
NEW: 102332099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102332099 - %'
)
NEW: 102332199
NEW: 102332299
NEW: 102332399
NEW: 102332499
NEW: 102332599
NEW: 102332699
NEW: 102332799
NEW: 102332899
NEW: 102332999
Ok.
Product Option Sync.
Opencart products: 196
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 = 27433
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102326899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3695 AS option_value_id,
language_id,
17 AS option_id,
'102326899 - Tela Creatore Premium 20 x 20' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3695
DELETE FROM oc_product
WHERE
model = '102326899'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3695,
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 = 27592
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27592,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102331699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3696 AS option_value_id,
language_id,
17 AS option_id,
'102331699 - Cavalete Trident de Mesa 14022' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 501
AND product_id = 27592
AND option_id = 17
AND option_value_id = 3696
DELETE FROM oc_product
WHERE
model = '102331699'
INSERT INTO oc_product_option_value
SET
product_option_id = 501,
product_id = 27592,
option_id = 17,
option_value_id = 3696,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.