Multiple Unit Billing in a Hardware Shop: Rod, Cement, Pipe

To bill hardware items correctly you need one base unit per product, a conversion to each other unit you sell in and a rule for rounding. Once those three are defined, stock stays correct whether you buy rod by the kilogram and sell it by the piece, or buy pipe by the length and sell it by the foot. Most hardware stock errors come from skipping this step.

The problem in plain terms

A supplier invoices you in kilograms. A mason asks for six pieces. Another customer wants a length cut from a pipe. Your notebook says one thing, the godown says another and by month end the difference is unexplained. The cause is not theft or carelessness. It is that the shop uses several units but the record uses one, with mental conversion in between.

Step 1: Choose a base unit

The base unit is the smallest unit in which you want stock counted. Choose it so that all other units are whole multiples or reliable conversions. For example:

Product	Typical base unit	Other units sold
Cement	Bag	Half bag, truckload (many bags)
Steel rod	Kilogram	Piece, bundle
PVC or GI pipe	Foot or metre	Full length
Electrical wire	Metre	Coil
Nails and screws	Piece or gram	Packet, kilogram
Paint	Litre	Tin of fixed size

This table is a starting point. Your own choice depends on how you buy and count.

Step 2: Define each conversion

For every product, write how one unit relates to another. Examples of the type of rule, not fixed figures:

• One bundle of a given rod size equals a stated number of pieces.
• One piece of that rod weighs a stated amount, and the weight differs by size and manufacturer.
• One full length of pipe equals a number of feet.
• One coil of wire equals a number of metres.

Take the figures from the supplier's specification or from a measured sample, and write them down. Avoid copying numbers from memory. If suppliers vary, create separate products by brand rather than forcing one conversion on both.

Step 3: Decide the rounding rule

Real weights are not exact. If a bundle is listed at a nominal weight but actually varies, decide how the shop treats the difference. Common choices are billing on actual scale weight for heavy items and on nominal count for small items. Whichever you choose, apply it consistently and make sure the person who weighs is the one who records.

Step 4: Purchase in the supplier's unit, sell in the customer's unit

At purchase, enter the quantity as invoiced, in the supplier's unit. The system converts to the base unit. At sale, choose the unit the customer asked for. The same stock reduces by the equivalent base quantity. In this way, the godown figure stays truthful.

1. Receive rod in kilograms from the supplier bill.
2. Sell six pieces to a mason.
3. Check that the stock in kilograms reduced by six pieces' weight.
4. Sell a full bundle to a contractor and check again.

Step 5: Set different prices per unit if needed

Some shops charge a slightly higher rate when a customer breaks a bundle or cuts a pipe. Price per unit should be a rate you set, not only a mathematical conversion. Allow for it in the rate list so staff do not improvise.

Step 6: Count in the unit that makes sense

During stock count, staff should count in the unit that matches the shelf: bags of cement, bundles of rod, lengths of pipe. The system converts the count to the base unit for comparison. This avoids asking staff to do arithmetic at the shelf.

Common mistakes

• Creating separate products for the same item in two units, so stock splits and never reconciles.
• Using one conversion for all sizes of rod.
• Forgetting that cut-offs and wastage exist. Decide how to record offcuts, for example as a write-off or as a separate offcut item.
• Letting counter staff change conversions. Restrict this to the owner or manager.
• Not updating conversions when a supplier changes packing.

Worked example of a conversion setup

Take a rod product, set up for illustration only. The base unit is kilogram. The supplier invoices in kilograms, so purchases enter directly. Customers ask in pieces, so you define "piece" with a weight taken from a measured sample or the manufacturer's specification, and "bundle" as a stated number of pieces. When a mason buys six pieces, the system reduces stock by six times the piece weight and prints "6 pcs" on the bill. When a contractor buys a bundle, the same stock reduces by the bundle's weight.

Now suppose a physical count finds the weight on the scale differs a little from the record. That is normal for steel, since manufacturing tolerances exist. Decide a tolerance, such as investigating differences above a small percentage, and write it into your stock policy. Differences within tolerance can be adjusted at month end with a note; larger ones deserve a search for the cause. Without such a rule, every small variance becomes an argument.

Wastage and breakage

Hardware has natural losses: broken tiles, bent pipes, spilled paint. Record them as breakage with a reason and date, so stock matches reality and you can see which products lose most. If one supplier's tiles break more often, you have evidence for a conversation or a change.

Software support

WebsNP Hardware Shop Software stores a base unit, alternative units and conversions per product, converts at purchase and sale, and shows stock in the unit you prefer. The same idea helps in building materials software, where deliveries can be by truck or trip. For shops that need thorough stock rules across rooms, inventory management software adds multi-godown control.

Next step

Choose ten products that confuse your staff and write the base unit, other units and conversion for each. Bring the list to a demo and ask us to set them up live. Message WebsNP on WhatsApp at +977 9846280400.

Get a demo and quote for Hardware Shop Software

Tell us about your business and we will reply the same working day with a demo and a clear quote. No obligation.

Chat on WhatsApp

Or call / WhatsApp +977 9846280400

Your name Phone / WhatsApp Email (optional) Business / organisation What do you need?

Request demo

More guides on Hardware Shop Software