Sub Un-Popularity Report¶

Menu Location: Products > Reports > Sub Un-Popularity Report

Last Updated: 2026-07-27

Overview¶

The Sub Un-Popularity Report shows which products customers most often sub OUT of their box, for a single delivery week. A "sub out" means the item that was originally scheduled to be in the box got swapped away, either the customer chose to remove it themselves, or the system automatically substituted something else in its place (for example, when the item was unavailable).

This is a per-week report, not a date-range report. You pick one delivery week from a dropdown and see sub-outs for that week only.

What it tells you:

Which products were most frequently subbed OUT (customer-initiated + system-initiated combined), for the selected week
For any one of those products, exactly what it was most commonly replaced with, broken out separately for customer-made sub-outs and system-made (automatic) sub-outs

Page Layout¶

Week selector: a single dropdown to choose the delivery week (Select Week button submits the form). There is no date-range picker and no "quick select" options.

Main Table¶

A single table listing every product that was subbed out of at least one box that week, one row per product:

Column	Description
Rank	Row number, ordered by Subbed Out Count (highest first)
Product	The product that was removed from the box (the original box menu item, by name)
Subbed Out Count	Number of order lines that week where this product was subbed out (customer-chosen + system-chosen combined)
% of All Sub-outs	This product's count divided by the total number of sub-outs that week

The table is always sorted by Subbed Out Count, highest first. There is no alternate sort option, no search box, and no minimum-occurrence filter on this main table.

Clicking a product name in the table opens a popup titled "Subout Details for [Product] / Week of [date]" with two side-by-side breakdowns:

Customers: how many times customers themselves subbed this product out that week, and a ranked list (top 10, with "...and N more" if there are more) of what they most commonly replaced it with, each with its own count.
The System: the same breakdown, but for sub-outs the system made automatically rather than the customer.

If there is no data for either side, it says "no customer subouts found" or "no system subouts found." The popup closes with a "Dismiss" button.

What This Report Does NOT Have¶

To avoid confusion with other reporting tools in the admin, this report does not include:

A date range, it is always scoped to one delivery week at a time
Product/brand/category search or filters
A complaint-rate, rejection-rate, refund-rate, or star-rating column, none of that data is tracked or shown here
Any customer complaint text, customer segment (VIP/regular/new) filter, or price-difference calculation
CSV/Excel export
An "Automatic vs Manual" column on the main table (that split only appears inside the Subout Details popup, as two separate breakdowns)
Any way to disable a substitution rule, issue a credit, or take action directly from this page, it is a read-only report

If you need those things, see Related Pages below.

Common Use Cases¶

See what's subbing out the most this week¶

Pick the delivery week from the dropdown. The table is already sorted so the most-subbed-out product for that week is Rank #1.

Understand what a product is being replaced with¶

Click any product name in the table. The popup splits out, separately, what customers chose to replace it with and what the system auto-subbed in its place, along with counts for each replacement.

Compare a past week to this week¶

Change the week dropdown and reselect. Each week's data is calculated independently; there is no built-in week-over-week comparison view.

Troubleshooting¶

Report shows "No results"¶

The selected week has no order lines with a customer- or system-made sub-out. Try a different week.

This just means all of that product's sub-outs that week came from the other mechanism (all customer-driven, or all system-driven). It is not an error.

Numbers look different from the Sub Popularity Report¶

This report counts products that were removed from the box (subbed OUT). The Sub Popularity Report counts the opposite side of the same swap: what ended up going INTO the box as the sub. The two reports are not meant to reconcile to the same totals for a given product, a product can appear frequently in one and rarely in the other.

Sub Popularity Report (kiv/reports/sub-popularity-report.php): the most popular things customers sub IN
No Sub Found Report (kiv/reports/no_sub_found.php): orders where the system couldn't find an automatic sub

End of Documentation