Product Sync.
Opencart products: 128
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: 27433
Image file:
UPDATING: Tela Creatore 3D
Product ID: 27421
Image file:
NEW: 101684399
NEW: 101684499
NEW: 101684599
NEW: 101684699
NEW: 101684799
NEW: 101684899
NEW: 101684999
UPDATING: Tinta para Linóleo
Product ID: 27518
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: 128
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 = 27433
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101684199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3560 AS option_value_id,
language_id,
17 AS option_id,
'101684199 - Tela Creatore Premium 24 x 30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3560
DELETE FROM oc_product
WHERE
model = '101684199'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3560,
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 = 27421
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101684299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3561 AS option_value_id,
language_id,
17 AS option_id,
'101684299 - Tela Creatore 70 x 100' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 407
AND product_id = 27421
AND option_id = 17
AND option_value_id = 3561
DELETE FROM oc_product
WHERE
model = '101684299'
INSERT INTO oc_product_option_value
SET
product_option_id = 407,
product_id = 27421,
option_id = 17,
option_value_id = 3561,
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 = 27518
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101685099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101685099.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3562 AS option_value_id,
language_id,
17 AS option_id,
'101685099 - Tinta Linóleo Base de Agua Essdee 300 ml Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3562
DELETE FROM oc_product
WHERE
model = '101685099'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3562,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.