Explore More Across Our Network

Channel Linking Report

Home || Linnworks || Channel Linking Report
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
Channel Linking Report 2
Channel Linking Report

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., 'CDISCOUNT', 'MAGENTO').
SubsourceSubsource of the item.
rownumRow 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.
Scroll to Top