Aging Inventory

Last Updated: Jan 14, 2019 08:55AM PST
This report measures the age of on-hand inventory based on the last date each variant was received on a purchase order. Use this report to identify aging inventory and take action on it.

Note: This article applies only to Stitch Classic.

Parameters

This report provides a real-time snapshot and can't be filtered.

This report only includes variants that have been received on at least one purchase order.

Data

This report includes the following fields:
Field Definition
Variant ID Variant ID in Stitch
Variant Name Name of the variant
SKU The variant's SKU number in Stitch
Last Received PO ID The purchase order ID of the last PO on which this variant was received in Stitch
Last PO Supplier The supplier assigned to the last PO on which this variant was received in Stitch
Last Received Date The most recent date on which this variant was received on a PO
Days Since Last Received The number of days since the last time this variant was received on a PO
Last Received Quantity The number of units received the last time this variant was received on a PO
Last 30 Days Units Sold The number of units of this variant sold in the past 30 days - based on order date (units may not be fulfilled yet)
Current Stock The current total Stock of this variant in Stitch
Current Available The current Available stock of this variant in Stitch
Last Received Value The monetary value of the units received the last time this variant was received on a PO. Calculated as Units x Cost (cost listed on the PO)
Last 30 Days Value Sold The monetary value of the units of this variant sold in the past 30 days. Calculated as Units Sold x AUC
Current Stock Value The monetary value of the total Stock of this variant. Calculated as Stock x AUC
Current Available Value The monetary value of the Available stock of this variant in Stitch. Calculated as Available x AUC

Use Cases

Use this report for a high-level view of fast and slow-moving products. Variants are ordered by days since last received (oldest first) then by number of units sold in the past 30 days (slowest movers first). Old slow movers are great candidates for flash sales, discounts, and bundles.