SBS Multi UoM: priced by the unit, box or pallet

Sell the same product by the unit, the box or the pallet. Each packaging unit carries its own ratio and its own price. Odoo keeps the base quantity for stock and procurement, the customer sees the packaging they ordered, and the price they were quoted is frozen onto the document.

A box is not just twelve units. Plenty of businesses sell the same item several ways: a customer buying one cartridge pays the single price, while a customer buying a carton of 144 pays less per cartridge. With this module you set a price per packaging unit once, on the product. The salesperson picks the packaging and the quantity, and Odoo works out the base quantity for stock and the correct price for the document.

A worked example. A cartridge with a list price of 5.00 per unit is configured with its base unit and three packaging units: Units (ratio 1, 5.00 per unit), Pack of 6 (ratio 6, price 27.00, 4.50 per unit), Box of 12 (ratio 12, price 54.00, 4.50 per unit) and Carton of 144 (ratio 144, price 600.00, 4.17 per unit). Ordering 3 Boxes of 12 then produces a line of 36 Units for stock, priced at 54.00 per box, a subtotal of 162.00. Leave a price at zero and that packaging falls back to the ordinary product or pricelist price.

Yesterday's order does not change when today's price does. The ratio and the price in force when a line is written are stored on that line, so documents you have already issued stay exactly as they were and only new lines pick up a new configuration. We checked this on a live database: an order line of 3 Boxes of 12 at 54.00 was written, then the Box configuration was changed to a ratio of 24 and a price of 99.00. The existing line stayed at 36 units and 54.00; a new line on the same order came out at 24 units and 99.00.

The packaging follows the paperwork. On a sales order you enter Multi Qty and Multi UoM; base quantity and price are derived, and discounts and taxes compute from the packaging price through Odoo's own tax pipeline. An invoice created from an order carries the packaging across, with the Multi Qty prorated when you invoice only part of the order. A manual customer invoice converts in both directions and applies the configured packaging price. A vendor bill converts the quantity but leaves your price alone, because the sales ladder is not applied to what a supplier charges you.

The printout shows the packaging, not the base units. A customer who ordered three boxes should see three boxes, not thirty-six units, so the quotation and invoice reports print the Multi Qty and Multi UoM in the quantity column. Products without a Multi UoM print exactly as they always did.

Configuration is checked on the server. A zero or negative ratio is rejected with the message that the Multi UoM ratio must be greater than zero. Adding the same packaging unit twice tells you that this Unit of Measure already exists in the template Multi UoM list. A unit that does not reference the product's base unit tells you that the Multi UoM must use the product's base UoM as its reference unit.

We tested every workflow on this page on a live Odoo 19 Community database. Variant-level configuration on attributed products, multi-company behaviour and pricelist interaction have not been tested yet.