Rounding Prices


Chapter Topics
Rounding the List Price
Rounding Prices in a Price List

Rounding your prices is one of the oldest tricks in the retail playbook. It is incredible how many shoppers believe an item is costing them $12 instead of $13 when they see the price tag with $12.99 on it. XpertMart gives you the tools you need so that this price rounding occurs automatically.

There are basically two places where you can setup price rounding, depending on whether you want to round the List Price of items or whether you are rounding the prices of a specific price list. Since you can sell at List Price or you can sell at the price appearing on a given price list you might want to use both methods. Even if you don't sell at List Price some retailers like to print these prices out and display them (so they can show their customers how much they are saving) so you may want to round your List Prices even if you don't use them for Transactions.

Rounding the List Price
If you want to round List Prices, open the Configure>Inventory Configure Menu and select the List Prices tab. Enter the amount you want XpertMart to automatically deduct from your List Prices. In the example below, XpertMart will subtract $0.01 from every price, turning $13.00 into $12.99. However, note that the rounding you set here will only cause take effect when you do a mass price change to the Styles List Price via Processes>Prices and Costs>Change Style Price or Cost. (If the only change you want to make to your List Prices is the rounding then simply use a multiplication factor of 1 to make sure nothing else is changed).


If you have selected the "Use Price w/Vat" checkbox then the system will round to the unit specified the List Price with VAT. If you have not selected this checkbox then it will round the List Price before tax.


Rounding Prices in a Price List
If you want to round the prices in the Prices Catalog of a specific price list, use the "Round To" and "Round Adjust" fields in the catalog. You have to enter these values individually into each record in the catalog or use the Replace Where function to set these values for multiple records at once.

When the Update Prices process is run (and only then), XpertMart will round the prices as per these values. The system rounds the price off to an even unit specified in "Round To" field. Then it subtracts from this rounded price the "Round Adjust"  amount. If you are setup (for that particular price list) to use VAT the system will round the Price with VAT, otherwise it will round the price before VAT or tax.


Example1: If you set the Round To value at $1.00 and the Round Adjust value to $0.02 then all of your prices will end in $.99 ($1.00 - $0.02 = $0.99). Your prices will be $12.99, $29.99, and so on.


Example 2: If you set the Round To value at $0.50 and the Round Adjust value to $0.01 then all of your prices will end in $.49 or $.99 ($0.50 - $0.01 = .49 or .99). Your prices will be $12.49, $23.99, and so on.


This is the formula that XpertMart uses internall for the rounding:

    Price that is being rounded + ("Round To" value / 2)

So if the price that is being rounded is $12.56 and the "Round To" value is $1.00 then the price becomes $13.06. XpertMartthen drops the fractional part and it becomes $13.00. Finally, it subtract the amoun in the "Round Adjust" field.

Copyright © 2002 XpertMart

* Return to Table of Contents*