Bulk Upload via Excel
Manage products and services
Add hundreds of products at once using an Excel spreadsheet.
Getting Started: 1. Go to the Inventory page 2. Click the "Upload Excel" button (green button next to "Add Product") 3. A bulk upload modal will open
- •Inside the modal, click "Download Sample Template"
- •This gives you a pre-formatted .xlsx file with the correct column headers
- •Fill in your product data using this template for best results
Download the Sample Template:
- •.xlsx (recommended)
- •.xls (legacy Excel)
- •.csv (comma-separated values)
Supported File Formats:
- •Description — Product name or description (required)
- •Price — Unit price (required, must be a number ≥ 0)
Required Columns:
- •Tax Rate (%) — Tax percentage (0–100)
- •Quantity — Stock count (defaults to 0)
- •Unit — Measurement unit (defaults to "pcs")
- •SKU — Stock Keeping Unit code
- •HSN Code — Harmonized System Nomenclature code
- •Barcode — EAN/UPC barcode number
- •Note — Internal notes or remarks
Optional Columns:
- •"Description", "Item Name", "Product Name", "Name" → maps to Description
- •"Price", "Rate", "Unit Price" → maps to Price
- •"Tax Rate (%)", "GST (%)", "Tax" → maps to Tax Rate
- •"Qty", "Stock", "Stock Qty" → maps to Quantity
Column Name Flexibility:
The system recognizes common variations of column names:
Upload Process: 1. Drag and drop your file onto the upload zone, or click to browse 2. The system parses your file and shows a preview table 3. Valid rows show a ✅ green check, invalid rows show a ❌ with the error 4. Click "Upload All" to create all valid products 5. Invalid rows are automatically skipped 6. A summary shows how many products were created and any errors
- •Maximum 500 products per upload
- •At least one valid row is required
Limits:
Pro Tips
- Always download and use the sample template for the correct format
- Preview your data before uploading to catch errors early
- Invalid rows are skipped — only valid products are created
- You can upload up to 500 products at once