Active FBA Inventory Analysis
Home || Linnworks || Active FBA Inventory Analysis
Description
RIS-SC-1009 Active FBA Inventory Analysis
This query retrieves information about Amazon SKUs from a stock channel, specifically targeting ASINs and various Prime-related attributes. It checks for FBA status and the presence of different Prime templates (Nationwide Prime, SFP Small and Light, and Custom Orders – Prime). Additionally, it fetches the price from the ‘download’ schema based on the provided source and subsource parameters.
How to generate the report: a step-by-step guide
- 1. Select the Active FBA Inventory Analysis 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 |
|---|---|
| Amazon.SKU | Amazon SKU (ChannelSKU) of the item. |
| ASIN | ASIN associated with the item. |
| FBA ASIN | Indicates whether the item is fulfilled by Amazon (FBA). |
| Nationwide Prime | Indicates whether the item is under the 'Nationwide Prime' template. |
| SFP Small and Light | Indicates whether the item is under the 'SFP Small and Light' template. |
| Custom Orders - Prime | Indicates whether the item is under the 'Custom Orders - Prime' template. |
| Amazon.Price | Amazon.Price |
Parameters
- 1. Source: The source of the items (e.g., ‘Amazon’).
- 2. Subsource: The subsource of the items (e.g., ‘Trimming Shop’).
- 3. PrimeTemplate1: The name of the first Prime template.
- 4. PrimeTemplate2: The name of the second Prime template.
- 5. PrimeTemplate3: The name of the third Prime template.
Summary
This query fetches Amazon SKUs from a stock channel, extracting ASINs and various Prime-related attributes. It specifically checks for FBA status and the presence of different Prime templates (Nationwide Prime, SFP Small and Light, and Custom Orders – Prime). Additionally, it retrieves the price of the items from the ‘download’ schema based on the provided source and subsource parameters. The final result includes only items that are FBA ASINs and fall under at least one of the specified Prime templates, ordered by Amazon SKU.
