Good water purifier inventory management software should track serial numbers, technician-held stock and consumables, and link all of it to AMC and service history. Set up stock in four groups (complete units, consumables, spares, installation material), then let AMC due dates decide what you reorder. That keeps sales, AMC and service visits in sync.
Why Excel and notebooks fail for RO service stock management
Excel and notebooks work with a few items and one person handling stock. Once AMC customers and technicians are added, these problems usually appear:
- Purchases, sales and parts sitting with technicians never match.
- No serial number record, so warranty disputes are hard to settle.
- Membranes and filters run out in peak season because reordering is done on gut feel.
- Parts “disappear” when technician stock is not tracked.
- Old and new batches get mixed, with no record of what was fitted and when.
What a water purifier dealer actually needs to track
| Stock group | Examples | How to track |
|---|---|---|
| Complete units | Domestic RO/UV purifiers | Serial number per unit |
| Consumables | Membranes, sediment and carbon cartridges | Quantity with a reorder level |
| Spares | Pumps, SMPS adapters, valves, tanks | Issue and return to technician |
| Installation material | Pipes, taps, connectors | Bulk quantity |
For context, domestic RO/UV purifiers usually cost about ₹8,000-₹25,000, membranes about ₹1,000-₹3,500, and pumps or SMPS about ₹500-₹1,500. These are indicative ranges only, so verify them with current market quotes. They show why membranes and pumps need closer tracking than pipes and connectors.
Commercial RO plants and their spares need separate handling. They are project-based, with different capacities and parts, so keep them in their own category instead of mixing them with domestic stock.
AMC management software and inventory: why they belong together
AMC due dates drive consumable demand. If you know who is due next month, you know roughly what to buy. Recording the parts used on each visit also builds a history of what was fitted and when. For the renewal side, see our guide on tracking water purifier AMC renewals.
Worked planning example (illustrative, made-up numbers)
Assume 80 AMC visits are due next month. Each visit uses one sediment and one carbon filter, and we assume about 15% of units need a new membrane. Buffers and on-hand stock are also assumed.
| Item | Need for 80 visits | Buffer | Total | On hand | Order |
|---|---|---|---|---|---|
| Sediment filter | 80 | 10% (8) | 88 | 20 | 68 |
| Carbon filter | 80 | 10% (8) | 88 | 30 | 58 |
| RO membrane | 12 | 25% (3) | 15 | 4 | 11 |
Now add lead time. If your supplier takes about 7 days and you use roughly 3 sediment filters a day, you consume about 21 during delivery. A reorder point of around 29 (21 plus a safety stock of 8) means you reorder before you run dry. Before summer or the monsoon, when you expect more visits, increase the numbers using your own past records.
10 things to look for in water purifier inventory software
- Master item list (SKU, brand, model, HSN, GST rate, purchase price, MRP, selling price). Test: add five real items and see if any field is missing.
- Serial number and warranty tracking. Test: sell one unit and search it by serial number later.
- Minimum stock and reorder alerts. Test: set a low level and see if the alert appears.
- Purchase entry against supplier invoices with GST input details. Test: enter one real invoice.
- Automatic stock deduction on billing and service jobs. Test: bill a filter and check that the count drops.
- Technician or van stock with issue and return. Test: issue parts to a technician, then record a return.
- Link to AMC and service history. Test: open a customer and see which parts were used and when.
- GST-compliant invoices. Check whether e-invoicing applies to you under the current threshold.
- Mobile access for technicians and shop staff. Test: try it on a low-end phone.
- Excel import, data export and WhatsApp reminders for AMC and filter changes. Test: import a small sample file and export it back.
GST and HSN basics for purifiers and spares
- Purifiers generally fall under HSN 8421 21. Spares and filters are often under 8421 99, but pumps, electrical parts and plastic fittings may sit under other HSNs. Check each item with your CA.
- Many of these items have been taxed at 18%. The GST Council announced slab changes in 2025, so verify on the GST portal or CBIC site whether anything affects HSN 8421. Note the date you checked.
- Check the current e-invoice threshold, since it has been lowered several times, and the Tamil Nadu commercial taxes guidance.
- Do not make BIS or compliance claims without checking the current BIS and QCO status. IS 16240 covers UV-based purifiers, but confirm what applies to your products.
How to choose: Excel vs generic billing vs dealer-specific CRM
| Option | Good for | Usually lacking |
|---|---|---|
| Excel / notebook | Very small stock, one person | Serial tracking, technician stock, reminders |
| Generic billing software | GST invoices, basic stock | AMC schedules, service history, filter-change reminders |
| Dealer-specific CRM | Sales, stock, AMC and service together | Check language, export and pricing terms |
Our piece on water purifier billing software covers the billing side in more detail.
Questions to ask any vendor
- Can I export all my data at any time, and in what format?
- Where is data stored, and who can see it? Can I set staff permissions?
- Is pricing per user, per month, per branch or per message? What costs extra, such as WhatsApp messages?
- Is there Tamil language support, and does it cover the screens my staff use?
- What happens to my data if I stop paying?
A simple trial script
Import 20 customers and 15 items. Buy one item against a supplier invoice. Sell a purifier with a serial number. Issue filters to a technician, record an AMC visit, then check that stock, customer history and invoice all agree.
Setting up inventory control in your shop, step by step
- Pick a start date and do a full physical count. This is your opening stock.
- Name items consistently, for example by brand, model and size, so duplicates do not creep in.
- Enter serial numbers for every unit in stock, then for each new purchase.
- Set reorder levels using last season’s usage and your supplier’s lead time.
- Bill only through the system, so sales deduct stock.
- Give every technician a stock location, and review it weekly.
- Record the part used on every service visit.
- Count monthly and investigate differences. Review slow-moving stock quarterly.
- Each month, plan purchases from the next month’s AMC due list.
This works best alongside a clear process for managing RO service customers.
Common mistakes to avoid
- Using the wrong HSN or GST rate on spares.
- Paying for generic billing software with no service or AMC features.
- Believing software is only for large companies. Dealers with 100+ AMC customers can benefit.
- Skipping physical counts.
- Not noting which filter or membrane was fitted on which date.
Stocking tips for Tamil Nadu dealers
Many dealers here are small, multi-brand and semi-urban. Hard water and high-TDS borewell water are common in many areas (a general observation, not sourced), which can mean more frequent consumable replacement.
- Peak season: build extra membrane and filter stock before summer and before the monsoon, based on your own past service counts.
- Supply gaps: in semi-urban areas, distributor deliveries can be slower, so keep a higher buffer for fast-moving parts.
- Multi-brand: keep separate SKUs for each brand and note compatible parts, so the wrong membrane is not issued.
- Multiple branches: treat each branch as a stock location and record transfers between them.
Confirm language support before choosing any tool. Do not assume a Tamil interface.
How Nixie CRM fits in
Nixie CRM by Shiny Software Services is built for water purifier dealers in India. It covers customer management, sales tracking, inventory management, GST invoice generation, AMC management, service tracking, quotation and payment follow-ups, and WhatsApp API reminders. Because stock connects with AMC and service, you can plan consumables before visits. Our RO AMC management software guide explains the AMC side.
Do not assume things we have not stated, such as a Tamil interface or specific integrations. Check them in the trial using the script above.
FAQ
Which software is best for a water purifier dealer who wants billing, AMC and stock in one place?
Look for a tool built for dealers, not only generic billing. Score two or three options against the 10-point list and run the same trial script on each. Pick the one that keeps stock, AMC and invoices consistent for your staff.
Can inventory software track serial numbers and warranty for each RO/UV purifier sold?
Good software should. Each sale should link a serial number to the customer and warranty start date. Confirm this in your trial.
How do I track stock held by my service technicians?
Treat each technician as a stock location. Record parts issued and returned, and deduct parts used on service jobs. Compare this with a physical check regularly.
What HSN code and GST rate apply to water purifiers and spare parts?
Purifiers generally fall under HSN 8421 21, and many spares under 8421 99 or other headings. Rates can change, so confirm them on the GST portal or CBIC site and with your CA before billing.
Can I import my existing customers and stock from Excel?
Many tools support Excel import. Ask for it and test with a small sample file first.
Can software send WhatsApp reminders for AMC renewals and filter changes?
Yes, if the tool supports WhatsApp API reminders. Message template and pricing rules are set by Meta and can change, so ask the vendor about costs.
Want to see stock, AMC and service work together? Start your 7-day free trial or explore Nixie CRM.