📥 Import Products
If you have an existing product catalog—from an e-commerce platform, spreadsheet, or POS system—you can import everything at once. This is especially useful when setting up your account or migrating from another system.
Navigate to Service Management > Products and click Import Products.
📤 Import Modal
Click Import Products from the Product Management dashboard to open the import modal.
📁 Supported Formats
| # | Format | Extension | Description |
|---|---|---|---|
| 1 | 📊 CSV | .csv | Comma-separated values file |
| 2 | 📗 Excel | .xlsx | Microsoft Excel spreadsheet |
| 3 | 📋 JSON | .json | JavaScript Object Notation file |
📝 File Structure Guide
Your import file must include the required columns. Below are examples for each format.
📊 CSV Example
category,name,sku,price,stock,description
Accessories,Braided USB-C Cable,SKU-003,19.99,500,6ft premium cable
Accessories,Wireless Charger Pad,SKU-005,34.99,250,Fast charging compatible
Smartphones,Aura Phone Lite,SKU-001,449.99,150,Entry-level smartphone
Wearables,Fittrack V5,SKU-004,179.99,200,Fitness smartwatch
📗 Excel Format
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| category | name | sku | price | stock | description |
| Accessories | Braided USB-C Cable | SKU-003 | 19.99 | 500 | 6ft premium cable |
| Accessories | Wireless Charger Pad | SKU-005 | 34.99 | 250 | Fast charging compatible |
| Smartphones | Aura Phone Lite | SKU-001 | 449.99 | 150 | Entry-level smartphone |
📋 JSON Example
{
"products": [
{
"category": "Accessories",
"name": "Braided USB-C Cable",
"sku": "SKU-003",
"price": 19.99,
"stock": 500,
"description": "6ft premium cable"
},
{
"category": "Smartphones",
"name": "Aura Phone Lite",
"sku": "SKU-001",
"price": 449.99,
"stock": 150,
"description": "Entry-level smartphone"
}
]
}
📋 Column Reference
| # | Column | Required | Type | Description |
|---|---|---|---|---|
| 1 | category | ✅ Yes | String | Category name (must exist) |
| 2 | name | ✅ Yes | String | Product display name |
| 3 | sku | ✅ Yes | String | Unique product identifier |
| 4 | price | ✅ Yes | Number | Product price (decimal) |
| 5 | stock | ❌ No | Integer | Available quantity |
| 6 | description | ❌ No | String | Product description |
| 7 | brand | ❌ No | String | Manufacturer name |
| 8 | barcode | ❌ No | String | UPC/EAN barcode |
✅ Processing & Validation
After uploading, the system validates your file:
| # | Check | Description |
|---|---|---|
| 1 | 📁 File Format | Verifies file type is CSV, XLSX, or JSON |
| 2 | 📋 Required Columns | Checks all required columns are present |
| 3 | 📦 Product Count | Shows number of products ready to import |
| 4 | 🏷️ Category Validation | Confirms all referenced categories exist |
🔄 Import Process
| Step | Action |
|---|---|
| 1️⃣ | Upload your file via drag-and-drop or file browser |
| 2️⃣ | System validates file format and structure |
| 3️⃣ | Review validation results and product count |
| 4️⃣ | Click Import Products to complete the import |
Categories referenced in your import file must already exist. Create categories first in the Categories tab before importing products.
Download a sample template from the import modal to ensure your file structure is correct before preparing your data.