product_price

The price for a product without currency denominator. The currency can be set by using the product_currency field.

Notes:

• CSVI VirtueMart will change all commas to periods for correct database insertion.
• If this field is left empty or is not numeric, the price will be deleted. This will show the “Call for pricing”. No discounts should exist for the product otherwise discount is still shown.
• Price will be updated if both product_sku and shopper_group_name already exist in the price table.

• Decimal

Calculations:

• Add (+)
• Subtract (-)
• Divide (/)
• Multiply (*)

Add and subtract support percentages

20.49

23456.78

+10%

-3

/2

*1.5