How do I generate a report of channel-mapped SKUs with their available quantities?
Last updated: October 11, 2026
Overview
Luminous lets you export a spreadsheet of every channel-mapped SKU alongside its available inventory quantity, buffer settings, price, and last-pushed data. This is the built-in way to get a snapshot of your channel product list with stock figures in one file.
Note on conversion factors: Unit-of-measure (UOM) conversion factors (e.g., units-per-case) are stored in product settings and are not included in the channel product export described below. If you also need conversion-factor data, you will need to cross-reference the export with your product UOM settings separately.
Step-by-step: Export Products from a Channel
In the left navigation, go to Manage → Channels.
Click the name of the channel you want to report on.
Open the Product Mapping tab for that channel.
In the top-right area of the page, click the Actions button (it shows a small arrow/chevron).
From the Actions drop-down, choose Export Products.
Luminous will prepare the export. Once it's ready you'll receive an Excel file (
.xlsx) named Channel Products.
What the export includes
Each row in the exported file represents one channel-mapped product entry. The columns are:
Column | What it contains |
|---|---|
CHANNEL_SKU | The SKU as it appears in the external channel (e.g., Shopify, TrackStar) |
CHANNEL_PRODUCT_NAME | The product name from the channel |
LUM_SKU | The mapped Luminous internal SKU |
BUFFER_QUANTITY | The stock buffer applied before pushing inventory to this channel |
BUFFER_TYPE | Whether the buffer is a fixed unit amount or a percentage |
LEAD_TIME_DAYS | Configured lead time for this channel SKU |
PRICE | Price configured for this channel listing |
CHANNEL | The channel label |
INTEGRATION | The integration account the product belongs to |
GTIN_FIELD | Any alternate GTIN configured for this mapping |
QTY_AVAILABLE | Current available quantity (on-hand minus pending orders) at the channel's warehouse group |
IGNORE_STOCK | Whether stock pushing is suppressed for this SKU |
LAST_PUSHED_DATETIME | When stock was last pushed to the channel for this SKU |
LAST_PUSHED_QUANTITY | The quantity that was last pushed |
Filtering before you export
The export reflects the active products for the channel you are viewing. If you only want to see a subset (e.g., mapped SKUs only, or a specific product status), use the column filters in the Product Mapping grid to narrow the list before exporting — the export will respect the channel scope you selected.
Where to find UOM conversion factors
If your question is specifically about how many base units make up a selling unit (e.g., 12 units per case), those conversion factors live in Admin → Products → [product] → Unit of Measure settings and can also be managed via the Unit Conversion Rules API. They are separate from the channel mapping export above.