Explore More Across Our Network

Retrieve Linked SKUs and Replace

Home || Linnworks || Retrieve Linked SKUs and Replace
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
Retrieve Linked SKUs and Replace
Retrieve Linked SKUs and Replace 2

Reported Values

The report returns the following values:
Column NameDescription
Old SKUOriginal Stock Keeping Unit (SKU)
Linked SKU Custom LabelCustom label linked to the SKU
SourceSource of the stock item
SubSourceSub-source of the stock item
ChannelReferenceIdReference ID associated with the channel
SKUModified 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.
Scroll to Top