> For the complete documentation index, see [llms.txt](https://howto.sellercraft.co/how-to-sellercraft/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://howto.sellercraft.co/how-to-sellercraft/oms/sellerwizard/ops-report/advance-ops-report.md).

# Advance Ops Report

Advance Ops Report consists of a comprehensive table that contains detailed information about orders, including item details, inventory, delivery status, and more. It provides sellers with an in-depth view of their e-commerce operations to help them make informed business decisions.

<figure><img src="https://3200660590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FY00avLzsxCKjiygAWqkf%2Fuploads%2FIQXLhDznBACN3jnt5Gng%2Fadvance%20ops%20report.png?alt=media&amp;token=20aef4bc-1899-422d-b8ef-4b23d989c5c0" alt=""><figcaption></figcaption></figure>

## Controls

1. Filter report by shop
2. Filter report by a date range
3. Filter report by order status
4. Select the columns you want to include in the table

{% hint style="info" %}
The report view can be switched between simple and advanced modes by utilizing the toggle option located on the upper right corner of the table.
{% endhint %}

{% hint style="info" %}
The table can be exported through the designated button located on the upper right-hand corner of the table.
{% endhint %}

## Column Definition

<table><thead><tr><th width="151">Column</th><th>Description</th></tr></thead><tbody><tr><td>Order Number</td><td>The unique identification number for each order.</td></tr><tr><td>Order Item ID</td><td>The unique identification number for each item within an order.</td></tr><tr><td>Shop</td><td>The name of the shop that the order was made from.</td></tr><tr><td>Inventory SKU</td><td>The inventory stock keeping unit (SKU) for the item.</td></tr><tr><td>Seller SKU</td><td>The seller SKU for the item.</td></tr><tr><td>Quantity Total</td><td>The total quantity of the item ordered.</td></tr><tr><td>Category</td><td>The category of the item.</td></tr><tr><td>Ordered At</td><td>The date and time when the order was placed.</td></tr><tr><td>Status</td><td>The current status of the order.</td></tr><tr><td>Week</td><td>The week in which the order was placed.</td></tr><tr><td>Year</td><td>The year in which the order was placed.</td></tr><tr><td>Pending Days</td><td>The number of days the order is pending.</td></tr><tr><td>SLA Expires at</td><td>The date and time when the service level agreement (SLA) for the order expires.</td></tr><tr><td>RTS Time</td><td>The date and time when the order was ready to ship.</td></tr><tr><td>Shipped Time</td><td>The date and time when the order was shipped.</td></tr><tr><td>Shipping Provider</td><td>The provider used to ship the order.</td></tr><tr><td>Tracking Code</td><td>The tracking code for the shipment.</td></tr><tr><td>Delivered Time</td><td>The date and time when the order was delivered.</td></tr><tr><td>Delivered Failed Time</td><td>The date and time when the delivery of the order failed.</td></tr><tr><td>Return Complete Time</td><td>The date and time when the return for the order was completed.</td></tr><tr><td>Cancelled Time</td><td>The date and time when the order was canceled.</td></tr></tbody></table>