Product Sync.
Opencart products: 32
Input products: 100
NEW: 491101399
NEW: 491101499
NEW: 491101599
NEW: 491101699
NEW: 491101799
NEW: 491102099
NEW: 491102199
NEW: 491102299
NEW: 491102499
NEW: 491102599
NEW: 491102999
NEW: 491104499
NEW: 491104899
NEW: 491105399
NEW: 491105499
NEW: 491105599
NEW: 491105699
NEW: 491105799
NEW: 491105899
NEW: 491105999
NEW: 491106099
NEW: 491106199
NEW: 491106299
NEW: 491106399
NEW: 491106499
NEW: 491106599
NEW: 491106699
NEW: 491106799
NEW: 491106899
NEW: 491106999
NEW: 491107099
NEW: 491107199
NEW: 491107299
NEW: 491107399
NEW: 491108399
NEW: 491111499
NEW: 491111699
NEW: 491300199
NEW: 491300399
NEW: 491300899
NEW: 491300999
NEW: 491301099
NEW: 491301199
NEW: 491301299
NEW: 491301399
NEW: 491301499
NEW: 491301699
NEW: 491301799
NEW: 491301899
NEW: 491302099
NEW: 491302399
NEW: 491302599
NEW: 491302699
NEW: 491302899
NEW: 491303199
NEW: 491303299
NEW: 491303399
NEW: 491303499
NEW: 491702699
NEW: 491800599
NEW: 491800899
NEW: 491801061
NEW: 491901399
NEW: 491901599
NEW: 491902299
NEW: 491902399
NEW: 491902899
NEW: 491903899
NEW: 491904099
NEW: 491904199
NEW: 491904499
NEW: 491904699
NEW: 491904799
NEW: 491904899
NEW: 491905399
NEW: 491960199
NEW: 491970199
NEW: 491970299
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 491970499
NEW: 492003999
NEW: 492004099
NEW: 492009199
NEW: 492009299
NEW: 492009399
NEW: 492009499
NEW: 492009599
NEW: 492009699
NEW: 492009799
NEW: 492009899
NEW: 492009999
NEW: 492010099
NEW: 492101099
NEW: 492101199
NEW: 492101399
NEW: 492101499
NEW: 492104099
NEW: 492104499
NEW: 492104820
Ok.
Product Option Sync.
Opencart products: 32
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 = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '491970399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2131
UPDATE oc_option_value_description
SET
name = '491970399 - CX CAVAL ACRIL GALERIA EASEL SET C/16 PCAS'
WHERE
option_value_id = 2131
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 2131
DELETE FROM oc_product
WHERE
model = '491970399'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 2131,
quantity = 1,
subtract = 1,
price = 12.114,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '492101699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2132
UPDATE oc_option_value_description
SET
name = '492101699 - CXA CARTAO AGUAR W&N C/12 TUBE SET'
WHERE
option_value_id = 2132
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 2132
DELETE FROM oc_product
WHERE
model = '492101699'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 2132,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.