Product Sync.
Opencart products: 208
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
UPDATING: Tinta para Linóleo
Product ID: 27070
Image file:
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: 208
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 = 27070
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2469
UPDATE oc_option_value_description
SET
name = '101571299 - Tinta Linóleo Ferrario Água 20 ml Nº1 Branco'
WHERE
option_value_id = 2469
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2469
DELETE FROM oc_product
WHERE
model = '101571299'
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 = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2469
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2470
UPDATE oc_option_value_description
SET
name = '101571399 - Tinta Linóleo Ferrario Água 20 ml Nº2 Amarelo'
WHERE
option_value_id = 2470
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2470
DELETE FROM oc_product
WHERE
model = '101571399'
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 = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2470
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2471
UPDATE oc_option_value_description
SET
name = '101571499 - Tinta Linóleo Ferrario Água 20 ml Nº4 Azul'
WHERE
option_value_id = 2471
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2471
DELETE FROM oc_product
WHERE
model = '101571499'
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 = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2471
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2472
UPDATE oc_option_value_description
SET
name = '101571599 - Tinta Linóleo Ferrario Água 20 ml Nº5 Verde'
WHERE
option_value_id = 2472
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2472
DELETE FROM oc_product
WHERE
model = '101571599'
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 = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2472
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2473
UPDATE oc_option_value_description
SET
name = '101571699 - Tinta Linóleo Ferrario Água 20 ml Nº6 Vermelho'
WHERE
option_value_id = 2473
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2473
DELETE FROM oc_product
WHERE
model = '101571699'
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 = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2473
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101571799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2474
UPDATE oc_option_value_description
SET
name = '101571799 - Tinta Linóleo Ferrario Água 20 ml Nº7 Preto'
WHERE
option_value_id = 2474
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2474
DELETE FROM oc_product
WHERE
model = '101571799'
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 = 132
AND product_id = 27070
AND option_id = 15
AND option_value_id = 2474
Ok.