Hardware shops going online: what to list first when you stock thousands of items

Much of what a neighbourhood hardware counter sells is a short list asked for again and again: a 6-inch tower bolt, Teflon tape, a tap washer, wall plugs. Your online store has to answer those requests, and four thousand listings will not help. Start with the twenty or so items your counter is asked for most, photographed, named the way customers say them, with a clear delivery radius. Put those on your own site, your Google Business Profile and a WhatsApp catalogue. Add the rest in groups as you photograph them, and keep bulky and mixed-to-order goods off the site until the first twenty work.

Why the whole inventory is the wrong place to start

Your billing software holds every item, but its names were written for the person making the bill. "TB SS 6 GLD." "ELB 1/2 CPVC." A customer types "tower bolt" or "half-inch elbow" and finds nothing. Upload the full list and you have a site that only your staff can search.

Then there are the photographs. A hardware listing without a picture is a guess. The customer cannot tell a 4-inch hinge from a 3-inch one, or the brass finish from the steel, and will ring the shop to ask. At that point the website has saved nobody any time.

And stock. Four thousand listings means four thousand counts to keep right. Show one item "in stock" that went last Tuesday, and the customer stops believing the site. Twenty items you can keep honest.

Pick the first twenty at the counter

Your best data is not in the computer. It is at the counter, in what people ask for. Keep a sheet beside the billing desk for two weeks and put a stroke against every request, including phone calls and WhatsApp messages. Note what you did not have, too. An illustrative fortnight in a residential area might look like this:

ASKED FOR                                  STROKES       HAD IT?
Tower bolt, 6 inch, steel                  ||||| ||||     yes
Teflon tape                                ||||| |||      yes
Wall plugs with screws, 6 mm               ||||| ||       yes
Tap washer set                             ||||| |        yes
CPVC elbow, half inch                      ||||| |        yes
Door stopper                               |||||          yes
Aldrop, 10 inch                            ||||           ran out
Padlock, 50 mm                             ||||           yes
Epoxy putty                                |||            yes
Mixer tap cartridge                        |||            "bring the old one"

Your list will differ. A shop near new construction will see more anchors, bits and cutting discs. One in an older area will see more tap washers, hose clips and hinges for wardrobes that have sagged.

Before an item goes online, put four questions to it, in this order, and stop at the first no.

Can a customer choose it without your advice? A tower bolt, yes. A mixer tap cartridge, no; there are dozens, and you match them by eye. Items that fail here get a "send us a photo of the old part" button on WhatsApp instead of a listing.

Does it fit on a two-wheeler? Wall plugs, yes. Full-length pipes and cement bags, no.

Can you keep it in stock? If it ran out twice in the fortnight, fix the supply before you advertise it.

Can you photograph it today? If yes, it goes in the first twenty.

Name it the way the customer says it

Write each name as a customer would ask for it at the counter: "Tower bolt, stainless steel, 6 inch, gold finish". Add the words people use locally in the description, such as "aldrop" for a door latch, because that is what they type. Group sizes and finishes on one page with a picker, so a tower bolt is one listing with choices rather than twelve separate ones.

Photograph each item on a plain sheet with a steel ruler beside it, by a window, on a phone. Show the item, the pack it comes in and the size. The ruler answers half the questions before anyone asks.

Imagine the shop that uploaded everything

Imagine a family-run hardware and paint shop in a Mysuru residential layout, with around 3,000 items in its billing system. The numbers here are illustrative. A developer imported all of them over a weekend. The site went live with billing codes as names and almost no photographs, and the owner printed the link on the shop board and added it to the Google Business Profile.

Customers opened it, searched "tower bolt", found nothing, and phoned the shop anyway. Items showed in stock that had sold out days earlier. Within a few weeks nobody was using it.

The owner hid all but two dozen items. Each one was renamed, photographed with a ruler and given a size picker. The site got a 3-kilometre delivery radius, a minimum order, and the "send a photo of the old part" button. After that, new groups went live as each was photographed: hinges first, then fasteners, then plumbing fittings. The counter staff answered WhatsApp orders between customers. Tower bolts and tap washers sold within a week; the hinge group sat unsold until the owner re-shot its photographs.

Choose the radius by the ride, not the map. Time a two-wheeler delivery to your farthest likely customer at the busiest hour; if it takes longer than the customer will wait for a washer, pull the radius in. The 3 kilometres here is the illustrative shop's answer, not a standard.

What to keep off the site for now

Bulky and heavy goods such as cement, full-length pipes, sheets and ladders stay as "call to order", unless you already deliver them by tempo. Paint tinted to a shade at the machine stays offline too; put the shade card up and a button to ask for tinting. Switches, wires and other electrical goods can wait too, until you can show the maker's box and invoice for each item.

A tally sheet by the billing desk

Put the tally sheet beside the billing counter and leave it there for two weeks. Then count the strokes. The items with the most strokes are your first online store. Building that first store is e-commerce website development work, and hardware sits in our e-commerce sales and marketing group. To have it built and found by people a few streets away, tell us what you need.