Product Sync.
Opencart products: 343
Input products: 100
NEW: 475376499
NEW: 475376599
NEW: 475376699
NEW: 475376799
NEW: 475376899
NEW: 475376999
NEW: 475377099
NEW: 475377199
NEW: 475377299
NEW: 475377399
NEW: 475377499
NEW: 475377599
NEW: 475377699
NEW: 475377799
NEW: 475377899
NEW: 475377999
NEW: 475378099
NEW: 475378199
NEW: 475378299
NEW: 475378399
NEW: 475378499
NEW: 475378599
NEW: 475378699
NEW: 475378799
NEW: 475378899
NEW: 475378999
NEW: 475379099
NEW: 475379199
NEW: 475379299
NEW: 475379399
NEW: 475379499
NEW: 475379599
NEW: 475379699
NEW: 475379799
NEW: 475379899
NEW: 475379999
NEW: 475380099
NEW: 475380199
NEW: 475380299
NEW: 475380399
NEW: 475380499
NEW: 475380599
NEW: 475380699
NEW: 475380799
NEW: 475380899
NEW: 475380999
NEW: 475381099
NEW: 475381199
NEW: 475381299
NEW: 475381399
NEW: 475381499
NEW: 475381599
NEW: 475381699
NEW: 475381799
NEW: 475381899
NEW: 475381999
NEW: 475382099
NEW: 475382199
NEW: 475382299
NEW: 475407799
NEW: 475500639
NEW: 475601599
NEW: 475605199
NEW: 475606099
NEW: 475900999
NEW: 475901599
NEW: 475904999
NEW: 477101799
NEW: 477103599
NEW: 477103699
NEW: 477103799
NEW: 477109099
NEW: 477109199
NEW: 477120299
NEW: 478000699
UPDATING: Terebentina Rectificada Talens
Product ID: 27310
Image file:
NEW: 478800299
NEW: 478800399
NEW: 478800499
NEW: 478800699
NEW: Terebentina Winsor & Newton 75 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Terebentina Winsor & Newton 75 ml - %'
)
NEW: 478800999
NEW: 479201699
NEW: 479203420
NEW: 479205099
NEW: 479205420
NEW: 479206799
NEW: 479299199
NEW: 479299299
NEW: 479299399
NEW: 479300099
NEW: 479300199
NEW: 479300299
NEW: 479501099
NEW: 479501199
NEW: 479501299
NEW: 479501599
UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 26999
Image file:
Ok.
Product Option Sync.
Opencart products: 344
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 = 27310
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '478800198 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2888
UPDATE oc_option_value_description
SET
name = '478800198 - Terebentina Rectificada Talens 250 ml'
WHERE
option_value_id = 2888
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 355
AND product_id = 27310
AND option_id = 15
AND option_value_id = 2888
DELETE FROM oc_product
WHERE
model = '478800198'
INSERT INTO oc_product_option_value
SET
product_option_id = 355,
product_id = 27310,
option_id = 15,
option_value_id = 2888,
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 '478800899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2889
UPDATE oc_option_value_description
SET
name = '478800899 - Terebentina Rectificada Talens 1000 ml'
WHERE
option_value_id = 2889
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 355
AND product_id = 27310
AND option_id = 15
AND option_value_id = 2889
DELETE FROM oc_product
WHERE
model = '478800899'
INSERT INTO oc_product_option_value
SET
product_option_id = 355,
product_id = 27310,
option_id = 15,
option_value_id = 2889,
quantity = 1,
subtract = 1,
price = 15.772,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
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 '478800799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2890
UPDATE oc_option_value_description
SET
name = '478800799 - Terebentina Winsor & Newton 75 ml'
WHERE
option_value_id = 2890
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 = 2890
DELETE FROM oc_product
WHERE
model = '478800799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2890,
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 = 26999
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479801999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479801999.jpg'
WHERE
option_value_id = 1331
UPDATE oc_option_value_description
SET
name = '479801999 - Acrílico Amsterdam 120 ml Branco Zinco 104'
WHERE
option_value_id = 1331
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1331
DELETE FROM oc_product
WHERE
model = '479801999'
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1331
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479802299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479802299.jpg'
WHERE
option_value_id = 1211
UPDATE oc_option_value_description
SET
name = '479802299 - Acrílico Amsterdam 120 ml Amarelo Nápoles Escuro 223'
WHERE
option_value_id = 1211
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1211
DELETE FROM oc_product
WHERE
model = '479802299'
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1211
Ok.