Home › Blog › Running the business › Hardware Shop Item List

Hardware Shop Item List: Setting Up 5,000 Items in Your Billing Software Without Chaos

Quick answer

Group hardware items into 15–25 categories (door hardware, fasteners, plumbing, electrical, paint, tools), name every item in one fixed order, and set unit, HSN and GST item by item.

In this article
  1. Why your hardware shop item list decides everything else
  2. Step 1: Fix one naming convention for SKUs
  3. Step 2: Build categories that match how customers ask
  4. Step 3: Choose the right units and conversions
  5. Step 4: Map HSN codes and GST rates carefully
  6. Step 5: Add barcodes and prepare an Excel sheet
  7. Step 6: Opening stock, reorder levels and upkeep
  8. Frequently asked questions

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:

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:

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:

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:

  1. Base unit — the smallest unit you track stock in (piece, metre, kg, litre).
  2. Purchase unit — how the supplier bills you (carton, coil, bundle).
  3. 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.

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:

Pre-launch checklist

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.

Related articles

Weighbridge Weight Difference Material Delivery Management for Building Material Shops Contractor and Mistri Commission Advance Booking for Cement and Steel Torn and Damaged Cement Bags Dealer Scheme Accounting All blog posts

Start Free Today

Set up in two minutes. No card required. Leave whenever you like — your data always stays yours.