SizeAmazon
Size of the item How to Use
This can be very useful in determining which variation of a product the listing is for. A great example would be a "Large" t-shirt size.
ColorAmazon
Color of item How to Use
This can be very useful in determing the correction variation of the product. A great example would be a "Navy blue" t-shirt color.
Parent ASINAmazon
Parent ASIN that the item/product variation belongs to. How to Use
If present, the Parent ASIN is an indicator that the listing has variations. Variations require special care in ensuring that you have the correct variation from your supplier and that your sales forecasts are accurate for that particular variation.
Variations ListAmazon
List of ASINs that belong to the same parent ASIN. How to Use
If present, this will link to all the other variations of this listing.
# of VariationsAmazon
The number of variations that belong to the same parent ASIN. How to Use
The number of variations available for the listing. Filter on this column looking for # of Variations = 0 to remove any listings with variations from your results.
Amazon Pack QuantityMixed
Number of total items in one pack. How to Use
An indicator for whether an item is considered a multipack. Multipacks require special care to ensure that you are purchasing enough from your supplier to complete the multipack. Filter on this column looking for Amazon Pack Quantity = 1 to remove any multipacks from your results.
Small and light eligibleDerived
Optional fulfillment program offered by Amazon, allowing for lower cost FBA fees for small and light items. Small and light eligible reasonsDerived
A list of reasons why the item is not eligible for the Small and Light program Top Level CategoryDerived
Whether the category is top level or not. The products that belong to this category have higher selling rate. How to Use
Items that do not have a Top Level Category will tend to sell very, very poorly. Best to avoid these.
BSR PercentageDerived
The product's BSR, divided by how many products are in the category How to Use
Items with lower BSR Percentages will generally tend to sell better than items with higher BSR Percentages.
WeightAmazon
Weight of the item How to Use
Items that are too heavy can make it hard to store, prep, and ship.
Competitive SellersDerived
Number of current sellers that are competing for the same price. Variable Closing FeeAmazon
An additional, per-unit fee that Amazon charges for certain categories ProfitDerived
The estimated profit for this product, after accounting for all fees. Calculation
Profit = Sale Proceeds - Cost - Inbound Shipping - Prep Cost - FBA Storage Fees
How to Use
One of the most important metrics to look at. You will want to ensure that the items you are selling are meeting your minimum profitability criteria.
ROIDerived
Estimated return of investment at the current selling price. Calculation
ROI = Profit / Cost
How to Use
An extremely important measure of how much profit your can expect from this item, relative to your purchase price. Higher ROIs are generally preferable to lower ROIs, as you can grow your capital quicker. Be aware of items with ROIs that are "too good to be true." ROIs greater than 200% or so should generally be looked at with suspicion. Ensure that the listing matches what your supplier is selling and that the Amazon Pack Quantity is correct.
Adjusted CostUser supplied
Price with the per product discount, supplier discount, and VAT applied. StockUser supplied
If the product is available in stock and how much. How to Use
If you mapped this, it can be a great way to quickly filter out items that your supplier does not have in stock.
MAP (Minimum Advertised Price)User supplied
Recommended minimum price. Supplier TitleUser supplied
Title of the item/product Supplier SKUUser supplied
Identifier number Supplier ImageUser supplied
Image of item/product Discount (% per product)User supplied
Discount percentage per item/product. Supplier Pack QuantityUser supplied
The number of items that come in a pack from your supplier. Defaults to 1 Size TierDerived
To which size category does the item/product belong to. How to Use
Filtering out Oversize tiered items can be a great way to easily remove overly bulky or heavy items, which can be a challenge for your warehousing team or can incur additional costs.
Lowest Price New FBAAmazon
The current lowest price for a new item, fulfilled via FBA Lowest Price Used FBAAmazon
The current lowest price for a used item, fulfilled via FBA Lowest Price New FBMAmazon
The current lowest price for a new item, fulfilled via FBM Lowest Price Used FBMAmazon
The current lowest price for a used item, fulfilled via FBM IP ComplaintsCrowdsourced
Whether or not this brand has a history of submitting IP complaints against sellers (true/false). How to Use
You will generally want to avoid selling products that have a history of IP complaints, unless you have specific authorization to sell that brand.
Is Brand BlocklistedYour BrandBlocklist
Whether or not the Brand that this item belongs to is on the Blocklist. MeltableAmazon
Is the item meltable or not (true/false). How to Use
You cannot sell meltable products using FBA during the summer months, from April 15th to October 15th.
FBA EligibleAmazon
Whether or not the product is eligible to be sent into FBA. This will most commonly be false for hazmat items, if you do not have hazmat approval. How to Use
If you cannot send a product into FBA, then you will need to sell it via FBM