Product Sync.
Opencart products: 226
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: 27013
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: 227
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 = 27013
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101853599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2512
UPDATE oc_option_value_description
SET
name = '101853599 - Guache Giotto 1000 ml Verde Prado'
WHERE
option_value_id = 2512
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2512
DELETE FROM oc_product
WHERE
model = '101853599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2512
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101853699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2513
UPDATE oc_option_value_description
SET
name = '101853699 - Guache Giotto 1000 ml Rosa'
WHERE
option_value_id = 2513
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2513
DELETE FROM oc_product
WHERE
model = '101853699'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 82
AND product_id = 27013
AND option_id = 15
AND option_value_id = 2513
Ok.