Retail inventory-to-sales by subsector — Q2 2026.

01 The headline read — Q2 2026 retail I/S ratios

The total retailers inventory-to-sales ratio (FRED series RETAILIRSA, sourced from Census Monthly Retail Trade Survey) was 1.26 in March 2026 — the latest available data point as of the May 2026 release. That is down from 1.30 in April 2024 (24 months ago) and meaningfully below the 1.30+ band that prevailed across most of 2024. The total-business I/S ratio (ISRATIO — retailers, wholesalers, and manufacturers combined) sits at 1.32 in March 2026, down from 1.40 two years ago. The 8 basis-point compression at the top of the inventory pyramid is real, but it is uneven across the supply chain.

The wholesale side is where the build still sits most stubbornly. Wholesale inventories in dollar terms ($932.8B in March 2026 via WHLSLRIMSA) are up 5.1% from April 2024 — running ahead of nominal retail sales growth over the same window. That means the pipeline upstream of retailers has actually fattened. Some of this is pre-tariff inventory pull-forward (importers staging stock ahead of the May–July 2025 tariff escalations); some is normalised channel inventory after the 2023 destock. Either way, the dollars are sitting somewhere — and where they land in Q3 2026 determines whether private retailers face another markdown cycle or not.

The retailers-only line at 1.26 conceals subsector variance of 100+ basis points, which is what actually matters operationally. The next section is where the real read lives.

02 Where the build still sits — subsector by subsector

The dispersion across the five major mainstream-retail NAICS subsectors is the operating signal worth reading carefully. Working from cleanest to most exposed:

Food & beverage stores (NAICS 445) — 0.76 I/S, clean

The grocery / beer-wine-liquor channel sits at a 0.76 inventory-to-sales ratio in March 2026, up modestly from 0.73 in April 2024 (+3 bp). This is the highest-turn major retail subsector by structure — perishability forces tight inventory discipline, and the ratio rarely strays outside a 0.70–0.80 band absent a pandemic-style demand shock. The 3 bp creep over 24 months reflects mainstream-grocery private-label expansion (more SKUs at slower individual velocities), not a real overstock condition. Operators in this category should not be re-engineering their replenishment cadence on the back of this data; the read is "no action required."

General merchandise (NAICS 452) — 1.23 I/S, compressing

The department-store / warehouse-club / supercentre line sits at 1.23 in March 2026, down from 1.29 in April 2024 — a 6 bp compression. This is where the post-pandemic destock actually worked. The Target, Costco, and Walmart-driven aggregate has tightened materially over the cycle, and the public-cohort 10-Qs back this up: Target at 75 days inventory (flat over 2 years), Costco at 28 days (down 3 days over 2 years). The general-merchandise category has done the inventory discipline work; the read for private operators here is "the cohort you compete against has tightened — match it or lose shelf."

Motor vehicles & parts dealers (NAICS 441) — 1.88 I/S, structurally elevated

Auto dealers sit at 1.88 in March 2026, down from a 24-month peak of 2.03 in September 2024 but still ~30% above the 2018-2019 pre-pandemic average of ~1.45. The compression is real but slow. The fundamentals are still ugly underneath: new-vehicle inventory days on lot averaged 70-90 across most of 2025 (vs. 50-60 historical) per Cox Automotive industry tracking, and the EV-specific inventory build is much worse. The category does not lend itself to fast resolution because production decisions made 12-18 months out lock the supply pipeline. Read: still long, will normalise into 2027.

Clothing & accessories (NAICS 448) — 2.09 I/S, improving but still highest

Apparel dropped to 2.09 in March 2026, down meaningfully from 2.29 in April 2024 (−20 bp) and from a 2024 peak of 2.34 in August. This is the subsector where the post-pandemic destock has worked most visibly. Lululemon's days inventory dropped from 165 to 159 over the same window; Target's apparel mix has been the lever for their headline-inventory discipline. But 2.09 is still elevated vs. the 2018-2019 pre-pandemic ~1.80 average — the category has another 15-25 bp of compression ahead before it normalises, and that compression will land mostly through markdowns in Q2 and Q3 2026.

Building materials & garden supply (NAICS 444) — 2.09 I/S, WORSE than 24 months ago

This is the surprise read in the data and the one private operators should pay closest attention to. Building materials sit at 2.09 in March 2026 — *up* from 1.95 in April 2024 (+14 bp) and within touching distance of the cycle peak of 2.18 in October 2025. The category has not destocked; if anything, it has restocked. Three drivers are doing the work: tariff pull-forward on steel, lumber, fixtures, and bath/kitchen SKUs ahead of the 2025 escalations; Home Depot and Lowe's strategically building stock for the housing-market recovery their forecasters keep calling for (and missing); and a long-cycle category demand softness as housing turnover stays anaemic. The wholesale layer behind this category is even worse than the retail layer.

03 What the listed-peer 10-Qs add

The Census aggregate is one view. The listed-retailer 10-Qs are the operating-level view — what is sitting on actual balance sheets at quarter-end. We pulled the latest quarterly inventory and COGS for seven names across the cohort and computed days inventory on hand (DIO = Inventory ÷ quarterly COGS × 91). The spread runs from 28 to 184 days, and the trajectory matters as much as the level.

