Product Sync.
Opencart products: 245
Input products: 100
NEW: 102070599
NEW: 102070699
NEW: 102070799
NEW: 102070899
NEW: 102070999
NEW: 102071099
NEW: 102071199
NEW: 102071299
NEW: 102071399
NEW: 102071499
NEW: 102071599
NEW: 102071699
NEW: 102071799
NEW: 102071899
NEW: 102071999
NEW: 102072099
NEW: 102072199
NEW: 102072299
NEW: 102072399
NEW: 102072499
NEW: 102072599
NEW: 102072699
NEW: 102072799
NEW: 102072899
NEW: 102072999
NEW: Tela Daler Rowney Simply
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tela Daler Rowney Simply - %'
)
NEW: 102073299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102073299 - %'
)
NEW: 102073399
NEW: 102073499
NEW: 102073599
NEW: 102073699
NEW: 102073799
NEW: 102073899
NEW: 102073999
NEW: 102074099
NEW: 102074199
NEW: 102074299
NEW: 102074399
NEW: 102074499
NEW: 102074599
NEW: 102074699
NEW: 102074799
NEW: 102074899
NEW: 102074999
NEW: 102075099
NEW: 102075199
NEW: 102075299
NEW: 102075399
NEW: 102075499
NEW: 102075599
NEW: 102075699
NEW: 102075799
NEW: 102075899
NEW: 102075999
NEW: 102076099
NEW: 102076199
NEW: 102076299
NEW: 102076399
NEW: 102076499
NEW: 102076599
NEW: 102076699
NEW: 102076799
NEW: 102076899
NEW: 102076999
NEW: 102077099
NEW: 102077199
NEW: 102077299
NEW: 102077399
NEW: 102077499
NEW: 102077599
NEW: 102077699
NEW: 102077799
NEW: 102077899
NEW: 102077999
NEW: 102078099
NEW: 102078199
NEW: 102078299
NEW: 102078399
NEW: 102078499
NEW: 102078599
NEW: 102078699
NEW: 102078799
NEW: 102078899
NEW: 102078999
NEW: 102079099
NEW: 102079199
NEW: 102079299
NEW: 102079399
NEW: 102079499
NEW: 102079599
NEW: 102079699
NEW: 102079799
NEW: 102079899
NEW: 102079999
NEW: 102080099
NEW: 102080199
NEW: 102080299
NEW: 102080399
NEW: 102080499
Ok.
Product Option Sync.
Opencart products: 247
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 = 27234
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27234,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102073099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2608
UPDATE oc_option_value_description
SET
name = '102073099 - Tela Daler Rowney Simply 30 x 40'
WHERE
option_value_id = 2608
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 333
AND product_id = 27234
AND option_id = 15
AND option_value_id = 2608
DELETE FROM oc_product
WHERE
model = '102073099'
INSERT INTO oc_product_option_value
SET
product_option_id = 333,
product_id = 27234,
option_id = 15,
option_value_id = 2608,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102073199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2609
UPDATE oc_option_value_description
SET
name = '102073199 - Tela Daler Rowney Simply 30 x 80'
WHERE
option_value_id = 2609
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 333
AND product_id = 27234
AND option_id = 15
AND option_value_id = 2609
DELETE FROM oc_product
WHERE
model = '102073199'
INSERT INTO oc_product_option_value
SET
product_option_id = 333,
product_id = 27234,
option_id = 15,
option_value_id = 2609,
quantity = 1,
subtract = 1,
price = 4.393,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.