Product Sync.
Opencart products: 120
Input products: 100
NEW: 101565499
NEW: 101565599
NEW: 101565699
NEW: 101565799
NEW: 101565899
NEW: 101565999
NEW: 101566099
NEW: 101566199
NEW: 101566299
NEW: 101566399
NEW: 101566499
NEW: 101566599
NEW: 101566699
NEW: 101566799
NEW: 101566899
NEW: 101566999
NEW: 101567099
NEW: 101567199
NEW: 101567299
NEW: 101567399
NEW: 101567499
NEW: 101567599
NEW: 101567699
NEW: 101567799
NEW: 101567899
NEW: 101567999
NEW: 101568099
NEW: 101568199
NEW: 101568299
NEW: 101568399
NEW: 101568499
NEW: 101568599
NEW: 101568699
NEW: 101568799
NEW: 101568899
NEW: 101568999
NEW: 101569099
NEW: 101569199
NEW: 101569299
NEW: 101569399
NEW: 101569499
NEW: 101569599
NEW: 101569699
NEW: 101569799
NEW: 101569899
NEW: 101569999
NEW: 101570099
NEW: 101570199
NEW: 101570299
NEW: 101570399
NEW: 101570499
NEW: 101570599
NEW: 101570699
NEW: 101570799
NEW: 101570899
NEW: 101570999
NEW: 101571099
NEW: 101571199
NEW: Tinta para Linóleo
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta para Linóleo - %'
)
NEW: 101571899
NEW: 101571999
NEW: 101572099
NEW: 101572199
NEW: 101572299
NEW: 101572399
NEW: 101572499
NEW: 101572599
NEW: 101572699
NEW: 101572799
NEW: 101572899
NEW: 101572999
NEW: 101573099
NEW: 101573199
NEW: 101573299
NEW: 101573399
NEW: 101573499
NEW: 101573599
NEW: 101573699
NEW: 101573799
NEW: 101573899
NEW: 101573999
NEW: 101574099
NEW: 101574199
NEW: 101574299
NEW: 101574399
NEW: 101574499
NEW: 101574599
NEW: 101574699
NEW: 101574799
NEW: 101574899
NEW: 101574999
NEW: 101575099
NEW: 101575199
NEW: 101575299
NEW: 101575399
Ok.
Product Option Sync.
Opencart products: 121
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 = 27518
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27518,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3542 AS option_value_id,
language_id,
17 AS option_id,
'101571299 - Tinta Linóleo Ferrario Água 20 ml Nº1 Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3542
DELETE FROM oc_product
WHERE
model = '101571299'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3542,
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 '101571399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3543 AS option_value_id,
language_id,
17 AS option_id,
'101571399 - Tinta Linóleo Ferrario Água 20 ml Nº2 Amarelo' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3543
DELETE FROM oc_product
WHERE
model = '101571399'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3543,
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 '101571499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3544 AS option_value_id,
language_id,
17 AS option_id,
'101571499 - Tinta Linóleo Ferrario Água 20 ml Nº4 Azul' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3544
DELETE FROM oc_product
WHERE
model = '101571499'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3544,
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 '101571599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3545 AS option_value_id,
language_id,
17 AS option_id,
'101571599 - Tinta Linóleo Ferrario Água 20 ml Nº5 Verde' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3545
DELETE FROM oc_product
WHERE
model = '101571599'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3545,
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 '101571699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3546 AS option_value_id,
language_id,
17 AS option_id,
'101571699 - Tinta Linóleo Ferrario Água 20 ml Nº6 Vermelho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3546
DELETE FROM oc_product
WHERE
model = '101571699'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3546,
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 '101571799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3547 AS option_value_id,
language_id,
17 AS option_id,
'101571799 - Tinta Linóleo Ferrario Água 20 ml Nº7 Preto' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 475
AND product_id = 27518
AND option_id = 17
AND option_value_id = 3547
DELETE FROM oc_product
WHERE
model = '101571799'
INSERT INTO oc_product_option_value
SET
product_option_id = 475,
product_id = 27518,
option_id = 17,
option_value_id = 3547,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.