Product Sync.
Opencart products: 47
Input products: 100
NEW: 100272899
NEW: 100272999
NEW: 100273099
NEW: 100273199
NEW: 100273299
NEW: 100273399
NEW: 100273499
NEW: 100273599
NEW: 100273699
NEW: 100273799
NEW: 100273899
NEW: 100273999
NEW: 100274099
NEW: 100274199
NEW: 100274299
NEW: 100274399
NEW: 100274499
NEW: 100274599
NEW: 100274699
NEW: 100274799
NEW: 100274899
NEW: 100274999
NEW: Pincel Scriva
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Scriva - %'
)
NEW: 100275399
NEW: 100275599
NEW: 100275699
NEW: 100275799
NEW: 100275899
NEW: 100275999
NEW: 100276099
NEW: 100276199
NEW: 100276299
NEW: 100276399
NEW: 100276499
NEW: 100276599
NEW: 100276699
NEW: 100276799
NEW: 100276899
NEW: 100276999
NEW: 100277099
NEW: 100277199
NEW: 100277299
NEW: 100277399
NEW: 100277499
NEW: 100277599
NEW: 100277699
NEW: 100277799
NEW: 100277899
NEW: 100277999
NEW: 100278099
NEW: 100278199
NEW: 100278299
NEW: 100278399
NEW: 100278499
NEW: 100278599
NEW: 100278699
NEW: 100278799
NEW: 100278899
NEW: 100278999
NEW: 100279099
NEW: 100279199
NEW: 100279299
NEW: 100279399
NEW: 100279499
NEW: 100279599
NEW: 100279699
NEW: 100279799
NEW: 100279899
NEW: 100279999
NEW: 100280099
NEW: 100280199
NEW: 100280299
NEW: 100280399
NEW: 100280499
NEW: 100280599
NEW: 100280699
NEW: 100280799
NEW: 100280899
NEW: 100280999
NEW: 100281099
NEW: 100281199
NEW: 100281299
NEW: 100281399
NEW: 100281499
NEW: 100281599
NEW: 100281699
NEW: 100281799
NEW: 100281899
NEW: 100281999
NEW: 100282099
NEW: 100282199
NEW: 100282299
NEW: 100282399
NEW: 100282499
NEW: 100282599
NEW: 100282699
NEW: 100282799
Ok.
Product Option Sync.
Opencart products: 48
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 = 27445
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27445,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100275099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3265 AS option_value_id,
language_id,
17 AS option_id,
'100275099 - Pincel Scriva N8' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 424
AND product_id = 27445
AND option_id = 17
AND option_value_id = 3265
DELETE FROM oc_product
WHERE
model = '100275099'
INSERT INTO oc_product_option_value
SET
product_option_id = 424,
product_id = 27445,
option_id = 17,
option_value_id = 3265,
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 '100275199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3266 AS option_value_id,
language_id,
17 AS option_id,
'100275199 - Pincel Scriva N9' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 424
AND product_id = 27445
AND option_id = 17
AND option_value_id = 3266
DELETE FROM oc_product
WHERE
model = '100275199'
INSERT INTO oc_product_option_value
SET
product_option_id = 424,
product_id = 27445,
option_id = 17,
option_value_id = 3266,
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 '100275299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3267 AS option_value_id,
language_id,
17 AS option_id,
'100275299 - Pincel Scriva N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 424
AND product_id = 27445
AND option_id = 17
AND option_value_id = 3267
DELETE FROM oc_product
WHERE
model = '100275299'
INSERT INTO oc_product_option_value
SET
product_option_id = 424,
product_id = 27445,
option_id = 17,
option_value_id = 3267,
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 '100275499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3268 AS option_value_id,
language_id,
17 AS option_id,
'100275499 - Pincel Scriva N12' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 424
AND product_id = 27445
AND option_id = 17
AND option_value_id = 3268
DELETE FROM oc_product
WHERE
model = '100275499'
INSERT INTO oc_product_option_value
SET
product_option_id = 424,
product_id = 27445,
option_id = 17,
option_value_id = 3268,
quantity = 1,
subtract = 1,
price = 0.366,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.