Product Sync.
Opencart products: 181
Input products: 100
NEW: 100979899
NEW: 100979999
NEW: 100980099
NEW: 100980199
NEW: 100980299
NEW: 100980399
NEW: 100980499
NEW: 100980599
NEW: 100980699
NEW: 100980799
NEW: 100980899
NEW: 100980999
NEW: 100981099
NEW: 100981199
NEW: 100981299
NEW: 100981399
NEW: 100981499
NEW: 100981599
NEW: 100981699
NEW: 100981799
NEW: 100981899
NEW: 100981999
NEW: 100982099
NEW: 100982199
NEW: 100982299
NEW: 100982399
NEW: 100982499
NEW: 100982599
NEW: 100982699
NEW: 100982799
NEW: 100982899
NEW: 100982999
NEW: 100983099
NEW: 100983199
NEW: 100983299
NEW: 100983399
NEW: 100983499
NEW: 100983599
NEW: 100983699
NEW: 100983799
NEW: 100983899
NEW: 100983999
NEW: 100984099
NEW: 100984199
NEW: 100984299
NEW: 100984399
NEW: 100984499
NEW: 100984599
NEW: 100984699
NEW: 100984799
NEW: 100984899
NEW: 100984999
NEW: 100985099
NEW: 100985199
NEW: 100985299
NEW: 100985399
NEW: 100985499
NEW: 100985599
NEW: 100985699
NEW: 100985799
NEW: 100985899
NEW: 100985999
NEW: 100986099
NEW: 100986199
NEW: 100986299
NEW: 100986399
NEW: 100986499
NEW: 100986599
NEW: 100986699
NEW: 100986799
NEW: 100986899
NEW: 100986999
NEW: 100987099
NEW: 100987199
NEW: 100987299
NEW: 100987399
NEW: 100987499
NEW: 100987599
NEW: 100987699
UPDATING: Aguarela Líquida Ecoline
Product ID: 27024
Image file:
NEW: 100987899
NEW: 100987999
NEW: 100988099
NEW: 100988199
NEW: 100988299
NEW: 100988399
NEW: 100988499
NEW: 100988599
NEW: 100988699
NEW: 100988799
NEW: 100988899
NEW: 100988999
NEW: 100989099
NEW: 100989199
NEW: Aguarela Winsor & Newton Cotman Pastilha
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Aguarela Winsor & Newton Cotman Pastilha - %'
)
Ok.
Product Option Sync.
Opencart products: 182
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 = 27024
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100987799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 985
UPDATE oc_option_value_description
SET
name = '100987799 - Aguarela Ecoline Talens 25 - 30 ml Ultramarino Escuro 506'
WHERE
option_value_id = 985
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 92
AND product_id = 27024
AND option_id = 15
AND option_value_id = 985
DELETE FROM oc_product
WHERE
model = '100987799'
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 = 92
AND product_id = 27024
AND option_id = 15
AND option_value_id = 985
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 '100989299 - %'
UPDATE oc_option_value
SET
image = 'catalog/100989299.jpg'
WHERE
option_value_id = 980
UPDATE oc_option_value_description
SET
name = '100989299 - Aguarela Winsor & Newton Cotman Pastilha Carmim Alizarina HUE 003'
WHERE
option_value_id = 980
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 = 980
DELETE FROM oc_product
WHERE
model = '100989299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 980,
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 '100989399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 981
UPDATE oc_option_value_description
SET
name = '100989399 - Aguarela Winsor & Newton Cotman Pastilha Siena Queimada 074'
WHERE
option_value_id = 981
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 = 981
DELETE FROM oc_product
WHERE
model = '100989399'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 981,
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 '100989499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 982
UPDATE oc_option_value_description
SET
name = '100989499 - Aguarela Winsor & Newton Cotman Pastilha Terra Sombra Queimada 076'
WHERE
option_value_id = 982
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 = 982
DELETE FROM oc_product
WHERE
model = '100989499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 982,
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 '100989599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 983
UPDATE oc_option_value_description
SET
name = '100989599 - Aguarela Winsor & Newton Cotman Pastilha Laranja Cádmio HUE 090'
WHERE
option_value_id = 983
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 = 983
DELETE FROM oc_product
WHERE
model = '100989599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 983,
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 '100989699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 984
UPDATE oc_option_value_description
SET
name = '100989699 - Aguarela Winsor & Newton Cotman Pastilha Vermelho Cádmio HUE 095'
WHERE
option_value_id = 984
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 = 984
DELETE FROM oc_product
WHERE
model = '100989699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 984,
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 '100989799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 975
UPDATE oc_option_value_description
SET
name = '100989799 - Aguarela Winsor & Newton Cotman Pastilha Vermelho Cádmio Escuro HUE 098'
WHERE
option_value_id = 975
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 = 975
DELETE FROM oc_product
WHERE
model = '100989799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 975,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.