Product Sync.
Opencart products: 281
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: 27139
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: 283
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 = 27139
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102326899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2657
UPDATE oc_option_value_description
SET
name = '102326899 - Tela Creatore Premium 20 x 20'
WHERE
option_value_id = 2657
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2657
DELETE FROM oc_product
WHERE
model = '102326899'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2657,
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 = 27270
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27270,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102331699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2658
UPDATE oc_option_value_description
SET
name = '102331699 - Cavalete Trident de Mesa 14022'
WHERE
option_value_id = 2658
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 339
AND product_id = 27270
AND option_id = 15
AND option_value_id = 2658
DELETE FROM oc_product
WHERE
model = '102331699'
INSERT INTO oc_product_option_value
SET
product_option_id = 339,
product_id = 27270,
option_id = 15,
option_value_id = 2658,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.