Quantity breaks
Donate to this project
Development Project Status: Seeking Funding
Support for quantity breaks will enable separate pricing for products, based on the quantity purchased.
This can be used to give customers a discount for buying multiple items.
At its simplest, quantity breaks involves setting a unit price that applies to a range of quantities e.g.:
| Quantity | Unit Price |
| >= 1 | 0.50 |
| >= 10 | 0.40 |
| >= 25 | 0.30 |
| >= 50 | 0.20 |
In the above, quantities 1-9 are charged at $0.50, and 10-24 are charged at $0.40 and so on.
User Interface Changes
To support quantity breaks, product editing will be changed to:
- order unit prices based on date and increasing quantity
- prevent entry of unit prices that have identical quantities for a given date range
- require a unit price with a quantity of 1 for the current date
Charging and Estimates changes
During charging and estimates, product unit prices will be selected based on the charge/estimate date, and the product quantity.
Product Import/Export
The Product Import/Export support needs to be updated to:
- support importing multiple unit prices with different quantities
- export unit prices ordered on date and increasing quantity
Archetype Changes
The productPrice.unitPrice archetype has an unused quantity node that will be changed to:
- be mandatory
- default to 1
Data Migration
If a productPrice.unitPrice has an existing value for quantity, this will need to be set to 1.
Comments
Re: Quantity breaks
Would it also be possible to set default numbers or volumes. For example, default to 100 tablets for Vetmedin, or 30 tablets for Incurin or Clomicalm. Would simplify how products are sold and avoid loosing money when a bottle of Vetmedin is sold for one tablet.
Happy to help fund
Ralph Hudson
Re: Quantity breaks
The product Selling Units are supposed to help avoid this. When a product is invoiced, its selling units are displayed along side the product quantity.
Where you sell individual tablets, the product's Selling Units should be set to "Tablets". If you normally sell by the box, then you would set the Selling Units to "Box".
-Tim
Re: Quantity breaks
Thanks for that Tim,
we use those, but staff still make mistakes when entering stoc orders and so we still have problems from time to time.
Setting a default number of tablets would get around this. I keep checking these drugs to correct them. Staff get confused at times as to whether the drug needs to be entered as a bottle or tablet, even if the unit says bottle, they don't always notice and sometimes it is cut off by the screen size.
So would still think it would be a great addition.
Re: Quantity breaks
sell them by the bottle. Problem solved.
Re: Quantity breaks
You would think so, even when you tell staff that certain products must be entered by the bottle, they forget, or as they enter the new stock order change it back to by the tablet or ml because that is how most products are entered.
It would still be much better to have a uniform method of entering stock but have a quantity break so mistakes are less likely to happen. That's been my experience.