Just like companies and contacts, you can easily import an existing list with products in Teamleader. This means you don't need to enter each product manually.
Here you will learn more about:
- Preparing your import
- Adding products via import
- Undoing an import of products
Preparing your import
Basically, you can import all files in the XLS, XLSX or CSV format. However, there are some things, you need to keep in mind when preparing your file for the import into Teamleader.
Note: You find an example file in attachment.
- Ensure that there is one entry per line
- You can import values into all fields of a product, however:
Every row must at least contain the field "name" or the field "ID"
You can also import descriptions: a short text with information about the product
If you use the field "ID", Teamleader assumes that each ID only occurs once in the file. If this is not the case, you get an error message telling you which IDs appear more than once.
If you use no ID, the name of a product must be unique, otherwise it will be impossible to distinguish the various products from one another. Here too, the system shows which names appear more than once and how many times.
Prices, purchase price and stock will generate an error message when the file contains non-numeric or negative values.
When importing suppliers by using their name, Teamleader will look at both contacts and companies for links to existing contacts/companies that are already in Teamleader. In order to link a product to a supplier, you add a column to your sheet and add the name in the right row.
To link a supplier to a company, you add the company name.
To link a supplier to contacts, you enter "First name Family name". If nothing is found, a company will be created with the name that you added.
Department: you can link your product to a particular department by adding the name of that department as a value.
VAT rates: the following values are accepted: "0", "6", "12", "21", for the respective normal VAT rates. In addition there are the following special codes:
EX: Outside Europe
VCMD: Intra-Community services
Custom fields: We recommend to first create the custom fields and only then perform the import. This article tells you all about creating custom fields.
- The file must be no larger than 5 MB. In any case, your file must not contain more than 35,000 rows and 200 columns.
Adding products via import
1. Navigate to "Products" > click on "Import" in the right hand corner
2. In the next pop up window you go for “Choose File”.
Note: You can only upload XLS, XLSX or CSV files.
3. Choose the right file from your storage.
4. Match the columns with the right fields.
- Teamleader does match some columns automatically. However, you should still check every column and match it accordingly.
- Make sure that every available value in the dropdown menu is only chosen maximum once.
5. Fill in standard values in case a cell of a compulsory value is empty.
- VAT rate
- Click on “Preview”
Note: In case you receive an error message:
- Check whether you really matched each value maximum once.
- Check whether you filled every cell of the mandatory fields (ID or product name)
- Click “Do import now”.
Undoing an import of products
If you imported products and realize that something went wrong, you still have the option to undo the import.
- You go to the overview of products, where you see at the bottom on the righthand side “Import”.
- Click 'Undo import' to actually undo the import. You have this option for about two weeks after the import if you didn't click on 'OK, dismiss' yet.
Note: In general we advise not to click on 'OK, dismiss' in order to keep the undo option available.