Product Sync.
Opencart products: 129
Input products: 100
NEW: 101797799
NEW: 101797899
NEW: 101797999
NEW: 101798099
NEW: 101798199
NEW: 101798299
NEW: 101798399
NEW: 101798499
NEW: 101798599
NEW: 101798699
NEW: 101798799
NEW: 101798899
NEW: 101798999
NEW: 101799099
NEW: 101799199
NEW: 101799299
NEW: 101799399
NEW: 101799499
NEW: 101799599
NEW: 101799699
NEW: 101799799
NEW: 101799899
NEW: 101799999
NEW: 101800099
NEW: 101800199
NEW: 101800299
NEW: 101800399
NEW: 101800499
NEW: 101800599
NEW: 101800699
NEW: 101800799
NEW: 101800899
NEW: 101800999
NEW: 101801099
NEW: 101801199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101801199 - %'
)
NEW: 101801299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101801299 - %'
)
NEW: 101801399
NEW: 101801499
NEW: 101801599
NEW: 101801699
NEW: 101801799
NEW: 101801899
NEW: 101801999
NEW: 101802099
NEW: 101802199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101802199 - %'
)
NEW: 101802299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101802299 - %'
)
NEW: 101802399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101802399 - %'
)
NEW: 101802499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101802499 - %'
)
NEW: 101802599
NEW: 101802699
NEW: 101802799
NEW: 101802899
NEW: Bloco para Acrílico Daler Rowney
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco para Acrílico Daler Rowney - %'
)
NEW: 101803299
NEW: 101803399
NEW: 101803499
NEW: 101803599
NEW: 101803699
NEW: 101803799
NEW: 101803899
NEW: 101803999
NEW: 101804099
NEW: 101804199
NEW: 101804299
NEW: 101804399
NEW: 101804499
NEW: 101804599
NEW: 101804699
NEW: 101804799
NEW: 101804899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101804899 - %'
)
NEW: 101804999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101804999 - %'
)
NEW: 101805099
NEW: 101805199
NEW: 101805299
NEW: 101805399
NEW: 101805499
NEW: 101805599
NEW: 101805699
NEW: 101805799
NEW: 101805899
NEW: 101805999
NEW: 101806099
NEW: 101806199
NEW: 101806299
NEW: 101806399
NEW: 101806499
NEW: 101806599
NEW: 101806699
NEW: 101806799
NEW: 101806899
NEW: 101806999
NEW: 101807099
NEW: 101807199
NEW: 101807299
NEW: 101807399
NEW: 101807499
NEW: 101807599
NEW: 101807699
Ok.
Product Option Sync.
Opencart products: 138
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 = 27533
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27533,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101802999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3572 AS option_value_id,
language_id,
17 AS option_id,
'101802999 - Bloco para Acrílico Daler Rowney A5' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 482
AND product_id = 27533
AND option_id = 17
AND option_value_id = 3572
DELETE FROM oc_product
WHERE
model = '101802999'
INSERT INTO oc_product_option_value
SET
product_option_id = 482,
product_id = 27533,
option_id = 17,
option_value_id = 3572,
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 '101803099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3573 AS option_value_id,
language_id,
17 AS option_id,
'101803099 - Bloco para Acrílico Daler Rowney A4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 482
AND product_id = 27533
AND option_id = 17
AND option_value_id = 3573
DELETE FROM oc_product
WHERE
model = '101803099'
INSERT INTO oc_product_option_value
SET
product_option_id = 482,
product_id = 27533,
option_id = 17,
option_value_id = 3573,
quantity = 1,
subtract = 1,
price = 3.577,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101803199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3574 AS option_value_id,
language_id,
17 AS option_id,
'101803199 - Bloco para Acrílico Daler Rowney A3' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 482
AND product_id = 27533
AND option_id = 17
AND option_value_id = 3574
DELETE FROM oc_product
WHERE
model = '101803199'
INSERT INTO oc_product_option_value
SET
product_option_id = 482,
product_id = 27533,
option_id = 17,
option_value_id = 3574,
quantity = 1,
subtract = 1,
price = 11.788,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.