Stockouts can do a lot of damage to revenue and can cause businesses to miss out on sales opportunities if they aren't careful.
In this guide, we will walk through the process of creating a stockout risk analysis in Genie to help you stay on top of stock levels and avoid preventable stockouts.
Building the view
Now, just like any view we create in Genie, the first step is to narrow down the catalog to show only the products we are concerned with.
Step 1: Add filter Stockout Date -> in the next 30 days. Alternatively, if you are looking further out in the week or have different criteria for stocking out, you can always go with 7, 60, or 90 days.
Step 2: Adjust columns to show the data points you need. In this case, we will select:
On hand
Daily sales
Stockout
In transit
Vendor/supplier if you want this
You can organize them however you'd like, but these metrics will help us see what is stocking out and on what day. This ensures you can focus on the more important and time-sensitive products first and have all the important information needed to reorder.
Step 3: Now we want to save the view to reference later
Step 4: In the top right corner select Save view, then enter the name of the view you are saving. We will call this one Stocking out in the next 30d.
Now, if you want to do further analysis on these products you can also export the list into a CSV. To do this you will have to first select the products you want to export. Then in the top right corner, you will see a downfacing arrow. This icon will let you choose what you want to download.
Selected means you will only download the products you have selected
Current Page means if you have a large catalog only the products displayed on the current page you are on will be exported.
All Variants means that it will export all product variants that meet the filter criteria.
Once you make your selection a CSV file will download with all of the product variants you chose.
Note: You will only see the data you have chosen to show in the view. This means if you want more data you will have to add more columns to your view before exporting.
We hope this guide helps you avoid preventable stockouts and keep your revenue happy and healthy.
If you have any questions feel free to reach out to our team or check out other guides in our help center. And if you want more information on building analytical views check out our guides on the inventory table and creating new views.