Product Sync.
Opencart products: 30
Input products: 100
NEW: 101833699
NEW: 101833799
NEW: 101833899
NEW: 101833999
NEW: 101834099
NEW: 101834199
NEW: 101834299
NEW: 101834399
NEW: 101834499
NEW: 101834599
NEW: 101834699
NEW: 101834799
NEW: 101834899
NEW: 101834999
NEW: 101835099
NEW: 101835199
NEW: 101835299
NEW: 101835399
NEW: 101835499
NEW: 101835599
NEW: 101835699
NEW: 101835799
NEW: 101835899
NEW: 101835999
NEW: 101836099
NEW: 101836199
NEW: 101836299
NEW: 101836399
NEW: 101836499
NEW: 101836599
NEW: 101836699
NEW: 101836799
NEW: 101836899
NEW: 101836999
NEW: 101837099
NEW: 101837199
NEW: 101837299
NEW: 101837399
NEW: 101837499
NEW: 101837599
NEW: 101837699
NEW: 101837799
NEW: 101837899
NEW: 101837999
NEW: 101838099
NEW: 101838199
NEW: 101838299
NEW: 101838399
NEW: 101838499
NEW: 101838599
NEW: 101838699
NEW: 101838799
NEW: 101838899
NEW: 101838999
NEW: 101839099
NEW: 101839199
NEW: 101839299
NEW: 101839399
NEW: 101839499
NEW: 101839599
NEW: 101839699
NEW: 101839799
NEW: 101839899
NEW: 101839999
NEW: 101840099
NEW: 101840199
NEW: 101840299
NEW: 101840399
NEW: 101840499
NEW: 101840599
NEW: 101840699
NEW: 101840799
NEW: 101840899
NEW: 101840999
NEW: 101841099
NEW: 101841199
NEW: 101841299
NEW: 101841399
NEW: 101841499
NEW: 101841599
NEW: 101841699
NEW: 101841799
NEW: 101841899
NEW: 101841999
NEW: 101842099
NEW: 101842199
NEW: 101842299
NEW: 101842399
NEW: 101842499
NEW: 101842599
NEW: 101842699
NEW: 101842799
NEW: 101842899
NEW: 101842999
NEW: 101843099
NEW: 101843199
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 101843399
Ok.
Product Option Sync.
Opencart products: 30
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 = 27391
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101843299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1530
UPDATE oc_option_value_description
SET
name = '101843299 - AGUAR ECOLINE TALENS 30 ML AMA PASTEL 226'
WHERE
option_value_id = 1530
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1530
DELETE FROM oc_product
WHERE
model = '101843299'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1530,
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 '101843499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1531
UPDATE oc_option_value_description
SET
name = '101843499 - AGUAR ECOLINE TALENS 30 ML LAR CLR 236'
WHERE
option_value_id = 1531
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1531
DELETE FROM oc_product
WHERE
model = '101843499'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1531,
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 '101843599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1532
UPDATE oc_option_value_description
SET
name = '101843599 - AGUAR ECOLINE TALENS 30 ML AZAFRANADO 245'
WHERE
option_value_id = 1532
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1532
DELETE FROM oc_product
WHERE
model = '101843599'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1532,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.