Before you can export product relations you 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 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.