Product Sync.
Opencart products: 205
Input products: 100
NEW: 102403999
NEW: 102404099
NEW: 102404199
NEW: 102404299
NEW: 102404399
NEW: 102404499
NEW: 102404599
NEW: 102404699
NEW: 102404799
NEW: 102404899
NEW: 102404999
NEW: 102405099
NEW: 102405199
NEW: 102405299
NEW: 102405399
NEW: 102405499
NEW: 102405599
NEW: 102405699
NEW: 102405799
NEW: 102405899
NEW: 102405999
NEW: 102406099
NEW: 102406199
NEW: 102406299
NEW: 102406399
NEW: 102406499
NEW: 102406599
NEW: 102406699
NEW: 102406799
NEW: 102406899
NEW: 102406999
NEW: 102407099
NEW: 102407199
NEW: 102407299
NEW: 102407399
NEW: 102407499
NEW: 102407599
NEW: 102407699
NEW: 102407799
NEW: 102407899
NEW: 102407999
NEW: 102408099
NEW: 102408199
NEW: 102408299
NEW: 102408399
NEW: 102408499
UPDATING: Guache Giotto Pintura a Dedos 750 ml
Product ID: 27510
Image file:
NEW: 102409099
NEW: 102409199
NEW: 102409299
NEW: 102409399
NEW: 102409499
NEW: 102409599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102409599 - %'
)
NEW: 102409699
NEW: 102409799
NEW: 102409899
NEW: 102409999
NEW: 102410099
NEW: 102410199
NEW: 102410299
NEW: 102410399
NEW: 102410499
NEW: 102410599
NEW: 102410699
NEW: 102410799
NEW: 102410899
NEW: 102410999
NEW: 102411099
NEW: 102411199
NEW: 102411299
NEW: 102411399
NEW: 102411499
NEW: 102411599
NEW: 102411699
NEW: 102411799
NEW: 102411899
NEW: 102411999
NEW: 102412099
NEW: 102412199
NEW: 102412299
NEW: 102412399
NEW: 102412499
NEW: 102412599
NEW: 102412699
NEW: 102412799
NEW: 102412899
NEW: 102412999
NEW: 102413099
NEW: 102413199
NEW: 102413299
NEW: 102413399
NEW: 102413499
NEW: 102413599
NEW: 102413699
NEW: 102413799
NEW: 102413899
Ok.
Product Option Sync.
Opencart products: 206
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 = 27510
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102408599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3732 AS option_value_id,
language_id,
17 AS option_id,
'102408599 - Guache Pintura a Dedos Giotto 750 ml Verde' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3732
DELETE FROM oc_product
WHERE
model = '102408599'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3732,
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 '102408699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3733 AS option_value_id,
language_id,
17 AS option_id,
'102408699 - Guache Pintura a Dedos Giotto 750 ml Laranja' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3733
DELETE FROM oc_product
WHERE
model = '102408699'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3733,
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 '102408799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3734 AS option_value_id,
language_id,
17 AS option_id,
'102408799 - Guache Pintura a Dedos Giotto 750 ml Castanho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3734
DELETE FROM oc_product
WHERE
model = '102408799'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3734,
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 '102408899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3735 AS option_value_id,
language_id,
17 AS option_id,
'102408899 - Guache Pintura a Dedos Giotto 750 ml Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3735
DELETE FROM oc_product
WHERE
model = '102408899'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3735,
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 '102408999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3736 AS option_value_id,
language_id,
17 AS option_id,
'102408999 - Guache Pintura a Dedos Giotto 750 ml Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 470
AND product_id = 27510
AND option_id = 17
AND option_value_id = 3736
DELETE FROM oc_product
WHERE
model = '102408999'
INSERT INTO oc_product_option_value
SET
product_option_id = 470,
product_id = 27510,
option_id = 17,
option_value_id = 3736,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.