Supported Data Types
You can import the following data types via CSV:
Products
Required: sku, name, price
Optional: cost, category, brand
Sales History
Required: date, sku, quantity
Optional: revenue, channel
Inventory
Required: sku, quantity
Optional: location, reorder_point
Competitors
Required: sku, competitor, price
Optional: url, date
How to Import
Step 1: Prepare Your File
- First row should contain column headers
- Use consistent date formats (YYYY-MM-DD preferred)
- Ensure SKU/product codes are unique identifiers
- Remove any summary rows or totals
Step 2: Upload
- Go to Settings → Integrations → CSV Import
- Select the data type you're importing
- Drag & drop your file or click to browse
- Wait for file validation
Step 3: Map Columns
Decisio auto-detects column mappings. Review and adjust if needed:
- Review the auto-detected mappings
- Click any mapping to change it
- Mark columns to skip (won't be imported)
- Set default values for missing optional fields
Step 4: Validate & Import
- Review the validation summary (errors, warnings)
- Fix critical errors if any (download error report)
- Choose to skip or fix warning rows
- Click Import to process
Download Templates
Start with our templates to ensure correct formatting:
Products Template
Product master data
Sales History Template
Transaction history
Inventory Template
Stock levels
Competitors Template
Competitive pricing
Column Mapping Reference
Products
| Decisio Field | Common Column Names | Required |
|---|---|---|
| sku | sku, product_id, item_code, barcode | Yes |
| name | name, product_name, title, description | Yes |
| price | price, selling_price, retail_price, mrp | Yes |
| cost | cost, unit_cost, cogs, purchase_price | No |
| category | category, product_category, type | No |
Sales History
| Decisio Field | Common Column Names | Required |
|---|---|---|
| date | date, order_date, transaction_date, sold_date | Yes |
| sku | sku, product_id, item_code | Yes |
| quantity | quantity, qty, units_sold, qty_sold | Yes |
| revenue | revenue, total, amount, sales | No |
Scheduled Imports
For regular data updates, you can set up scheduled imports:
- SFTP Upload: Upload to secure folder, auto-imported daily
- Cloud Storage: Link Google Drive or Dropbox folder
- Email Import: Send files to unique import email address
Best Practices
- Use consistent SKU formats across all files
- Import products before sales history (for matching)
- Include at least 90 days of sales history for forecasting
- Update inventory regularly for accurate reorder recommendations
Troubleshooting
File Too Large
- Maximum file size is 100MB
- Split large files into chunks
- Use ZIP compression if needed
Encoding Issues
- Save files as UTF-8 encoding
- Check for special characters in product names
- Avoid using formulas (export as values)
Date Format Errors
- Use YYYY-MM-DD format for best results
- Avoid mixed date formats in same column
- Remove time components if not needed