Description
RIS-SC-1021 Retrieve Linked SKUs and Replace
This query retrieves information about stock items, including their old SKU, linked SKU custom label, source, sub-source, and channel reference ID. It also modifies the SKU by replacing ‘CORG’ with ‘ORG’ in the SKU column for items with an ItemNumber starting with ‘oz-sh-corg%’.
How to generate the report: a step-by-step guide
- 1. Select the Retrieve Linked SKUs and Replace 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 |
---|---|
Old SKU | Original 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 |
ChannelReferenceId | Reference ID associated with the channel |
SKU | Modified Stock Keeping Unit (SKU) |
Summary
This SQL query retrieves information about stock items and their linked custom labels from the database. It also performs a transformation on the SKU by replacing ‘CORG’ with ‘ORG’ for items with a specific ItemNumber pattern. The query is designed to provide insights into stock items and their associated data, facilitating inventory management and tracking.