Inventory 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick inventory perishable fefo

Expiring/Perishable Stock Priority (FEFO)

Using an expiry-date metafield, rank stock oldest-to-newest per SKU and flag units approaching expiry so fulfillment picks them first and markdowns go out before they're wasted.

📋 Prompt
Run in Sidekick
Help me manage first-expired-first-out for my perishable/dated products using the [EXPIRY_DATE_METAFIELD] metafield I track expiry dates in.


  Pull every SKU in [PRODUCT_LIST_OR_COLLECTION] that has an expiry date recorded in [EXPIRY_DATE_METAFIELD], along with current on-hand quantity.
  Flag every unit/batch with an expiry date within the next [EXPIRY_ALERT_WINDOW_DAYS] days, sorted soonest-to-expire first.
  For each flagged item, show current sales velocity and calculate whether it will sell through before expiry at the current rate — flag the ones that won’t.
  For items that won’t sell through in time, recommend a markdown percentage and start date to accelerate sell-through before the expiry date.
  If any SKU has multiple batches with different expiry dates recorded, note that Shopify inventory doesn’t track batch-level FEFO natively, so I need to manually direct fulfillment/warehouse staff to pick the oldest-dated units first for that SKU — call this out explicitly, don’t imply the system enforces it automatically.


Give me the expiry-risk table first, then the markdown recommendations below it.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions