SKU Details: Size, Colour, and Quantity
Home || Linnworks || SKU Details: Size, Colour, and Quantity
Description
RIS-SC-1016 SKU Details: Size, Colour, and Quantity
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.
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.
Reported Values
The report returns the following values:
| Column Name | Description |
|---|---|
| SKU | Stock Keeping Unit (SKU) of the item. |
| ItemTitle | Title of the item. |
| Size | Size of the item (if available). |
| Colour | Color of the item (if available). |
| Pack/Qty | Pack or quantity information of the item (if available). |
Parameters
- 1. @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 (%).
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.
