What you'll do: download the template, fill it with your customers and suppliers, and upload it to add them all in one go.
Before you start:
- Your role needs Add customer or Add supplier.
- One file can hold up to 5000 rows and 10 MB.
Open Inventory & Products → Import → Import Contacts, or press Import on the Customers or Suppliers page.
1 Import On Import Contacts, press Download Template and open the file in Excel.
Fill one contact per row, keeping the columns in the order shown under Import Instructions:
- Contact Type:
customer,supplierorboth(required); - First Name (required); Business Name is required for suppliers and for Both;
- Pay Term and Pay Term Period (
daysormonths) are required for suppliers and for Both; - Mobile (required), and optionally Contact ID (leave blank to generate it), Tax Number, Opening Balance, Credit Limit, Email, address columns and Date of Birth.
Keep the first row (the column names) as it is.
- Contact Type:
Back on Import Contacts, drop the file in the box (XLS, XLSX or CSV) and press Import Contacts.
1 Download Template · 2 File box · 3 Import Instructions When the file is accepted, Hala opens the contacts list with the new contacts.