Quantity breaks

Donate to this project

Development Project Status: Seeking Funding

Total cost estimate (ex-Tax): 
Due date for completion of this stage: 
Project funding: 

You can donate money to this project by entering the amount above and clicking the 'Add to cart' button. In the Checkout process you can either choose to pay now (via Bank Transfer, Cheque or Pay Pal) or you can pledge the amount by choosing the 'Pledge a payment for a Development Project' method. If you make a pledge, then when we have 100% funding commitments, you will be notified by email and you can then action your payment. Note that development will not commence until all funds are received.

Project description: 

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.


Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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".


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.

Syndicate content