Use Stock Age Data to Clear Aged Inventory and Spotlight New Arrivals
supplemental-datainventory-managementgoogle-shoppingmeta-adscampaign-strategy

Use Stock Age Data to Clear Aged Inventory and Spotlight New Arrivals

By FeedOn Team ·

The Inventory Blind Spot in Advertising

Your warehouse management system knows exactly how long every product has been sitting on the shelf. Your ERP tracks receipt dates. Your inventory team watches aging reports weekly.

But none of this information reaches your advertising. Google Shopping doesn't know that SKU-3001 arrived yesterday and SKU-3002 has been gathering dust for 4 months. So both get the same ad treatment — same bids, same budget, same priority.

This is a missed opportunity on both ends:

  • New arrivals deserve premium visibility to build early momentum

  • Aged inventory needs promotional push before it requires deep markdowns

Step 1: Export Stock Age to a Sheet

Most ERP and WMS systems can export an inventory aging report. Convert it into a Google Sheet with a simple structure:

SKUreceipt_datedays_in_stockstock_tierSKU-30012026-02-207New InSKU-30022025-12-0188ClearanceSKU-30032026-01-1543CoreSKU-30042026-02-252New In

Tier logic:

  • New In — received in the last 14 days

  • Core — 14 to 60 days in stock

  • Clearance — over 60 days in stock

You can calculate stock_tier directly in Google Sheets with a simple formula, or pre-calculate it in your export.

Step 2: Merge into Your Feed

Connect the sheet via FeedOn's Supplemental Data Mapping. Map the SKU and merge the stock_tier column. Then use a feed rule to assign it to a custom label (e.g., custom_label_2).

Step 3: Build Lifecycle Campaigns

New In Campaign

  • Filter: custom_label_2 = "New In"

  • Strategy: Higher bids, broader targeting, maximize impressions in the first two weeks

  • Goal: Build click history and conversion data early so Google's algorithms learn faster

  • Meta: Feature in Collection Ads with "Just Arrived" creative

Core Campaign

  • Filter: custom_label_2 = "Core"

  • Strategy: Standard bidding, let Smart Bidding optimize based on accumulated data

  • Goal: Maintain steady sales velocity

Clearance Campaign

  • Filter: custom_label_2 = "Clearance"

  • Strategy: Pair with a price reduction or free shipping offer. Lower ROAS target to prioritize volume.

  • Goal: Move aged inventory before it needs a deep discount

  • Meta: Create urgency-driven ads — "Limited Stock" or "Last Chance"

Why This Matters for Your Bottom Line

Aged inventory is expensive. It ties up capital, takes up warehouse space, and eventually gets marked down to a loss. By pushing aged stock through ads before it hits critical age, you:

  • Sell at higher prices (20% off now vs. 50% off later)

  • Free up warehouse space and working capital

  • Reduce end-of-season write-offs

Meanwhile, new arrivals get the visibility they need to build early sales momentum — which feeds into Google's and Meta's algorithms, improving their long-term performance.

Keep the Sheet Updated

Stock age changes daily. Set up a weekly (or even daily) export from your ERP to the Google Sheet, then schedule a refresh in FeedOn. The tiers update automatically, and products move between campaigns as they age — no manual intervention.

1. What is stock age and why is it important for retailers?

Stock age refers to the length of time inventory has been sitting in your warehouse or store without being sold. It's a critical metric for retailers because aging inventory ties up capital, occupies valuable warehouse space, and can lead to markdowns or obsolescence. Understanding stock age helps businesses make informed decisions about pricing, promotions, and purchasing to maintain healthy inventory turnover and profitability.

2. How does aging inventory negatively impact my business?

Aging inventory creates several challenges for your business: it locks up working capital that could be invested elsewhere, increases storage and handling costs, raises the risk of product obsolescence or expiration, and often requires steep discounts to clear. Additionally, older stock can prevent you from stocking fresh, in-demand products, ultimately affecting customer satisfaction and your bottom line.

3. What strategies can I use to clear old inventory effectively?

Effective strategies for clearing aging stock include implementing strategic markdown pricing, bundling slow-moving items with popular products, running targeted promotions or flash sales, offering discounts to loyal customers, partnering with liquidation companies, donating excess inventory for tax benefits, and using AI-powered tools to optimize clearance timing and pricing to maximize recovery value.

4. How can I prevent inventory from aging in the first place?

Prevention starts with accurate demand forecasting using historical sales data and market trends. Implement a robust inventory management system that tracks stock age in real-time, establish reorder points based on actual demand patterns, conduct regular inventory audits, use FIFO (First-In-First-Out) practices, and leverage AI-powered predictive analytics to anticipate demand shifts before they impact your inventory levels.

5. How do I balance clearing old stock with making room for new arrivals?

The key is strategic planning and timing. Use data analytics to identify which aging items to clear first based on profitability and space requirements. Schedule clearance promotions ahead of new product launches, allocate specific warehouse zones for incoming merchandise, and implement a phased approach where you gradually reduce old stock while ramping up new arrivals to maintain consistent revenue flow.

6. What role does AI play in inventory management and stock optimization?

AI-powered inventory management systems analyze vast amounts of sales data, seasonal trends, and market conditions to provide accurate demand forecasts. These tools can automatically identify aging stock, recommend optimal markdown timing and pricing, predict which new products will perform best, optimize stock levels across multiple locations, and help prevent both overstock and stockout situations, leading to improved profitability.

7. When should I mark down aging inventory versus holding it longer?

The decision depends on several factors: product type and shelf life, storage costs, upcoming seasonal changes, and historical markdown effectiveness. Generally, it's better to take controlled markdowns earlier rather than waiting until stock is severely aged and requires deeper discounts. AI analytics can help determine the optimal markdown timing by calculating the trade-off between holding costs and potential recovery value.