Importing & Exporting Products
Last updated: 15 February 2025 · 2 min read
Easily manage bulk products with BillBook's Import & Export feature!
Importing Products
- Go to → Products → Import Products
- Download the template file
- Fill in all product details according to the column names & instructions.
- Do NOT remove the headings in the template file.
- Import the file into BillBook
Common Import Errors & Fixes
Error: UNIT not found
Ensure the unit name in your Excel file matches a unit already in the system. Go to Products → Units and add the missing unit.
Error: Separation Symbol Not Found
Format your Expiry Date column in Excel as Text, and enter the date in MM-DD-YYYY format.
Not Well-Defined Errors
Try splitting your import file into smaller files (e.g., 250 products per file).
Exporting Products
- Go to → List Products
- Click on the Download Excel button
- Your product list will be downloaded instantly.
To remove the Actions column from export, use the Column Visibility feature before exporting.