After importing products from CSV in Virtuemart a discount is showed

Submit to reddit

After importing products into Virtuemart using CSV Import a discount is shown being available – although offering the same price as the list price. This happens because no discount id is set in the table. Running the following on the mysql table fixes that:

UPDATE `jos_vm_product` SET `product_discount_id`=0 WHERE 1