You will need to customize each table view on every page of Happy Buyers (i.e your All products, SKU groups and Cart table grids. But updated, these changes will persist.
To begin, click the blue actions button on the top right of your table and select Customize Table
From here you can:
- Apply alternating row colors to make rows visually scannable
- Show or hide columns from your view with the on/off toggle
- Rearrange the order of the columns by clicking and dragging the six dot icon
- Freeze columns by clicking the lock icon
Frozen column view
All frozen columns will appear first, and the other data will float underneath when scrolling left to right.
Resize column widths
You are also able to click Fit columns to screen from the Actions dropdown to fit all of your columns in your browser view.
💡 Tip - Click header to sort columns ascending or descending
All columns in Happy Buyers are sortable in ascending or descending order. Click the heading of any column, i.e. Units per day, to sort from high to low or vice versa!
Column defintions:
SKU
Unique product SKU synced from your POS system for each product
Name
Product name as logged in your POS system
Vendor name
The vendor or distributor for the product
Brand name
The brand of the product
Category
Product category as mapped by Happy Buyers; this can be manually adjusted for each product and does not write to your POS system
Strain
If recorded in your POS, the strain classification of the product
POS category
The product's category as listed in your POS
POS subcategory
The product's subcategory as listed in your POS (currently available for Dutchie only)
Store
At which store the product is located (if you're a single location retailer, toggle this off to free up screen space)
Units per day
The units sold per day for any given product
📚 FYI
Happy Buyers calculates Units per day from inventory in Sellable inventory rooms only, and also factors in out of stock events (down to the hour) and any applied blockout dates.
Days out of stock
How many days the product was out of stock during your selected Lookback period
Unit cost
The wholesale cost (price you paid) for the product, pulled from the product catalog
Unit price
The MSRP (price the customer pays) for the product
Avg margin
The average margin for the product in your selected Lookback period, calculated post-discount, pre-tax
$ Sold
The dollar amount sold of the product in your selected Lookback period, calculated post-discount, pre-tax
Est profit
The estimated profit generated by sales of the product in your selected Lookback period, calculated post-discount, pre-tax
Discount $
Tracks the total discounted amount from each line item in your selected lookback period. For example, if it's 20% off a $10 item, discount dollars = $2.
Avg discount %
The average percent discount that has been applied for each line item in the selected lookback period.
Weight
The product's weight in grams
Current inventory
How much inventory you have in stock in both Sellable and Backstock inventory rooms
Sellable inventory
How much inventory you have in stock in Sellable inventory rooms only
Predicted days on hand
How many forecasted days of supply you have in Current inventory
Sellable days on hand
How many forecasted days of supply you have in Sellable inventory
Continue to carry
Should you continue to carry this product or not based on the performance of this product compared to other like products
Units needed
How many units you will need to meet your set Desired days on hand
Case size
The number of units in a case size for each product; the purchase request will round up to the nearest case size quantity.
Units to order
How many units you need to order to meet your set Desired days on hand, with consideration to the applied Min order qty and your set Lead time
Last activity
The last date of activity registered for this product in any inventory room
Units aged 0-30
The number of units between 0 and 30 days
Units aged 31-60
The number of units between 31-60 days
Units aged 61-90
The number of units between 61-90 days
Units aged 90+
The number of units that have aged past 90 days