Hardware Store POS: Brand and Model SKUs and Special Orders

To run a hardware store with thousands of SKUs, give every sellable item one unique SKU, build the name the same way every time (brand, line, model, spec, pack size), and keep tool kits, bare tools and batteries as separate items. Then treat special orders as their own process with a deposit, a model number and a deadline, not as a note on a receipt. Do those four things and your counts stay close even with 20,000 items.

This post covers two angles that matter for a power tools and hardware shop: deep SKU lists by brand and model, and special orders. For trade accounts, price tiers and selling by the foot, see our earlier post on hardware store POS and contractor accounts. The advice below is general retail advice first. Where Retailer OS does something about it, I say so, and where it does not, I say that too.

How should a hardware store structure SKUs by brand and model?

A SKU is your own internal code for exactly one sellable item at exactly one pack size, and it should never be reused for something else. Manufacturers change model numbers, retire colors and repack boxes. If your code is tied to the manufacturer number alone, you will end up with two different products under one code the day they change a box from 100 screws to 125.

The fix is a naming pattern that every person follows. A cashier searching at the counter types a fragment, so the most useful words must come first and in the same order every time:

• Brand first, spelled one way. “Brand A,” never “BrandA” in one place and “Brand-A” in another.
• Line or voltage second, such as 20V or 18V, because that is how customers shop for cordless tools.
• Model number third, exactly as printed on the box.
• Spec fourth: size, finish, length, thread.
• Pack last: each, 10-pack, box of 100.

So a drill reads “Brand A 20V DCD-100 Drill/Driver Bare Tool, each,” and a box of screws reads “Brand B Deck Screw #8 x 2-1/2 in. Coated, box of 100.” Ugly, but searchable, and a new hire can find it on day one. Keep the manufacturer number in its own field as well, so a rep’s order sheet can be matched to your catalog without guessing.

Where do barcodes come from?

Most branded goods already carry a UPC. Scan it and you are done. Items without a barcode, like loose hardware, bagged fasteners you pack yourself and cut-to-length goods, need your own label. If you sell your own packaged goods, the barcode standards body at GS1 is where company prefixes come from. Print labels at receiving, not at the register, so the shelf is ready when the stock is.

How do you handle tool batteries, chargers and kits?

Keep the bare tool, the battery, the charger and the kit as four separate items. A kit is a box that holds a tool, two batteries and a charger. It is also usually the best margin on the wall, because the manufacturer prices it below the parts.

Here is why this matters, with simple numbers. Say a drill kit costs you $189.00 and sells for $279.00. That is a gross margin of $90.00, or 32.3%. The same drill as a bare tool costs $79.00 and sells for $119.00, a margin of $40.00, or 33.6%. A spare battery costs $52.00 and sells for $89.00, a margin of $37.00, or 41.6%. Batteries are where the money is, and a customer who buys a bare tool is almost always going to need one.

The trap is opening a kit. A customer wants the drill but not the battery, so a well-meaning employee opens the box and sells the bare tool from the kit stock. Now the kit count is one too high, the bare tool count is one too low, and nobody can explain it at the next count. Set a rule: kits stay sealed. If a kit really must be broken, do it with a stock adjustment and a reason, so the change leaves a record.

• Pick the two or three battery platforms you will stock deeply, and carry only the common sizes for the rest.
• Put chargers and batteries on the wall behind the register or in a locked case. They are small, expensive and easy to take.
• Date-code batteries when they arrive and sell the oldest first.
• Do not mix platforms on one shelf. A customer looking for 18V should not have to read every box.

How do you manage fasteners, plumbing and electrical parts without a mess?

This is the long tail. A single screw can come in six lengths, three finishes and two pack sizes, which is 36 items from one product. Multiply by 200 screw types and the list passes 7,000 before you have added a single pipe fitting.

Decide early how to model this. A variant is one product with options, such as length or finish, where each combination has its own SKU, barcode and count. Use variants when the choices are real options of the same product. Use separate items when the products are different enough that nobody would shop them together. Rules of thumb:

• Same product, different size or finish: one product with variants.
• Same part sold loose and in a box: separate SKUs with their own counts, or one item sold by a unit of measure. Pick one way and write it down.
• Different brand of the same part: separate items, because the cost, the margin and the supplier all differ.

Importing is where most shops get stuck, because the old list is messy. Our CSV prep checklist for importing products walks through cleaning names, units and costs before you load anything. Load your 500 best sellers first, check them, then add the rest by category.

How do you keep a 20,000-item catalog counted and reordered?

