Product Sync.
Opencart products: 30
Input products: 100
NEW: 102342599
NEW: 102342699
NEW: 102342799
NEW: 102342899
NEW: 102342999
NEW: 102343099
NEW: 102343199
NEW: 102343299
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 102343599
NEW: 102343699
NEW: 102343799
NEW: 102343899
NEW: 102343999
NEW: 102344099
NEW: 102344199
NEW: 102344299
NEW: 102344399
NEW: 102344499
NEW: 102344599
NEW: 102344699
NEW: 102344799
NEW: 102344899
NEW: 102345099
NEW: 102345199
NEW: 102345299
NEW: 102345399
NEW: 102345499
NEW: 102345599
NEW: 102345699
NEW: 102345799
NEW: 102345899
NEW: 102345999
NEW: 102346099
NEW: 102346199
NEW: 102346299
NEW: 102346399
NEW: 102346499
NEW: 102346599
NEW: 102346699
NEW: 102346799
NEW: 102346899
NEW: 102346999
NEW: 102347099
NEW: 102347199
NEW: 102347299
NEW: 102347399
NEW: 102347499
NEW: 102347599
NEW: 102347699
NEW: 102347799
NEW: 102347899
NEW: 102347999
NEW: 102348099
NEW: 102348199
NEW: 102348299
NEW: 102348399
NEW: 102348499
NEW: 102348599
NEW: 102348699
NEW: 102348799
NEW: 102348899
NEW: 102348999
NEW: 102349099
NEW: 102349199
NEW: 102349299
NEW: 102349399
NEW: 102349499
NEW: 102349599
NEW: 102349699
NEW: 102349799
NEW: 102349899
NEW: 102349999
NEW: 102350099
NEW: 102350199
NEW: 102350299
NEW: 102350399
NEW: 102350499
NEW: 102350599
NEW: 102350699
NEW: 102350799
NEW: 102350899
NEW: 102350999
NEW: 102351099
NEW: 102351199
NEW: 102351299
NEW: 102351399
NEW: 102351499
NEW: 102351599
NEW: 102351699
NEW: 102351799
NEW: 102351899
NEW: 102351999
NEW: 102352099
NEW: 102352199
NEW: 102352299
NEW: 102352399
NEW: 102352499
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 = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102343399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1922
UPDATE oc_option_value_description
SET
name = '102343399 - CXA AGUAR W&N COTMAN POCKET PLUS SET TRAVELLER'
WHERE
option_value_id = 1922
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 = 1922
DELETE FROM oc_product
WHERE
model = '102343399'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1922,
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 '102343499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1923
UPDATE oc_option_value_description
SET
name = '102343499 - CXA AGUAR W&N COTMAN FIELD C/12 PAST'
WHERE
option_value_id = 1923
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 = 1923
DELETE FROM oc_product
WHERE
model = '102343499'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1923,
quantity = 1,
subtract = 1,
price = 4.106,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102344999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1924
UPDATE oc_option_value_description
SET
name = '102344999 - SET AGUAR W&N COTMAN TRAVEL BAG'
WHERE
option_value_id = 1924
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 = 1924
DELETE FROM oc_product
WHERE
model = '102344999'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1924,
quantity = 1,
subtract = 1,
price = 8.13,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.