Bulk Upload Items via Excel
If you have dozens or hundreds of items to add, entering them one by one is impractical. The Bulk Upload feature lets you fill in an Excel spreadsheet with item details (name, price, barcode, category, GST rate, opening stock) and import them all at once. This is especially useful when you are setting up Stock Register for the first time or adding a new product line from a supplier's catalog.
Steps
- Navigate to Inventory > Items.
- Click "Bulk Upload" button.
- Download the Excel Template by clicking "Download Sample".
- Fill in item details in the template following the format.
- Upload the filled Excel file by clicking "Upload File".
- Review the imported items for accuracy.
- Click "Save All" to add all items to your inventory.
Tip: Double-check your Excel data before uploading — ensure item names are unique and prices are in the correct format to avoid import errors.
Common Questions
Download the sample template from the Bulk Upload page. It is in .xlsx format with pre-defined columns for item name, barcode, category, purchase price, selling price, MRP, GST rate, HSN code, and opening stock. Follow the template exactly for a smooth import.
The bulk upload feature is primarily for adding new items. To update existing items, use the Edit Items in Bulk feature instead, which lets you modify multiple items at once.
Stock Register will show you a preview of the imported data before saving. Any rows with errors (such as missing item names or invalid formats) will be highlighted so you can fix them before completing the upload.
Yes, the Excel template includes columns for opening stock, GST rate, and HSN code. Fill in these fields for each item in the spreadsheet, and they will be imported along with the item names and prices.
Yes, copy the item details from your supplier's price list into the Stock Register Excel template. Map the item names, purchase prices, selling prices, and other details into the correct columns, then upload the file to add all items at once.
You can upload hundreds of items in a single Excel file. There is no strict limit on the number of rows. Just ensure each row has at least an item name, and double-check the data for accuracy before uploading to avoid errors during import.
Related Guides
Related Features
Related Glossary Terms
Ready to Get Started?
Manage inventory, billing, and accounting effortlessly.