Product Sync.
Opencart products: 212
Input products: 100
NEW: 101676599
NEW: 101676699
NEW: 101676799
NEW: 101676899
NEW: 101676999
NEW: 101677099
NEW: 101677199
NEW: 101677299
NEW: 101677399
NEW: 101677499
NEW: 101677599
NEW: 101677699
NEW: 101677799
NEW: 101677899
NEW: 101677999
NEW: 101678099
NEW: 101678199
NEW: 101678299
NEW: 101678399
NEW: 101678499
NEW: 101678599
NEW: 101678699
NEW: 101678799
NEW: 101678899
NEW: 101678999
NEW: 101679099
NEW: 101679199
NEW: 101679299
NEW: 101679399
NEW: 101679499
NEW: 101679599
NEW: 101679699
NEW: 101679799
NEW: 101679899
NEW: 101679999
NEW: 101680099
NEW: 101680199
NEW: 101680299
NEW: 101680399
NEW: 101680499
NEW: 101680599
NEW: 101680699
NEW: 101680799
NEW: 101680899
NEW: 101680999
NEW: 101681099
NEW: 101681199
NEW: 101681299
NEW: 101681399
NEW: 101681499
NEW: 101681599
NEW: 101681699
NEW: 101681799
NEW: 101681899
NEW: 101681999
NEW: 101682099
NEW: 101682199
NEW: 101682299
NEW: 101682399
NEW: 101682499
NEW: 101682599
NEW: 101682699
NEW: 101682799
NEW: 101682899
NEW: 101682999
NEW: 101683099
NEW: 101683199
NEW: 101683299
NEW: 101683399
NEW: 101683499
NEW: 101683599
NEW: 101683699
NEW: 101683799
NEW: 101683899
NEW: 101683999
NEW: 101684099
UPDATING: Tela Creatore Premium
Product ID: 27139
Image file:
UPDATING: Tela Creatore 3D
Product ID: 27130
Image file:
NEW: 101684399
NEW: 101684499
NEW: 101684599
NEW: 101684699
NEW: 101684799
NEW: 101684899
NEW: 101684999
UPDATING: Tinta para Linóleo
Product ID: 27070
Image file:
NEW: 101685199
NEW: 101685299
NEW: 101685399
NEW: 101685499
NEW: 101685599
NEW: 101685699
NEW: 101685799
NEW: 101685899
NEW: 101685999
NEW: 101686099
NEW: 101686199
NEW: 101686299
NEW: 101686399
NEW: 101686499
Ok.
Product Option Sync.
Opencart products: 212
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 = 27139
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101684199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2488
UPDATE oc_option_value_description
SET
name = '101684199 - Tela Creatore Premium 24 x 30'
WHERE
option_value_id = 2488
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2488
DELETE FROM oc_product
WHERE
model = '101684199'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2488,
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 = 27130
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101684299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2489
UPDATE oc_option_value_description
SET
name = '101684299 - Tela Creatore 70 x 100'
WHERE
option_value_id = 2489
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 284
AND product_id = 27130
AND option_id = 15
AND option_value_id = 2489
DELETE FROM oc_product
WHERE
model = '101684299'
INSERT INTO oc_product_option_value
SET
product_option_id = 284,
product_id = 27130,
option_id = 15,
option_value_id = 2489,
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 = 27070
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101685099 - %'
UPDATE oc_option_value
SET
image = 'catalog/101685099.jpg'
WHERE
option_value_id = 2490
UPDATE oc_option_value_description
SET
name = '101685099 - Tinta Linóleo Base de Agua Essdee 300 ml Preto'
WHERE
option_value_id = 2490
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2490
DELETE FROM oc_product
WHERE
model = '101685099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2490
Ok.