Difference between revisions of "Import clients from Excel"

From Protemos Wiki
Jump to: navigation, search
(Import clients' contacts)
(Import clients' contacts)
Line 87: Line 87:
 
3. You need to enter 1 or 0 in the required '''Invoicing''' field.
 
3. You need to enter 1 or 0 in the required '''Invoicing''' field.
  
:'''1''' — this contact person will be getting invoices by default.
+
:'''1''' — this contact person will be added automatically as the default recipient when sending invoices to the client via the system.
  
 
:'''0''' — this contact person will not be getting invoices as a default recipient every time you send the invoices from the system.
 
:'''0''' — this contact person will not be getting invoices as a default recipient every time you send the invoices from the system.

Revision as of 13:04, 15 June 2020

Import clients from Excel page: http://cloud.protemos.com/client-import/index

Watch our video tutorial on how to import clientsYT client.png


If you already have the list of clients, contacts, and prices, you can easily import it on this page without entering such information manually.

To do that, go to the Clients page and press the "Import from Excel" button:

Import clients from Excel button.png

The clients’ information is imported step-by-step.

1. Download the template file for import by clicking the "Download Excel template" link, and fill it out.

2. Click the "Choose file" button to upload the template with your information into the system.

3. Press the "Submit" button to import the template:

Import clients from exel.png

If the filled file has no mistakes, the information from it will be imported into the system.

Otherwise, the file will be returned with an indication of the found mistakes in the Errors column. Correct the mistakes to be able to import the information again.

  • CLIENTS—use this template to enter general information about clients.
  • CLIENTS CONTACTS—for entering the contact information (relates to the Company category of clients).
  • CLIENTS PRICES—to import prices for clients.
  • CLIENTS PAYMENTS—to import payments from clients

Import clients' general information

1. Download and open the CLIENTS template. Here you can see the following:

1600px

2. Copy and paste the required information about clients.

3. You need to select required fields from drop-down lists: Type, Default legal entity, Country, and Default currency.

  • Type (Company, Individual):

2type.png

  • Default legal entity:

Default le import.png

Country 2.png

  • Default currency—you should define this list for your account in Protemos before downloading the template. For more details, please check the Currencies page:

Default currency.png

4. You need to enter 1 or 0 in the required Can log in and Assignable fields.

  • Can log in:

1—clients will be able to log in (in that case, clients will get invitation emails from the system once you import the template).

0—clients will not be able to log in (in that case, invitation emails from the system will not be sent, but you can invite clients later).

  • Assignable:

1—clients will appear in the drop-down lists while creating projects.

0—clients will not appear in the drop-down lists, thus, you will not be able to create projects for these clients.

You can change this setting in clients' profiles at any time.

Note: If there are any errors, the file will be re-downloaded with mistakes indicated in the "Errors" column. Fix the errors and upload the file again.

Import clients' contacts

1. Download and open the CLIENTS CONTACTS template:

1inv .png

2. Copy and paste the required information about your clients' contacts.

3. You need to enter 1 or 0 in the required Invoicing field.

1 — this contact person will be added automatically as the default recipient when sending invoices to the client via the system.
0 — this contact person will not be getting invoices as a default recipient every time you send the invoices from the system.

You may select and remove the recipients of invoices before sending the email right on the Send invoice page.

You can always change this setting in the client profile.

Note: If there are any errors, the file will be re-downloaded with mistakes indicated in the "Errors" column. Fix the errors and upload the file again.

Import clients' prices

1. Download and open the CLIENTS PRICES template:

900px

2. Copy and paste the required information about your clients.

3. Please select the required Service, Languages, Specialization, Unit, and Currency from drop-down lists. You should define System values before downloading the template.

4. If you need to enter specific prices for different specializations, language pairs, services, currencies, and units for the client, you should add all needed combinations in a separate line as shown in the example below:

900px

Note: If there are any errors, the file will be re-downloaded with mistakes indicated in the "Errors" column. Fix the errors and upload the file again.

Import clients' payments

1. Download and open the CLIENTS PAYMENTS template:

900px

2. Copy and paste the required information about your clients.

3. Please select the required Payment method and Currency from drop-down lists. You should define Payment methods and Currencies before downloading the template.

Pm.png 1currencypaymtemplate.png

Note: If there are any errors, the file will be re-downloaded with mistakes indicated in the "Errors" column. Fix the errors and upload the file again.