Import all your products at once using CSV files instead of entering them one by one. This feature is only available in the desktop edition of Telesto.
The CSV import tool is available on Windows, macOS, and Linux desktop versions of Telesto.
- Open Telesto desktop edition
- Click on the toolbar menu
- Select Tools
- Choose Import CSV file
Telesto provides a CSV template with the correct format and column headers.
- Download the CSV template
- Open and edit it in your preferred spreadsheet software (Excel, etc.)
- Browse, select the CSV file, and click Import
Do not edit the first row (header). Add your product data starting from the second row.
Header columns:
product_name,ean_upc,purchase_price,selling_price,product_desc,color,stock_onhand,stock_critical,category_name,supplier_name,location_name
- Column 1: Product name
- Column 2: UPC/SKU
- Column 3: Purchase price
- Column 4: Selling price
- Column 5: Description
- Column 6: Color
- Column 7: Stock on hand
- Column 8: Critical stock level
- Column 9: Category name*
- Column 10: Supplier name*
- Column 11: Location name*
The last three columns (marked with *) reference existing data in your Telesto system.
These columns must match existing names in your system:
- Category name: Must match an existing category
- Supplier name: Must match an existing supplier
- Location name: Must match an existing warehouse/location
Categories, suppliers, and locations referenced in your CSV must already exist in Telesto before importing. Create these items first if they don't exist.