Channel SKUs

See and manage every listing you sell on Amazon and Walmart, how each one links to your catalog, and what inventory OrderPilot sends.

What it's for

A channel SKU is one listing on a sales channel: an Amazon offer (identified by its ASIN and your seller SKU) or a Walmart item (identified by its Walmart SKU and item ID).

The Channel SKUs page lists all of them in one place. Use it to:

• See the status of every listing on Amazon and Walmart.
• Check each listing's price against the buy box.
• Link each listing to the catalog SKU (the product you actually stock), including multi-packs and bundles.
• See which vendors can supply each listing, and at what cost.
• See how much inventory OrderPilot calculates and sends to the channel.
• Work on many listings at once: import, export, push inventory, publish, restrict and more.

This article covers the main list. Two related articles cover the rest:

• Channel SKUs: bulk actions, imports and exports covers everything in the Actions menu.
• Channel SKUs: the listing details window covers the window that opens when you click a listing.

Where to find it

In the left sidebar, open Inventory and click Channel SKUs.

You need the SKUs permission to open this page. If you can't see it, ask an admin on your team.

The screen at a glance

From top to bottom you'll see:

1. Title and count. The total number of listings that match your current search and filters.
2. Toolbar. The search box, Filters, your active filter chips, the Views button, the Actions menu and + Add listing.
3. Channel tabs. All, Amazon and Walmart.
4. Status tiles. A count for each listing status. Click a tile to show only those listings.
5. The listings table.
6. Page controls at the bottom.

Channel tabs

• All shows Amazon and Walmart listings together. A small channel icon next to each ID shows where the listing lives.
• Amazon shows only Amazon listings.
• Walmart shows only Walmart listings. The first column becomes Walmart ID. The Buy Box, Bought/mo and Rank columns are hidden because they only apply to Amazon.

Switching tabs clears any status filter, because each channel uses its own status words.

Status tiles

The tiles above the table show how many listings are in each status. Click a tile to filter the table to that status. Click All to clear it. The selected tile has a green outline.

• Amazon tab: Active, Inactive, Suppressed, Stranded.
• Walmart tab: Published, Unpublished, System problem, Retired, Inactive.
• All tab: whichever of these statuses you currently have listings in.

Every tab also shows two extra tiles:

• Not published: the channel has never reported this listing. It isn't live there yet, or it has never synced.
• Not linked: the listing isn't linked to a catalog SKU yet. OrderPilot can't work out its inventory or cost until it is linked.

Columns in the table

Many cells have a small copy icon (⧉) next to them. Click it to copy the ASIN, SKU, UPC, title or vendor SKU.

Hover tips

• Restricted: hover over the red Restricted line to see why the listing was restricted, who did it and when.
• Amazon problems: on Amazon listings that are Inactive, Suppressed, Stranded or similar, hover over the status to see Amazon's own reason. OrderPilot checks with Amazon the first time you hover.
• Vendors: hover over a vendor badge to see that vendor's item title, cost per unit and vendor SKU.

Sorting and resizing columns

• Click a column header to sort A to Z (or low to high). Click again to reverse it. Sorting covers all your listings, not just the current page. You can't sort by Image or Linked.
• Drag the right edge of a column header to make it wider. OrderPilot remembers your widths in this browser.

Pages

At the bottom, use ← Previous, the page numbers and Next → to move between pages. The Results per page box lets you show 50, 100, 250 or 1000 rows. Choose Endless scroll to keep loading more rows as you scroll down. This browser remembers your choice.

Search and filters

Search

Type in the search box to search by ASIN or Walmart ID, channel SKU, UPC or title. Results update as you type. Searching looks across all statuses, so any status tile you picked is cleared.

Filters

Click ⚙ Filters ▾ and pick a filter. A small box opens where you set the value. Click Apply.

Each active filter appears as a green chip next to the Filters button.

• Click a chip to change its value.
• Click the ✕ on a chip to remove that filter.
• Click Clear all to remove every filter.

Available filters:

Views and columns

The 🗂 Views button (next to ⋮) shows the name of the saved view you are using. Click it or the ⋮ button to open the menu.

Customize columns

Choose 🧩 Customize columns.

• Untick a column to hide it. Tick it to show it again.
• Drag a column by its ☰ handle to change the order.

