RIS-SC-1002

Sales By Sub Source Channels

Description

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

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.

Reported Values

The report returns the following values:
Column NameDescription
ImageURL of the stock item's image.
Product TypeType of the product.
SKUStock Keeping Unit (SKU) of the item.
TitleTitle or name of the item.
InStockQuantity of the item in stock.
[Subsource]Quantities of the item for each sub-source.
young team coworkers working project

Parameters

@startDate: Specifies the start date of the date range. The default value is ’01 Sep 2020′.

@endDate: Specifies the end date of the date range. The default value is ’20 Sep 2020′.