Product Sync.
Opencart products: 190
Input products: 100
NEW: 101191899
NEW: 101191999
NEW: 101192099
NEW: 101192199
NEW: 101192299
NEW: 101192399
NEW: 101192499
NEW: 101192599
NEW: 101192699
NEW: 101192799
NEW: 101192899
NEW: 101192999
NEW: 101193099
NEW: 101193199
NEW: 101193299
NEW: 101193399
NEW: 101193499
NEW: 101193599
NEW: 101193699
NEW: 101193799
NEW: 101193899
NEW: 101193999
NEW: 101194099
NEW: 101194199
NEW: 101194299
NEW: 101194399
NEW: 101194499
NEW: 101194599
NEW: 101194699
NEW: 101194799
NEW: 101194899
NEW: 101194999
NEW: 101195099
NEW: 101195199
NEW: 101195299
NEW: 101195399
NEW: 101195499
NEW: 101195599
NEW: 101195699
NEW: 101195799
NEW: 101195899
NEW: 101195999
NEW: 101196099
NEW: 101196199
NEW: 101196299
NEW: 101196399
NEW: 101196499
NEW: 101196599
NEW: Tinta da China Talens 490 ml
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 Talens 490 ml - %'
)
NEW: 101196799
UPDATING: Tela Winsor & Newton
Product ID: 27164
Image file:
NEW: 101196999
NEW: 101197099
NEW: 101197199
NEW: 101197299
NEW: 101197399
NEW: 101197499
NEW: 101197599
NEW: 101197699
NEW: 101197799
NEW: 101197899
NEW: 101197999
NEW: 101198099
NEW: 101198199
NEW: 101198299
NEW: Pincel Talens Lingua de Gato Aguarela S195
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Talens Lingua de Gato Aguarela S195 - %'
)
NEW: 101198499
NEW: 101198599
NEW: 101198699
NEW: 101198799
NEW: 101198899
NEW: 101198999
NEW: 101199099
NEW: 101199199
NEW: 101199299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101199299 - %'
)
NEW: 101199399
NEW: 101199499
UPDATING: Goma Laca Inart
Product ID: 27053
Image file:
NEW: 101199699
NEW: 101199799
NEW: 101199899
NEW: 101199999
NEW: 101200099
NEW: 101200199
NEW: 101200299
NEW: 101200399
UPDATING: Médio para Vitral Pébeo
Product ID: 27152
Image file:
NEW: 101200599
NEW: 101200699
NEW: 101200799
NEW: 101200899
NEW: 101200999
NEW: 101201099
NEW: 101201199
NEW: 101201299
NEW: 101201399
NEW: 101201499
NEW: 101201599
NEW: 101201699
NEW: 101201799
Ok.
Product Option Sync.
Opencart products: 193
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 = 27179
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27179,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101196699 - %'
UPDATE oc_option_value
SET
image = 'catalog/101196699.jpg'
WHERE
option_value_id = 2414
UPDATE oc_option_value_description
SET
name = '101196699 - Tinta da China Talens 490 ml'
WHERE
option_value_id = 2414
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 310
AND product_id = 27179
AND option_id = 15
AND option_value_id = 2414
DELETE FROM oc_product
WHERE
model = '101196699'
INSERT INTO oc_product_option_value
SET
product_option_id = 310,
product_id = 27179,
option_id = 15,
option_value_id = 2414,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101196899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2415
UPDATE oc_option_value_description
SET
name = '101196899 - TELA Winsor & Newton Triangular 40 cm'
WHERE
option_value_id = 2415
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2415
DELETE FROM oc_product
WHERE
model = '101196899'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2415,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27180
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27180,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101198399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2416
UPDATE oc_option_value_description
SET
name = '101198399 - Pincel Talens Lingua de Gato Aguarela S195 N1'
WHERE
option_value_id = 2416
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 311
AND product_id = 27180
AND option_id = 15
AND option_value_id = 2416
DELETE FROM oc_product
WHERE
model = '101198399'
INSERT INTO oc_product_option_value
SET
product_option_id = 311,
product_id = 27180,
option_id = 15,
option_value_id = 2416,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27053
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101199599 - %'
UPDATE oc_option_value
SET
image = 'catalog/101199599.jpg'
WHERE
option_value_id = 2418
UPDATE oc_option_value_description
SET
name = '101199599 - Goma Laca Inart Castanha 250 ml'
WHERE
option_value_id = 2418
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 118
AND product_id = 27053
AND option_id = 15
AND option_value_id = 2418
DELETE FROM oc_product
WHERE
model = '101199599'
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 = 118
AND product_id = 27053
AND option_id = 15
AND option_value_id = 2418
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27152
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101200499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2419
UPDATE oc_option_value_description
SET
name = '101200499 - Médio para Vitral Pébéo Clareador 250 ml'
WHERE
option_value_id = 2419
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 298
AND product_id = 27152
AND option_id = 15
AND option_value_id = 2419
DELETE FROM oc_product
WHERE
model = '101200499'
INSERT INTO oc_product_option_value
SET
product_option_id = 298,
product_id = 27152,
option_id = 15,
option_value_id = 2419,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.