Knowledge base

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

Column Definition Chart

11 Likes
6044 Views
Tips & Tutorials Web 4 days ago
Available Columns
Description
Feature Availability
Windows appWeb appWeb app Pro
Amazon LinkLink to Amazon product pageYesYesYes
Amazon SellerReturns whether Amazon is a current competing seller on listing. More InformationLimitedYes
Amazon Seller InStock Rate 30d% of time Amazon was a competing seller on listing in last 30 daysYes
Amazon Seller InStock Rate 90d% of time Amazon was a competing seller on listing in last 90 daysYes
Amazon Seller InStock Rate 180d% of time Amazon was a competing seller on listing in last 180 daysYes
ASINASIN identifier of productYesYesYes
Avg Buybox 30dAverage BuyBox sell price on listing in the last 30 daysYes
Avg Buybox 90dAverage BuyBox sell price on listing in the last 90 daysYes
Avg Buybox 180dAverage BuyBox sell price on listing in the last 180 daysYes
Avg Sales Rank 30dAverage Sales Rank on listing in the last 30 daysYes
Avg Sales Rank 90dAverage Sales Rank on listing in the last 90 daysYes
Avg Sales Rank 180dAverage Sales Rank on listing in the last 180 daysYes
B2B Sales RankSales Rank as it relates only to Amazon Business purchasesBPO OnlyBPO Only
B2B Sales Rank GrowthGrowth in B2B Sales Rank expressed as HIGH, MEDIUM, LOWBPO OnlyBPO Only
BrandBrand name of productYesYesYes
Brand You OfferIndicates whether the BPO product is sold by a brand you have a history of sellingBPO OnlyBPO Only
Buy Box LandedActive BuyBox sell price on listing + buyer’s shipping charge (if any)YesYesYes
BuyBox ContentionNumber of FBA offers that are competing for and are rotating on the BuyboxYesYesYes
Buyer IndustryIndustry the Buyer is in that made a request for Amazon to sell this product.BPO OnlyBPO Only
CamelCCCamelCamelCamel.com link showing sell price history chartYesYesYes
CategoryThe 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.YesYesYes
Category You OfferIndicates whether the BPO product is sold in an Amazon Category that you have a history of selling inBPO OnlyBPO Only
ColorColor of productYesYesYes
CostUnit 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.YesYesYes
Cost Sub TotalTotal fees charged by Amazon. Referral Fee + Variable Closing Fee + Fulfillment Subtotal (FBA fees, if applicable)YesYesYes
Custom NotesAdd your notes about a product into the grid for any product. Notes are automatically savedYesYesYes
Date Buyer RequestedDate the Buyer made the request for Amazon to sell a product that does not currently have an Amazon listingBPO OnlyBPO Only
EANEAN of productBPO OnlyBPO Only
Est SalesEstimated 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 ContentionYesYesYes
FavoritesAdd/Remove products to your custom Favorites lists. Solid star represents a product already added to a Favorites listYesYes
Fulfillment SubtotalSum of Amazon FBA fulfillment feesYesYesYes
Inbound Shipping EstimateCost 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 productsYesYesYes
ISBNISBN of productBPO OnlyBPO Only
Is HazmatIndicates whether Amazon classifies product as Hazardous / Dangerous GoodsYesYes
Is Top Level CategoryIndicates 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
KeepaKeepa link showing historical sell price and sales velocity chartYesYesYes
Last RunDate and time the product was last processed by the app. Results can be refreshed in the app by using the Refresh featureYesYes
Lowest FBALowest FBA fulfilled sell price on a product listing. Column name changed from “Low New FBA Price” to “Lowest FBA” 10/2022.YesYesYes
Lowest FBMLowest merchant fulfilled sell price + shipping (if applicable) on a product listing. Column name changed from “Low New Mfn Price” to “Lowest FBM” 10/2022.YesYesYes
Lowest Price Last WeekThe lowest sell price on a BPO product listing over the last 7 daysBPO OnlyBPO Only
Lowest Sales Rank 30dLowest Sales Rank on listing in the last 30 daysYes
Lowest Sales Rank 90dLowest Sales Rank on listing in the last 90 daysYes
Lowest Sales Rank 180dLowest Sales Rank on listing in the last 180 daysYes
ManufacturerManufacturer of productYesYesYes
Margin %Profit Margin % = Profit / Sell PriceYesYesYes
ModelModel of productYesYesYes
New FBA OffersNumber of FBA sellers on product listing. Column name changed from “New FBA Num Offers” to “New FBA Offers” 10/2022.YesYesYes
New FBM OffersNumber of merchant fulfilled sellers on product listing. Column name changed from “New MFN Num Offers” to “New FBA Offers” 10/2022.YesYesYes
Package DimensionsPackage Length x Width x HeightYesYesYes
Package QuantityQuantity of product packs sold together in one bundle. Used for multi-pack calculations. This cell can be edited for custom calculationsYesYesYes
Package WeightPackage weight. Important for shipping costYesYesYes
Page ViewsVolume of product Page Views expressed as HIGH, MEDIUM, LOWBPO OnlyBPO Only
Parent ASINThe parent ASIN for a listing with variationsYesYesYes
Part NumberPart number of productYesYesYes
Product IDShows 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 sheetYesYesYes
Product PerformanceProduct Performance expressed as HIGH, MEDIUM, LOWBPO OnlyBPO Only
ProfitProfit on each unit sale. Sell Price minus all costs associated with selling on Amazon ie: shipping, taxes, additional fees (if applicable)YesYesYes
RatingAverage customer review rating on listingLimitedYes
Referral FeeAmazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee ScheduleYesYesYes
ReviewsNumber of customer reviews on listingLimitedYes
ROIReturn on Investment (ROI) = Profit / CostYesYesYes
Sales RankIndicates how well a product is selling within its product category. The lower the number, the better the product has soldYesYesYes
Sales Rank Drops 30dThe 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 90dThe 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 180dThe 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 PriceAssumed 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 calculationsYesYesYes
Seller ProceedsGross profit before cost of goods sold. Sell price – Cost SubtotalYesYesYes
Sub CategorySub Category of productYesYes
TitleTitle of the product’s Amazon listingYesYesYes
Total OffersTotal number of FBA and MFN sellers on listingYesYesYes
UPCUPC of productYesYes
Variable Closing FeeAmazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee ScheduleYesYesYes
Variation CountNumber of variations associated with productYes
VAT %VAT % used to calculate VAT $. This cell can be edited for custom % calculationsYesYesYes
VAT $VAT tax applied per settings in Additional Expenses settingsYesYesYes

Was this article helpful?

Related Articles

Leave a Comment