Product Sync.
Opencart products: 60
Input products: 100
NEW: 100454699
NEW: 100454799
NEW: 100454899
UPDATING: Pincel Pelikan 25A
Product ID: 27454
Image file:
NEW: Tinta da China Pelikan
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta da China Pelikan - %'
)
NEW: 100455699
NEW: 100455799
NEW: 100455899
NEW: 100455999
NEW: 100456099
NEW: 100456199
NEW: 100456299
NEW: 100456399
NEW: 100456499
NEW: 100456599
NEW: 100456699
NEW: 100456799
NEW: 100456899
NEW: 100456999
NEW: 100457099
NEW: 100457199
NEW: 100457299
NEW: 100457399
NEW: 100457499
NEW: 100457599
NEW: 100457699
NEW: 100457799
NEW: 100457899
NEW: 100457999
NEW: 100458099
NEW: 100458199
NEW: 100458299
NEW: 100458399
NEW: 100458499
NEW: 100458599
NEW: 100458699
NEW: 100458799
NEW: 100458899
NEW: 100458999
NEW: 100459099
NEW: 100459199
NEW: 100459299
NEW: 100459399
NEW: 100459499
NEW: 100459599
NEW: 100459699
NEW: 100459799
NEW: 100459899
NEW: 100459999
NEW: 100460099
NEW: 100460199
NEW: 100460299
NEW: 100460399
NEW: 100460499
NEW: 100460599
NEW: 100460699
NEW: 100460799
NEW: 100460899
NEW: 100460999
NEW: 100461099
NEW: 100461199
NEW: 100461299
NEW: 100461399
NEW: 100461499
NEW: 100461599
NEW: 100461699
NEW: 100461799
NEW: 100461899
NEW: 100461999
NEW: 100462099
NEW: 100462199
NEW: 100462299
NEW: 100462399
NEW: 100462499
NEW: 100462599
NEW: 100462699
NEW: 100462799
NEW: 100462899
NEW: 100462999
NEW: 100463099
NEW: 100463199
NEW: 100463299
NEW: 100463399
NEW: 100463499
NEW: 100463599
NEW: 100463699
NEW: 100463799
NEW: 100463899
NEW: 100463999
NEW: 100464099
NEW: 100464199
NEW: 100464299
NEW: 100464399
NEW: 100464499
NEW: 100464599
Ok.
Product Option Sync.
Opencart products: 61
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 = 27454
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100454999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3327 AS option_value_id,
language_id,
17 AS option_id,
'100454999 - Pincel Pelikan 25A N2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3327
DELETE FROM oc_product
WHERE
model = '100454999'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3327,
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 '100455099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3328 AS option_value_id,
language_id,
17 AS option_id,
'100455099 - Pincel Pelikan 25A N6' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3328
DELETE FROM oc_product
WHERE
model = '100455099'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3328,
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 '100455199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3329 AS option_value_id,
language_id,
17 AS option_id,
'100455199 - Pincel Pelikan 25A N7' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3329
DELETE FROM oc_product
WHERE
model = '100455199'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3329,
quantity = 1,
subtract = 1,
price = 0.243,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100455299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3330 AS option_value_id,
language_id,
17 AS option_id,
'100455299 - Pincel Pelikan 25A N8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3330
DELETE FROM oc_product
WHERE
model = '100455299'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3330,
quantity = 1,
subtract = 1,
price = 0.325,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100455399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3331 AS option_value_id,
language_id,
17 AS option_id,
'100455399 - Pincel Pelikan 25A N14' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3331
DELETE FROM oc_product
WHERE
model = '100455399'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3331,
quantity = 1,
subtract = 1,
price = 0.894,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100455499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3332 AS option_value_id,
language_id,
17 AS option_id,
'100455499 - Pincel Pelikan 25A N16' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3332
DELETE FROM oc_product
WHERE
model = '100455499'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3332,
quantity = 1,
subtract = 1,
price = 1.056,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27458
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27458,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100455599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3333 AS option_value_id,
language_id,
17 AS option_id,
'100455599 - Tinta da China Pelikan 10 ml Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 437
AND product_id = 27458
AND option_id = 17
AND option_value_id = 3333
DELETE FROM oc_product
WHERE
model = '100455599'
INSERT INTO oc_product_option_value
SET
product_option_id = 437,
product_id = 27458,
option_id = 17,
option_value_id = 3333,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.