Product Sync.
Opencart products: 84
Input products: 100
NEW: 100727299
NEW: 100727399
NEW: 100727499
NEW: 100727599
NEW: 100727699
NEW: 100727799
NEW: 100727899
NEW: 100727999
NEW: 100728099
NEW: 100728199
NEW: 100728299
NEW: 100728399
NEW: 100728499
NEW: 100728599
NEW: 100728699
NEW: 100728799
NEW: 100728899
NEW: 100728999
NEW: 100729099
NEW: 100729199
NEW: 100729299
NEW: 100729399
NEW: 100729499
NEW: 100729599
NEW: 100729699
NEW: 100729799
NEW: 100729899
NEW: 100729999
NEW: 100730099
NEW: 100730199
NEW: 100730299
NEW: 100730399
NEW: 100730499
NEW: 100730599
NEW: 100730699
NEW: 100730799
NEW: 100730899
NEW: 100730999
NEW: 100731099
NEW: 100731199
NEW: 100731299
NEW: 100731399
NEW: 100731499
NEW: 100731599
NEW: 100731699
NEW: 100731799
NEW: 100731899
NEW: 100731999
NEW: 100732099
NEW: 100732199
NEW: 100732299
NEW: 100732399
NEW: 100732499
NEW: 100732599
NEW: 100732699
NEW: 100732799
NEW: 100732899
NEW: 100732999
NEW: 100733099
NEW: 100733199
NEW: 100733299
NEW: 100733399
NEW: 100733499
NEW: 100733599
NEW: 100733699
NEW: 100733799
NEW: 100733899
NEW: 100733999
NEW: 100734099
NEW: 100734199
NEW: 100734299
NEW: 100734399
NEW: 100734499
NEW: 100734599
NEW: 100734699
NEW: 100734799
NEW: 100734899
NEW: 100734999
NEW: 100735099
NEW: 100735199
NEW: 100735299
NEW: 100735399
NEW: 100735499
NEW: 100735599
NEW: 100735799
NEW: 100735899
NEW: 100735999
NEW: 100736099
NEW: 100736199
NEW: 100736299
NEW: 100736399
NEW: Guache Giotto Lavável 500 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Guache Giotto Lavável 500 ml - %'
)
NEW: 100736699
NEW: 100736799
NEW: 100736899
NEW: 100736999
NEW: 100737099
NEW: 100737199
NEW: 100737299
Ok.
Product Option Sync.
Opencart products: 85
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 = 27482
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27482,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100736499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3450 AS option_value_id,
language_id,
17 AS option_id,
'100736499 - Guache Giotto 500 ml Lavável Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3450
DELETE FROM oc_product
WHERE
model = '100736499'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3450,
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 '100736599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3451 AS option_value_id,
language_id,
17 AS option_id,
'100736599 - Guache Giotto 500 ml Lavável Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 455
AND product_id = 27482
AND option_id = 17
AND option_value_id = 3451
DELETE FROM oc_product
WHERE
model = '100736599'
INSERT INTO oc_product_option_value
SET
product_option_id = 455,
product_id = 27482,
option_id = 17,
option_value_id = 3451,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.