Channel Inventory Aggregation by Source and Subsources
Home || Linnworks || Channel Inventory Aggregation by Source and Subsources
Description
RIS-SC-1012 Channel Inventory Aggregation by Source and Subsources
This query retrieves data from the Stock_ChannelList table, including information about linked SKUs, channel titles, listing IDs, and corresponding SKUs from the StockItem table. It allows filtering by source and subsource parameters.
How to generate the report: a step-by-step guide
- 1. Select the Channel Inventory Aggregation by Source and Subsources Report in the Query type drop-down menu.
- 2. Click the Generate Report button.
- 3. Select the Time Zone and click the Download (CSV file) button when downloading the report.
Reported Values
The report returns the following values:
| Column Name | Description |
|---|---|
| Linked SKU Custom Label | Custom label associated with the linked SKU. |
| Channel Title | Title of the item on the channel. |
| Listing Id | ID of the listing on the channel. |
| SKU | Stock Keeping Unit (SKU) of the item. |
| Source | Source of the item (e.g., 'AMAZON'). |
| Subsource | Subsource of the item (e.g., 'Trimming Shop', 'Wedding Decor - UK'). |
| rownum | Row number within the result set. |
Parameters
- 1. @Source: The source parameter for filtering inventory items.
- 2. @SubSource1: The first subsource parameter for filtering inventory items.
- 3. @SubSource2: The second subsource parameter for filtering inventory items.
Summary
This query retrieves data from the Stock_ChannelList table, including information about linked SKUs, channel titles, listing IDs, and corresponding SKUs from the StockItem table. It allows filtering by source and subsource parameters, and the result set is grouped by source, subsource, SKU, linked SKU custom label, channel title, listing ID, and row number.
