Import template for partners
You can download an Import template for partners, to create or update partner information for multiple partners at the same time. The import template must afterwards be uploaded to tracezilla.
If this is your first time uploading partners to tracezilla, it can be a good idea to first create one partner directly into the application. This way, when you download the import template, the first row of the excel sheet will be pre-filled, so it is easier to see which information goes to which column, and also in which format.
NB: It is possible to edit in partners in tracezilla while you have downloaded the import template to your computer, so do not wait too long to upload changes via the import template. It could potentially create conflicting data or overwrite the changes made in tracezilla. Please agree with other users that there is no editing in the application, while partners are being updated locally on a file.
If a data error occurs when uploading the template, the application will let you know in which row and column the error is located, and what causes the error.
Import partners
- Click Partners in the top menu, and choose Find partner in the drop-down menu.
- Click Import in the upper right corner.
- Click Get import template in the pop-up window.
- Enter or edit the information in the template. Remember to save the template on your computer.
- When you have finished creating or editing partners, go back to tracezilla.
- Click Upload File in the dialog window.
Partners
In the left column below, you have the headers of the excel sheet. The right column provides explanations for each header.
| Column header | Explanation |
|---|---|
| ID | This ID is used by the application to recognize the partner when the excel sheet is imported to the application. It ensures that the correct partner will be uploaded with the correct data. Do not delete or edit data. |
| Partner name | Enter the partner’s company name. The partner name will appear on documents, e.g. invoices. |
| VAT ID | Enter the partner’s VAT ID, which normally can be found on the partner’s website. |
| External Ref. | Do not fill in the field. The information is used internally in the system. |
| Country | Enter the partner’s country of origin. The format must be the two letter ISO country code. E.g. DK for Denmark, GB for Great Britain, etc. |
| Currency | Enter the default currency of which the partner is payed and invoiced. The format must be the three letter code according to ISO 4217. E.g. DKK, GBP, EUR, ect. |
| Language | Enter the language as it is to appear on documents sent to the partner. The language format must be the two letter ISO language code, e.g. da for danish, en for english. The language on documents must furthermore be translated. You can do this by following this tutorial https://www.tracezilla.com/en/tutorials/document-translation |
| World wide web address | Enter the partner’s website address in the format https://example.com |
| Enter the partner’s email address, e.g. example@example.com This is the default recipient address for documents, e.g. invoices, when a contact has not been added to the partner. |
|
| Phone | Enter the phone number of the partner. |
| Fax | Enter the fax number of the partner. |
| Payment term method | Enter the default payment term method for the partner, e.g. Nett days. You can see the payment terms in the application. |
| Payment term text | Enter a text for the payment term method above, e.g. Nett 14 days. You can see the payment terms in the application. |
| Payment term days | Can be: Number. Enter the number of days matching the entered data in the two previous fields, e.g. 14. |
| Default delivery term | Can be: Capital letters. Enter the abbreviation of the delivery clause for the terms of delivery according to INCO TERMS, e.g. DDP, EXW, etc. Read more about INCO TERMS here. |
| Default delivery term, text | Can be: Text and numbers. Enter a text for the delivery terms entered in the previous field. |
| Price List (Purchasing) | If you have created a price list with purchase prices for raw materials, you can copy the name from the application and associate the price list with a partner. Then the prices of goods will automatically be filled in from this price list when you create a purchase order with this partner as supplier. |
| Price List (Sale) | If you have created a price list with sales prices, you can copy the name from the application and associate the price list with a partner. Then the prices of sold goods will be automatically filled in from this price list when you create a sales order for this customer. |
| Retail prices currency | Enter the currency of retail prices, if you wish for these to appear on invoice documents for this partner. E.g. EUR, GBP, USD, etc. Read more about retail prices here. |
| Blocked | Can be: Yes/No. When creating a new partner, enter No. A partner can not be deleted, only blocked. When blocking a partner, the partner can no longer be added to new orders. When blocked, the partner will be marked with a red warning. |
| Created | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
| Updated | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
Locations
| Column header | Explanation |
|---|---|
| ID | This ID is generated automatically. Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner ID | Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner | Enter the partner’s company name. |
| Reference code | Enter a reference code, if relevant. |
| Location | Enter the name of the location, e.g. “Headquarters”, “Warehouse”, “Production”, etc. |
| World wide web address | Enter a web address, if relevant. |
| Country | Enter the country code of the location. The format must be the two letter ISO country code. E.g. DK for Denmark, GB for Great Britain, etc. |
| Address | Enter the location address. |
| Address 2 | Enter the location address. |
| State/province/region | Enter a state, region, etc., if relevant. |
| Zip code | Enter the Zip code |
| City | Enter the city. |
| Blocked | Can be: Yes/No. When creating the location, enter No. If you wish to block the location, enter Yes. |
| Created | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
| Updated | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
Certificates
| Column header | Explanation |
|---|---|
| ID | This ID is generated automatically. Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner ID | Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner | Enter the partner’s company name. |
| Certificate body | Can be: A partner. Enter the partner name of the certificate body. |
| Reference | Enter a reference number. |
| Certificate url | Enter a http, if public certificate. |
| Issued at | Enter the date of issue in the format yyyy-mm-dd. |
| Valid from | Enter the first date of the validity period in the format yyyy-mm-dd. |
| Expires | Enter the end date of the validity period in the format yyyy-mm-dd. |
| Created | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
| Updated | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
Comments
| Column header | Explanation |
|---|---|
| ID | This ID is generated automatically. Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner ID | Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner | Enter the partner’s company name. |
| Comment | Enter a comment of choice. |
| Created by, Name | Enter the user name of the comment. |
| Created by, Email | Enter the email address of the user. |
| Created | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
| Updated | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
Contacts
| Column header | Explanation |
|---|---|
| ID | This ID is generated automatically. Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner ID | Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner | Enter the partner’s company name. |
| Name of contact | Enter name of contact. |
| Enter the email address of the contact. | |
| Phone | Enter a phone number. |
| Cell | Enter a cellphone number of the contact. |
| Is this the contact that should be chosen as default?… | If no location has been specified for the contact, this will be the default contact for all locations. |
| Comment | Enter a comment of choice. |
| Created | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
| Updated | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
Tags
| Column header | Explanation |
|---|---|
| Partner ID | Leave the field empty. If data is already entered, do not delete or edit data. |
| Partner | Enter the partner’s company name. |
| Created | This field will be auto-filled. Do not edit or delete the text. If a new partner is being added, leave the field empty. |
| Remove | Can be: Yes/No. When creating the tag, enter No. If you wish to delete the tag, enter Yes. |