Product Sync.
Opencart products: 168
Input products: 100
NEW: 102211999
NEW: 102212099
NEW: 102212199
NEW: 102212299
NEW: 102212399
NEW: 102212499
NEW: 102212599
NEW: 102212699
NEW: 102212799
NEW: 102212899
NEW: 102212999
NEW: 102213099
NEW: 102213199
NEW: 102213299
NEW: 102213399
NEW: 102213499
NEW: 102213599
NEW: 102213699
NEW: 102213799
NEW: 102213899
NEW: 102213999
NEW: 102214099
NEW: 102214199
NEW: 102214299
NEW: 102214399
NEW: 102214499
NEW: 102214599
NEW: 102214699
NEW: 102214799
NEW: 102214899
NEW: 102214999
NEW: 102215099
NEW: 102215199
NEW: 102215299
NEW: 102215399
NEW: 102215499
NEW: 102215599
NEW: 102215699
NEW: 102215799
NEW: 102215899
NEW: 102215999
NEW: 102216099
NEW: 102216199
NEW: 102216299
NEW: 102216399
NEW: 102216499
NEW: 102216599
NEW: 102216699
NEW: 102216799
NEW: 102216899
NEW: 102216999
NEW: 102217099
NEW: 102217199
NEW: 102217299
NEW: 102217399
NEW: 102217499
NEW: 102217599
NEW: 102217699
NEW: 102217799
NEW: 102217899
NEW: 102217999
NEW: 102218099
NEW: 102218199
NEW: 102218299
NEW: 102218399
NEW: 102218499
NEW: 102218599
NEW: 102218699
NEW: 102218799
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102218799 - %'
)
NEW: 102218899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102218899 - %'
)
NEW: 102218999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102218999 - %'
)
NEW: 102219099
NEW: 102219199
NEW: 102219299
NEW: 102219399
NEW: 102219499
NEW: 102219599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102219599 - %'
)
NEW: 102219699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102219699 - %'
)
NEW: 102219799
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102219799 - %'
)
NEW: 102219899
NEW: 102219999
NEW: 102220099
NEW: 102220199
NEW: 102220299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220299 - %'
)
NEW: 102220399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220399 - %'
)
NEW: Cavalete Combi Mesa Caixa Acrilíco Daler Rowney Graduate e Acessórios
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Combi Mesa Caixa Acrilíco Daler Rowney Graduate e Acessórios - %'
)
NEW: 102220599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220599 - %'
)
NEW: 102220699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220699 - %'
)
NEW: 102220799
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220799 - %'
)
NEW: 102220899
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220899 - %'
)
NEW: 102220999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102220999 - %'
)
NEW: 102221099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102221099 - %'
)
NEW: 102221199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102221199 - %'
)
NEW: 102221299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102221299 - %'
)
NEW: 102221399
NEW: 102221499
NEW: 102221599
NEW: 102221699
NEW: 102221799
NEW: Médio para Acrílico Winsor & Newton
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Médio para Acrílico Winsor & Newton - %'
)
Ok.
Product Option Sync.
Opencart products: 186
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 =
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102220499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1909
UPDATE oc_option_value_description
SET
name = '102220499 - Cavalete Combi Mesa Caixa Acrilíco Daler Rowney Graduate e Acessórios'
WHERE
option_value_id = 1909
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 17
AND option_value_id = 1909
DELETE FROM oc_product
WHERE
model = '102220499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 17,
option_value_id = 1909,
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 = 27583
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27583,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102221899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/102221899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3686 AS option_value_id,
language_id,
17 AS option_id,
'102221899 - Set Médios Winsor & Newton Acrílico 30 ml com 4 Unidades' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 499
AND product_id = 27583
AND option_id = 17
AND option_value_id = 3686
DELETE FROM oc_product
WHERE
model = '102221899'
INSERT INTO oc_product_option_value
SET
product_option_id = 499,
product_id = 27583,
option_id = 17,
option_value_id = 3686,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.