Explore More Across Our Network

Ebay Channel Linking Report

Home || Linnworks || Ebay Channel Linking Report
Description

RIS-SC-1013 Ebay Channel Linking Report

This query retrieves data related to stock items from the Stock_ChannelList table for two different subsources (‘Etsy-TS’ and ‘Etsy-WD’). 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
Ebay 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 (always 'ETSY' in this case).
SubsourceSubsource of the item (e.g., 'Etsy-TS', 'Etsy-WD').
rownumRow number within the result set.

Parameters

Summary

This query fetches data from the Stock_ChannelList table for subsources ‘Etsy-TS’ and ‘Etsy-WD’, 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 subsources. Each row in the result set is assigned a row number ordered by NULL, effectively giving an arbitrary order.
Scroll to Top