Analyze demand on any set of products, such as rotational, strain-based skus, in Happy Buyers to understand sell-through, days on hand, and units to reorder.
Demand Reports allow fast and accurate insight into the sales and overall demand for a custom set of products. You can run demand reports on product groups like Jeeter 1G prerolls, Smokiez Sour Fruit Chews, 100mg brownies, 3.5g house flower, .5g live rosin ceramic vape carts....the list is endless!
How to create a demand group
- Go to the restock report in Happy Buyers ↗️
- Set your desired days on hand, lead time and lookback period
- Filter down to a subset of products using the category filters on the left of the screen
- Use the search bar to further refine the group of products
- Click Create demand group on the top right of your restock report.
- Name your demand group accordingly. For example: Brand name 1g Pre-rolls
- Decide if you want it to reoccur/automatically run one or multiple days per week. Leaving this unchecked will only analyze demand for this group one time.
- Check if you'd like the report emailed to you once its complete. You can also add multiple email addresses to anyone in or out of your organization that you would like to receive the report.
- Click Create and run. It will take a few minutes before your report is generated.
Note: Some filters can not be added to a demand group as it skews the forecast such as Restock only, Active products, and out of stock only.
View your Demand Groups
A demand group contains a subset of specific products to allow you to view the overall sales velocity, stock levels, and reorder amounts for the product group. These can be used for one-off analysis, refreshed as needed, or scheduled to run automatically.
Navigate to the Demand Group page to view a list of all your created groups
- Star your favorite groups for quick access
- If a latest report has low stock at any store, a low stock status will be visible
- If a report is more than 3 days old it will have an out of date status so you will not order with the wrong data.
View the Demand Reports
Click on any group to view its most recent demand report. The report contains the calculated demand on a specific date in time across the demand group that allows you to make real-time inventory decisions.
The report calculates:
- Units sold per day across all products
- Total units sold in the selected time period
- Predicted days on hand across all products
- Total units to reorder
- Along with the ability to export 2 CSVs:
- Suggested allocation of products and amounts to order
- All individual products, run rates and units needed (plus all columns found on the restock report)
Edit demand groups
You can edit your demand groups by navigating to the actions column on the demand group page. These details will only apply to future reports you run and not reflected on past reports.
Click the menu on the actions column to access demand group settings.
- Group details including the name, days on hand, lead time, and lookback period
- Schedule recurring reports
- Add emails of users in or outside of your organization to receive a report any time it is run
- Product batch defaults for minimum order quantity and category. Updating these defaults and rerunning your report will change all product order quantities and categories across all skus in the demand group.
Sharing demand reports
You can email or send a link to a demand report page to anyone outside of your organization. They will be able to view and download associated CSVs.
💡 You can automate your reports to send weekly to your vendors.