Product Sync.
Opencart products: 161
Input products: 100
NEW: 100454699
NEW: 100454799
NEW: 100454899
UPDATING: Pincel Pelikan 25A
Product ID: 27148
Image file:
UPDATING: Tinta da China Pelikan
Product ID: 27033
Image file:
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: 161
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 = 27148
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100454999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2237
UPDATE oc_option_value_description
SET
name = '100454999 - Pincel Pelikan 25A N2'
WHERE
option_value_id = 2237
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2237
DELETE FROM oc_product
WHERE
model = '100454999'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2237,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2238
UPDATE oc_option_value_description
SET
name = '100455099 - Pincel Pelikan 25A N6'
WHERE
option_value_id = 2238
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2238
DELETE FROM oc_product
WHERE
model = '100455099'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2238,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2239
UPDATE oc_option_value_description
SET
name = '100455199 - Pincel Pelikan 25A N7'
WHERE
option_value_id = 2239
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2239
DELETE FROM oc_product
WHERE
model = '100455199'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2239,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2240
UPDATE oc_option_value_description
SET
name = '100455299 - Pincel Pelikan 25A N8'
WHERE
option_value_id = 2240
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2240
DELETE FROM oc_product
WHERE
model = '100455299'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2240,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2241
UPDATE oc_option_value_description
SET
name = '100455399 - Pincel Pelikan 25A N14'
WHERE
option_value_id = 2241
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2241
DELETE FROM oc_product
WHERE
model = '100455399'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2241,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2242
UPDATE oc_option_value_description
SET
name = '100455499 - Pincel Pelikan 25A N16'
WHERE
option_value_id = 2242
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2242
DELETE FROM oc_product
WHERE
model = '100455499'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2242,
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 = 27033
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100455599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2243
UPDATE oc_option_value_description
SET
name = '100455599 - Tinta da China Pelikan 10 ml Preto'
WHERE
option_value_id = 2243
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 100
AND product_id = 27033
AND option_id = 15
AND option_value_id = 2243
DELETE FROM oc_product
WHERE
model = '100455599'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 100
AND product_id = 27033
AND option_id = 15
AND option_value_id = 2243
Ok.