Costco (COST) — 28 days, world-class

Inventory of $18.99B against quarterly COGS of $60.72B (Q2 FY26, period ending Feb 15 2026). That works out to 28 days of inventory on hand — the industry-leading turn for the warehouse-club model. Even at the November 2025 holiday peak the days only climbed to 31. This is the operating envelope that mainstream retail cannot match without the membership-fee revenue model and the SKU rationalisation discipline that comes with it. Private operators benchmarking themselves against Costco days are benchmarking against a structurally different business — useful as a north star, not as a peer comparison.

Target (TGT) — 75 days, controlled

Target ran 75 days inventory in Q3 FY25 (period ending Nov 1, 2025) — $14.90B against quarterly COGS of $18.14B. Two years prior the same quarter ran 74 days. Inventory grew 1.1% YoY against revenue that declined 1.5% YoY — a subtle warning signal that the discipline is fraying at the edges, but nothing approaching a crisis. The TGT read is the cleanest mainstream-retail benchmark in the public cohort: aspirational for private operators in the general-merchandise and discretionary-mix categories.

Best Buy (BBY) — 98 days, up 7

Best Buy ran 98 days at Q3 FY26 (Nov 1, 2025) — $7.99B inventory against $7.42B quarterly COGS. The same quarter two years ago ran 91 days. The 7-day creep reflects soft consumer-electronics demand against committed inventory orders placed 6-9 months in advance. The Q3 read includes the holiday inventory build (Q1 FY26 ran $5.19B at 70 days). Read: under control but not improving.

Williams-Sonoma (WSM) — 131 days, up 22

WSM is the cohort's most striking days-inventory build. Q1 FY26 (May 3, 2026) closed with $1.46B inventory against $1.01B quarterly COGS — 131 days. Two years ago the same quarter ran 109 days. That is a 22-day extension over 24 months, almost entirely attributable to tariff-window inventory pull-forward across the Pottery Barn, West Elm, and Williams-Sonoma brands. The bet: pre-position stock at pre-escalation landed cost before the May 2025 and July 2025 tariff steps. The risk: that demand soft-lands harder than the company's consumer-confidence model assumed. Gross margin held at 43.9% in Q1 FY26, so the bet has not damaged unit economics yet — but the inventory pile is what it is.

Lululemon (LULU) — 159 days, down 6

Lululemon ran 159 days at Q3 FY25 (Nov 2, 2025) — $2.00B inventory against $1.14B quarterly COGS. The same quarter two years ago ran 165 days. Improvement, but still elevated. The category structural problem is that premium athletic apparel has 12-18 month product development cycles and global allocation requirements that lock inventory commitments long before demand signal clarifies. Read: directionally fine but operating at the high end of healthy.

DICK'S Sporting Goods (DKS) — 184 days, acquisition-distorted

DKS reported 184 days at Q3 FY25 (Nov 1, 2025) — $5.64B inventory against $2.79B quarterly COGS. This is M&A-distorted: the September 2025 Foot Locker acquisition added ~$2B+ of inventory at fair-value carrying step-up against a quarterly COGS run-rate that does not yet reflect Foot Locker volume. Backing out Foot Locker (Q2 FY25 ran $3.40B at ~$2.30B COGS = 134 days; same Q2 two years ago $2.85B at $2.11B = 123 days) suggests organic DKS sits at roughly 110-130 days — elevated but not crisis-level. The headline 184 is a print-quality issue, not an operating signal.

04 The tariff and freight overlay

The Q2 2026 inventory data has to be read against the May 2025 and July 2025 tariff escalations and the freight cost normalisation that followed. The pre-tariff inventory pull-forward distorted the H2 2024 and Q1 2025 ratios upward across multiple subsectors — and the comp set rolling off that pull-forward window into Q2 and Q3 2026 will mechanically improve the YoY ratios even without genuine demand improvement.

For mainstream retailers, the operating implication is that the demand-supply rebalancing is less complete than the year-over-year comparisons will make it look. The categories where pull-forward was largest — building materials, electronics, furniture and home goods, sporting goods — are the categories where Q2 and Q3 2026 inventory ratios will optically improve the most, but where the underlying demand picture has the most uncertainty. Operators should not over-index on the H2 2026 YoY ratio improvements; the base effect is doing most of the work.

Container freight rates have normalised meaningfully. Spot rates for trans-Pacific shipping ran $1,800-2,200 per FEU through Q1 2026, down from $4,500+ at the September 2024 Red Sea-driven peak. That removes one cost-side pressure from inventory carrying decisions but does not address the demand-side question. Private operators committing to Q4 2026 inventory positions in May–June 2026 are doing so against a freight environment that no longer subsidises caution — meaning the cost of being over-inventoried in November is cheaper than it was 12 months ago, which is exactly when over-ordering becomes most tempting.

05 Markdown pressure — where it lands in Q3 2026

