NOTE
The Pio app feature presented in this article is visible only to Pio Admins.
Inventory Export & Storage usage reports are available from the Admin section. Whenever you need a full inventory overview from your Pio app or a fresh report of how much storage your 3PL customers are using, go to Inventory > Overview and select the 'Export' button to download the reports.
Inventory Export
The inventory export can be filtered by shop and by SKU or Location.
Inventory by SKU
The inventory by SKU export includes the product SKU, name, quantity in stock, quantity allocated for orders, and number of bins/shelves where the product is stored.
Inventory by Location
The other option is to export the inventory by Location. This export includes the product SKU, name, category, quantity in stock, quantity allocated for orders, bin/shelf id, bin layout, calculated compartment fill rate, and inventory turn ratio.
Compartment fill rate is a calculated number based on the maximum items of a SKU stored in a compartment historically. Sort and filter your inventory export by fill rate to find the bins with the lowest fill rate. The bins with the lowest fill rate can for example be optimized by moving the inventory over to a smaller compartment or add it to another compartment holding the same SKU.
Inventory turnover ratio is a calculated number based on the number of items sold in the period divided by the average items in stock. It shows whether we currently have more or less stock compared to the average over the past month. A ratio greater than 1 means that, on average, we have had more in stock than we do now (indicating high turnover), while a ratio less than 1 means that today's inventory exceeds the monthly average (indicating low turnover).
Storage Usage Report
The storage usage report lists all connected shops with how much storage in bins and shelves each shop is using on average.
Choose an end date to download the CSV report. It will include daily and average storage usage—like bin and shelf locations used per shop—for the selected month up to that date.