What is bulk importing of Customers?
If you have customers in another system or spreadsheet that you wish to import to vWork, you can bulk import them into the app using a CSV file.
Why should I bulk import Customers?
Save time and energy adding your customers and import them quickly into vWork.
How do I bulk import customers?
1. Create a CSV for Import
You can bulk import jobs into vWork if you have the information saved as a CSV file (you can save Excel spreadsheets as CSV files if you need to).
If importing mobile numbers, they must have no spaces and be in the following format:
+country,prefix,number for example: +4407911123456, +61412345678 or +6421345678
2. Upload Your CSV
You can upload your CSV on the import customers tab. Simply select your CSV file, choose if your columns have headings and then click "Start Matching".
3. Match Your CSV Fields to your Chosen Customer fields
You can match as many fields as you want by simply dragging your imported field from the left-hand side over to one of the available customer fields on the right.
We will only import the fields that you choose to match.
4. Accept and import.
When you have mapped all the fields you wish to import, click "Submit". You should then see a confirmation dialog like the one shown below. Click "Accept" when you are sure you have selected the correct information to import.
Important Things to Note
Don't Forget the API...
We also have a full API available if you wish to look at automating this process, all of the API information can be found here.