Real-time assortment for Home Improvement.
store-level assortment signals, caught before they compound.
Why assortment matters
in home retail.
The top 2,000 SKUs generate the bulk of revenue, but the remaining 48,000 are what makes you a project destination. Drop a niche fitting and you lose the entire project basket. Ward identifies which tail SKUs are project-basket anchors worth keeping and which are truly dead weight that should be rationalized.
Industry benchmarks
Home improvement long-tail SKUs (the bottom 60-70% of catalog by velocity) typically generate 8-15% of standalone revenue but anchor 25-35% of project basket value. Pro customers depend disproportionately on the tail, losing tail items typically costs 2-4x the standalone revenue impact in Pro retention.
Long-tail rationalization, plumbing department
Plumbing carries thousands of SKUs, hundreds with zero sales in 90 days. Ward's project basket analysis reveals that many of those "dead" SKUs appear alongside high-velocity project items, a specialty elbow fitting with minimal standalone sales is still critical to a complete project basket. Deleting it sends the customer to a competitor for the entire job. Ward separates true orphaned SKUs from project-basket anchors and recommends cutting only the former.
What Ward actually tracks
Ward tracks long-tail project basket affinity, Pro vs DIY assortment dependency, seasonal SKU activation cycles, and revenue-per-linear-foot by department and planogram section.
Data signals
POS at SKU-basket grain over 18+ months, Pro account purchase tagging, seasonal activation history, planogram space allocation, and supplier minimum-order constraints.
Three pitfalls Ward catches
in home assortment.
- 01 SKU rationalization based on standalone velocity destroys project-basket anchors and drives customers to competitors for the entire job, net assortment economics turn negative.
- 02 Pro account purchasing patterns differ from DIY in tail-SKU dependency; cutting "dead" specialty fasteners hurts Pro retention more than DIY revenue.
- 03 Seasonal activation cycles mean a SKU "dead" for 9 months can be critical for 3; chain-wide 90-day velocity cuts kill seasonal anchors prematurely.
How Ward runs assortment
for home retailers.
-
01
Build the project basket affinity graph
Ward analyzes 18 months of basket data to identify which low-velocity SKUs anchor multi-SKU project baskets and which are truly orphan.
-
02
Score SKUs on project anchor value
Each tail SKU is scored on its basket-anchor contribution per Pro and DIY segment, separating true dead weight from undervalued anchors.
-
03
Rationalize only the orphans
Cards recommend cuts only on SKUs with low standalone velocity AND low project-anchor contribution, preserving the catalog depth that makes the chain a project destination.
What a Ward card looks like.
Cluster B stores (urban, high-traffic) underperforming on premium snacks vs Cluster A by 34%. Assortment gap: 12 SKUs missing.
Chat
Ask anything. Ward routes to the right agent and returns cited answers.
I pulled Store 37’s last 28 days against the chain baseline. Two root causes, both compounding.
| Signal | Finding |
|---|---|
labor_efficiency | Rev/labor-hour −22% vs. cluster, staffing mismatch at 11a–1p peak |
inventory.fresh | Fresh fill 83%, backroom replenishment lag at 2–4p |
promo.lift | BOGO crackers cannibalized Brand Y by 28%, net category +6% |
Recommend: re-baseline Store 37 schedule against true peak, raise replen window to 1p, and review the BOGO before next cycle.
labor_scheduling…
Dashboards
Pinned views built from saved data-lake queries.
Models
Browse, search, and manage data–lake model definitions for your tenant.
| Name | Namespace | Version |
|---|---|---|
retail_pos_transactions | retail | 1.0 |
retail_inventory_snapshot | retail | 1.2 |
retail_labor_scheduling | retail | 1.0 |
retail_promo_calendar | retail | 1.1 |
retail_supplier_performance | retail | 1.0 |
sap_inventory_shrinkage | sap | 1.0 |
ga4_daily_events | marketing | 1.0 |
meta_ads_ad_level | marketing | 1.0 |
Sources
Connect external systems to the data lake.
| Name | Type | Last sync |
|---|---|---|
sap_pos_transactions | import | 2m ago |
sap_inventory_shrinkage | import | 2m ago |
sap_labor_scheduling | import | 14m ago |
retail_inventory_weekly | import | 1h ago |
retail_google_ads_daily | import | 1h ago |
retail_meta_ads_daily | import | 1h ago |
retail_ga4_website_daily | import | 1h ago |
Architecture
Two ways to connect. Federate against your live systems, or ingest into Ward’s data lake. Toggle below.
sap.possnow.inventoryPipelines
Move data from sources into models on a schedule.
| Name | Source | Model | Status | Schedule |
|---|---|---|---|---|
sync_sap_pos_transactions | sap_pos_transactions | pos_transactions | enabled | hourly |
sync_sap_labor_scheduling | sap_labor_scheduling | labor_scheduling | enabled | daily |
sync_sap_inventory_shrinkage | sap_inventory_shrinkage | inventory_shrinkage | enabled | daily |
sync_retail_inventory_weekly | retail_inventory_weekly | inventory_weekly | enabled | weekly |
sync_retail_google_ads_daily | retail_google_ads_daily | google_ads_daily | enabled | daily |
sync_retail_ga4_website_daily | retail_ga4_website_daily | ga4_website_daily | enabled | daily |
Streams
Real-time ingestion pipelines.
pos.txnstore_037, basket $42.18inv.movedc_west → store_104labor.clockstore_022 shift_startpos.txnstore_211, basket $19.04
Policies
Browse and manage Cedar access policies for your tenant.
| Policy ID | Effect | Resources |
|---|---|---|
merch-read-default | permit | Model::* |
finance-read-shrinkage | permit | Model::"shrinkage" |
vendor-blocked | forbid | Model::"labor_*" |
region-west-only | permit | Tenant::"acme" |
Entities
Principals and resources referenced by Cedar policies.
| Entity UID | Type | Tenant |
|---|---|---|
Tenant::"acme" | Tenant | acme |
Model::"sap.pos_transactions" | Model | acme |
Model::"sap.inventory_shrinkage" | Model | acme |
Model::"sap.labor_scheduling" | Model | acme |
Model::"retail.toast_pos_daily" | Model | acme |
Model::"retail.ga4_website_daily" | Model | acme |
Providers
Manage LLM API keys and the model profiles that use them.
| Name | Provider | Used by | Created |
|---|---|---|---|
anthropic-default | Anthropic | 3 profiles | Apr 22 |
openai-default | OpenAI | 2 profiles | Apr 22 |
gemini-default | Gemini | 1 profile | Apr 22 |
ollama-onprem | Ollama | 2 profiles | Apr 22 |
LLM-agnostic. Bring your own key, route per task. No lock-in.
Settings
Manage your dashboard preferences and account.
Light and dark themes are available. Your choice is remembered per browser.
Home assortment:
the shift.
- ×Project basket identification
- ×Seasonal pre-positioning
- ×Long-tail inventory
- ✓Store cluster segmentation
- ✓SKU rationalization recommendations
- ✓Whitespace opportunity detection
Home KPI impact.
Ward requires 6\u201312 months to baseline seasonal categories. Pro vs DIY segment separation is critical for accurate modeling.
Questions about home assortment.
The top 2,000 SKUs generate the bulk of revenue, but the remaining 48,000 are what makes you a project destination. Drop a niche fitting and you lose the entire project basket. Ward identifies which tail SKUs are project-basket anchors worth keeping and which are truly dead weight that should be rationalized.
Plumbing carries thousands of SKUs, hundreds with zero sales in 90 days. Ward's project basket analysis reveals that many of those "dead" SKUs appear alongside high-velocity project items, a specialty elbow fitting with minimal standalone sales is still critical to a complete project basket. Deleting it sends the customer to a competitor for the entire job. Ward separates true orphaned SKUs from project-basket anchors and recommends cutting only the former.
Ward tracks long-tail project basket affinity, Pro vs DIY assortment dependency, seasonal SKU activation cycles, and revenue-per-linear-foot by department and planogram section.
First assortment insight cards arrive within 48 hours. Robust home baselines form within two weeks. Ward requires 6\u201312 months to baseline seasonal categories. Pro vs DIY segment separation is critical for accurate modeling.
More Home insight cards.
Home retailers: see what assortment problems Ward catches.
Root causes, not just alerts. See it on your data.
Find out what your data has been hiding.
Tell us about your operation. We’ll show you the problems Ward catches, and the ones your current tools miss.