Difference between revisions of "Import clients from Excel"
(→Import clients' contacts) |
(→Import clients' prices) |
||
| Line 110: | Line 110: | ||
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: | 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: | ||
| − | [[File: | + | [[File:Import client prices2.png|border|700px]] |
<span style="color:red">'''Note:'''</span> If there are any errors, the file will be re-downloaded with mistakes indicated in the''' "Errors"''' column. | <span style="color:red">'''Note:'''</span> If there are any errors, the file will be re-downloaded with mistakes indicated in the''' "Errors"''' column. | ||
Revision as of 09:23, 28 September 2022
Import clients from Excel page: http://cloud.protemos.com/client-import/index
Watch our video tutorial on how to import clients — 
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 click the "Import from Excel" button:
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. Click the "Submit" button to import the template:
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
Contents
Import clients' general information
1. Download and open the CLIENTS template. Here you can see the following:
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):
- Default legal entity:
- Country (should be specified using ISO-3166 alpha-2 code. See the list of codes here — https://en.wikipedia.org/wiki/ISO_3166-1):
- Default currency — you should define this list for your account in Protemos before downloading the template. For more details, please check the Currencies page:
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:
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:
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:
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:
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.
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.
