** Indicates a Drop Ship Metric only.

Key Terms

  • Supplier Name - Name of the Supplier communicated on the Purchase Order.

  • Supplier Number - Supplier Number as identified by you the retailer

  • Product Number - Product Number as communicated on the Purchase Order

  • Product Description - Product Description as communicated on the Purchase Order.

  • Vendor Part Number - An item identifier provided by the vendor

  • Buyer Part Number - An item identifier provided by the buyer

  • Department - Department as communicated on the Purchase Order

  • Buyer - Name of the buyer as communicated on the Purchase Order**

  • Purchase Order Date - Purchase Order Date as communicated on the Purchase Order

  • Purchase Order Number (PO#) - Purchase Order as communicated on the Purchase Order.

  • PO Type – Fulfillment Model as communicated on the Purchase Order**


Report Metrics

Sales

  • Current Extended Price – Sum total of Order dollar amounts.

  • # of Orders – Sum total number of Orders.

Fill Rates

  • On-time PO Fill Rate Original – Percentage of items received on time in relation to the original Purchase Order quantity.

  • On-time PO Fille Rate Revised – Percentage of items received on time after any Vendor or Retailer initiated changes have been applied.

  • PO Fill Rate Original – Percentage of items that were filled by your Vendors, based on the original Purchase Order values.

  • PO Fill Rate Revised – Percentage of items that were filled by your Vendors after any Vendor or Retailer initiated changes have been applied.

Volume

  • Original Order Quantity – Total quantity of items listed on original purchase orders.

  • Revised Order Qty – Total quantity of items listed on original purchase orders.

  • Shipped Qty – Total quantity of items shipped.

  • # of Orders Shipped – Number of orders that have one or more shipments sent against them.

  • # Shipments – The total number of shipment documents received. Note that a shipment can contain multiple orders. Meaning there may not be a 1:1 ratio between # Orders Shipped and # Shipments.

  • # POs w Invoices – Number of orders that have one or more invoices sent against them.

  • Line Items Current – Total number of current line items on the purchase order.**

  • Current Order Qty - The total number of items ordered taking into account any Purchase Order Changes that have been sent.**

  • Overship Qty – Number of items that have been over shipped.**

Order Timeliness

  • Avg Variance to Ship By Date – The average number of days between the Ship By Date given on Purchase Orders and when those orders actually shipped.

    • For this metric, a value of 0 means that Vendors are shipping on the Ship By Date.

    • Negative numbers indicate that orders were shipped before the given Ship By Date. These orders could either be on time or possibly early.

    • Positive numbers indicate that orders were shipped after the given Ship By Date. These would be considered late.

  • % Early Shipments – Percentage of shipments with a Ship Date that fell before the Ship Not Before date.

  • % On-Time Shipments / & Shipped on Time – Percentage of shipments sent within the shipping window.**

  • % Late Shipments – Percentage of shipments with a Ship Date that fell after the Ship By Date.

  • Ship Not Before Date – Ship Not Before Date as communicated on the Purchase Order**

  • Ship By Date – Ship By Date as communicated on the Purchase Order.**

Compliance

  • % POs w 855 Acks - Percentage of orders that received an 855 (Purchase Order Acknowledgment).

  • % POs w Changes – Percentage of orders for which an 860 (Purchase Order Change) was sent.

  • % POs w ASN - Percentage of orders that received an 856 (Advance Ship Notice).

  • % POs w Invoice - Percentage of orders that received an 810 (Invoice).

  • % 846 w INV – Percentage of days within a specified timeframe that a supplier sent at least one 846 Inventory Advice.**

  • Avg 846 INV Count/Day – This is the count of all 846 Inventory Advice documents sent by a supplier for a specified timeframe divided by the number of days within the timeframe.**

  • # Acknowledgements – Number of Purchase Order Acknowledgments received against a Purchase Order.**

  • # Changes - Number of Purchase Order Changes that were sent against the Purchase Order.**


🆘 SPS Support

If you have any additional questions regarding Order Performance Analytics changes, please reach out to our Support team at the contact information below:

✉️ Support@spscommerce.com

Did this answer your question?