Knowledge base

  1. Knowledge Base
  2. Web
  3. Tips & Tutorials
  4. Column Definition Chart

Column Definition Chart

8 Likes
7793 Views
Tips & Tutorials Tips & Tutorials Web 10 months ago
Available Columns
Description
Feature Availability
Windows app Web app Web app Pro
Amazon Link Link to Amazon product page Yes Yes Yes
Amazon Seller Returns whether Amazon is a current competing seller on listing. More Information Limited Yes
Amazon Seller InStock Rate 30d % of time Amazon was a competing seller on listing in last 30 days Yes
Amazon Seller InStock Rate 90d % of time Amazon was a competing seller on listing in last 90 days Yes
Amazon Seller InStock Rate 180d % of time Amazon was a competing seller on listing in last 180 days Yes
ASIN ASIN identifier of product Yes Yes Yes
Avg Buybox 30d Average BuyBox sell price on listing in the last 30 days Yes
Avg Buybox 90d Average BuyBox sell price on listing in the last 90 days Yes
Avg Buybox 180d Average BuyBox sell price on listing in the last 180 days Yes
Avg Sales Rank 30d Average Sales Rank on listing in the last 30 days Yes
Avg Sales Rank 90d Average Sales Rank on listing in the last 90 days Yes
Avg Sales Rank 180d Average Sales Rank on listing in the last 180 days Yes
B2B Sales Rank Sales Rank as it relates only to Amazon Business purchases BPO Only BPO Only
B2B Sales Rank Growth Growth in B2B Sales Rank expressed as HIGH, MEDIUM, LOW BPO Only BPO Only
Brand Brand name of product Yes Yes Yes
Brand You Offer Indicates whether the BPO product is sold by a brand you have a history of selling BPO Only BPO Only
Buy Box Landed Active BuyBox sell price on listing + buyer’s shipping charge (if any) Yes Yes Yes
BuyBox Contention Number of FBA offers that are competing for and are rotating on the Buybox Yes Yes Yes
Buyer Industry Industry the Buyer is in that made a request for Amazon to sell this product. BPO Only BPO Only
CamelCC CamelCamelCamel.com link showing sell price history chart Yes Yes Yes
Category The name of a product category, such as Sporting Goods, to which a product belongs to. Column name changed from “Product Group” to “Category” 10/2022. Yes Yes Yes
Category You Offer Indicates whether the BPO product is sold in an Amazon Category that you have a history of selling in BPO Only BPO Only
Color Color of product Yes Yes Yes
Cost Unit cost of purchasing the product from your supplier, also known as cost of goods sold (COGS). The app gets this data from your supplier sheet and uses it to calculate Profit calculations. This cell can be edited for custom calculations. Column name changed from “Purchase Price” to “Cost” 10/2022. Yes Yes Yes
Cost Sub Total Total fees charged by Amazon. Referral Fee + Variable Closing Fee + Fulfillment Subtotal (FBA fees, if applicable) Yes Yes Yes
Custom Notes Add your notes about a product into the grid for any product. Notes are automatically saved Yes Yes Yes
Date Buyer Requested Date the Buyer made the request for Amazon to sell a product that does not currently have an Amazon listing BPO Only BPO Only
EAN EAN of product BPO Only BPO Only
Est Sales Estimated number of products that are sold on a listing on a monthly basis. Est Sales are shared by all sellers sharing the BuyBox. See BuyBox Contention Yes Yes Yes
Favorites Add/Remove products to your custom Favorites lists. Solid star represents a product already added to a Favorites list Yes Yes
Fulfillment Subtotal Sum of Amazon FBA fulfillment fees Yes Yes Yes
Inbound Shipping Estimate Cost of shipping the product (ie: to an Amazon fulfillment center). Added as an optional cost in “Additional Expenses” screen. Expressed as an average cost per lb. assumption which is applied to all products Yes Yes Yes
ISBN ISBN of product BPO Only BPO Only
Is Hazmat Indicates whether Amazon classifies product as Hazardous / Dangerous Goods Yes Yes
Is Top Level Category Indicates if the Category of the product is a top level category. This is relevant when analyzing sales as sub-category products are generally not ranked in the top level category due to lack of sales. See Category. Yes Yes
Keepa Keepa link showing historical sell price and sales velocity chart Yes Yes Yes
Last Run Date and time the product was last processed by the app. Results can be refreshed in the app by using the Refresh feature Yes Yes
Lowest FBA Lowest FBA fulfilled sell price on a product listing. Column name changed from “Low New FBA Price” to “Lowest FBA” 10/2022. Yes Yes Yes
Lowest FBM Lowest merchant fulfilled sell price + shipping (if applicable) on a product listing. Column name changed from “Low New Mfn Price” to “Lowest FBM” 10/2022. Yes Yes Yes
Lowest Price Last Week The lowest sell price on a BPO product listing over the last 7 days BPO Only BPO Only
Lowest Sales Rank 30d Lowest Sales Rank on listing in the last 30 days Yes
Lowest Sales Rank 90d Lowest Sales Rank on listing in the last 90 days Yes
Lowest Sales Rank 180d Lowest Sales Rank on listing in the last 180 days Yes
Manufacturer Manufacturer of product Yes Yes Yes
Margin % Profit Margin % = Profit / Sell Price Yes Yes Yes
Model Model of product Yes Yes Yes
New FBA Offers Number of FBA sellers on product listing. Column name changed from “New FBA Num Offers” to “New FBA Offers” 10/2022. Yes Yes Yes
New FBM Offers Number of merchant fulfilled sellers on product listing. Column name changed from “New MFN Num Offers” to “New FBA Offers” 10/2022. Yes Yes Yes
Package Dimensions Package Length x Width x Height Yes Yes Yes
Package Quantity Quantity of product packs sold together in one bundle. Used for multi-pack calculations. This cell can be edited for custom calculations Yes Yes Yes
Package Weight Package weight. Important for shipping cost Yes Yes Yes
Page Views Volume of product Page Views expressed as HIGH, MEDIUM, LOW BPO Only BPO Only
Parent ASIN The parent ASIN for a listing with variations Yes Yes Yes
Part Number Part number of product Yes Yes Yes
Product ID Shows the UPC, EAN, ASIN or ISBN from your supplier sheet that was used to match the product to Amazon. Useful for reconciling results to original product on the supplier sheet Yes Yes Yes
Product Performance Product Performance expressed as HIGH, MEDIUM, LOW BPO Only BPO Only
Profit Profit on each unit sale. Sell Price minus all costs associated with selling on Amazon ie: shipping, taxes, additional fees (if applicable) Yes Yes Yes
Rating Average customer review rating on listing Limited Yes
Referral Fee Amazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule Yes Yes Yes
Reviews Number of customer reviews on listing Limited Yes
ROI Return on Investment (ROI) = Profit / Cost Yes Yes Yes
Sales Rank Indicates how well a product is selling within its product category. The lower the number, the better the product has sold Yes Yes Yes
Sales Rank Drops 30d The number of Sales Rank “drops” recorded on historical chart in last 30 days. Sales Rank drops correspond to sales but are only a directional guide since sales velocity, inventory changes, chart coverage, etc., all plays a role. Yes
Sales Rank Drops 90d The number of Sales Rank “drops” recorded on historical chart in last 90 days. Sales Rank drops correspond to sales but are only a directional guide since sales velocity, inventory changes, chart coverage, etc., all plays a role. Yes
Sales Rank Drops 180d The number of Sales Rank “drops” recorded on historical chart in last 180 days. Sales Rank drops correspond to sales but are only a directional guide since sales velocity, inventory changes, chart coverage, etc., all plays a role. Yes
Sell Price Assumed sell price of product. FBA fees & Profit calculations are based on this price. App will assume sell price to either a) Low FBA Price or b) Low FBM Price (if no FBA fulfilled sellers exist on listing). This cell can be edited for custom calculations Yes Yes Yes
Seller Proceeds Gross profit before cost of goods sold. Sell price – Cost Subtotal Yes Yes Yes
Sub Category Sub Category of product Yes Yes
Title Title of the product’s Amazon listing Yes Yes Yes
Total Offers Total number of FBA and MFN sellers on listing Yes Yes Yes
UPC UPC of product Yes Yes
Variable Closing Fee Amazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule Yes Yes Yes
Variation Count Number of variations associated with product Yes
VAT % VAT % used to calculate VAT $. This cell can be edited for custom % calculations Yes Yes Yes
VAT $ VAT tax applied per settings in Additional Expenses settings Yes Yes Yes

Was this article helpful?

Related Articles