Product Sync.
Opencart products: 211
Input products: 100
NEW: 102454699
NEW: 102454799
NEW: 102454899
NEW: 102454999
NEW: 102455099
NEW: 102455199
NEW: 102455299
NEW: 102455399
NEW: 102455499
NEW: 102455599
NEW: 102455699
NEW: 102455799
NEW: 102455899
NEW: 102455999
NEW: 102456099
NEW: 102456199
NEW: 102456299
NEW: 102456399
NEW: 102456499
NEW: 102456599
NEW: 102456699
NEW: 102456799
NEW: 102456899
NEW: 102456999
NEW: 102457099
NEW: 102457199
NEW: 102457299
NEW: 102457399
NEW: 102457499
NEW: 102457599
NEW: 102457699
NEW: 102457799
NEW: 102457899
NEW: 102457999
NEW: Pincel Giotto S400
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Giotto S400 - %'
)
NEW: 102458999
NEW: 102459099
NEW: 102459499
NEW: 102459599
NEW: 102459699
NEW: 102459799
NEW: 102459899
NEW: 102459999
NEW: 102460099
NEW: 102460199
NEW: 102460299
NEW: 102460399
NEW: 102460499
NEW: 102460599
NEW: 102460699
NEW: 102460799
NEW: 102460899
NEW: 102460999
NEW: 102461099
NEW: 102461199
NEW: 102461299
NEW: 102461399
NEW: 102461499
NEW: 102461599
NEW: 102461699
NEW: 102461799
NEW: 102461899
NEW: 102461999
NEW: 102462099
NEW: 102462199
NEW: 102462299
NEW: 102462399
NEW: 102462499
NEW: 102462599
NEW: 102462699
NEW: 102462799
NEW: 102462899
NEW: 102462999
NEW: 102463099
NEW: 102463199
NEW: 102463299
NEW: 102463399
NEW: 102463499
NEW: 102463599
NEW: 102463699
NEW: 102463799
NEW: 102463899
NEW: 102463999
NEW: 102464099
NEW: 102464199
NEW: 102464299
NEW: 102464399
NEW: 102464499
NEW: 102464599
Ok.
Product Option Sync.
Opencart products: 212
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 = 27609
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27609,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3740 AS option_value_id,
language_id,
17 AS option_id,
'102458099 - Pincel Giotto S400 N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3740
DELETE FROM oc_product
WHERE
model = '102458099'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3740,
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 '102458199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3741 AS option_value_id,
language_id,
17 AS option_id,
'102458199 - Pincel Giotto S400 N2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3741
DELETE FROM oc_product
WHERE
model = '102458199'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3741,
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 '102458299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3742 AS option_value_id,
language_id,
17 AS option_id,
'102458299 - Pincel Giotto S400 N3' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3742
DELETE FROM oc_product
WHERE
model = '102458299'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3742,
quantity = 1,
subtract = 1,
price = 0.04,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3743 AS option_value_id,
language_id,
17 AS option_id,
'102458399 - Pincel Giotto S400 N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3743
DELETE FROM oc_product
WHERE
model = '102458399'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3743,
quantity = 1,
subtract = 1,
price = 0.04,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3744 AS option_value_id,
language_id,
17 AS option_id,
'102458499 - Pincel Giotto S400 N5' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3744
DELETE FROM oc_product
WHERE
model = '102458499'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3744,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3745 AS option_value_id,
language_id,
17 AS option_id,
'102458599 - Pincel Giotto S400 N6' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3745
DELETE FROM oc_product
WHERE
model = '102458599'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3745,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3746 AS option_value_id,
language_id,
17 AS option_id,
'102458699 - Pincel Giotto S400 N7' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3746
DELETE FROM oc_product
WHERE
model = '102458699'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3746,
quantity = 1,
subtract = 1,
price = 0.122,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3747 AS option_value_id,
language_id,
17 AS option_id,
'102458799 - Pincel Giotto S400 N8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3747
DELETE FROM oc_product
WHERE
model = '102458799'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3747,
quantity = 1,
subtract = 1,
price = 0.162,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102458899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3748 AS option_value_id,
language_id,
17 AS option_id,
'102458899 - Pincel Giotto S400 N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3748
DELETE FROM oc_product
WHERE
model = '102458899'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3748,
quantity = 1,
subtract = 1,
price = 0.203,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102459199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3749 AS option_value_id,
language_id,
17 AS option_id,
'102459199 - Pincel Giotto S400 N11' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3749
DELETE FROM oc_product
WHERE
model = '102459199'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3749,
quantity = 1,
subtract = 1,
price = 0.244,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102459299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3750 AS option_value_id,
language_id,
17 AS option_id,
'102459299 - Pincel Giotto S400 N12' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3750
DELETE FROM oc_product
WHERE
model = '102459299'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3750,
quantity = 1,
subtract = 1,
price = 0.284,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102459399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3751 AS option_value_id,
language_id,
17 AS option_id,
'102459399 - Pincel Giotto S400 N14' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 506
AND product_id = 27609
AND option_id = 17
AND option_value_id = 3751
DELETE FROM oc_product
WHERE
model = '102459399'
INSERT INTO oc_product_option_value
SET
product_option_id = 506,
product_id = 27609,
option_id = 17,
option_value_id = 3751,
quantity = 1,
subtract = 1,
price = 0.406,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.