After logging in to Pimcore, open your supplier folder and then tap Children Grid:



 Or in the product catalog in the tree, on a desired series / composition / size or color:
  

Once you have opened Children grid, press «Grid Options» on the far right and select «Supplier Export»
 

Then press the arrow to the right of the box "CSV Export" and select "XLSX Export".
 

 

The following dialog box will appear, check the box for "Enable inheritance" and then OK.
 

 

 The file is automatically saved under "downloads" on your local PC