Product Sync.
Opencart products: 17
Input products: 100
NEW: 100070799
NEW: 100070899
NEW: 100070999
NEW: 100071099
NEW: 100071199
NEW: 100071299
NEW: 100071399
NEW: 100071499
NEW: 100071599
NEW: 100071699
NEW: 100071799
NEW: 100071899
NEW: 100071999
NEW: 100072099
NEW: 100072199
NEW: 100072299
NEW: 100072399
NEW: 100072499
NEW: 100072599
NEW: 100072699
NEW: 100072799
NEW: 100072899
NEW: 100072999
NEW: 100073099
NEW: 100073199
NEW: 100073299
NEW: 100073399
NEW: 100073499
NEW: 100073599
NEW: 100073699
NEW: 100073799
NEW: 100073899
NEW: 100073999
NEW: 100074099
NEW: 100074199
NEW: 100074299
NEW: 100074399
NEW: 100074499
NEW: 100074599
NEW: 100074699
NEW: 100074799
NEW: 100074899
NEW: 100074999
NEW: 100075099
NEW: 100075199
NEW: 100075299
NEW: 100075399
NEW: 100075499
NEW: 100075599
NEW: 100075699
NEW: 100075799
NEW: 100075899
NEW: 100075999
NEW: 100076099
NEW: 100076199
NEW: 100076299
NEW: 100076399
NEW: 100076499
NEW: 100076599
NEW: 100076699
NEW: 100076799
NEW: Bloco Aguarela Canson XL
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Aguarela Canson XL - %'
)
NEW: Bloco Aguarela Canson Vidalon Rústico
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Aguarela Canson Vidalon Rústico - %'
)
NEW: 100077399
NEW: 100077499
NEW: 100077599
NEW: 100077699
NEW: 100077799
NEW: 100077899
NEW: 100077999
NEW: 100078099
NEW: 100078199
NEW: 100078299
NEW: 100078399
NEW: 100078499
NEW: 100078599
NEW: 100078699
NEW: 100078799
NEW: 100078899
NEW: 100078999
NEW: 100079099
NEW: 100079199
NEW: 100079299
NEW: 100079399
NEW: 100079499
NEW: 100079599
NEW: 100079699
NEW: 100079799
NEW: 100079899
NEW: 100079999
NEW: 100080099
NEW: 100080199
NEW: 100080299
NEW: 100080399
NEW: 100080499
NEW: 100080599
NEW: 100080699
Ok.
Product Option Sync.
Opencart products: 19
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 = 27415
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27415,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100076899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3239 AS option_value_id,
language_id,
17 AS option_id,
'100076899 - Bloco Aguarela Canson XL 300 gr GF A4 30 Fls' 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 = 3239
DELETE FROM oc_product
WHERE
model = '100076899'
INSERT INTO oc_product_option_value
SET
product_option_id = 403,
product_id = 27415,
option_id = 17,
option_value_id = 3239,
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 '100076999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3240 AS option_value_id,
language_id,
17 AS option_id,
'100076999 - Bloco Aguarela Canson XL 300 gr GF A3 30 Fls' 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 = 3240
DELETE FROM oc_product
WHERE
model = '100076999'
INSERT INTO oc_product_option_value
SET
product_option_id = 403,
product_id = 27415,
option_id = 17,
option_value_id = 3240,
quantity = 1,
subtract = 1,
price = 4.146,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27416
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27416,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100077099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3241 AS option_value_id,
language_id,
17 AS option_id,
'100077099 - Bloco Aguarela Canson Vidalon Rústico 24 x 32 300 gr 12 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 404
AND product_id = 27416
AND option_id = 17
AND option_value_id = 3241
DELETE FROM oc_product
WHERE
model = '100077099'
INSERT INTO oc_product_option_value
SET
product_option_id = 404,
product_id = 27416,
option_id = 17,
option_value_id = 3241,
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 '100077199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3242 AS option_value_id,
language_id,
17 AS option_id,
'100077199 - Bloco Aguarela Canson Vidalon Rústico 27 x 36 300 gr 12 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 404
AND product_id = 27416
AND option_id = 17
AND option_value_id = 3242
DELETE FROM oc_product
WHERE
model = '100077199'
INSERT INTO oc_product_option_value
SET
product_option_id = 404,
product_id = 27416,
option_id = 17,
option_value_id = 3242,
quantity = 1,
subtract = 1,
price = 1.626,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100077299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3243 AS option_value_id,
language_id,
17 AS option_id,
'100077299 - Bloco Aguarela Canson Vidalon Rústico 32 x 41 300 gr 12 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 404
AND product_id = 27416
AND option_id = 17
AND option_value_id = 3243
DELETE FROM oc_product
WHERE
model = '100077299'
INSERT INTO oc_product_option_value
SET
product_option_id = 404,
product_id = 27416,
option_id = 17,
option_value_id = 3243,
quantity = 1,
subtract = 1,
price = 3.943,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.