Product Sync.
Opencart products: 16
Input products: 100
NEW: 100212199
NEW: 100212299
NEW: 100212399
NEW: 100212499
NEW: 100212599
NEW: 100212699
NEW: 100212799
NEW: 100212899
NEW: 100212999
NEW: 100213099
NEW: 100213199
NEW: 100213299
NEW: 100213399
NEW: 100213499
NEW: 100213599
NEW: 100213699
NEW: 100213799
NEW: 100213899
NEW: 100213999
NEW: 100214099
NEW: 100214199
NEW: 100214299
NEW: 100214399
NEW: 100214499
NEW: 100214599
NEW: 100214699
NEW: 100214799
NEW: 100214899
NEW: 100214999
NEW: 100215099
NEW: 100215199
NEW: 100215299
NEW: 100215399
NEW: 100215499
NEW: 100215599
NEW: 100215699
NEW: 100215799
NEW: 100215899
NEW: 100215999
NEW: Giotto 7,5 e 10ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Giotto 7,5 e 10ml - %'
)
NEW: 100216199
NEW: 100216299
NEW: 100216399
NEW: 100216499
NEW: 100216599
NEW: 100216699
NEW: 100216799
NEW: 100216899
NEW: 100216999
NEW: 100217099
NEW: 100217199
NEW: 100217299
NEW: 100217399
NEW: 100217499
NEW: 100217599
NEW: 100217699
NEW: 100217799
NEW: 100217899
NEW: 100217999
NEW: 100218099
NEW: 100218199
NEW: 100218299
NEW: 100218399
NEW: 100218499
NEW: 100218599
NEW: 100218699
NEW: 100218799
NEW: 100218899
NEW: 100218999
NEW: 100219099
NEW: 100219199
NEW: 100219299
NEW: 100219399
UPDATING: Giotto 250ml
Product ID: 27384
Image file: Giotto 250ml.jpg
NEW: 100219699
NEW: 100219899
NEW: 100219999
NEW: 100220099
NEW: 100220199
NEW: 100220299
NEW: 100220399
NEW: 100220499
NEW: 100220599
NEW: 100220699
NEW: 100220799
NEW: 100220899
NEW: 100220999
NEW: 100221099
NEW: 100221199
NEW: 100221299
NEW: 100221399
NEW: 100221499
NEW: 100221599
NEW: 100221699
NEW: 100221799
NEW: 100221899
NEW: 100221999
NEW: 100222099
Ok.
Product Option Sync.
Opencart products: 17
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 = 27388
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27388,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100216099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1734
UPDATE oc_option_value_description
SET
name = '100216099 - GUACHE GIOTTO CX/6 CORES REF303600'
WHERE
option_value_id = 1734
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 381
AND product_id = 27388
AND option_id = 17
AND option_value_id = 1734
DELETE FROM oc_product
WHERE
model = '100216099'
INSERT INTO oc_product_option_value
SET
product_option_id = 381,
product_id = 27388,
option_id = 17,
option_value_id = 1734,
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 = 27384
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100219499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1735
UPDATE oc_option_value_description
SET
name = '100219499 - GUACHE ACRILICA GIOT 250 ML REF 533900 PRATA'
WHERE
option_value_id = 1735
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1735
DELETE FROM oc_product
WHERE
model = '100219499'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1735,
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 '100219599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1736
UPDATE oc_option_value_description
SET
name = '100219599 - GUACHE ACRILICA GIOT 250 ML REF 533900 MAG'
WHERE
option_value_id = 1736
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1736
DELETE FROM oc_product
WHERE
model = '100219599'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1736,
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 '100219799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1737
UPDATE oc_option_value_description
SET
name = '100219799 - GUACHE ACRILICA GIOT 250 ML REF 533800 OURO'
WHERE
option_value_id = 1737
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 377
AND product_id = 27384
AND option_id = 17
AND option_value_id = 1737
DELETE FROM oc_product
WHERE
model = '100219799'
INSERT INTO oc_product_option_value
SET
product_option_id = 377,
product_id = 27384,
option_id = 17,
option_value_id = 1737,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.