RIS-SC-1013

Ebay Channel Linking Report

Description

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.
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 Ebay 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.

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.

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.
young team coworkers working project

Parameters

@startDate: The start date of the order processing period.

@endDate: The end date of the order processing period.