Product Sync.
Opencart products: 101
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: 27478
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: 27489
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: 27464
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: 104
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 = 27499
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27499,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101196699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101196699.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3491 AS option_value_id,
language_id,
17 AS option_id,
'101196699 - Tinta da China Talens 490 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 464
AND product_id = 27499
AND option_id = 17
AND option_value_id = 3491
DELETE FROM oc_product
WHERE
model = '101196699'
INSERT INTO oc_product_option_value
SET
product_option_id = 464,
product_id = 27499,
option_id = 17,
option_value_id = 3491,
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 = 27478
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101196899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3492 AS option_value_id,
language_id,
17 AS option_id,
'101196899 - TELA Winsor & Newton Triangular 40 cm' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3492
DELETE FROM oc_product
WHERE
model = '101196899'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3492,
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 = 27500
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27500,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101198399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3493 AS option_value_id,
language_id,
17 AS option_id,
'101198399 - Pincel Talens Lingua de Gato Aguarela S195 N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 465
AND product_id = 27500
AND option_id = 17
AND option_value_id = 3493
DELETE FROM oc_product
WHERE
model = '101198399'
INSERT INTO oc_product_option_value
SET
product_option_id = 465,
product_id = 27500,
option_id = 17,
option_value_id = 3493,
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 = 27489
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101199599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101199599.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3494 AS option_value_id,
language_id,
17 AS option_id,
'101199599 - Goma Laca Inart Castanha 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 459
AND product_id = 27489
AND option_id = 17
AND option_value_id = 3494
DELETE FROM oc_product
WHERE
model = '101199599'
INSERT INTO oc_product_option_value
SET
product_option_id = 459,
product_id = 27489,
option_id = 17,
option_value_id = 3494,
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 = 27464
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101200499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3495 AS option_value_id,
language_id,
17 AS option_id,
'101200499 - Médio para Vitral Pébéo Clareador 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 442
AND product_id = 27464
AND option_id = 17
AND option_value_id = 3495
DELETE FROM oc_product
WHERE
model = '101200499'
INSERT INTO oc_product_option_value
SET
product_option_id = 442,
product_id = 27464,
option_id = 17,
option_value_id = 3495,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.