Product Sync.
Opencart products: 326
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: 27125
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: 327
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 = 27315
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27315,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '411804298 - %'
UPDATE oc_option_value
SET
image = 'catalog/411804298.jpg'
WHERE
option_value_id = 2834
UPDATE oc_option_value_description
SET
name = '411804298 - Bloco Fabriano Watercolour 18 x 24 200 gr'
WHERE
option_value_id = 2834
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 356
AND product_id = 27315
AND option_id = 15
AND option_value_id = 2834
DELETE FROM oc_product
WHERE
model = '411804298'
INSERT INTO oc_product_option_value
SET
product_option_id = 356,
product_id = 27315,
option_id = 15,
option_value_id = 2834,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2836
UPDATE oc_option_value_description
SET
name = '411815898 - Bloco Fabriano Watercolour 13,5 x 21 300 gr'
WHERE
option_value_id = 2836
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 356
AND product_id = 27315
AND option_id = 15
AND option_value_id = 2836
DELETE FROM oc_product
WHERE
model = '411815898'
INSERT INTO oc_product_option_value
SET
product_option_id = 356,
product_id = 27315,
option_id = 15,
option_value_id = 2836,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2837
UPDATE oc_option_value_description
SET
name = '411816098 - Bloco Fabriano Watercolour 24 x 32 300 gr'
WHERE
option_value_id = 2837
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 356
AND product_id = 27315
AND option_id = 15
AND option_value_id = 2837
DELETE FROM oc_product
WHERE
model = '411816098'
INSERT INTO oc_product_option_value
SET
product_option_id = 356,
product_id = 27315,
option_id = 15,
option_value_id = 2837,
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 = 27125
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '411805298 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2835
UPDATE oc_option_value_description
SET
name = '411805298 - Bloco Fabriano Pintura 30 x 40 400 gr'
WHERE
option_value_id = 2835
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 281
AND product_id = 27125
AND option_id = 15
AND option_value_id = 2835
DELETE FROM oc_product
WHERE
model = '411805298'
INSERT INTO oc_product_option_value
SET
product_option_id = 281,
product_id = 27125,
option_id = 15,
option_value_id = 2835,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.