Product Sync.
Opencart products: 158
Input products: 100
NEW: 100333499
NEW: 100333599
NEW: 100333699
NEW: 100333799
NEW: 100333899
NEW: 100333999
NEW: 100334099
NEW: 100334199
NEW: 100334299
NEW: 100334399
NEW: 100334499
NEW: 100334599
NEW: 100334699
NEW: 100334799
NEW: 100334899
NEW: 100334999
NEW: 100335099
NEW: 100335199
NEW: 100335299
NEW: 100335399
NEW: 100335499
NEW: 100335599
NEW: 100335699
NEW: 100335799
NEW: 100335899
NEW: 100335999
NEW: 100336099
NEW: 100336199
NEW: 100336299
NEW: 100336399
NEW: 100336499
NEW: 100336599
NEW: 100336699
NEW: 100336799
NEW: 100336899
NEW: 100336999
NEW: 100337099
NEW: 100337199
NEW: 100337299
NEW: 100337399
NEW: 100337499
NEW: 100337599
NEW: 100337699
NEW: 100337799
NEW: 100337899
NEW: 100337999
NEW: 100338099
NEW: 100338199
NEW: 100338299
NEW: 100338399
NEW: 100338499
NEW: 100338599
NEW: 100338699
NEW: 100338799
NEW: 100338899
NEW: 100338999
NEW: 100339099
NEW: 100339199
NEW: 100339299
NEW: 100339399
NEW: 100339499
NEW: 100339599
NEW: 100339699
NEW: 100339799
UPDATING: Pincel Escolar Giotto
Product ID: 27025
Image file:
NEW: 100339999
NEW: 100340099
NEW: 100340199
NEW: 100340299
NEW: 100340399
NEW: 100340499
NEW: 100340599
NEW: 100340699
NEW: 100340799
NEW: 100340899
NEW: 100340999
NEW: 100341099
NEW: 100341199
NEW: 100341299
NEW: 100341399
NEW: 100341499
NEW: 100341599
NEW: 100341699
NEW: 100341799
NEW: 100341899
UPDATING: Guache Pelikan
Product ID: 27022
Image file:
NEW: 100342099
NEW: 100342199
NEW: 100342299
NEW: 100342399
NEW: 100342499
NEW: 100342599
NEW: 100342699
NEW: 100342799
NEW: 100342899
NEW: 100342999
NEW: 100343099
NEW: 100343199
NEW: 100343299
NEW: 100343399
Ok.
Product Option Sync.
Opencart products: 158
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 = 27025
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100339899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2182
UPDATE oc_option_value_description
SET
name = '100339899 - Pincel Cerda Giotto'
WHERE
option_value_id = 2182
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 93
AND product_id = 27025
AND option_id = 15
AND option_value_id = 2182
DELETE FROM oc_product
WHERE
model = '100339899'
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 = 93
AND product_id = 27025
AND option_id = 15
AND option_value_id = 2182
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27022
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100341999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1752
UPDATE oc_option_value_description
SET
name = '100341999 - Guache Pelikan 10 ml Verde'
WHERE
option_value_id = 1752
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1752
DELETE FROM oc_product
WHERE
model = '100341999'
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 = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1752
Ok.