RIS-SC-1004

Channel Inventory Report by Location

Description

This query retrieves inventory information for items based on specified parameters such as source, subsource, and location. It fetches data including Linnworks SKU, barcode number, channel SKU, channel title, channel reference ID, price, fulfillment network, and quantity.
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 Channel Inventory Report by Location in the Query type drop-down menu.
  2. Select your subsource,Source,Name from the dropdown.
  3. Click the Generate Report button.
  4. Select the Time Zone and click the Download (CSV file) button when downloading the report.

Summary

This query retrieves inventory information for items based on specified parameters such as source, subsource, and location. It fetches data including Linnworks SKU, barcode number, channel SKU, channel title, channel reference ID, price, fulfillment network, and quantity. The results are ordered by quantity in descending order.

Reported Values

The report returns the following values:

Column Name
Description
LW SKUThe SKU of the item in Linnworks.
Barcode NumberThe barcode number associated with the item.
Channel SKUThe SKU of the item on the channel.
Channel TitleThe title of the item on the channel.
Channel Reference IdThe reference ID of the item on the channel.
PriceThe price of the item.
Fulfillment NetworkThe fulfillment network of the item.
QuantityThe quantity of the item in stock.
young team coworkers working project

Parameters

@Subsource: The subsource parameter for filtering inventory items.

@Source: The source parameter for filtering inventory items.

@Name: The name parameter for filtering inventory items.