Retrieve Linked Channel SKUs
Home || Linnworks || Retrieve Linked Channel SKUs
Description
RIS-SC-1023 Retrieve Linked Channel SKUs
This query retrieves information about stock items based on a specified SKU prefix. It selects the SKU, linked SKU custom label, source, and sub-source from the StockItem table, while also generating a new SKU by replacing ‘LLC’ with ‘LLCPRP’ in the ItemNumber column. The search criteria limit results to items with an ItemNumber starting with ‘DB-RBN’ followed by ‘LLC-‘.
How to generate the report: a step-by-step guide
- 1. Select the Retrieve Linked Channel SKUs 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) |
| Linked SKU Custom Label | Custom label linked to the SKU |
| Source | Source of the stock item |
| SubSource | Sub-source of the stock item |
| New SKU | Modified Stock Keeping Unit (SKU) |
Parameters
- 1. @SKU: The SKU prefix used as a filter criterion.
Summary
This SQL query retrieves information about stock items with a specific SKU prefix from the database. It generates a new SKU by replacing ‘LLC’ with ‘LLCPRP’ in the ItemNumber column, facilitating data manipulation or updates. The query is designed to provide relevant details about stock items and their associated data, aiding in inventory management tasks.
