Multi Unit Pricing for Sandpaper

A more detailed explanation of Multi Unit Pricing is shown below. In this example, we will use sandpaper as our inventory item. The store purchases, stocks, and displays the sandpaper as a box of 25 sheets. Within IC | Inventory File, the display unit of measure is located in the top right corner and the stock and purchase units are located near the middle. For the sandpaper inventory item, all three of these fields are set to BX25 (Box of 25).

 

You may want to sell the box, but customers may just want to buy a couple of sheets individually. To set up your system to allow this, click the Prices tab and click on Qty Prices. Click New to create a new quantity break price for this item. Here, you will need to set the sell unit to the unit of measure you want. For our example, we want EA (Each) with a Factor of 1. This will allow for individual sheets to be sold. After the UOM is set, establish the Beginning and Ending Quantity (Beg. Qty of 1 and End Qty of 25 will allow for anywhere from 1 sheet to the entire box of 25 to be sold). Finally, you will need to set the price per unit sold. You can set this to a fixed dollar amount (will not change if retail price of the box is changed) or a percent of retail (will change when retail is changed). Once these options are set, click OK to save the changes.

 

Since this is a new selling unit, the system will ask the lookup number to associate with this Qty Break. If you plan on having a separate ID for individual sheets, input that manually in the "New Item Number" field, otherwise, you can select the existing ID to have it display at Ring Sale when the original ID is scanned/entered in.

 

Now that you have multiple units of measure assigned to this item, your on-hand quantity will appear differently (as long as you have the decimals set to above 0 on the General tab; 2 or 3 is ideal).

 

 If you have one box of 25 sheets, a 1 will be in the on hand field. If a customer walks in and purchases a single sheet, this quantity will be reduced by 1/25 (or 0.04). The resulting on hand will be 24/25 (or 0.96). This will mean you need to alter your minimum and maximum quantities as well. If you want to reorder once you get down to five sheets in a box, enter "0.2" in the Min field. Below shows a sample sale when the ID is scanned. You can see it displays the two options for selling and the resulting On-Hand when only a couple of sheets are sold.