Product Sync.
Opencart products: 213
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
UPDATING: Bloco para Acrílico Daler Rowney
Product ID: 27076
Image file:
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: 221
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 = 27076
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101802999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2503
UPDATE oc_option_value_description
SET
name = '101802999 - Bloco para Acrílico Daler Rowney A5'
WHERE
option_value_id = 2503
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 137
AND product_id = 27076
AND option_id = 15
AND option_value_id = 2503
DELETE FROM oc_product
WHERE
model = '101802999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 137
AND product_id = 27076
AND option_id = 15
AND option_value_id = 2503
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101803099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2504
UPDATE oc_option_value_description
SET
name = '101803099 - Bloco para Acrílico Daler Rowney A4'
WHERE
option_value_id = 2504
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 137
AND product_id = 27076
AND option_id = 15
AND option_value_id = 2504
DELETE FROM oc_product
WHERE
model = '101803099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 3.577,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 137
AND product_id = 27076
AND option_id = 15
AND option_value_id = 2504
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101803199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2505
UPDATE oc_option_value_description
SET
name = '101803199 - Bloco para Acrílico Daler Rowney A3'
WHERE
option_value_id = 2505
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 137
AND product_id = 27076
AND option_id = 15
AND option_value_id = 2505
DELETE FROM oc_product
WHERE
model = '101803199'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 11.788,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 137
AND product_id = 27076
AND option_id = 15
AND option_value_id = 2505
Ok.