RIS-SC-1009

Active FBA Inventory Analysis

Description

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.
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 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.

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.

Reported Values

The report returns the following values:
Column NameDescription
Amazon.SKUAmazon SKU (ChannelSKU) of the item.
ASINASIN associated with the item.
FBA ASINIndicates whether the item is fulfilled by Amazon (FBA).
Nationwide PrimeIndicates whether the item is under the 'Nationwide Prime' template.
SFP Small and LightIndicates whether the item is under the 'SFP Small and Light' template.
Custom Orders - PrimeIndicates whether the item is under the 'Custom Orders - Prime' template.
Amazon.PriceAmazon.Price
young team coworkers working project

Parameters

Source: The source of the items (e.g., ‘Amazon’).

Subsource: The subsource of the items (e.g., ‘Trimming Shop’).

PrimeTemplate1: The name of the first Prime template.

PrimeTemplate2: The name of the second Prime template.

PrimeTemplate3: The name of the third Prime template.