📈 SKU groups

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.

What does a SKU group (formerly demand group) do?

SKU groups calculate an aggregated, smart run-rate across the group of products, only dropping out-of-stocks when ALL sellable product quantities are zero. They allow fast and accurate insight into the sales and overall demand for like-products, with no need to create massive pivot tables. An automated suggested order is also generated and can be easily be shared with your vendor—saving time while improving order accuracy.

Examples of products to group are rotational-SKUs or products with similar price, weight, and even strain classification:

• Jeeter 1G prerolls
• Smokiez Sour Fruit Chews
• 100mg brownies, 3.5g Indica house flower
• .5g live rosin ceramic vape carts
• ....the list is endless!
  
  

How to create a SKU group

1. Go to the restock report in Happy Buyers ↗️
2. Set your desired days on hand, lead time and lookback period
3. Filter down to a subset of products using the category filters on the left of the screen
4. Use the search bar to further refine the group of products
5. Click Create SKU group on the top right of your restock report.
6. Name your SKU group accordingly. For example: [Brand name] 1g Pre-rolls
7. 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, but you can always re-run your report on demand to get accurate run rates.
8. 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.
9. Click Create and run. It will take a few minutes before your report is generated.

Note: Some filters can not be added to a SKU group as it skews the forecast such as Restock only, Active products, and out of stock only. 

View your SKU Groups

A SKU group contains a subset of specific products and allows 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 regularly.

Navigate to the SKU 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 outdated information

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 SKU 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 SKU groups

You can edit your SKU groups by navigating to the actions column on the SKU group page. These updates will only apply to future reports you run and are not reflected on past reports.

Click the menu on the actions column to access SKU group settings.

• Group details including the group name, days on hand, lead time, and lookback period
• Schedule to automate this report recurring weekly on a custom schedule and add emails of users in or outside of your organization to receive a report any time it is run
• Batch update to edit minimum order quantity and Happy Buyers category. Updating these defaults and rerunning your report will change all product order quantities and categories across all SKUs in the SKU group, and future products matching the filters applied

Sharing demand reports 

You can auto-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.