Difference between revisions of "Importing the list of clients"

From SimplyBook.me
 
Line 9: Line 9:
 
'''How to use this option:'''
 
'''How to use this option:'''
 
:1. Enable "Import Clients" custom feature on your Custom features page:
 
:1. Enable "Import Clients" custom feature on your Custom features page:
[[File:Import clients enable path new cf.png | center]]
+
[[File:Import clients enable path redesigned.png|1200px | center|link=https://help.simplybook.me/images/5/55/Import_clients_enable_path_redesigned.png]]
 
<br><br>
 
<br><br>
 
:2. Prepare your Excel file.  
 
:2. Prepare your Excel file.  
Line 17: Line 17:
 
<br><br>
 
<br><br>
 
:3. Go to Manage//Clients//Import from CSV or simply click on "Settings" near this custom feature.  
 
:3. Go to Manage//Clients//Import from CSV or simply click on "Settings" near this custom feature.  
[[ File:Import clients file upload path.png | center]]
+
[[ File:Import csv file path redesigned.png|1200px | center|link=https://help.simplybook.me/images/c/cb/Import_csv_file_path_redesigned.png]]
 
<br><br>
 
<br><br>
 
:4. Press "Choose file" and select the prepared file.
 
:4. Press "Choose file" and select the prepared file.
[[File:Import clients file upload step1.png | center]]
+
[[File:Import page redesigned.png|1200px| center|link=https://help.simplybook.me/images/0/06/Import_page_redesigned.png]]
 
<br><br>
 
<br><br>
:5. Assign values to the columns from drop-down lists in the upper bar (above each column, marked with black arrows). Assign "name", "email" and "phone".
+
:5. Assign values to the columns from drop-down lists in the upper bar (above each column, marked with black arrows). Assign "name", "email" and "phone".<br>
[[File: Import clients assigning column headers.png | center]]
+
:(if you are using [[Special:MyLanguage/Client_Fields_Custom_Feature|Client Fields Custom Feature]] you can also import some of the forms values)
 +
[[File:Assign values to columns import redesigned.png|1200px | center|link=https://help.simplybook.me/images/b/bf/Assign_values_to_columns_import_redesigned.png]]
 
<br><br>
 
<br><br>
 
:6. Press "Confirm clients import".  
 
:6. Press "Confirm clients import".  

Latest revision as of 13:34, 13 September 2024

How to import clients

Free custom feature!

Attention! It is forbidden to import a client list with emails and client information where the clients have not specifically granted you the right to do so.


Please note that this feature is available with Standard and Premium subscriptions only(former Advanced, Gold and Platinum).
It is only possible to import 500 clients by default. If you need to import more please contact support for details.



How to use this option:

1. Enable "Import Clients" custom feature on your Custom features page:
Import clients enable path redesigned.png



2. Prepare your Excel file.
- No text above the list of clients should be written
- Make sure all cells are correctly displayed
- Save file in .csv format with comma separation.



3. Go to Manage//Clients//Import from CSV or simply click on "Settings" near this custom feature.
Import csv file path redesigned.png



4. Press "Choose file" and select the prepared file.
Import page redesigned.png



5. Assign values to the columns from drop-down lists in the upper bar (above each column, marked with black arrows). Assign "name", "email" and "phone".
(if you are using Client Fields Custom Feature you can also import some of the forms values)
Assign values to columns import redesigned.png



6. Press "Confirm clients import".
Please note that only 10 clients will be shown in preview, but after you import, all clients will be shown.



If you can't import clients, please check the possible reasons
1. Format of .csv file is incorrect. It should be saved in .csv with comma or tab separation.
2. There is some text above the data or unnecessary columns that prevent successful import. Please delete the text.
3. Values are not assigned. Use drop-down menus above the columns to assign values "name", "email", "phone", etc.