RIS-SC-1012

Channel Inventory Aggregation by Source and Subsources

Description

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.
image 13
male female graphic designers interacting computer
female web designer taking notes office
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.

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.

Reported Values

The report returns the following values:
Column NameDescription
Linked SKU Custom LabelCustom label associated with the linked SKU.
Channel TitleTitle of the item on the channel.
Listing IdID of the listing on the channel.
SKUStock Keeping Unit (SKU) of the item.
SourceSource of the item (e.g., 'AMAZON').
SubsourceSubsource of the item (e.g., 'Trimming Shop', 'Wedding Decor - UK').
rownumRow number within the result set.
young team coworkers working project

Parameters

@Source: The source parameter for filtering inventory items.

@SubSource1: The first subsource parameter for filtering inventory items.

@SubSource2: The second subsource parameter for filtering inventory items.