Product Sync.
Opencart products: 18
Input products: 100
NEW: 100293099
NEW: 100293199
NEW: 100293299
NEW: 100293399
NEW: 100293499
NEW: 100293599
NEW: 100293699
NEW: 100293799
NEW: 100293899
NEW: 100293999
NEW: 100294099
UPDATING: Giotto 500ml
Product ID: 27389
Image file: Giotto 500ml.jpg
NEW: 100294299
NEW: 100294399
NEW: 100294499
NEW: 100294599
NEW: 100294699
NEW: 100294799
NEW: 100294899
NEW: 100294999
NEW: 100295099
NEW: 100295199
NEW: 100295299
NEW: 100295399
NEW: 100295499
NEW: 100295599
NEW: 100295699
NEW: 100295799
NEW: Pelikan 10ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pelikan 10ml - %'
)
NEW: 100296099
NEW: 100296199
NEW: 100296299
NEW: 100296399
NEW: 100296499
NEW: 100296599
NEW: 100296699
NEW: 100296799
NEW: 100296899
NEW: 100296999
NEW: 100297099
NEW: 100297199
NEW: 100297299
NEW: 100297399
NEW: 100297499
NEW: 100297599
NEW: 100297699
NEW: 100297799
NEW: 100297899
NEW: 100297999
NEW: 100298099
NEW: 100298199
NEW: 100298299
NEW: 100298399
NEW: 100298499
NEW: 100298599
NEW: 100298699
NEW: 100298799
NEW: 100298899
NEW: 100298999
NEW: 100299099
NEW: 100299199
NEW: 100299299
NEW: 100299399
NEW: 100299499
NEW: 100299599
NEW: 100299699
NEW: 100299799
NEW: 100299899
NEW: 100299999
NEW: 100300099
NEW: 100300199
NEW: 100300299
NEW: 100300399
NEW: 100300499
NEW: 100300599
NEW: 100300699
NEW: 100300799
NEW: 100300899
NEW: 100300999
NEW: 100301099
NEW: 100301199
NEW: 100301299
NEW: 100301399
NEW: 100301499
NEW: 100301599
NEW: 100301699
NEW: 100301799
NEW: 100301899
NEW: 100301999
NEW: 100302099
NEW: 100302199
NEW: 100302299
NEW: 100302399
NEW: 100302499
NEW: 100302599
NEW: 100302699
NEW: 100302799
NEW: 100302899
NEW: 100302999
Ok.
Product Option Sync.
Opencart products: 19
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 = 27389
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100294199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1739
UPDATE oc_option_value_description
SET
name = '100294199 - GUACHE GIOT REF 532806 ROSA 500 ML'
WHERE
option_value_id = 1739
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 382
AND product_id = 27389
AND option_id = 17
AND option_value_id = 1739
DELETE FROM oc_product
WHERE
model = '100294199'
INSERT INTO oc_product_option_value
SET
product_option_id = 382,
product_id = 27389,
option_id = 17,
option_value_id = 1739,
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 = 27390
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27390,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100295899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1740
UPDATE oc_option_value_description
SET
name = '100295899 - GUACHE PELIKAN 10ML 740/3 PRT'
WHERE
option_value_id = 1740
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1740
DELETE FROM oc_product
WHERE
model = '100295899'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1740,
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 '100295999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1741
UPDATE oc_option_value_description
SET
name = '100295999 - GUACHE PELIKAN 10ML 740/4 AZL ULTRAM'
WHERE
option_value_id = 1741
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 383
AND product_id = 27390
AND option_id = 17
AND option_value_id = 1741
DELETE FROM oc_product
WHERE
model = '100295999'
INSERT INTO oc_product_option_value
SET
product_option_id = 383,
product_id = 27390,
option_id = 17,
option_value_id = 1741,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.