Product Sync.
Opencart products: 194
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: 27557
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: 27484
Image file:
NEW: 102261599
NEW: 102261699
NEW: 102261799
NEW: 102261899
NEW: 102261999
NEW: 102262099
NEW: 102262199
NEW: 102262299
Ok.
Product Option Sync.
Opencart products: 194
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 = 27557
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102258199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3691 AS option_value_id,
language_id,
17 AS option_id,
'102258199 - Tela Daler Rowney Simply 20 x 20' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 494
AND product_id = 27557
AND option_id = 17
AND option_value_id = 3691
DELETE FROM oc_product
WHERE
model = '102258199'
INSERT INTO oc_product_option_value
SET
product_option_id = 494,
product_id = 27557,
option_id = 17,
option_value_id = 3691,
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 = 27484
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102261499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3692 AS option_value_id,
language_id,
17 AS option_id,
'102261499 - Pincel Pentel com Reservatório Fino' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 457
AND product_id = 27484
AND option_id = 17
AND option_value_id = 3692
DELETE FROM oc_product
WHERE
model = '102261499'
INSERT INTO oc_product_option_value
SET
product_option_id = 457,
product_id = 27484,
option_id = 17,
option_value_id = 3692,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.