The Q2 2026 inventory data lets us forecast where markdown intensity is most likely to concentrate as we move into the back-to-school and holiday-build seasons. Three categories sit in the high-risk zone, and one sits in the low-risk zone.

High markdown-risk: building materials and home/furniture

Building materials at 2.09 I/S ratio has not destocked. The Home Depot Q1 FY26 release flagged "ongoing demand softness in big-ticket discretionary categories" and committed to "managed pricing actions" — corporate language for markdowns. Williams-Sonoma's 22-day inventory extension over two years sits in the same logic. The H2 2026 markdown window in this category is likely to be wider, deeper, and more sustained than the H2 2025 cycle was. Private operators competing in adjacent categories (specialty home goods, mid-price furniture, garden / outdoor seasonal) should plan for sharper price competition through Q3 and Q4 2026.

Medium markdown-risk: apparel and discretionary specialty

Clothing at 2.09 has done substantial destock work but still has 15-25 bp to compress. The Lululemon, Gap, American Eagle, and Urban Outfitters cohort have all flagged "promotional intensity remaining elevated" through their Q4 2025 and Q1 2026 calls. The good news is the trajectory is improving; the bad news is the level is still high enough to drive sustained markdowns in 2026. Private DTC apparel brands should plan working capital around a 200-400 bp gross-margin headwind through 2026 as inventory clears.

Low markdown-risk: food, general merchandise, beauty

Food at 0.76 turns fast and the structural overstocks are negligible. General merchandise at 1.23 has done the destock work. Beauty (NAICS 446, not in the public FRED subsector cut but readable through Ulta and e.l.f. 10-Qs) has structurally held — Ulta's Q3 FY25 operating margin held at 10.8% and the company is buying back $370M+ of stock per quarter, neither of which is consistent with a markdown-pressured environment. Private operators in these categories face less inventory-clearing competition; the working capital cycle is operating closer to normal.

06 What private operators should do — operating responses

The Q2 2026 inventory read translates into specific operating decisions for private retailers and DTC/CPG brands. Five responses sequenced by what to do first.

1. 01
   Re-baseline your category benchmark immediately. The "industry average" days-inventory number you used in last year's budget or in your last sponsor process is now stale. Pull the latest Census subsector ratio for your NAICS code, pull the listed-peer cohort that matches your channel mix and AOV, and compute your own days inventory the same way. If your days are above the peer median, your sponsor or banker is going to see it before you do. Get ahead of it.
2. 02
   Run a 90-day SKU-level inventory triage. For each SKU, compute weeks-of-supply at current sell-through and tag everything above 26 weeks as "review for clearance." For SKUs above 39 weeks, build a clearance plan with specific markdown depth and timing. Brands that get the markdown work done in Q3 2026 protect their Q4 holiday gross margin; brands that wait until Q4 give it up in panic markdowns. The SKU-level discipline matters more than the corporate-level inventory number.
3. 03
   Renegotiate vendor commitments where you can. For purchase orders not yet shipped, push back on quantity, push back on timing, or push back on landed cost. The vendor side of the supply chain has even more inventory than the retail side (wholesale at $933B, up 5.1% over 2 years) — their willingness to renegotiate is structurally higher than they will signal in the first conversation. Brands carrying the bulk of the inventory exposure are sometimes the ones paying for inventory their vendor wishes was off their books too.
4. 04
   Rebuild your reserves before sell-side or audit cycle. If you are tracking toward a sell-side process or a year-end audit in 2026, the returns reserve, trade-deduction accrual, and inventory standard-cost adequacy are the three lines most likely to surface as QoE adjustments against a high-inventory backdrop. Rebuild them on the layered model (SKU × channel × season) before someone else does. Our buy-side QoE post documents what the diligence team will find if you do not get there first.
5. 05
   Reset working capital assumptions for 2026 H2 and 2027 H1. If your treasury model assumes inventory unwinds at "industry-normal" rates over the next 12 months, the Q2 2026 data says you need a category-specific overlay. Home and apparel brands should model a 60-90 day inventory normalisation extension. Food, beauty, and general merchandise can stay close to baseline. Hold an extra 4-8 weeks of operating liquidity if you are in a high-build category.

07 What we are watching into Q3 2026

Three signals matter into Q3 2026. First, whether the building-materials I/S ratio rolls back below 2.00 — the May 2026 release (covering April data) is the test. If it stays at 2.05+ through summer 2026, the markdown wave we are forecasting for H2 2026 will be sharper than the cohort consensus expects. Second, whether the Q2 calendar earnings cohort (Target, Best Buy, Williams-Sonoma reporting in May–June 2026) calls out reserve adequacy changes — any uptick in returns reserve as % of sales, inventory write-downs, or shrink adjustments is an early warning that the diligence-style adjustments are appearing in audited filings. Third, whether the wholesale inventory line (WHLSLRIMSA) starts compressing — the retail layer has done some destock work, but the channel above it has not. The wholesale-side clearance is the lever that determines whether 2026 H2 markdowns are short and sharp or long and grinding.

We publish this read quarterly; the Q3 2026 update will land in August 2026 covering July data, which is the cleanest test of whether the pre-tariff inventory pull-forward has properly cleared.