RIS-SC-1021

Retrieve Linked SKUs and Replace

Description

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%’.
image 13
male female graphic designers interacting computer
female web designer taking notes office
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.

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.

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)
young team coworkers working project

Parameters

@startDate: The start date of the order processing period.

@endDate: The end date of the order processing period.