Product Sync.
Opencart products: 143
Input products: 100
NEW: 101848299
NEW: 101848399
NEW: 101848499
NEW: 101848599
NEW: 101848699
NEW: 101848799
NEW: 101848899
NEW: 101848999
NEW: 101849099
NEW: 101849199
NEW: 101849299
NEW: 101849399
NEW: 101849499
NEW: 101849599
NEW: 101849699
NEW: 101849799
NEW: 101849899
NEW: 101849999
NEW: 101850099
NEW: 101850199
NEW: 101850299
NEW: 101850399
NEW: 101850499
NEW: 101850599
NEW: 101850699
NEW: 101850799
NEW: 101850899
NEW: 101850999
NEW: 101851099
NEW: 101851199
NEW: 101851299
NEW: 101851399
NEW: 101851499
NEW: 101851599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101851599 - %'
)
NEW: 101851699
NEW: 101851799
NEW: 101851899
NEW: 101851999
NEW: 101852099
NEW: 101852199
NEW: 101852299
NEW: 101852399
NEW: 101852499
NEW: 101852599
NEW: 101852699
NEW: 101852799
NEW: 101852899
NEW: 101852999
NEW: 101853099
NEW: 101853199
NEW: 101853299
NEW: 101853399
NEW: 101853499
UPDATING: Guache Giotto 1000 ml
Product ID: 27437
Image file:
NEW: 101853799
NEW: 101853899
NEW: 101853999
NEW: 101854099
NEW: 101854199
NEW: 101854299
NEW: 101854399
NEW: 101854499
NEW: 101854599
NEW: 101854699
NEW: 101854799
NEW: 101854899
NEW: 101854999
NEW: 101855099
NEW: 101855199
NEW: 101855299
NEW: 101855399
NEW: 101855499
NEW: 101855599
NEW: 101855699
NEW: 101855799
NEW: 101855899
NEW: 101855999
NEW: 101856099
NEW: 101856199
NEW: 101856299
NEW: 101856399
NEW: 101856499
NEW: 101856599
NEW: 101856699
NEW: 101856799
NEW: 101856899
NEW: 101856999
NEW: 101857099
NEW: 101857199
NEW: 101857299
NEW: 101857399
NEW: 101857499
NEW: 101857599
NEW: 101857699
NEW: 101857799
NEW: 101857899
NEW: 101857999
NEW: 101858099
NEW: 101858199
Ok.
Product Option Sync.
Opencart products: 144
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 = 27437
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101853599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3576 AS option_value_id,
language_id,
17 AS option_id,
'101853599 - Guache Giotto 1000 ml Verde Prado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3576
DELETE FROM oc_product
WHERE
model = '101853599'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3576,
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 '101853699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3577 AS option_value_id,
language_id,
17 AS option_id,
'101853699 - Guache Giotto 1000 ml Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 418
AND product_id = 27437
AND option_id = 17
AND option_value_id = 3577
DELETE FROM oc_product
WHERE
model = '101853699'
INSERT INTO oc_product_option_value
SET
product_option_id = 418,
product_id = 27437,
option_id = 17,
option_value_id = 3577,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.