"Templates are a round-trip: download the Excel file, fill it, then Bulk upload it back." Row 1 holds the headers, row 2 holds hints, and your data starts on row 3. Keep the headers exactly as they are.
Data Import templates
| Import | File | Row 1 headers, in order | Rows | A bad row |
|---|---|---|---|---|
| Suppliers | suppliers_template.xlsx | name, contactPerson, email, phone, address, city, state, zipCode, category, paymentTerms, status, notes | 150 | Stops the whole file |
| Clients | clients_template.xlsx | name, email, phone, companyName, address, status, notes | Not stated | Stops the whole file |
| Item catalog | items_template.xlsx | name, category, unit, description, sku, brand, model, specifications, minStock, capacity, location, status, equipmentType, maintenanceTemplate. A second sheet lists units for each category. | 150 | Stops the whole file |
| Open enquiries | enquiries_template.xlsx | clientName, clientEmail, clientPhone, clientCompany, clientAddress, projectType, projectDescription, budget, estimatedDuration, priority, status, source, notes, followUpDate | 150 | Stops the whole file |
| Employees | employees_template.xlsx | Employee code, Full name, Phone, Email, Department, Designation, Date of joining, Status | See HRMS | Only that row is rejected |
| AMC / service contracts | contracts_template.xlsx | Client name, Client phone, Client GSTIN, Contract number, Contract type, Start date, End date, Contract value, Visit frequency, Visits already completed, Machine description, Site address, Contact person, Contact phone, Notes | See Service | Only that row is rejected |
| Opening stock | opening_stock_template.xlsx | Item Name, SKU, Category, Unit, Brand, Model, Capacity, Quantity, Unit Price, Location, Serial Numbers, Min Stock, Supplier Name, PO Reference, Warehouse | 1,000 | Nothing is written until you confirm |
Employees hints: Employee code "Optional: left blank, a code such as EMP-014 is given"; Full name and Phone "Required"; Date of joining "Optional: DD/MM/YYYY or YYYY-MM-DD"; Status "Optional: active (default), inactive, on_leave, resigned".
Opening stock hints
| Column | Hint |
|---|---|
| Item Name | Required |
| SKU | Optional: primary match key (no spaces) |
| Category | Required: pick from dropdown |
| Unit | Required: filtered by category |
| Capacity | Optional (whole number for pieces/units/rolls/box) |
| Quantity | Required: whole number ≥ 1 |
| Unit Price | Optional: blank = Not valued (never 0) |
| Serial Numbers | Optional: comma-separated; count must equal Quantity |
| Min Stock | Optional: used only when a NEW item is created |
| Supplier Name | Optional: exact match links; new name = pending supplier |
| PO Reference | Optional: your old PO number (reference only) |
| Warehouse | Optional: warehouse name; blank = your default warehouse |
The file must be .xlsx or .xls, up to 1,000 rows and 2 MB.
Users template
Management › Users › Download Template gives users_bulk_upload_template.xlsx, sheet "Users".
| Header | Hint |
|---|---|
| name | Required: letters and spaces only |
| Required: valid email address | |
| password | Required: min 8 chars, include A-Z a-z 0-9 and special char (any symbol, e.g. @ # - _ !) |
| role | Required: select from dropdown |
| phone | Optional: e.g. +919876543210 |
| department | Optional: e.g. Operations |
Rows 3 to 102, so 100 users per file. The file must be .xlsx or .xls and under 500 KB.
