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

    Download the Sample Template:

  • •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

    Supported File Formats:

  • •.xlsx (recommended)
  • •.xls (legacy Excel)
  • •.csv (comma-separated values)

    Required Columns:

  • •Description — Product name or description (required)
  • •Price — Unit price (required, must be a number ≥ 0)

    Optional 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

    Column Name Flexibility:

    The system recognizes common variations of column names:

  • •"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

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

    Limits:

  • •Maximum 500 products per upload
  • •At least one valid row is required

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