Product Sync.
Opencart products: 271
Input products: 100
NEW: 102222099
NEW: 102222199
NEW: 102222299
NEW: 102222399
NEW: 102222499
NEW: 102222599
NEW: 102222699
NEW: 102222799
NEW: 102222899
NEW: 102222999
NEW: 102223099
NEW: 102223199
NEW: 102223299
NEW: 102223399
NEW: 102223499
NEW: 102223599
NEW: 102223699
NEW: 102223799
NEW: 102223899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102223899 - %'
)
NEW: 102223999
NEW: 102224099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102224099 - %'
)
NEW: 102224199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102224199 - %'
)
NEW: 102224299
NEW: 102224399
NEW: 102224499
NEW: 102224599
NEW: 102224699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102224699 - %'
)
NEW: 102224799
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102224799 - %'
)
NEW: 102224899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102224899 - %'
)
NEW: 102224999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102224999 - %'
)
NEW: 102225099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102225099 - %'
)
NEW: 102225199
NEW: 102225299
NEW: 102225399
NEW: 102225499
NEW: 102225599
NEW: 102225699
NEW: Cavalete Mabef Campo Basico
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Mabef Campo Basico - %'
)
NEW: 102225899
NEW: 102225999
NEW: 102226099
NEW: 102226199
NEW: 102226299
NEW: 102226399
NEW: 102226499
NEW: 102226599
NEW: 102226699
NEW: 102226799
NEW: 102226899
NEW: 102226999
NEW: 102227099
NEW: 102227199
NEW: 102227299
NEW: 102227399
NEW: 102227499
NEW: 102227599
NEW: 102227699
NEW: 102227799
NEW: 102227899
NEW: 102227999
NEW: 102228099
NEW: 102228199
NEW: 102228299
NEW: 102228399
NEW: 102228499
NEW: 102228599
NEW: 102228699
NEW: 102228799
NEW: 102228899
NEW: 102228999
NEW: 102229099
NEW: 102229199
NEW: 102229299
NEW: 102229399
NEW: 102229499
NEW: 102229599
NEW: 102229699
NEW: 102229799
NEW: 102229899
NEW: 102229999
NEW: 102230099
NEW: 102230199
NEW: 102230299
NEW: 102230399
NEW: 102230499
NEW: 102230599
NEW: 102230699
NEW: 102230799
NEW: 102230899
NEW: 102230999
NEW: 102231099
NEW: 102231199
NEW: 102231299
NEW: 102231399
NEW: 102231499
NEW: 102231599
NEW: 102231699
NEW: 102231799
NEW: 102231899
NEW: 102231999
Ok.
Product Option Sync.
Opencart products: 280
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 = 27268
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27268,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102225799 - %'
UPDATE oc_option_value
SET
image = 'catalog/102225799.jpg'
WHERE
option_value_id = 1610
UPDATE oc_option_value_description
SET
name = '102225799 - Cavalete Mabef Campo Basico'
WHERE
option_value_id = 1610
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 338
AND product_id = 27268
AND option_id = 15
AND option_value_id = 1610
DELETE FROM oc_product
WHERE
model = '102225799'
INSERT INTO oc_product_option_value
SET
product_option_id = 338,
product_id = 27268,
option_id = 15,
option_value_id = 1610,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.