Description
RIS-SC-1002 Sales By Sub Source Channels
This query retrieves stock item information with their associated images and quantities for a specified date range. It pivots the data based on the sub-source of the items. The image URLs are constructed dynamically using the item’s image ID and a hash of the database name.
How to generate the report: a step-by-step guide
- 1. Select the Sales By Sub Source Channels report in the Query type drop-down menu.
- 2. Click the calendar icon to select Start and End dates.
- 3. Click the Generate Report button.
- 4. 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 |
---|---|
Image | URL of the stock item's image. |
Product Type | Type of the product. |
SKU | Stock Keeping Unit (SKU) of the item. |
Title | Title or name of the item. |
InStock | Quantity of the item in stock. |
[Subsource] | Quantities of the item for each sub-source. |
Parameters
- 1. @startDate: Specifies the start date of the date range. The default value is ’01 Sep 2020′.
- 2. @endDate: Specifies the end date of the date range. The default value is ’20 Sep 2020′.
Summary
This query retrieves detailed information about stock items including their images, product types, SKUs, titles, and quantities in stock within a specified date range. It dynamically constructs image URLs using a hash of the database name and the item’s image ID. The data is pivoted based on sub-sources, providing a comprehensive view of stock quantities across different sources.