Before you generate a search based on relations you will not find anything to export at Excel export - Relations, so let's go trough that first.
- Click on the search icon on the menubar.
- Click on a selection you want to use for filtering the products used.
- Make selection.
Once you have the selection of product you want to check against a spesific Relation, go to Selection - Relations.
Search and select the Relation you want to include to the search filter.
If you add more than one Relation before you click on "Add to search" it will be treated as a AND selection, and the chip in the search bar will be listed as a combined chip. In the example below this will narrow the search to products that has both "Accesories" and "Spare parts".
If you want to include a list that has relation A or B (++), you need to add one by one relation to expand the search result.
As you can see below, when you add the relations separately they will not be combined and the result will be a list of products that has either Accessories or Spare parts as a relation in this search.
Sometimes you need to search for products that are missing a spesific relation instead of those who has a relation.
By selecting a relation so it appears as a chip in the Relation window and then clicking on it, it will change to a strike trough chip that will list products that does not have this relation.
Once you have the search result you want, click on the magnifier icon and you will have a list of products.
From here you can click on the 3 dots to get the contextual menu and edit columns if you want the result to show some different
If you have generated an Excel relation export based on a stored dashboard search or any other product searches, you can find these by
- clicking on integrations (in the left menubar)
- Then click on Relations (under Excel export).
- Here you will find a list of generated Excel exports for download. Download a report by clicking on the download icon
- Exports completed more than 7 days ago will be removed unless they have been checkmarked for "Store indefinitely". If you click on the report within the marked area you will get a pop-up screen where you can change the name of the report and checkmark it for indefinitely storage. Keep in mind that this report is a snapshot. It will not auto update the results as the dashboard searches will.
For information on how to create these searches, look here.