How to Identify Late Orders

If you cannot find answer then contact us.

< All Topics
Print

How to Identify Late Orders

In order to identify late order, a seller must down a Purchase Order Report in the Seller Portal.

Login to your Seller Portal account.

Go to Seller Tools > Reports.

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

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.

Excel File for Calculating Late Orders

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.

Was this article helpful?
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous Improving Metrics & Best Shipping Practices
Next Getting a Suspended Account Reinstated
Table of Contents