Inventory · 25 July 2026
How to Track Stock Purchased in Boxes and Sold in Units
Explain carton-to-piece inventory for wholesale businesses, including purchase conversion, stock value, and reorder signals.
Wholesalers rarely buy the way they sell. A publisher ships 20 cartons; a bookshop orders 12 copies. An FMCG supplier delivers boxes; the counter sells pieces. If your system only understands one unit of measure, someone maintains a conversion column in Excel — and that column drifts.
Define the conversion once
For each product, decide how many sellable units sit in one box or carton. Example: 1 box = 24 units. Purchases entered as boxes should increase stock by boxes × units per box. Sales entered as units should reduce the same stock pool. Everyone — sales and warehouse — should see available units (and boxes if that helps packing).
Keep purchase history tied to cost
When goods arrive, record the supplier purchase with quantity and cost. That history supports inventory value at average cost and answers “when did we last buy this?” when you negotiate or reorder. Operational inventory value is not a substitute for a full accountant’s valuation, but it stops you flying blind.
Use low stock as a reorder signal
Software will not magically know your lead times unless you configure them carefully. What it can do is show products that are low relative to how you sell, so you reorder before a stockout. Treat recommendations as decision support, not autopilot.
How ProDistro approaches this
ProDistro’s wholesale inventory software tracks stock availability, low-stock alerts, unit and box inventory, purchase history, and inventory value. Book distributors use the same pattern for titles that arrive in cartons — see book distribution software in Pakistan. Batch and expiry workflows are for pharma setups when enabled; they are not required for general wholesale or books.
Related: moving from Excel · distribution management overview.
How do you record a carton purchase and a piece sale?
Wholesale stock breaks when the purchase is written in cartons and the sale is written in pieces, and nobody agreed how many pieces are in the carton. Define that number once on the product. A purchase of four cartons adds four times that number to the quantity on hand. A sale of six pieces subtracts six. The warehouse can still talk in cartons. The ledger stays in the unit you sell. If you keep a carton column and a piece column and add them by eye, you will double-count an open carton by the afternoon.
Do this before you load opening stock. Count what you have in the selling unit, including open cartons, and enter that quantity. Do not enter “20 cartons” in a field that means pieces, and do not enter pieces in a field that means cartons. The first wrong opening figure makes every later sale look like the software lost stock. If you discover the pack size was wrong after a few invoices, fix the product and recount. Do not keep selling on a conversion you know is false.
The same rule covers books that arrive in cartons and leave as copies, and general goods that arrive in cases and leave as units. Medicine adds strips and batches on top of this. General wholesale does not need an expiry field to need a pack size. Turn on batches only for the products that have them.
Where does the cost of one piece come from?
The supplier bill is usually for a carton. The sale is for a piece. Cost per piece is the carton cost divided by the pieces in the carton, using the same pack size as the stock conversion. If those two numbers differ, your margin on the invoice is a guess. Keep the purchase attached to the product so you can see what you last paid, and do not maintain a second cost in a sheet that the invoice never reads.
Stock value is that cost times the quantity on hand in the selling unit. It will be wrong if the quantity is wrong, which is why the weekly check is a count, not a new formula. Pick a handful of fast products, count pieces, and compare. A difference of exactly one carton means a receipt or a sale used the wrong unit. Post the correction as the transaction you missed. Overwriting the quantity hides the miss and it will happen again on the next busy day.
When is the on-hand figure a reason to buy more?
Buy when the selling-unit quantity is low relative to what you actually sell, and when you are not already holding a pile of the same product from the last receipt. A low-stock line is a prompt, not an order. Look at the last purchase and at what is still unsold before you repeat it. For products with an expiry, look at the date as well. Reordering a short-dated item because the carton count looks small is how you add a second pile next to the first.
On the sales screen, the person typing should see that a piece sale will reduce pieces, and that a carton sale will reduce a carton worth of pieces. They should not need a calculator taped to the monitor. If the software asks them to convert in their head, you still have the spreadsheet problem, with an extra login.
The landing page for this is inventory software for wholesalers. The medicine-specific pack sizes are on carton, box, strip, and unit stock.
How do you open a carton without losing the count?
Opening a carton is not a stock movement if the carton was already in the on-hand quantity as pieces. You are only changing where the pieces sit. Do not receive the carton again when you break it open, and do not issue a second adjustment that subtracts a carton and adds pieces. That double entry is the usual reason a correct pack size still will not match the shelf. The purchase already added the pieces. Breaking the seal is a warehouse fact, not a second receipt.
Tell the person who sells loose pieces to sell pieces, and the person who sells full cartons to sell cartons, both against the same product. If they keep a side tally of “open carton, six left” on paper, that tally will diverge the moment someone else sells two of those six. The side tally is the spreadsheet returning. The screen should be the place they look before they promise a carton to the next customer.
When the count is off, fix the oldest missing transaction you can find: a van sale not posted, a return not posted, a purchase entered as pieces when the bill said cartons. Then recount. Adjusting the quantity to match the shelf without that search makes today look right and tomorrow wrong by the same missed invoice. The pack size is innocent until you have checked the transactions that were supposed to use it.
Tell the next person who receives a delivery to say the unit out loud before they save: cartons on the bill, pieces in the system, and the number of pieces that should be added. If they cannot say that number without a calculator, the pack size on the product is missing or wrong. Fix it before the second bill of the day, not after the shelf count at the end of the month. A carton purchase that lands as pieces is the whole point of the conversion.