SKUs with Invalid Bin Rack in Aisle
Home || Linnworks || SKUs with Invalid Bin Rack in Aisle
Description
RIS-SC-1020 SKUs with Invalid Bin Rack in Aisle
This query retrieves the SKU (Stock Keeping Unit) and corresponding Bin Rack numbers for stock items stored in the inventory. It filters out items with Bin Rack numbers containing ‘A’ but not exactly four characters in length. Additionally, it excludes items that contain composites, are archived, or have been logically deleted.
How to generate the report: a step-by-step guide
- 1. Select the SKUs with Invalid Bin Rack in Aisle 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 |
| BinRack | Bin Rack number associated with the item |
Summary
This SQL query extracts SKU and Bin Rack number data for stock items from the database. It filters out items based on specific criteria such as Bin Rack number pattern, composite item status, archival status, and logical deletion. The query is designed to provide relevant information about stock items and their storage locations within the inventory.
