Channel Orders
See, search and manage every Amazon, Walmart and manual order in one list, and act on many orders at once.
What it's for
Channel Orders is your main order list. Every order from Amazon and Walmart, plus any order you create by hand, lands here. Use it to:
- See which orders still need work and which are close to their ship-by date.
- Search for one order, or filter down to a group of orders.
- Change status, reroute, export, mark shipped or cancel many orders at once.
- Create a manual order or upload orders from a spreadsheet.
Click any row to open the order window with all of its details. That window has its own article: Order details window.
Where to find it
In the left sidebar, open Orders and click Channel Orders.
You need the Orders permission to see this page. If the number of problem orders appears on the dashboard, its View orders button also brings you here.
The screen at a glance
Status tabs
The row of tabs across the top splits your orders by where they are. The number next to each tab is how many orders it holds.
| Tab | What's in it |
|---|---|
| Pending | Orders that are not ready to ship yet. Either Amazon has not released them yet, or they have been sent to a vendor and are waiting for the vendor's confirmation (the "855"). |
| Unshipped | Orders you still need to ship: New, Routed, Acknowledged, OK to ship, On hold and Problem. |
| Canceled | Cancelled orders, plus return requests on orders that never shipped. Its number only shows while you are on this tab. |
| Shipped | Shipped orders, plus return requests on orders that did ship. |
| All | Every order. |
Very large counts are rounded, for example "40K+" or "1M+".
Quick filters
Some tabs show a row of quick filter chips under the tabs. Only one chip can be on at a time.
On the Pending tab:
- All β every pending order.
- Still on hold at Amazon β Amazon has not released these yet. Nothing for you to do.
- Released β awaiting 855 β Amazon released these and they are waiting on a vendor. This is the chip that is on when you open the tab, because these are the orders waiting on you.
On the Unshipped tab:
- All β every unshipped order.
- Verge of late β the ship-by date is today.
- Verge of cancellation β the ship-by date has already passed.
These two chips count days in US Pacific time, the same way Amazon Seller Central does, so the numbers should match Seller Central.
Channel tabs
Under the status tabs you can pick All, Amazon or Walmart. The table and the tab counts change to show only that channel.
Toolbar
- Search box β type an order number, OP order number, customer name or channel SKU. When you search, the page jumps to the All tab so the order is found whatever its status.
- Filters β add one or more filters (see below). Each filter you add shows as a green chip. Click a chip to change it, click its β to remove it, or click Clear all.
- Actions β the bulk actions menu (see the table below).
- + Create manual order β opens the form for a new order.
- When orders are ticked, a "N selected" count shows at the right.
Filters
| Filter | How it works |
|---|---|
| Order status | Tick one or more statuses, such as New, Awaiting 855, OK to ship, Problem, Buyer wants to cancel or Return requested. |
| Payment | Unpaid, Paid, Partially refunded or Refunded. |
| Order date | A from and to date. |
| Ship by date | A from and to date. |
| Deliver by date | A from and to date. |
| Channel SKU | Paste a list, one per line or separated by commas. |
| Catalog SKU | Paste a list. |
| Source SKU | Paste a list. |
| Linked to vendor | Shows orders whose items are linked to a given vendor, or not linked at all. |
| Assigned to | Who holds the order's items: Warehouse, one of your vendors, or Unassigned. |
| Amazon order #s | Paste a list of marketplace order numbers. |
| OP order #s | Paste a list of OrderPilot order numbers. |
Filters stay on when you change channel. Switching to a different status tab clears all filters and the search box.
Table columns
| Column | What it shows |
|---|---|
| OP Order # | OrderPilot's own order number. The small tag under the channel icon says who ships it: FBA or FBM for Amazon, WFS or Seller for Walmart. |
| Marketplace # | The order number on Amazon or Walmart. For Amazon it is a link that opens the order in Seller Central. |
| Picture | The first item's picture. Hover to see it bigger. |
| Item | The first item's title. "+2" means there are more items. |
| Channel SKU | The first item's SKU on the channel. |
| Customer | The buyer's name. |
| Items | How many different items are on the order. Hover over it to see each item with its ASIN, catalog SKU, vendor SKU and status. |
| Qty | Total units ordered. |
| Price paid | What the buyer paid. Hover to see a quick profit and loss breakdown, marked "estimate" or "final". You only see this if you have the Financials permission. |
| Status | Where the order is. "Buyer wants to cancel" replaces the status when the buyer asked to cancel. "Rerouting" shows while a reroute is running. |
| Payment | Paid, Unpaid, Partial refund or Refunded. |
| Ship by / Deliver by | The dates the channel requires. |
| Vendor | Who is filling the order: a vendor, "Warehouse", or "2 vendors" when it is split. |
| Placed | When the buyer placed the order. |
| Date | When the order arrived in OrderPilot. |
Small copy icons next to order numbers and SKUs copy the value with one click.
You can change the table to suit you:
- Sort β click a column header to sort A to Z, click again for Z to A. The picture, item and quantity columns can't be sorted.
- Reorder β drag a column header to a new place.
- Resize β drag the edge of a column header.
Your column order and widths are remembered in your browser.
Pages
The table shows 100 orders at a time. Use Prev and Next, or type a page number and click Go. The menu next to them switches between Pages and Scroll down. In Scroll down mode, more orders load as you scroll. The total number of orders shows at the bottom right.
Buttons and actions
Bulk actions work on the orders you have ticked. Tick the box in the header to select every order on the page. A banner then offers Select all β¦ orders in this view, which selects every order that matches your current tab, filters and search, not just this page.
| Button | What it does |
|---|---|
| Change status to⦠| Sets every selected order to the status you pick. Asks you to confirm first. |
| Push to Veeqo | Sends the selected orders to Veeqo. Only shows if Veeqo is turned on for your account. Asks you to confirm. |
| Push to ShipStation | Sends the selected orders to ShipStation. Runs in the background and shows progress. Only shows if ShipStation is turned on. Asks you to confirm. |
| Mark shipped on Amazon (no tracking) | Tells Amazon these orders have shipped before you have tracking. Amazon emails the buyers a shipping confirmation right away. The order's status in OrderPilot does not change, and the real tracking is sent automatically once ShipStation returns it. Cancelled orders and orders that already sent tracking are skipped. |
| Reroute selected | Routes the orders again from scratch: warehouse first, then vendors by cost. You choose a mode first (see "How to reroute orders"). Shows progress while it runs. |
| Export selected | Downloads the selected orders as a CSV file. You pick the columns (see "How to export orders"). |
| Import from Amazon | Starts a full import of orders from Amazon in the background and opens the Jobs panel so you can watch it. |
| Upload orders | Opens the upload window to create or update orders from a CSV file. |
| Cancel selected on Amazon | Cancels the selected orders in Amazon Seller Central and marks them cancelled in OrderPilot. This cannot be undone. You pick a reason and must type a confirmation sentence. |
| Delete selected | Deletes the selected orders from OrderPilot. Asks you to confirm. This cannot be undone. |
| β» Pull pending (Pending tab only) | Asks Amazon right now about every order you hold as pending. Released orders get their address pulled and are routed. Orders Amazon cancelled are cancelled here too. A message tells you how many were checked, released, cancelled or still on hold. |
| β© Full Amazon sync (Pending tab only) | Starts the full Amazon import in the background: new orders, buyer cancel requests, and shipped or cancelled updates on orders of any status. Watch it under Jobs. |
| + Create manual order | Opens the form to type in a new order. |
How to find one order
- Click in the search box at the top left.
- Type the order number, OP order number, customer name or channel SKU.
- Wait a moment. The page switches to the All tab and shows the matches.
- Click the row to open the order.
To look up many orders at once, use Filters βΊ Amazon order #s or OP order #s and paste the whole list.
How to work through orders about to be late
- Click the Unshipped tab.
- Click Verge of cancellation first. These are already past their ship-by date.
- Open each order and ship it, reroute it, or cancel it.
- Then click Verge of late for the orders that must ship today.
How to change the status of many orders
- Tick the orders you want, or use Select all β¦ orders in this view.
- Click Actions βΊ Change status toβ¦.
- Pick the new status.
- Click OK to confirm.
How to reroute orders
- Tick the orders you want to route again.
- Click Actions βΊ Reroute selected.
- Pick a mode: - Use current routing settings β only uses vendors that are marked in stock. This is the normal, everyday choice. - Ignore out-of-stock flags β retry every vendor β tries the cheapest vendor even if it is flagged out of stock. If that vendor rejects the order, it moves to the next one. Use this at the end of the day for orders nobody could fill, because a vendor may have restocked overnight. Expect more rejections. A vendor that confirms gets its out-of-stock flag cleared automatically.
- Wait for the progress message to finish. A message tells you how many were rerouted and how many failed.
How to export orders
- Tick the orders you want, or select all in the view.
- Click Actions βΊ Export selected.
- Tick the columns you want. Use Select all or Clear to start fast.
- Optional: click Save asβ¦ and give the column set a name. Next time, pick it from Saved exportsβ¦. To remove a saved set, pick it and click Delete.
- Click β¬ Download CSV.
How to upload orders from a CSV file
- Click Actions βΊ Upload orders.
- Click β¬ Download template to get a file with every field.
- Fill in only the columns you need. Blank cells are ignored. Repeat an order number on several rows to add more items or packages to the same order. A ShipStation shipments export also works as is.
- Back in the window, choose what should happen: - Create new + update existing (the default) - Update existing only - Create new only
- Tick Overwrite values that already exist only if you want your file to replace data. Otherwise only empty fields are filled.
- Click the drop area to pick your CSV file, or drag the file onto it.
- Watch the progress line under the drop area. Big files are fine; the upload runs in the background.
Orders are matched by order number.
How to create a manual order
- Click + Create manual order.
- Pick the Marketplace (Amazon, Walmart or Manual). The marketplace order number is optional.
- Add the ship-by and deliver-by dates if you have them.
- Fill in the customer. Full name, Address, City, State and ZIP are required.
- Click + Add item, then search by ASIN, UPC, catalog SKU or title and click the right product. Set the quantity. Repeat for each item.
- Optional: fill in the P&L fields (customer paid, sales tax, Amazon fee, estimated shipping) and a note.
- Click Create order. You see the new OP order number, and the order window opens.
If a required field is empty, the form points to it and tells you what is missing.
How to cancel orders on Amazon in bulk
- Tick the orders.
- Click Actions βΊ Cancel selected on Amazon.
- Pick a Cancellation reason. It is sent to Amazon.
- Type the sentence shown in red exactly, for example "I want to cancel 3 orders". The button stays grey until it matches.
- Click π« Cancel on Amazon.
Amazon notifies the buyers. There is no way to undo this. Orders with no Amazon item details are skipped and listed in the result.
Tips and troubleshooting
- My search finds nothing. Check for typos. Search always looks at the All tab, so the status tab is not the problem. If you have filter chips on, click Clear all.
- The Canceled tab has no number. That is on purpose. The count only shows while you are on that tab.
- My selection disappeared. When you change the tab, filters or search, your selection is cleared so you never act on orders you can no longer see.
- I can't see the Price paid breakdown or P&L. You need the Financials permission. Ask an admin to turn it on in Settings βΊ Users & Access.
- No Push to Veeqo or Push to ShipStation in the menu. These only show when that integration is turned on for your account.
- Verge numbers don't match what I expected. They count by calendar day in US Pacific time, like Seller Central.
- An order shows "Rerouting" for a long time. The tag only shows for about 15 minutes after a reroute starts. After that, the order shows its normal status again.
- Scanning a pick QR code. If you use a barcode scanner on this page, scanning a warehouse pick QR code scans that order line out of the warehouse. See Order details window.