Product Sync.
Opencart products: 206
Input products: 100
NEW: 101525099
NEW: 101525199
NEW: 101525299
NEW: 101525399
NEW: 101525499
NEW: 101525599
UPDATING: Pincel Talens Espatulado para Óleo e Acrílico S234
Product ID: 27190
Image file:
NEW: 101525799
NEW: 101525899
NEW: 101525999
NEW: Pincel Talens Aguarela S
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 Aguarela S - %'
)
NEW: 101526199
NEW: 101526299
NEW: 101526399
NEW: 101526499
NEW: 101526599
NEW: 101526699
NEW: 101526799
NEW: 101526899
NEW: 101526999
NEW: 101527099
NEW: 101527199
NEW: 101527299
NEW: 101527399
NEW: 101527499
NEW: 101527599
NEW: 101527699
NEW: 101527799
NEW: 101527899
NEW: 101527999
NEW: 101528099
NEW: 101528199
NEW: 101528299
NEW: 101528399
NEW: 101528499
NEW: 101528599
NEW: 101528699
NEW: 101528799
NEW: 101528899
NEW: 101528999
NEW: 101529099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101529099 - %'
)
NEW: 101529199
NEW: 101529299
NEW: 101529399
NEW: 101529499
NEW: 101529599
NEW: 101529699
NEW: 101529799
NEW: 101529899
NEW: 1015299
NEW: 101529999
NEW: 101530099
NEW: 101530199
NEW: 101530299
NEW: 101530399
NEW: 101530499
NEW: 101530599
NEW: 101530699
NEW: 101530799
NEW: 101530899
NEW: 101530999
NEW: 101531099
NEW: 101531199
NEW: 101531299
NEW: 101531399
NEW: 101531499
NEW: 101531599
NEW: 101531799
NEW: 101531899
NEW: 101531999
NEW: 101532099
NEW: 101532199
NEW: 101532299
NEW: 101532399
NEW: 101532499
NEW: 101532599
NEW: 101532699
NEW: 101532799
NEW: 101532899
NEW: 101532999
NEW: 101533099
NEW: 101533199
NEW: 101533299
NEW: 101533399
NEW: 101533499
NEW: 101533599
NEW: 101533699
NEW: 101533799
NEW: 101533899
NEW: 101533999
NEW: 101534099
NEW: 101534199
NEW: 101534299
NEW: 101534399
NEW: 101534499
NEW: 101534599
NEW: 101534699
NEW: 101534799
NEW: 101534899
NEW: 101534999
Ok.
Product Option Sync.
Opencart products: 208
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 = 27190
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101525699 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3185 AS option_value_id,
language_id,
15 AS option_id,
'101525699 - \''Pincel Talens Espatulado para Óleo/Acrílico S234 N18' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 316
AND product_id = 27190
AND option_id = 15
AND option_value_id = 3185
DELETE FROM oc_product
WHERE
model = '101525699'
INSERT INTO oc_product_option_value
SET
product_option_id = 316,
product_id = 27190,
option_id = 15,
option_value_id = 3185,
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 = 27195
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27195,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101526099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2467
UPDATE oc_option_value_description
SET
name = '101526099 - Pincel Talens Aguarela S191 N18'
WHERE
option_value_id = 2467
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 319
AND product_id = 27195
AND option_id = 15
AND option_value_id = 2467
DELETE FROM oc_product
WHERE
model = '101526099'
INSERT INTO oc_product_option_value
SET
product_option_id = 319,
product_id = 27195,
option_id = 15,
option_value_id = 2467,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.