A hardware shop item list is usually the biggest job when a shop moves from a paper bill book to software. A typical counter sells screws in ten sizes, hinges in five finishes, PVC fittings in a dozen diameters and paint in many shades and pack sizes. If those items go into the system carelessly, staff cannot find them at billing time, stock never matches, and GST reports show the wrong HSN codes.
This guide walks through a practical item master setup: how to name products, group them, pick units, map HSN codes and add barcodes, so that 5,000 items stay searchable a year later.
Why your hardware shop item list decides everything else
Every bill, stock report and GST return pulls data from the item master, so one mistake repeats on every invoice.
Common problems:
- The same item entered twice ("SS Hinge 4in" and "Hinge SS 4 inch"), so stock is split between two records.
- Pack sizes mixed up — a box of 100 screws billed as one piece.
- HSN code left blank or copied wrongly, which then flows into GSTR-1.
A few days spent on a clean structure, before going live, saves months of correction later.
Step 1: Fix one naming convention for SKUs
A good name is predictable: anyone on the counter can guess how it is written.
Use the same order of words for every item:
Item type → Material/brand → Size → Finish/grade → Pack
| Messy entry | Clean name |
|---|---|
| 4" hinge steel | Hinge SS 4in Matt |
| screw 1.5 inch box | Screw Wood 1.5in x 8 Box100 |
| PVC elbow 1 | PVC Elbow 1in |
| Tower bolt 6 brass | Tower Bolt Brass 6in |
| primer 1 ltr (two brands, one record) | Primer Brand-A 1L, Primer Brand-B 1L |
Simple rules that help:
- Write sizes one way only: always "in" for inches and "mm" for millimetres. Never mix "inch", "\"", and "in".
- Put the brand name in the item name only when you stock the same item from more than one brand.
SKU codes
Give each item a short code using category prefix + running number: HNG-001 for hinges, SCR-014 for screws. Codes only need to be unique and never reused.
Step 2: Build categories that match how customers ask
Customers ask for "plumbing ka saman" or "darwaze ka hardware", not brands. Build two or three category levels around that.
Example structure for a mixed hardware shop:
- Door and window hardware — hinges, handles, tower bolts, locks, aldrops
- Fasteners — screws, nuts and bolts, anchors, nails
- Plumbing — PVC pipes, fittings, GI pipes, taps, solvent
- Electrical — wires, switches, MCBs, boxes
- Paint and allied — primer, enamel, putty, brushes, thinner
- Tools — hand tools, power tool accessories, measuring tapes
Keep around 15–25 top-level categories; more and staff stop using them. Categories also show which section earns most and where dead stock sits.
Step 3: Choose the right units and conversions
The same screw may arrive in a carton, sit in boxes of 100 and sell loose. Decide for each item:
- Base unit — the smallest unit you track stock in (piece, metre, kg, litre).
- Purchase unit — how the supplier bills you (carton, coil, bundle).
- Sale units — how customers buy (piece, box, dozen, metre).
Worked example: wood screws
Supplier sends 1 carton = 20 boxes, 1 box = 100 screws. Set base unit = piece.
- Purchase 5 cartons → stock goes up by 5 × 20 × 100 = 10,000 pieces.
- Sell 3 boxes and 24 loose screws → stock goes down by 300 + 24 = 324 pieces.
- Balance = 9,676 pieces, which is 96 boxes and 76 loose screws.
The same logic applies to wire bought by the coil and sold by the metre, or putty bought by the bag and sold by the kg. MaterialBill supports this kind of multi-unit billing, so you can buy in one unit and sell in another while stock stays in one base unit.
Step 4: Map HSN codes and GST rates carefully
Every taxable item needs the correct HSN code and GST rate. For most hardware, the rate is 18%, but do not assume — set it item by item.
| Item group | HSN (chapter heading) | GST rate |
|---|---|---|
| Screws, bolts, nuts, washers | 7318 | 18% |
| Door/window fittings (hinges, handles, tower bolts) | 8302 | 18% |
| PVC pipes and fittings | 3917 | 18% |
| GI/MS pipes | 7306 | 18% |
| Wires and cables | 8544 | 18% |
| Switches, sockets, MCBs | 8536 | 18% |
| Paint and varnish | 3208 / 3209 | 18% |
| Wall putty | 3214 | 18% |
How many digits to print: under Notification No. 78/2020–Central Tax, businesses with aggregate turnover up to ₹5 crore in the previous year must show at least 4-digit HSN on tax invoices (optional on B2C invoices), and those above ₹5 crore must show 6 digits. Ask your CA to confirm the exact 6- or 8-digit code for each product line. If HSN is new to you, read our guide on what an HSN code is, and check full rates on our GST rates page.
GST rates and rules change; check the latest CBIC notification or ask your CA before filing.
Step 5: Add barcodes and prepare an Excel sheet
Barcodes
Many branded items already carry a manufacturer barcode. Scan it into the item record. For loose or unbranded items, print your own labels using the SKU code. Barcode scanning at the counter removes the "which hinge was it?" problem. MaterialBill offers barcode billing for this.
Prepare the list in Excel first
Typing 5,000 items one by one is slow and error-prone. Build the list in a spreadsheet with fixed columns:
| Column | Example |
|---|---|
| Item code | SCR-014 |
| Item name | Screw Wood 1.5in x 8 Box100 |
| Category | Fasteners |
| Base unit | Piece |
| Purchase unit + conversion | Carton = 2,000 pcs |
| HSN | 7318 |
| GST rate | 18% |
| Purchase rate | (your current rate) |
| Sale rate | (your current rate) |
| Opening stock | 1,240 |
| Reorder level | 400 |
Ask your software provider whether bulk import is supported and in what format before you begin, so the columns match.
Sort the sheet by name and remove near-duplicates before importing.
Step 6: Opening stock, reorder levels and upkeep
Count physical stock section by section on go-live day and enter it as opening stock; old book balances are rarely accurate. Our stock management guide covers counting methods.
Set a reorder level for fast-moving items so low-stock alerts work. Then keep the list clean every month:
- Mark discontinued items inactive instead of deleting them (old bills still refer to them).
- Allow only one or two people to create new items.
- Review new items weekly for naming mistakes.
Pre-launch checklist
- [ ] Naming convention written down and shared with staff
- [ ] Top-level categories finalised (15–25)
- [ ] Base, purchase and sale units set with conversions
- [ ] HSN code and GST rate on every taxable item
- [ ] Barcodes scanned or labels printed for fast movers
- [ ] Duplicates removed in Excel
- [ ] Physical opening stock counted and entered
- [ ] Reorder levels set for top 200 items
- [ ] Item-creation rights limited to named staff
Frequently asked questions
How many items does a typical hardware shop have?
It varies with the range. A small counter may have a few hundred items; a shop covering plumbing, electrical, paint and tools can pass several thousand once every size and finish is counted.
Should each size be a separate item?
Yes. Each size, finish and pack that has its own price or stock should be its own item. Grouping them under one name makes stock counts meaningless.
Do I need to show HSN on every bill?
Tax invoices need HSN as per your turnover slab — 4 digits up to ₹5 crore turnover and 6 digits above it. Businesses up to ₹5 crore may skip it on invoices to unregistered buyers. Confirm with your CA.
What should I do with old stock that has no barcode?
Create the item normally with an SKU code and print your own barcode label for it, or bill it by searching the name.
Can I change item names later?
Usually yes, but frequent renaming confuses staff. Fix the convention first.
A clean item list makes billing fast and reports trustworthy. If you want software that handles multi-unit items, item-wise stock and barcode billing for a hardware counter, take a look at MaterialBill's hardware shop billing software — you can start free and set up your first categories in an afternoon.