> ## Documentation Index
> Fetch the complete documentation index at: https://www.twicecommerce.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# How to find overdue orders

> Filter the Orders table to the open and in-progress orders whose end date has passed, and save it as a view to check every morning.

> [card] [Open in TWICE Admin](https://admin.twicecommerce.com/orders)
>
> orders

Save a view of the orders that should already be finished: still **Open** or **In progress**, with an end date before today. The **Orders** table has no overdue column, so this view is where late orders surface. [Order Lifecycle](https://www.twicecommerce.com/docs/concepts/orders/order-lifecycle.md) explains Open, In progress and Completed.

## Prerequisites

> [!WARNING]
>
> **Required permissions:** **View orders** (`orders:order` in view) to open **Orders**. All four system roles hold it, and saving a view of your own needs nothing more. See [Users & Roles](https://www.twicecommerce.com/docs/settings/users-roles.md).

> [!NOTE]
>
> **Have ready before you start:**
>
> * **A name for the view**, such as Overdue.

## The walkthrough

**1. Open Orders on the All tab**

Select **Orders** in the left sidebar and click the **All** tab above the table. If filters show under the search box, click **Reset** at the right end of their row. With more than one location, check the location selector in the top-left corner first: the table lists only that location's orders.

![The Orders table with no filters, with Orders in the left sidebar and the All tab highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-01.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=2de6682fcbaaf1ec7d6ed61267ab309c)

**2. Filter on Stage**

Click the funnel button to the right of the search box, whose tooltip reads **Filter**, and choose **Stage** in the list of columns. A **Stage** filter appears under the search box with its panel open, listing **Open**, **In progress** and **Completed**.

![The list of columns open under the Filter funnel button, with the button and Stage highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-02.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=1b66af33d9a5203c8093b8ac8204340b)

**3. Tick Open and In progress**

Select the checkboxes next to **Open** and **In progress**, then click outside the panel to close it. The table lists every order that is not completed.

![The Stage filter's panel open, with the Open and In progress checkboxes ticked and highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-03.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=8f4e23a14eb5853ebf31584fefd364a5)

**4. Add an End date filter**

Click **Add filter** beside the **Stage** filter and choose **End date** in the list of columns. Type the start of its name in **Search by column name** at the top of the list to find it. Its panel opens under the new filter, with an operator list that reads **is**.

![The column list open under Add filter, narrowed by a search, with Add filter and End date highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-04.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=ea2b763b1d30efadaa92794529a33921)

**5. Choose is before today**

Open the operator list and choose **is before today**, then click outside the panel to close it. The table lists the orders whose end date has passed and that nobody has completed.

![The End date filter's panel with its operator list open, and the is operator and is before today highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-05.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=b58e880b7c7e71460b9b19e30b763644)

**6. Save the table as a view**

Click the plus button at the end of the tab row. A new tab opens with a placeholder name, such as View 4, and the number of orders it holds beside the name. It keeps both filters.

![The new view's tab selected with both filters in place, and the plus button and the new tab with its count highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-06.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=beba8c7a26344a62dc15d8e52fe9cf83)

**7. Open Rename**

Click the arrow next to the new tab's name. A menu of view actions opens. Choose **Rename**, and the **Rename view** dialog opens.

![The new view's menu open under its tab, with the arrow beside the tab name and Rename highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-07.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=df6a9118eba72f5fa3a35398d9c80231)

**8. Name the view**

Enter Overdue in **View name** and click **Save**. The dialog closes and the tab shows the new name.

![The Rename view dialog with a name entered, and the View name field and the Save button highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-08.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=2907a429d5bcbbc01f1c3f11a56fba75)

**9. Open an order from the view**

Click an order's row to open it. An item that went out and is past its return date carries an **Overdue** chip on its line, and the banner under the order's header counts the late items, such as **1 item is overdue**.

![An In progress order opened from the view, with the Overdue chip on its line and the 1 item is overdue banner highlighted](https://mintcdn.com/twicecommerce/gAy6DOwWGKXblDg8/images/guide-find-overdue-orders-09.webp?fit=max\&auto=format\&n=gAy6DOwWGKXblDg8\&q=85\&s=308d96eafd5dce19d95bc3df6941a9eb)

## How do I know it worked?

* **The Overdue tab** is on the tab row, with a count of the orders on it.
* **Every row ended before today** and is still open or in progress.
* **An order leaves the view** once it is completed.

## Troubleshooting / common pitfalls

> [accordion] An order on the view has every item back
>
> Its **Fulfillment state** reads **Returned**, so nothing is out, but nobody completed the order. Complete it to take it off the view. See [Complete an order](https://www.twicecommerce.com/docs/guides/orders/complete-an-order.md).

> [accordion] An Open order is on the view
>
> Nobody moved it to **In progress**, so its items may never have gone out, and the order page counts only items that went out as overdue. Start the order or cancel it. See [Order Lifecycle](https://www.twicecommerce.com/docs/concepts/orders/order-lifecycle.md#faqs).

> [accordion] An order due back today is not on the view
>
> **is before today** compares whole calendar days, so an order that ends today joins the view tomorrow. Keep a view of today's returns for those. See [Tables](https://www.twicecommerce.com/docs/admin/tables.md#filtering).

## Related articles

> [card] [Order Lifecycle](https://www.twicecommerce.com/docs/concepts/orders/order-lifecycle.md)
>
> The statuses an order moves through, and what each move does.

> [card] [Planning the day](https://www.twicecommerce.com/docs/guides/orders/daily-pickups-and-returns)
>
> Every walkthrough for working the day from the Orders table.

> [card] [Save a daily view](https://www.twicecommerce.com/docs/guides/orders/save-a-daily-view.md)
>
> Save today's pickups or returns as a tab on the Orders table.

> [card] [Returns and damage](https://www.twicecommerce.com/docs/guides/orders/handle-a-return)
>
> Take goods back late, damaged or in part.

> [card] [Complete an order](https://www.twicecommerce.com/docs/guides/orders/complete-an-order.md)
>
> Close the order once nothing is left to do on it.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.