OrderPilot Help
Help β€Ί Orders

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:

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

The Unshipped tab with its quick filters, the channel tabs, the toolbar and the order table.

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:

On the Unshipped tab:

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

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:

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

Tick orders, then open Actions to work on all of them at once.

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

  1. Click in the search box at the top left.
  2. Type the order number, OP order number, customer name or channel SKU.
  3. Wait a moment. The page switches to the All tab and shows the matches.
  4. 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

  1. Click the Unshipped tab.
  2. Click Verge of cancellation first. These are already past their ship-by date.
  3. Open each order and ship it, reroute it, or cancel it.
  4. Then click Verge of late for the orders that must ship today.

How to change the status of many orders

  1. Tick the orders you want, or use Select all … orders in this view.
  2. Click Actions β€Ί Change status to….
  3. Pick the new status.
  4. Click OK to confirm.

How to reroute orders

  1. Tick the orders you want to route again.
  2. Click Actions β€Ί Reroute selected.
  3. 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.
  4. Wait for the progress message to finish. A message tells you how many were rerouted and how many failed.

How to export orders

  1. Tick the orders you want, or select all in the view.
  2. Click Actions β€Ί Export selected.
  3. Tick the columns you want. Use Select all or Clear to start fast.
  4. 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.
  5. Click ⬇ Download CSV.

How to upload orders from a CSV file

  1. Click Actions β€Ί Upload orders.
  2. Click ⬇ Download template to get a file with every field.
  3. 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.
  4. Back in the window, choose what should happen: - Create new + update existing (the default) - Update existing only - Create new only
  5. Tick Overwrite values that already exist only if you want your file to replace data. Otherwise only empty fields are filled.
  6. Click the drop area to pick your CSV file, or drag the file onto it.
  7. 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

  1. Click + Create manual order.
  2. Pick the Marketplace (Amazon, Walmart or Manual). The marketplace order number is optional.
  3. Add the ship-by and deliver-by dates if you have them.
  4. Fill in the customer. Full name, Address, City, State and ZIP are required.
  5. Click + Add item, then search by ASIN, UPC, catalog SKU or title and click the right product. Set the quantity. Repeat for each item.
  6. Optional: fill in the P&L fields (customer paid, sales tax, Amazon fee, estimated shipping) and a note.
  7. 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

  1. Tick the orders.
  2. Click Actions β€Ί Cancel selected on Amazon.
  3. Pick a Cancellation reason. It is sent to Amazon.
  4. Type the sentence shown in red exactly, for example "I want to cancel 3 orders". The button stays grey until it matches.
  5. 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

Still stuck? Email support@softavant.com and tell us what you were trying to do.