Product Sync.
Opencart products: 281
Input products: 100
NEW: 102252399
NEW: 102252499
NEW: 102252599
NEW: 102252699
NEW: 102252799
NEW: 102252899
NEW: 102252999
NEW: 102253099
NEW: 102253199
NEW: 102253299
NEW: 102253399
NEW: 102253499
NEW: 102253599
NEW: 102253699
NEW: 102253799
NEW: 102253899
NEW: 102253999
NEW: 102254099
NEW: 102254199
NEW: 102254299
NEW: 102254399
NEW: 102254499
NEW: 102254599
NEW: 102254699
NEW: 102254799
NEW: 102254899
NEW: 102254999
NEW: 102255099
NEW: 102255199
NEW: 102255299
NEW: 102255399
NEW: 102255499
NEW: 102255599
NEW: 102255699
NEW: 102255799
NEW: 102255899
NEW: 102255999
NEW: 102256099
NEW: 102256199
NEW: 102256299
NEW: 102256399
NEW: 102256499
NEW: 102256599
NEW: 102256699
NEW: 102256799
NEW: 102256899
NEW: 102256999
NEW: 102257099
NEW: 102257199
NEW: 102257299
NEW: 102257399
NEW: 102257499
NEW: 102257599
NEW: 102257699
NEW: 102257799
NEW: 102257899
NEW: 102257999
NEW: 102258099
UPDATING: Tela Daler Rowney Simply
Product ID: 27234
Image file:
NEW: 102258299
NEW: 102258399
NEW: 102258499
NEW: 102258599
NEW: 102258699
NEW: 102258799
NEW: 102258899
NEW: 102258999
NEW: 102259099
NEW: 102259199
NEW: 102259299
NEW: 102259399
NEW: 102259499
NEW: 102259599
NEW: 102259699
NEW: 102259799
NEW: 102259899
NEW: 102259999
NEW: 102260099
NEW: 102260199
NEW: 102260299
NEW: 102260399
NEW: 102260499
NEW: 102260599
NEW: 102260699
NEW: 102260799
NEW: 102260899
NEW: 102260999
NEW: 102261099
NEW: 102261199
NEW: 102261299
NEW: 102261399
UPDATING: Pincel Pentel com Reservatório
Product ID: 27168
Image file:
NEW: 102261599
NEW: 102261699
NEW: 102261799
NEW: 102261899
NEW: 102261999
NEW: 102262099
NEW: 102262199
NEW: 102262299
Ok.
Product Option Sync.
Opencart products: 281
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 = 27234
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102258199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2653
UPDATE oc_option_value_description
SET
name = '102258199 - Tela Daler Rowney Simply 20 x 20'
WHERE
option_value_id = 2653
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 333
AND product_id = 27234
AND option_id = 15
AND option_value_id = 2653
DELETE FROM oc_product
WHERE
model = '102258199'
INSERT INTO oc_product_option_value
SET
product_option_id = 333,
product_id = 27234,
option_id = 15,
option_value_id = 2653,
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 = 27168
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102261499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2654
UPDATE oc_option_value_description
SET
name = '102261499 - Pincel Pentel com Reservatório Fino'
WHERE
option_value_id = 2654
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 308
AND product_id = 27168
AND option_id = 15
AND option_value_id = 2654
DELETE FROM oc_product
WHERE
model = '102261499'
INSERT INTO oc_product_option_value
SET
product_option_id = 308,
product_id = 27168,
option_id = 15,
option_value_id = 2654,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.