Product Sync.
Opencart products: 179
Input products: 100
NEW: 100767799
NEW: 100767899
NEW: 100767999
UPDATING: Guache Giotto Lavável 500 ml
Product ID: 27050
Image file:
NEW: 100768199
NEW: 100768299
NEW: 100768399
NEW: 100768499
NEW: 100768599
NEW: 100768699
NEW: 100768799
NEW: 100768899
NEW: 100768999
NEW: 100769099
NEW: 100769199
NEW: 100769299
NEW: 100769399
NEW: 100769499
NEW: 100769599
NEW: 100769699
NEW: 100769799
NEW: 100769899
NEW: 100769999
NEW: 100770099
NEW: 100770199
NEW: 100770299
NEW: 100770399
NEW: 100770499
NEW: 100770599
NEW: 100770699
NEW: 100770799
NEW: 100770899
NEW: 100770999
NEW: 100771099
NEW: 100771199
NEW: 100771209
NEW: 100771299
NEW: 100771399
NEW: 100771499
NEW: 100771599
NEW: 100771699
NEW: 100771799
NEW: 100771899
NEW: 100771999
NEW: 100772099
NEW: 100772199
NEW: 100772299
NEW: 100772399
NEW: 100772499
NEW: 100772599
NEW: 100772699
NEW: 100772799
NEW: 100772899
NEW: 100772999
NEW: 100773099
NEW: 100773199
NEW: 100773299
NEW: 100773699
NEW: 100773799
NEW: 100773899
NEW: 100773999
NEW: 100774099
NEW: 100774199
NEW: 100774299
NEW: 100774399
NEW: 100774499
NEW: 100774599
NEW: 100774699
NEW: 100774799
NEW: 100774899
NEW: 100774999
NEW: 100775099
NEW: 100775199
NEW: 100775299
NEW: 100775399
NEW: 100775499
NEW: 100775599
NEW: 100775699
NEW: 100775799
NEW: 100775899
NEW: 100775999
NEW: 100776099
NEW: 100776199
NEW: 100776299
NEW: 100776399
NEW: 100776499
NEW: 100776599
NEW: 100776699
NEW: 100776799
NEW: 100776899
NEW: 100776999
NEW: 100777099
NEW: 100777199
NEW: 100777299
NEW: 100777399
NEW: 100777499
NEW: 100777599
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 '100768099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2369
UPDATE oc_option_value_description
SET
name = '100768099 - Guache Giotto 500 ml Lavável Laranja'
WHERE
option_value_id = 2369
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 = 2369
DELETE FROM oc_product
WHERE
model = '100768099'
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 = 2369
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100773399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2370
UPDATE oc_option_value_description
SET
name = '100773399 - Guache Giotto 500 ml Lavável Rosa'
WHERE
option_value_id = 2370
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 = 2370
DELETE FROM oc_product
WHERE
model = '100773399'
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 = 2370
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100773499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2371
UPDATE oc_option_value_description
SET
name = '100773499 - Guache Giotto 500 ml Lavável Vermelhão'
WHERE
option_value_id = 2371
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 = 2371
DELETE FROM oc_product
WHERE
model = '100773499'
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 = 2371
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100773599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2372
UPDATE oc_option_value_description
SET
name = '100773599 - Guache Giotto 500 ml Lavável Vermelho Escarlate'
WHERE
option_value_id = 2372
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 = 2372
DELETE FROM oc_product
WHERE
model = '100773599'
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 = 2372
Ok.