Stock control for electrical shops: item codes, counts and accountability

An electrical shop is not a simple inventory. Cable is sold by the metre, breakers by rating and pole, sockets by type and finish, and fittings that look alike can carry different ratings. A stock record that treats all of them as “electrical items” will drift from the shelf within a week.

The aim of stock control is not a perfect spreadsheet. It is a record that answers three questions quickly: what is here, where is it, and who moved it?

Give every item a stable code

Start with a code that does not change when the price changes or the supplier changes. A category prefix, a short description and a variant is enough: for example, a breaker code that records the rating and the pole count, or a cable code that records the conductor size and the length unit.

Record the unit of measure with the code. Cable may be stocked in rolls and sold in metres. A code that does not state the unit invites a costly conversion error.

• One code per sellable variant, not one code per supplier invoice line.
• A description a new staff member can match to the shelf.
• A unit of measure and, where relevant, the pack size.
• A reorder level based on normal sales, not on a guess.

Record stock at receiving

When goods arrive, count them before they reach the shelf. Record the supplier, the invoice or delivery note, the quantity received, the cost and any shortage or damage. If the count happens later, the delivery and the shelf become two separate stories.

Where the same item comes from two suppliers at different costs, keep the cost attached to the receipt. A single average cost hides which supplier is actually cheaper.

Give every location a name

A shop floor, a store room and a second branch are different locations. Transfers between them should be recorded as transfers, not as a sale and a purchase. Otherwise the total stock looks correct while each location is wrong.

Update the record at the point of sale

A stock record updated at the end of the day depends on someone remembering every sale. Update at the moment of sale, even if the update is a simple entry on a phone or a till. The closer the record is to the transaction, the smaller the gap at closing.

For items sold by length or partial quantity, record the quantity sold rather than the number of pieces. A roll of cable that leaves the store should reduce the metres, not the roll count.

Control prices from one place

Decide who may change a price. Record the old price, the new price, the date and the person who approved it. This is not bureaucracy; it is the difference between a discount and an unexplained margin loss.

Keep a current price list where staff can see it. If a price is negotiated for a customer, record the reason and the approver.

Make cash accountable by shift

At the start of a shift, record the opening float. At the end, count the cash and compare it with sales, refunds and any expenses paid from the till. The person responsible should sign or confirm the closing figure.

A difference is information. Record it, explain it and look for a pattern. Punishing every small difference without investigating it teaches staff to hide differences instead of reporting them.

Count in cycles

1. 01

   Weekly sample count

   Count a rotating selection of high-value or fast-moving categories. Compare the count with the record and investigate the largest differences first.

2. 02

   Monthly category count

   Count one full category, such as breakers or sockets. This catches mis-picks and units errors without stopping the whole shop.

3. 03

   Full count

   Do a complete count less often, with a clear cut-off: no sales or transfers while the count is open, or a documented way to adjust for them.

Common stock-control mistakes

• Using the supplier's description as the item name, so the same item appears under several names.
• Recording only quantity and not location.
• Treating a transfer as a sale.
• Allowing price changes without a record.
• Counting stock without stopping movement, then adjusting the record to match the count.
• Keeping the stock record in one person's memory.

The measure of a stock system is not how much it records. It is whether a staff member can find the truth in it during a busy day, and whether the owner can trust the number without standing in the shop.