Product Sync.
Opencart products: 121
Input products: 100
NEW: 101585699
NEW: 101585799
NEW: 101585899
NEW: 101585999
NEW: 101586099
NEW: 101586199
NEW: 101586299
NEW: 101586399
NEW: 101586499
NEW: 101586599
NEW: 101586699
NEW: 101586799
NEW: 101586899
NEW: 101586999
NEW: 101587099
NEW: 101587199
NEW: 101587299
NEW: 101587399
NEW: 101587499
NEW: 101587599
NEW: 101587699
NEW: 101587799
NEW: 101587899
NEW: 101587999
NEW: 101588099
NEW: 101588199
NEW: 101588299
NEW: 101588399
NEW: 101588499
NEW: 101588599
NEW: 101588699
NEW: 101588799
NEW: 101588899
NEW: 101588999
NEW: 101589099
NEW: 101589199
NEW: 101589299
NEW: 101589399
NEW: 101589499
NEW: 101589599
NEW: 101589699
NEW: 101589799
NEW: Bloco para Acrílico e Óleo Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco para Acrílico e Óleo Talens - %'
)
NEW: Bloco para Acrílico Van Gogh
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco para Acrílico Van Gogh - %'
)
NEW: Bloco para Aguarela Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco para Aguarela Talens - %'
)
NEW: 101590499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101590499 - %'
)
NEW: 101590599
NEW: 101590699
NEW: 101590799
NEW: 101590899
NEW: 101590999
NEW: 101591099
NEW: 101591199
NEW: 101591299
NEW: 101591399
NEW: 101591499
NEW: 101591599
NEW: 101591699
NEW: 101591799
NEW: 101591899
NEW: 101591999
NEW: 101592099
NEW: 101592199
NEW: 101592299
NEW: 101592399
NEW: 101592499
NEW: 101592599
NEW: 101592699
NEW: 101592799
NEW: 101592899
NEW: 101592999
NEW: 101593099
NEW: 101593199
NEW: 101593299
NEW: 101593399
NEW: 101593499
NEW: 101593599
NEW: 101593699
NEW: 101593799
NEW: 101593899
NEW: 101593999
NEW: 101594099
NEW: 101594199
NEW: 101594299
NEW: 101594399
NEW: 101594499
NEW: 101594599
NEW: 101594699
NEW: 101594799
NEW: 101594899
NEW: 101594999
NEW: 101595099
NEW: 101595199
NEW: 101595299
NEW: 101595399
NEW: 101595499
NEW: 101595599
Ok.
Product Option Sync.
Opencart products: 125
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 = 27519
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27519,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101589899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101589899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3548 AS option_value_id,
language_id,
17 AS option_id,
'101589899 - Bloco para Óleo Van Gogh 24 x 32 240 gr 10 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 476
AND product_id = 27519
AND option_id = 17
AND option_value_id = 3548
DELETE FROM oc_product
WHERE
model = '101589899'
INSERT INTO oc_product_option_value
SET
product_option_id = 476,
product_id = 27519,
option_id = 17,
option_value_id = 3548,
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 '101589999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3549 AS option_value_id,
language_id,
17 AS option_id,
'101589999 - Bloco para Óleo Van Gogh 30 x 40 240 gr 10 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 476
AND product_id = 27519
AND option_id = 17
AND option_value_id = 3549
DELETE FROM oc_product
WHERE
model = '101589999'
INSERT INTO oc_product_option_value
SET
product_option_id = 476,
product_id = 27519,
option_id = 17,
option_value_id = 3549,
quantity = 1,
subtract = 1,
price = 3.292,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27520
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27520,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101590099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101590099.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3550 AS option_value_id,
language_id,
17 AS option_id,
'101590099 - Bloco para Acrílico Van Gogh 24 X30 370 gr 10 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 477
AND product_id = 27520
AND option_id = 17
AND option_value_id = 3550
DELETE FROM oc_product
WHERE
model = '101590099'
INSERT INTO oc_product_option_value
SET
product_option_id = 477,
product_id = 27520,
option_id = 17,
option_value_id = 3550,
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 '101590199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3551 AS option_value_id,
language_id,
17 AS option_id,
'101590199 - Bloco para Acrílico Van Gogh 30X40 370GR 10FLS' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 477
AND product_id = 27520
AND option_id = 17
AND option_value_id = 3551
DELETE FROM oc_product
WHERE
model = '101590199'
INSERT INTO oc_product_option_value
SET
product_option_id = 477,
product_id = 27520,
option_id = 17,
option_value_id = 3551,
quantity = 1,
subtract = 1,
price = 3.333,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27521
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27521,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101590299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/101590299.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3552 AS option_value_id,
language_id,
17 AS option_id,
'101590299 - Bloco para Aguarela Van Gogh 10,5 x 15 200 gr 20 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 478
AND product_id = 27521
AND option_id = 17
AND option_value_id = 3552
DELETE FROM oc_product
WHERE
model = '101590299'
INSERT INTO oc_product_option_value
SET
product_option_id = 478,
product_id = 27521,
option_id = 17,
option_value_id = 3552,
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 '101590399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3553 AS option_value_id,
language_id,
17 AS option_id,
'101590399 - Bloco para Aguarela Van Gogh 24 x 32 200 gr 20 Fls' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 478
AND product_id = 27521
AND option_id = 17
AND option_value_id = 3553
DELETE FROM oc_product
WHERE
model = '101590399'
INSERT INTO oc_product_option_value
SET
product_option_id = 478,
product_id = 27521,
option_id = 17,
option_value_id = 3553,
quantity = 1,
subtract = 1,
price = 4.472,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.