Orders

Orders

The Orders page is where you manage every purchase Seller Oracle has recorded from your retailer emails. It is the page you will spend the most time in.

The orders list

Orders are shown in a paginated table, 50 per page, newest first. Each row carries the data Seller Oracle extracted from the email trail:

• Order: the product names in the order (one line per item).
• ASIN: the Amazon ASIN matched to each item. If an item has no ASIN yet, you can assign one here.
• Qty: quantity per item.
• Order Ref: the retailer's order number.
• Date: when the purchase was placed.
• Retailer: where you bought from.
• Total: the order total in the retailer's currency. For foreign-currency orders, a home-currency figure appears next to it (see Foreign-currency totals).
• Invoice: the invoice tracking status. Click it to change it.
• Status: the order status. Click it to change it.
• Prep: whether the items have been sent to your prep centre. Click it to change it.
• Amazon: a rollup of how many items in the order are listed on Amazon.

Click any row to open the order's detail page.

Filtering and search

The filter bar above the list narrows the table. Filters combine, so you can stack a retailer, a status, and a search term at once.

• Status tabs: the tab bar filters by order status and covers every order status. Each tab shows a live count. There is also a Hidden tab at the end for orders you have hidden.
• Retailer: filter to a single retailer. Each option shows that retailer's order count.
• Invoice: filter by invoice tracking status.
• Prep: filter by whether items have been sent to prep.
• Amazon: filter by listing progress (Listed on Amazon, or Not listed).
• Reviews: filter to orders that need review or have been resolved (see Orders flagged for review).
• Search: match on order reference, product name, or retailer name. Type a full 10-character ASIN to find every order containing that ASIN.

Use Clear to reset the filters and the search box.

Foreign-currency totals

When an order is in a currency other than your home currency, the Total column shows a second, smaller figure in your home currency, for example €29.99 ~£25. The tilde means the figure is an estimate from the daily exchange rate. For a full explanation and how to record the real settled amount, see Multi-currency orders.

Orders flagged for review

Seller Oracle reads your emails with AI. Most extractions are clean, but some are not. When an extraction looks off, the app flags the order for review rather than letting a wrong number sit silently in your records.

A red Review badge appears next to the order reference in the list. For a full explanation of the flag reasons and how to resolve them, see Accuracy and review.

Use the Reviews filter to pull up everything that needs attention. Open a flagged order, check the figures against the email, correct anything wrong (see Correcting the figures), then mark it reviewed. Resolved orders stay in your records and can be found again with the Resolved option in the same filter.

Order detail

Click an order to open its detail page. Everything about the order is here, and most of it is editable inline.

Header and status

The header shows the retailer name and the order reference. Below it are badges for the current status, whether the order has been sent to prep, and the Amazon listing rollup, plus a Report Problem button.

To change the status, invoice status, or prep state, use the Update Fulfillment panel and the Invoice row. Status and invoice both save as soon as you submit. For what each value means, see the order statuses and invoice statuses reference.

Needs review banner

If the order was flagged, a Needs Review banner sits at the top of the page. It lists the specific reasons the AI was unsure and, where available, a short summary of what it decided. Check the figures against the linked emails, fix anything that is wrong, then click Mark Reviewed. The banner clears and the Review badge comes off the order in the list.

The financial details

The detail panel holds the money side of the order:

• Total Amount: the order total, editable.
• Currency: the retailer's currency (GBP, EUR, or USD), editable.
• Settled: shown for foreign-currency orders, in your home currency. This is the estimated conversion until you type the real amount your bank charged. A tilde marks the estimate; once you save your figure the tilde goes.
• Shipping Cost: extracted separately when the email includes it, editable.

To edit any of these, click the pencil next to the value, change it, and save.

The order items

The items table lists every line in the order with its product name, quantity, unit price, line total, ASIN, SKU, Amazon listing status, and item status. Quantity, unit price, and line total are each editable inline (click the pencil). Items can hold different statuses to each other, so one line can be dispatched while another is still on order.

• ASIN: the Amazon ASIN this product maps to. If an item is unmatched, assign the ASIN here. The ASIN is saved against that item. To assign ASINs across multiple unmatched items at once, use the To-do list.
• SKU: auto-generated from your SKU settings, or edit it by hand (40 characters maximum).
• Amazon: the per-item listing status: Not listed, Listing..., Listed, or Failed. The Amazon column on the orders list rolls these up across the order.

Correcting the figures

Every financial edit you make, on the order or on an item, is recorded. The Correction History panel at the bottom of the page logs each change with the field, the old value, the new value, who made it, and when. It is a full audit trail, so corrected records stay trustworthy.

The old manual "Listed on Amazon" toggle is gone. The Amazon column and badge are now worked out from each item's listing status, not set by hand.

Notes and feedback

Add free-text Notes to any order. There is also a separate Feedback field for anything you want to flag to the Seller Oracle team about how the order was read.

Delivery OTP

If an email contained a one-time delivery code, it is shown prominently near the top of the order, and a matching alert appears on your dashboard. Read the code out to the driver.

Linked emails

Every email tied to the order is listed under Email Trail: the order confirmation, dispatch and delivery notices, returns, and so on. Click any subject to open the full email. Attachments such as invoices and receipts are listed in their own section.

Report a problem

If Seller Oracle read something wrong and you would rather flag it than fix it yourself, click Report Problem, describe what is wrong, and submit. The team picks it up and you can track the resolution.

Hide an order

If an order is a duplicate or came from an email that should not have created one, hide it. Hidden orders are soft-deleted, so they drop out of your list and stop counting towards your spend, but nothing is lost and you can restore them. Hiding shows a toast with an Undo button, and the Hidden tab on the list holds everything you have hidden.