Retrive all products inventory per location

Summary:

How can we get the entire inventory per location?

Content (required):

Hi,

We are using Oracle Commerce Cloud (Version 23.05) with Classic Storefront and we need to extract the inventory for all products, however, we are using location inventories (two locations) to manage the stock per site.

Is there a way to export the inventory for all products per location by doing just one request or exporting a file? Or the only option is doing product by product using the request described in the link below?

https://docs.oracle.com/en/cloud/saas/cx-commerce/ccdev/retrieve-inventory-data-locations.html

Regards,

Casimiro

Version (include the version you are using, if applicable):