Product Sync.
Opencart products: 113
Input products: 100
NEW: 101353499
NEW: 101353599
NEW: 101353699
NEW: 101353799
NEW: 101353899
NEW: 101353999
NEW: 101354099
NEW: 101354199
NEW: 101354299
NEW: 101354399
NEW: 101354499
NEW: 101354599
NEW: 101354699
NEW: 101354799
NEW: 101354899
NEW: 101354999
NEW: 101355099
NEW: 101355199
NEW: 101355299
NEW: 101355399
NEW: 101355499
NEW: 101355599
NEW: 101355699
NEW: 101355799
NEW: 101355899
NEW: 101355999
NEW: 101356099
NEW: 101356199
NEW: 101356299
NEW: 101356399
NEW: 101356499
NEW: 101356599
NEW: 101356699
NEW: 101356799
NEW: 101356899
NEW: 101356999
NEW: 101357099
NEW: 101357199
NEW: 101357299
NEW: 101357399
NEW: 101357499
NEW: 101357599
NEW: 101357699
NEW: 101357799
NEW: 101357899
NEW: 101357999
NEW: 101358099
NEW: 101358199
NEW: 101358299
NEW: 101358399
NEW: 101358499
NEW: 101358599
NEW: 101358699
NEW: 101358799
NEW: 101358899
NEW: 101358999
NEW: 101359099
NEW: 101359199
NEW: 101359299
NEW: 101359399
NEW: 101359499
NEW: 101359599
NEW: 101359699
NEW: 101359799
NEW: 101359899
NEW: 101359999
NEW: 101360099
NEW: 101360199
NEW: 101360299
NEW: 101360399
NEW: 101360499
NEW: 101360599
NEW: 101360699
NEW: 101360799
NEW: 101360899
NEW: 101360999
NEW: 101361099
NEW: 101361199
NEW: 101361299
NEW: 101361399
NEW: 101361499
NEW: 101361599
NEW: 101361699
NEW: Pincel Talens Espatulado para Óleo e Acrílico S234
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Talens Espatulado para Óleo e Acrílico S234 - %'
)
NEW: 101361899
NEW: 101361999
NEW: 101362099
NEW: 101362199
NEW: 101362299
NEW: 101362399
NEW: 101362599
NEW: 101362699
NEW: 101362799
NEW: 101362899
NEW: 101362999
NEW: 101363099
NEW: 101363199
NEW: 101363299
NEW: 101363399
Ok.
Product Option Sync.
Opencart products: 114
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 = 27511
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27511,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101361799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3538 AS option_value_id,
language_id,
17 AS option_id,
'101361799 - \''Pincel Talens Espatulado para Óleo/Acrílico S234 N14' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 471
AND product_id = 27511
AND option_id = 17
AND option_value_id = 3538
DELETE FROM oc_product
WHERE
model = '101361799'
INSERT INTO oc_product_option_value
SET
product_option_id = 471,
product_id = 27511,
option_id = 17,
option_value_id = 3538,
quantity = 1,
subtract = 1,
price = 0.732,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101362499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3539 AS option_value_id,
language_id,
17 AS option_id,
'101362499 - \''Pincel Talens Espatulado para Óleo/Acrílico S234 N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 471
AND product_id = 27511
AND option_id = 17
AND option_value_id = 3539
DELETE FROM oc_product
WHERE
model = '101362499'
INSERT INTO oc_product_option_value
SET
product_option_id = 471,
product_id = 27511,
option_id = 17,
option_value_id = 3539,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.