Product Commodity Codes
Home || Linnworks || Product Commodity Codes
Description
RIS-SC-1008 Product Commodity Codes
This query retrieves the SKU (ItemNumber) and Commodity Code for stock items that match certain criteria. It joins the StockItem table with the Stockitem_ExtendedProperties table to retrieve the Commodity Code associated with each stock item.
How to generate the report: a step-by-step guide
- 1. Select the Product Commodity Codes 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 | The SKU / Item Number of the stock item. |
| CommodityCode | The commodity code associated with the stock item. |
Summary
This query selects the ItemNumber (SKU) and CommodityCode from the StockItem table, joined with the Stockitem_ExtendedProperties table to fetch the Commodity Code. It filters the results to include only active and non-archived items with SKU starting with ‘BL-‘ and having a non-null Commodity Code.
