Product Sync.
Opencart products: 179
Input products: 100
NEW: 100787899
NEW: 100787999
NEW: 100788099
NEW: 100788199
NEW: 100788299
NEW: 100788399
NEW: 100788499
NEW: 100788599
NEW: 100788699
NEW: 100788799
NEW: 100788899
NEW: 100788999
NEW: 100789099
NEW: 100789199
NEW: 100789299
UPDATING: Guache Giotto Lavável 500 ml
Product ID: 27050
Image file:
NEW: 100789499
NEW: 100789599
NEW: 100789699
NEW: 100789899
NEW: 100789999
NEW: 100790099
NEW: 100790199
NEW: 100790299
NEW: 100790399
NEW: 100790499
NEW: 100790599
NEW: 100790699
NEW: 100790799
NEW: 100790899
NEW: 100790999
NEW: 100791099
NEW: 100791199
NEW: 100791299
NEW: 100791399
NEW: 100791499
NEW: 100791599
NEW: 100791699
NEW: 100791799
NEW: 100791899
NEW: 100791999
NEW: 100792099
NEW: 100792199
NEW: 100792299
NEW: 100792399
NEW: 100792499
NEW: 100792599
NEW: 100792699
NEW: 100792799
NEW: 100792899
NEW: 100792999
NEW: 100793099
NEW: 100793199
NEW: 100793299
NEW: 100793399
NEW: 100793499
NEW: 100793599
NEW: 100793699
NEW: 100793799
NEW: 100793899
NEW: 100793999
NEW: 100794099
NEW: 100794199
NEW: 100794299
NEW: 100794399
NEW: 100794499
NEW: 100794599
NEW: 100794699
NEW: 100794799
NEW: 100794899
NEW: 100794999
NEW: 100795099
NEW: 100795199
NEW: 100795299
NEW: 100795399
NEW: 100795499
NEW: 100795599
NEW: 100795699
NEW: 100795799
NEW: 100795899
NEW: 100795999
NEW: 100796099
NEW: 100796199
NEW: 100796299
NEW: 100796399
NEW: 100796499
NEW: 100796599
NEW: 100796699
NEW: 100796799
NEW: 100796899
NEW: 100796999
NEW: 100797099
NEW: 100797199
NEW: 100797299
NEW: 100797399
NEW: 100797499
NEW: 100797599
NEW: 100797699
NEW: 100797799
Ok.
Product Option Sync.
Opencart products: 179
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 = 27050
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100789399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2381
UPDATE oc_option_value_description
SET
name = '100789399 - Guache Giotto 500 ml Lavável Preto'
WHERE
option_value_id = 2381
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2381
DELETE FROM oc_product
WHERE
model = '100789399'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2381
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100789799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2382
UPDATE oc_option_value_description
SET
name = '100789799 - Guache Giotto 500 ml Lavável Castanho'
WHERE
option_value_id = 2382
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2382
DELETE FROM oc_product
WHERE
model = '100789799'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2382
Ok.