Billing and stock
Import your product list from Excel
Bring an existing product list into AgroPay: download the sample sheet, fill it in Excel, save as CSV, check the preview and import. Includes opening stock, batch and expiry columns.
- 1Download the sample sheet
Open Masters, Bulk import (Excel), and download the sample file.
- 2Fill it in Excel
One row per product, or per batch if you are entering opening stock with batches.
- 3Save as CSV
In Excel choose File, Save As, and pick CSV (Comma delimited).
- 4Upload and check the preview
Upload the CSV. Every row is checked and shown with any problems before anything is saved.
- 5Import
Fix rows marked with problems, then confirm the import.
If you already have your products in Excel or in another billing program’s export, you do not have to type them again.
The sheet
Open Masters → Bulk import (Excel) and download the sample file. It has these columns:
| Column | What to put |
|---|---|
| Product Name | As you want it on the bill |
| Category | Seed, Fertilizer, Pesticide or Other. Marathi and Hindi words such as बियाणे, खत or कीटकनाशक are understood too |
| HSN | The HSN code |
| GST% | 0, 5, 18 and so on. A rate that does not legally exist is rejected |
| Pack Size | For example 50 kg or 250 ml |
| Sale Price | Your selling price |
| Reorder Level | Low-stock warning level (optional) |
| Batch No | For opening stock with batches (optional) |
| Expiry (MM/YYYY) | For example 11/2026 (optional) |
| Opening Qty | Quantity on the shelf today (optional) |
| Cost Rate | What you paid per unit (optional) |
| MRP | The printed MRP |
Save as CSV
AgroPay reads CSV files. In Excel, choose File → Save As and pick CSV (Comma delimited). Keep the header row.
Upload and check
Upload the file. AgroPay checks every row and shows you a preview with any problems marked, before anything is saved. Fix those rows in Excel, save the CSV again and re-upload.
Uploading the same sheet twice does not double your stock, so a second attempt after a fix is safe.
Tip
If most of your products are common brands, tick them from the starter list first and import only the rest. It saves checking HSN codes and GST rates row by row.
Updated 13 September 2026