...
...
- 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.
need to have a list of products that Excel can search for and report relations on.
If you want a report on all products with an active feed status, click on Prouduct on the left side.
From here you can click on the 3 dots to get the contextual menu, and then choose Generate excel.
Standard this will show you "Export products", so you need to click on "Export relations"
From here you can choose the header language. Standard is your user language, but you will be able to select other languages if it is activated in feed. The difference is only in the header names as shown further down in the example.
If you click on Relations you can choose/select the relations you want to list (from the search you have), and you can choose more than one.
If you want an export of product that does NOT have the spesific relations you have chosen, you need to checkmark "Include products without relations"
If you have Base products in feed and the relations are set on the base product and not on the variants, you can checkmark "Include inherited relations" to also list the variants that has inherited the relation.
When done, click on Download as Excel.
PS: This will not download the excel file to your download folder. It will generate the report in feed, and you will get a notification when it is done.
You can click on this notification and click on the "Relation excel export" to be transfered to the list of Relation reports.
The Excel report file will look something like this:
Here is an alternativ way to find the Excel report if you need to find the list of historical reports:
- click
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
...
- 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.
PS: If you save a search result stored in your dashboard that includes filtering on Relations you still need to choose what Relation you want to export in the Relation export since that is a mandatory field in the export.
Fortunately you will see the search filter when you do the export, so you can choose the same Relations in the dropdown menu.
If you want a smaller range of product relations, look here:
A smaller range of products can be used for basis on the Relations export by using filters that reduces the number of products that is included.
The filter does not affect the connected products that is attached to the relation. If a connected product is not included in the filtered list, it will be included as long as the product that has that relation is included in the filtered list.
To create a filtered list do the following:
- Click on the search icon on the menubar.
- Click on a selection you want to use for filtering the products used.
- Make selection.
For information on how to create these searches, look here.
Once you have filtered down to the selection of product you want, you can export this to excel by clicking on the magnifier icon and you will have a list of products.
From here follow the instructions on the left side of the screen.