These changes are saved automatically in this browser. You don't need to save a view for everyday tweaks.

Save a view

At the bottom of the Customize columns panel:

1. Type a name in Save as view.
2. Tick Set as my default if you want this view to be your starting point.
3. Click 💾 Save view.

A view saves your columns, column order, column widths, filters, search text and channel tab. If you save with the name of an existing view, that view is updated.

Manage saved views

Choose 🗂 Manage saved views to see your views. Views are personal. Each user has their own list.

• Click a view's name to switch to it. This restores its columns and its filters.
• Click ☆ to make a view your default. Click ★ to unset it.
• Click ✏️ to rename a view.
• Click 🗑 to delete a view. You'll be asked to confirm.

Selecting listings

Most bulk actions work on the listings you select.

• Tick the box at the start of a row to select it.
• Tick the box in the header to select every row on the current page.
• After selecting the whole page, a green banner appears. Click Select all matching listings to select every listing that matches your current tab, search and filters, across all pages. Click Clear in the banner to undo it.

Buttons and actions

How to add a listing by hand

1. Click + Add listing.
2. Under Channel, pick Amazon or Walmart.
3. Fill in the IDs: - Amazon: ASIN is required. Channel SKU is your seller SKU. - Walmart: Walmart SKU is required. Walmart ID (the item ID) and UPC / GTIN are optional.
4. Add a Title if you like, and choose a Status. Suppressed and Stranded are only offered for Amazon.
5. Enter the Listing price.
6. Leave Qty override blank to use your normal channel quantity rules. Enter a number only if you want to always send that quantity.
7. Under Catalog SKU Components, click + Add catalog SKU. Type at least two characters, then pick the catalog SKU from the list. Set its Qty. - For a 3-pack, add the one catalog SKU with Qty 3. - For a bundle, add each catalog SKU with its own quantity. - Click × to remove a row.
8. Click Save listing.

You must add at least one catalog SKU. A listing with more than one catalog SKU, or one catalog SKU with a quantity above 1, is saved as a bundle or multi-pack.

How to find listings that need linking

1. Click the Not linked status tile.
2. Open each listing and use + Add component on the Components tab to link it.

To link many listings at once, use Imports in the Actions menu with the Prefill the template option. That gives you a file with every unlinked channel SKU already filled in. See Channel SKUs: bulk actions, imports and exports.

How to find listings priced above the buy box

1. Click the Amazon tab.
2. Click ⚙ Filters ▾ and choose List vs Buy Box.
3. Pick List price ABOVE Buy Box. Optionally enter an amount, for example 1 and $ and or more.
4. Click Apply.
5. To keep this list handy, open ⋮ → Customize columns, type a name such as "Above buy box" and click 💾 Save view.

Restricted listings

Restrict is OrderPilot's own on/off switch for a listing. A restricted listing:

• has 0 inventory sent to the channel, so it stops selling;
• keeps its restriction even when the channel sync runs;
• shows a red ⛔ Restricted line in the Status column.

The channel's own status (Active, Inactive and so on) is separate and can't be edited in OrderPilot.

You can restrict listings in bulk from Actions → Restrict / Unrestrict…, or one at a time from the listing details window.

Tips and troubleshooting

• A listing shows "Not published". Amazon or Walmart has never reported it. It may not be live yet, or the listings sync hasn't picked it up. Publish it from the Actions menu, or wait for the next sync.
• Calc Inv is 0. Check the Catalog SKU and Vendors columns. A listing that isn't linked, or whose vendors are all out of stock, usually has nothing to send. Remember that a restricted listing always sends 0, whatever this column shows.
• The Avg Ship value has a small "min" label. The listing has no shipping history yet, so the minimum shipping amount from your inventory settings is used instead.
• The Buy Box shows "You" but List Price is different. List Price comes from the last listings sync and can lag behind your repricer. When you hold the buy box, the buy box price is your live price.
• Rank or Vendor SKUs columns are missing. They're hidden by default. Turn them on in ⋮ → Customize columns.
• My column layout changed on another computer. Automatic column changes are stored in each browser. Save a view to use the same layout everywhere.
• Picking a saved view changed my filters. Views save filters as well as columns. Clear the chips or pick another view.
• Sharing a listing. When a listing window is open, the address in your browser points to that listing. Copy it to send a teammate straight to it.