RIS-SC-1016

SKU Details: Size, Colour, and Quantity

Description

This query retrieves information about stock items from the StockItem table based on a search parameter for the item number (SKU). It selects columns such as SKU, item title, size, color, and pack/quantity. The query also joins with the Stockitem_ExtendedProperties table to fetch additional properties like size, color, and pack/quantity based on their respective property names.
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 SKU Details: Size, Colour, and Quantity 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 StockItem table for items matching a provided search parameter for the item number (SKU). It retrieves additional information such as item title, size, color, and pack/quantity by joining with the Stockitem_ExtendedProperties table based on their respective property names. The results are filtered to exclude logically deleted and archived items and are sorted by SKU.

Reported Values

The report returns the following values:
Column NameDescription
SKUStock Keeping Unit (SKU) of the item.
ItemTitleTitle of the item.
SizeSize of the item (if available).
ColourColor of the item (if available).
Pack/QtyPack or quantity information of the item (if available).
young team coworkers working project

Parameters

@search: A search parameter used to filter stock items based on their item number (SKU). It is expected to be provided as a string with wildcard characters (%).