How do I identify which orders were shipped late?

When is an order considered as late?

An order is considered as late when it is not shipped by the “Expected Ship Date” aka “Ship by Date”.  We calculate the Expected Ship Date based on a Seller’s order prep time (SOPT) and any non-shipping dates that Sellers enter into the Seller Portal.

After an order is shipped, Sellers provide the actual ship date when creating the shipment notification (ASN).

When we calculate the late ship rate we take the following into account:

  • The date range is based on the Expected Ship Date and not the PO Date.
  • Any order that has not been marked as shipped yet and is overdue (past the expected ship date) is considered as late.
  • If the order has 2 or more lines items, if 1 item was shipped on-time and 1 item was shipped after the Expected Ship Date, the order is considered late. We count orders, not quantity or line items.
  • Canceled orders still count in the total order count for a given period of time.

Running a report

Login to your Seller Portal account.

Go to Seller Tools > Reports

In the Report type field, find the report called “Purchase Order Report”.

3-23-2017 8-17-40 AM

Populate the ‘Expected Ship by Date’ fields to filter your report.

Note: If you received a notice from the Seller Performance team that stated your late ship rate was reviewed, the date range will be stated in the email. Use those two dates to filter your report.

Click the download report

Adding a calculated field in the Excel file to see what was late.

Open the Purchase Order Report Excel file. You will find columns L & M are the ‘Expected Ship Date’ and the ‘Actual Ship Date’.  If the ‘Actual Ship Date’ field is blank, the order is either canceled or still open.

Insert a column to report to the right of the Actual Ship Date column. Add an equation that checks if the Actual Ship Date is greater than the Expected Ship Date.  For example “=M2>L2”.  If a result is “TRUE” then, that line item was shipped late.

Remember, an overdue order is late. Any line item that is late will make the entire order be considered as a late order.