Description
RIS-SC-1015 Channel Linking Report
This query retrieves data related to stock items from the Stock_ChannelList table for two different sources (‘CDISCOUNT’ and ‘MAGENTO’) and their respective subsources. It selects information such as the linked SKU custom label, channel title, listing ID, SKU, source, and subsource. The data is filtered based on specific conditions related to the source and subsource fields.
How to generate the report: a step-by-step guide
- 1. Select the Channel Linking 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., 'CDISCOUNT', 'MAGENTO'). |
| Subsource | Subsource of the item. |
| rownum | Row number within the result set. |
Summary
This query fetches data from the Stock_ChannelList table for sources ‘CDISCOUNT’ and ‘MAGENTO’, including information about linked SKU custom labels, channel titles, listing IDs, SKUs, sources, and subsources. The result set is combined using UNION ALL to include data for both sources and their respective subsources. Each row in the result set is assigned a row number ordered by NULL, effectively giving an arbitrary order.
