A reorder trigger for an expiry-dated product needs more than an inventory total. The worksheet should show which units remain usable, how the supplier supplies them and what uncertainty the business is willing to carry.
Build the product record
- Identify the marketplace, SKU and pack size, including any case-pack purchasing requirement.
- Record the supplier's confirmed production, preparation and transport commitments separately.
- List expiry lots and the remaining usable stock in each location. Do not combine quarantined, damaged or expired units with stock available for sale.
- Note known promotions and purchase commitments as dated inputs, rather than treating them as ordinary historical demand.
Amazon's expiry-dated product guidance covers the US store. Check the destination store's current instructions separately before applying its preparation or shelf-life requirements.
Review the trigger with a person
Record the restock trigger chosen for the product and why it fits the supplier commitments, available cash and expiry constraints. If a supplier changes a commitment, revisit the trigger instead of leaving the worksheet untouched.
Keep the chosen order quantity, the approver and the supplier confirmation with the purchase record. Review the trigger when a supplier commitment, expiry constraint or stock record changes.