Product Sync.
Opencart products: 240
Input products: 100
NEW: 411503099
NEW: 411800198
NEW: 411800798
NEW: 411801198
NEW: 411801398
NEW: 411801698
NEW: 411801798
NEW: 411801898
NEW: 411802099
NEW: Bloco Fabriano Watercolour
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Fabriano Watercolour - %'
)
NEW: 411804398
NEW: 411804498
NEW: 411805198
UPDATING: Bloco Aguarela Canson XL
Product ID: 27415
Image file:
NEW: 411805799
NEW: 411806399
NEW: 411806799
NEW: 411807099
NEW: 411807199
NEW: 411809199
NEW: 411809499
NEW: 411809599
NEW: 411809699
NEW: 411809799
NEW: 411811199
NEW: 411812899
NEW: 411813299
NEW: 411813399
NEW: 411814199
NEW: 411814299
NEW: 411814399
NEW: 411816198
NEW: 411816298
NEW: 411819899
NEW: 411820199
NEW: 411821799
NEW: 411822599
NEW: 411822899
NEW: 411823099
NEW: 411830799
NEW: 411830899
NEW: 411830999
NEW: 411831099
NEW: 411831199
NEW: 411831299
NEW: 411831499
NEW: 411831599
NEW: 411831699
NEW: 411832299
NEW: 411832399
NEW: 411832499
NEW: 411832599
NEW: 411832699
NEW: 411832799
NEW: 411832899
NEW: 411832999
NEW: 411833199
NEW: 411833299
NEW: 411833399
NEW: 411833499
NEW: 411833699
NEW: 411833799
NEW: 411834099
NEW: 411834199
NEW: 411834299
NEW: 411834399
NEW: 411834499
NEW: 412002399
NEW: 412002699
NEW: 412312199
NEW: 412312899
NEW: 412314299
NEW: 412400999
NEW: 412401399
NEW: 412402699
NEW: 412404376
NEW: 412407399
NEW: 412409199
NEW: 412414899
NEW: 412417399
NEW: 412419199
NEW: 412419999
NEW: 412420699
NEW: 412420899
NEW: 412421599
NEW: 412421799
NEW: 412423399
NEW: 412425899
NEW: 412426199
NEW: 412426499
NEW: 412426699
NEW: 412426799
NEW: 412601099
NEW: 413811999
NEW: 413812099
NEW: 413812199
NEW: 413812299
NEW: 413812399
Ok.
Product Option Sync.
Opencart products: 241
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 = 27638
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27638,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '411804298 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/411804298.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3856 AS option_value_id,
language_id,
17 AS option_id,
'411804298 - Bloco Fabriano Watercolour 18 x 24 200 gr' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 520
AND product_id = 27638
AND option_id = 17
AND option_value_id = 3856
DELETE FROM oc_product
WHERE
model = '411804298'
INSERT INTO oc_product_option_value
SET
product_option_id = 520,
product_id = 27638,
option_id = 17,
option_value_id = 3856,
quantity = 1,
subtract = 1,
price = 1.748,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '411815898 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3857 AS option_value_id,
language_id,
17 AS option_id,
'411815898 - Bloco Fabriano Watercolour 13,5 x 21 300 gr' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 520
AND product_id = 27638
AND option_id = 17
AND option_value_id = 3857
DELETE FROM oc_product
WHERE
model = '411815898'
INSERT INTO oc_product_option_value
SET
product_option_id = 520,
product_id = 27638,
option_id = 17,
option_value_id = 3857,
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 '411816098 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3858 AS option_value_id,
language_id,
17 AS option_id,
'411816098 - Bloco Fabriano Watercolour 24 x 32 300 gr' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 520
AND product_id = 27638
AND option_id = 17
AND option_value_id = 3858
DELETE FROM oc_product
WHERE
model = '411816098'
INSERT INTO oc_product_option_value
SET
product_option_id = 520,
product_id = 27638,
option_id = 17,
option_value_id = 3858,
quantity = 1,
subtract = 1,
price = 4.147,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27415
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '411805298 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3859 AS option_value_id,
language_id,
17 AS option_id,
'411805298 - Bloco Fabriano Pintura 30 x 40 400 gr' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 403
AND product_id = 27415
AND option_id = 17
AND option_value_id = 3859
DELETE FROM oc_product
WHERE
model = '411805298'
INSERT INTO oc_product_option_value
SET
product_option_id = 403,
product_id = 27415,
option_id = 17,
option_value_id = 3859,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.