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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions