Product Sync.
Opencart products: 156
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: 157
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 = 27145
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27145,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100275099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2175
UPDATE oc_option_value_description
SET
name = '100275099 - Pincel Scriva N8'
WHERE
option_value_id = 2175
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 292
AND product_id = 27145
AND option_id = 15
AND option_value_id = 2175
DELETE FROM oc_product
WHERE
model = '100275099'
INSERT INTO oc_product_option_value
SET
product_option_id = 292,
product_id = 27145,
option_id = 15,
option_value_id = 2175,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2176
UPDATE oc_option_value_description
SET
name = '100275199 - Pincel Scriva N9'
WHERE
option_value_id = 2176
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 292
AND product_id = 27145
AND option_id = 15
AND option_value_id = 2176
DELETE FROM oc_product
WHERE
model = '100275199'
INSERT INTO oc_product_option_value
SET
product_option_id = 292,
product_id = 27145,
option_id = 15,
option_value_id = 2176,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2177
UPDATE oc_option_value_description
SET
name = '100275299 - Pincel Scriva N10'
WHERE
option_value_id = 2177
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 292
AND product_id = 27145
AND option_id = 15
AND option_value_id = 2177
DELETE FROM oc_product
WHERE
model = '100275299'
INSERT INTO oc_product_option_value
SET
product_option_id = 292,
product_id = 27145,
option_id = 15,
option_value_id = 2177,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2178
UPDATE oc_option_value_description
SET
name = '100275499 - Pincel Scriva N12'
WHERE
option_value_id = 2178
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 292
AND product_id = 27145
AND option_id = 15
AND option_value_id = 2178
DELETE FROM oc_product
WHERE
model = '100275499'
INSERT INTO oc_product_option_value
SET
product_option_id = 292,
product_id = 27145,
option_id = 15,
option_value_id = 2178,
quantity = 1,
subtract = 1,
price = 0.366,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.