Product Sync.
Opencart products: 208
Input products: 100
NEW: 102444599
NEW: 102444699
NEW: 102444799
NEW: 102444899
NEW: 102444999
NEW: 102445099
NEW: 102445199
NEW: 102445299
NEW: 102445399
NEW: 102445499
NEW: 102445599
NEW: 102445699
NEW: 102445799
NEW: 102445899
NEW: 102445999
NEW: 102446099
NEW: 102446199
NEW: 102446299
NEW: 102446399
NEW: 102446499
NEW: 102446599
NEW: 102446699
NEW: 102446799
NEW: 102446899
NEW: 102446999
NEW: 102447099
NEW: 102447199
NEW: 102447299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102447299 - %'
)
NEW: 102447399
NEW: 102447499
NEW: 102447599
NEW: 102447699
NEW: 102447799
NEW: 102447899
NEW: 102447999
NEW: 102448099
NEW: 102448199
NEW: 102448299
NEW: 102448399
NEW: 102448499
NEW: 102448599
NEW: 102448699
NEW: 102448799
NEW: 102448899
NEW: 102448999
NEW: 102449099
NEW: 102449199
NEW: 102449299
NEW: 102449399
NEW: 102449499
NEW: 102449599
NEW: 102449699
NEW: 102449799
NEW: 102449899
NEW: 102449999
NEW: 102450099
NEW: 102450199
NEW: 102450299
NEW: 102450399
NEW: 102450499
NEW: 102450599
NEW: 102450699
NEW: 102450799
NEW: 102450899
NEW: 102450999
NEW: 102451099
NEW: 102451199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102451199 - %'
)
NEW: 102451299
NEW: 102451399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102451399 - %'
)
NEW: 102451499
NEW: 102451599
NEW: 102451699
NEW: 102451799
NEW: 102451899
NEW: 102451999
NEW: 102452099
NEW: 102452199
NEW: 102452299
NEW: 102452399
NEW: 102452499
NEW: 102452599
NEW: 102452699
NEW: 102452799
NEW: 102452899
NEW: 102452999
NEW: 102453099
NEW: 102453199
NEW: 102453299
NEW: 102453399
NEW: 102453499
NEW: 102453599
NEW: 102453699
NEW: 102453799
NEW: 102453899
UPDATING: Tela Creatore Premium
Product ID: 27433
Image file:
NEW: 102454199
NEW: 102454299
NEW: 102454399
NEW: 102454499
Ok.
Product Option Sync.
Opencart products: 211
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 '102453999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3738 AS option_value_id,
language_id,
17 AS option_id,
'102453999 - Tela Creatore Premium 50 x 50' 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 = 3738
DELETE FROM oc_product
WHERE
model = '102453999'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3738,
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 '102454099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3739 AS option_value_id,
language_id,
17 AS option_id,
'102454099 - Tela Creatore Premium 70 x 80' 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 = 3739
DELETE FROM oc_product
WHERE
model = '102454099'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3739,
quantity = 1,
subtract = 1,
price = 6.301,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.