Product Sync.
Opencart products: 73
Input products: 100
NEW: 100606099
NEW: 100606199
NEW: 100606299
NEW: 100606399
NEW: 100606499
NEW: 100606599
NEW: 100606699
NEW: 100606799
NEW: 100606899
NEW: 100606999
NEW: 100607099
NEW: 100607199
NEW: 100607299
NEW: 100607399
NEW: 100607499
NEW: 100607599
NEW: 100607699
NEW: 100607799
NEW: 100607899
NEW: 100607999
NEW: 100608099
NEW: 100608199
NEW: 100608299
NEW: 100608399
NEW: 100608499
NEW: 100608599
NEW: 100608699
NEW: 100608799
NEW: 100608899
NEW: 100608999
NEW: 100609099
NEW: 100609199
NEW: 100609299
NEW: 100609399
NEW: 100609499
NEW: 100609599
NEW: 100609699
NEW: 100609799
NEW: 100609899
NEW: 100609999
NEW: 100610099
NEW: 100610199
NEW: 100610299
NEW: 100610399
NEW: 100610499
NEW: 100610599
NEW: 100610699
NEW: 100610799
NEW: 100610899
NEW: 100610999
NEW: 100611099
NEW: 100611199
NEW: 100611299
NEW: 100611399
NEW: 100611499
NEW: 100611599
NEW: 100611699
NEW: 100611799
NEW: 100611899
NEW: 100611999
NEW: 100612099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100612099 - %'
)
NEW: 100612199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100612199 - %'
)
NEW: 100612299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100612299 - %'
)
NEW: 100612399
NEW: 100612499
NEW: Cavalete Mesa Art Creation Mira
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Mesa Art Creation Mira - %'
)
NEW: 100612699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100612699 - %'
)
NEW: 100612799
NEW: 100612899
NEW: 100612999
NEW: 100613099
NEW: 100613199
NEW: 100613299
NEW: 100613399
NEW: 100613499
NEW: 100613599
NEW: 100613699
NEW: 100613799
NEW: 100613899
NEW: Cavalete Tripé Lyra
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Tripé Lyra - %'
)
NEW: Cavalete Base Quadrada com Gaveta
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Base Quadrada com Gaveta - %'
)
NEW: 100614199
NEW: 100614299
NEW: 100614399
NEW: 100614499
NEW: 100614599
NEW: 100614699
NEW: 100614799
NEW: 100614899
NEW: 100614999
NEW: 100615099
NEW: 100615199
NEW: 100615299
NEW: 100615399
NEW: 100615499
NEW: 100615599
NEW: 100615699
NEW: 100615799
NEW: 100615899
NEW: 100615999
Ok.
Product Option Sync.
Opencart products: 80
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 = 27474
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27474,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100612599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1445
UPDATE oc_option_value_description
SET
name = '100612599 - Cavalete Mesa Art Creation Mira'
WHERE
option_value_id = 1445
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 448
AND product_id = 27474
AND option_id = 17
AND option_value_id = 1445
DELETE FROM oc_product
WHERE
model = '100612599'
INSERT INTO oc_product_option_value
SET
product_option_id = 448,
product_id = 27474,
option_id = 17,
option_value_id = 1445,
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 = 27476
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27476,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100613999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1446
UPDATE oc_option_value_description
SET
name = '100613999 - Cavalete Tripé Lyra'
WHERE
option_value_id = 1446
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 449
AND product_id = 27476
AND option_id = 17
AND option_value_id = 1446
DELETE FROM oc_product
WHERE
model = '100613999'
INSERT INTO oc_product_option_value
SET
product_option_id = 449,
product_id = 27476,
option_id = 17,
option_value_id = 1446,
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 = 27477
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27477,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100614099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1447
UPDATE oc_option_value_description
SET
name = '100614099 - Cavalete Base Quadrada com Gaveta'
WHERE
option_value_id = 1447
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 450
AND product_id = 27477
AND option_id = 17
AND option_value_id = 1447
DELETE FROM oc_product
WHERE
model = '100614099'
INSERT INTO oc_product_option_value
SET
product_option_id = 450,
product_id = 27477,
option_id = 17,
option_value_id = 1447,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.