Product Sync.
Opencart products: 202
Input products: 100
NEW: 101403999
NEW: 101404099
NEW: 101404199
NEW: 101404299
NEW: 101404399
NEW: 101404499
NEW: 101404599
NEW: 101404699
NEW: 101404799
NEW: 101404899
NEW: 101404999
NEW: 101405099
NEW: 101405199
NEW: 101405299
NEW: 101405399
NEW: 101405499
NEW: 101405599
NEW: 101405699
NEW: 101405799
NEW: 101405899
NEW: 101405999
NEW: 101406099
NEW: 101406199
NEW: 101406299
NEW: 101406399
NEW: 101406499
NEW: 101406599
NEW: 101406699
NEW: 101406799
NEW: 101406899
NEW: 101406999
NEW: 101407099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101407099 - %'
)
NEW: Cavalete Estudio Luxo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Estudio Luxo - %'
)
NEW: 101407299
NEW: Cavalete Trident Mini de Mesa 12016
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Trident Mini de Mesa 12016 - %'
)
NEW: 101407499
NEW: 101407599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101407599 - %'
)
NEW: 101407699
NEW: 101407799
NEW: 101407899
NEW: 101407999
NEW: 101408099
NEW: 101408199
NEW: 101408299
NEW: 101408399
NEW: 101408499
NEW: 101408599
NEW: 101408699
NEW: 101408799
NEW: 101408899
NEW: 101408999
NEW: 101409099
NEW: 101409199
NEW: 101409299
NEW: 101409399
NEW: 101409499
NEW: 101409599
NEW: 101409699
NEW: 101409799
NEW: 101409899
NEW: 101409999
NEW: 101410099
NEW: 101410199
NEW: 101410299
NEW: 101410399
NEW: 101410499
NEW: 101410599
NEW: 101410699
NEW: 101410799
NEW: 101410899
NEW: 101410999
NEW: 101411099
NEW: 101411199
NEW: 101411299
NEW: 101411399
NEW: 101411499
NEW: 101411599
NEW: 101411699
NEW: 101411799
NEW: 101411899
NEW: 101411999
NEW: 101412099
NEW: 101412199
NEW: 101412299
NEW: 101412399
NEW: 101412499
NEW: 101412599
NEW: 101412699
NEW: 101412799
NEW: 101412899
NEW: 101412999
NEW: 101413099
NEW: 101413199
NEW: 101413299
NEW: 101413399
NEW: 101413499
NEW: 101413599
NEW: 101413699
NEW: 101413799
NEW: 101413899
Ok.
Product Option Sync.
Opencart products: 206
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 = 27192
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27192,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101407199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1606
UPDATE oc_option_value_description
SET
name = '101407199 - Cavalete Estudio Luxo'
WHERE
option_value_id = 1606
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 317
AND product_id = 27192
AND option_id = 15
AND option_value_id = 1606
DELETE FROM oc_product
WHERE
model = '101407199'
INSERT INTO oc_product_option_value
SET
product_option_id = 317,
product_id = 27192,
option_id = 15,
option_value_id = 1606,
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 = 27193
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27193,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101407399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1608
UPDATE oc_option_value_description
SET
name = '101407399 - Cavalete Trident Mini de Mesa 12016'
WHERE
option_value_id = 1608
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 318
AND product_id = 27193
AND option_id = 15
AND option_value_id = 1608
DELETE FROM oc_product
WHERE
model = '101407399'
INSERT INTO oc_product_option_value
SET
product_option_id = 318,
product_id = 27193,
option_id = 15,
option_value_id = 1608,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.