You cannot count everything every month, and you do not need to. Sort items by how much money they bring in and count them on different schedules. This is the ABC method:

• A items: the top 20% of SKUs, which usually bring in about 80% of sales. Count monthly.
• B items: the next 30%. Count every quarter.
• C items: the remaining 50%, the slow tail. Count twice a year.

With 20,000 items that is about 4,000 A items. Counting 200 a week gets through them in 20 weeks, so split them by aisle and count the fastest movers first. Our step-by-step physical inventory count guide covers how to run a count and read the variance.

For reordering, use a reorder point. The formula is weekly sales × supplier lead time in weeks, plus a safety margin. A battery that sells 6 a week from a supplier who ships in 2 weeks has a base need of 12. Add 4 as a margin, and you reorder when the shelf and back room hold 16 combined. For slow items that sell once a month, a reorder point of 1 or 2 is enough, and it is better to be out of stock on a $4 part than to tie up cash in a dozen of them.

How should special orders work at a hardware counter?

A special order is an item you do not stock that you order for one customer. The risk is simple: if the customer does not come back, you own a $420 part that nobody else wants. Most hardware shops lose money here not on the margin but on orders that go missing, get ordered twice or sit for months.

Write a policy and print it. A sound one has these parts:

• Take a deposit at the counter: 50% for standard items, 100% for anything the vendor will not take back.
• Write the exact manufacturer model number on the order, and read it back to the customer.
• Record the vendor’s lead time and promise a date that is a few days later than theirs.
• Set a hold limit, such as 14 days after arrival, and state what happens after that.
• Set a restocking fee for returns of special-order items, such as 20%.
• Call or text the customer when it arrives, and mark the date you did.

Here is the math on why the deposit and fee matter. A $420 item on a 50% deposit means you hold $210 up front. If the customer walks and the vendor charges you a 20% return fee of $84, your cost to unwind the order is $84, and you keep the $210 only if your policy says so. With no deposit and no policy, you are out the whole $420 if you cannot return the part. Deposits turn a risk into a decision.

One honest note on the product side. Retailer OS lists special orders and deposits as part of its furniture flow. It does not list them as a hardware feature, so if special orders are central to your shop, ask for that exact flow in a demo before you rely on it. Customer profiles with purchase history, store credit and customer accounts as tenders do exist, and a deposit can be recorded using those tools. Whether that fits your process is a question to settle in the demo. If you want to text customers when an order arrives, texting needs a Messaging & AI plan (Starter is $39.99 a month).

How does Retailer OS handle a deep hardware catalog?

Here is what the product does today for the catalog problems above. It is based on what ships, not on what would be nice.

• Items and variants: SKUs, barcodes, variants in a matrix, units of measure and serial-number tracking, so a drill can carry its serial number when that matters for warranty.
• Imports: CSV import for items, customers and vendors, plus AI-assisted import of other files, and a Shopify move handled by the Retailer OS team. AI-assisted import comes with a Messaging & AI plan.
• Labels and scanning: barcode scanner support and label printing from the catalog.
• Stock control: per-item, per-location stock with a movement ledger. Every sale, transfer, receipt and adjustment leaves a row, so you can see why a count changed.
• Purchasing: purchase orders to vendors, receiving against the PO, cost tracking, and reorder points.
• Counts: stock counts show system, counted and variance side by side. The drawer count at close shows the expected amount, so it is not blind.
• Ordering help: reorder suggestions come with a Messaging & AI plan (from $39.99 a month). Reorder points work without one.
• Offline selling: the desktop app keeps ringing sales when the internet drops and syncs on reconnect. The iOS app has no offline mode.

If you also sell online, the online store is a paid add-on at $99.99 a month and uses the same catalog and stock as the register. Amazon and eBay are each a further $99.99 a month. None of those are needed to run the counter.

What does it cost for a hardware store?

Retailer OS is priced per store and per user seat: $99.99 a month for the store and $9.99 a month for each user. The owner is a seat too, so the smallest bill is $109.98 a month. A shop with an owner, a manager and three counter staff has five seats: 5 × $9.99 = $49.95, plus $99.99 for the store, so $149.94 a month. There is no platform fee and no cut of sales. Card payments run on your own Stripe account, and Stripe bills its processing fees directly. See the pricing page for the full list, or look at the small business POS overview if you run one counter.

What should you ask in a demo?

• Show me how a product with 36 variants is set up and counted.
• Show me what happens in the stock record when a kit is broken open.
• Show me a special order from deposit to pickup, including what happens if the customer does not return.
• Load a 200-row sample of my own item list and show me the result.
• Show me the count screen for one aisle, with the variance.