Importing products from Excel

Step by step

1. Go to Products › Import Products.
2. Click Download template file and open it in Excel or Google Sheets.
3. Fill in one product per row. Read the Instructions table on the import page: it explains every column and which ones are required (e.g. name, unit, SKU, prices).
4. Save the file as .xlsx (or .csv).
5. Back on the import page, choose the file and click Submit.

If there's a problem, nothing is imported and you'll see the row number and reason. Fix that row and import again.

Tips for a smooth import

• Units, categories and brands must be spelled exactly as they exist in TechFusion (create them first). "bag" and "Bag " (extra space) are different.
• SKUs must be unique. Leave the SKU column empty to generate codes automatically.
• Numbers only in price columns: no "KSh", commas or spaces.
• Business location column: write the location's name exactly as in Settings › Business Locations.
• Opening stock can be included in the product import, or imported separately with Products › Import Opening Stock.
• Test with 5–10 rows first, then import the rest.

Note: Very large files can take a minute. Don't click Submit twice or you may import products twice.