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
- 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.
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 (always 'ETSY' in this case). |
Subsource | Subsource of the item (e.g., 'Etsy-TS', 'Etsy-WD'). |
rownum | Row number within the result set. |
Parameters
- 1. @startDate: The start date of the order processing period.
- 2. @endDate: The end date of the order processing period.
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.