Knowledge base

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

Column Definition Chart

10 Likes
5398 Views
Tips & Tutorials Web 4 months ago
Available Column DataDescriptionAvailability
Amazon LinkLink to Amazon product page
Amazon SellerReturns whether Amazon is a competing seller on listing
ASINASIN identifier of product
B2B Sales RankSales Rank as it relates only to Amazon Business purchasesWeb app BPO only
B2B Sales Rank GrowthGrowth in B2B Sales Rank expressed as HIGH, MEDIUM, LOWWeb app BPO only
BrandProduct’s brand name
Brand You OfferIndicates whether the BPO product is sold by a brand you have a history of sellingWeb app BPO only
Buy Box LandedThe active BuyBox sales price on listing + buyer’s shipping charge (if any)
BuyBox ContentionNumber of FBA offers that are competing for and are rotating on the Buybox
Buyer IndustryThe industry that the Buyer is in that made the request for Amazon to sell a product that does not currently have an Amazon listingWeb app BPO only
CamelCCCamelCamelCamel.com link showing sell price history chart
CategoryThe product’s Amazon categoryWeb app BPO only
Category You OfferIndicates whether the BPO product is sold in an Amazon Category that you have a history of selling inWeb app BPO only
ColorAn product’s color
Cost SubtotalTotal fees charged by Amazon. Referral Fee + Variable Closing Fee + Fullfilment Subtotal (FBA fees, if applicable)
Custom NotesAllows you to add your notes about a product into the grid for any productWeb app only
Date Buyer RequestedThe date that the Buyer made the request for Amazon to sell a product that does not currently have an Amazon listingWeb app BPO only
EANEAN of productWeb app BPO only
Est SalesEstimated number of products are sold on a listing on a monthly basis. Est Sales are shared by all sellers sharing the BuyBox. See BuyBox Contention
FavoritesAdd/Remove products to your custom Favorites lists. Solid star represents a product already added to a Favorites listWeb app only
Fulfillment SubtotalThe sum of Amazon FBA fullfilment fees
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 products
ISBNISBN of productWeb app BPO only
KeepaKeepa.com link showing historical sell price and sales velocity chart
Last RunDate and time the product was last processed by the app. Results can be refreshed in the app by using the Refresh feature
Low New FBA PriceLowest FBA fullfilled sell price on a product listing
Low New Mfn PriceLowest merchant fullfilled sell price + shipping (if applicable) on a product listing
Lowest Price Last WeekThe lowest sell price on a BPO product listing over the last 7 daysWeb app BPO only
ManufacturerManufacturer of product
Margin %Profit Margin %. Profit / Sell Price
ModelModel of product
New FBA Num OffersNumber of FBA sellers on product listing
New MFN Num OffersNumber of merchant fulfilled sellers on product listing
Package DimensionsPackage Length x Width x Height
Package QuantityQuantity of product packs sold together in one bundle. Used for multi-pack calculations. This cell can be edited for custom calculations
Package WeightPackage weight. Important for shipping cost
Page ViewsVolume of product Page Views expressed as HIGH, MEDIUM, LOWWeb app BPO only
Parent ASINThe parent ASIN for a listing with variations
Part NumberPart number of product
Product GroupThe name of a product category, such as sporting goods, to which an product belongs to
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 supplier sheet
Product PerformanceProduct Performance expressed as HIGH, MEDIUM, LOWWeb app BPO only
ProfitProfit on each sale. Sell Price minus all costs associated with selling on Amazon ie: shipping, taxes, additional fees (if applicable)
Purchase PriceShows the cost of purchasing the product from your supplier or the cost required to manufacture/produce a single unit. Otherwise known as cost of goods sold (COGS). Obtained from your supplier sheet and required for accurate Profit calculations. This cell can be edited for custom calculations
RatingAverage customer review rating on listing
Referral FeeAmazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule
ReviewsNumber of customer reviews on listing
ROIReturn on Investment. Profit / Purchase Price
Sales RankIndicates how well an product is selling within its product category. The lower the number, the better the product has sold
Sell PriceAssumed sell price of product. FBA fees & Profit calculations are based on this price. App will assume sell price to either a) Low New FBA Price or b) Low New Mfn Price if no FBA fullfilled sellers exist on listing. This cell can be edited for custom calculations
Seller ProceedsGross profit before paying for product’s purchase price from supplier (COGS). Sell price – Cost Subtotal
Sub CategoryProduct Sub CategoryWeb app BPO only
TitleTitle of the product’s Amazon listing
Total OffersTotal number of FBA and MFN sellers on listing
UPCUPC of productWeb app BPO only
Variable Closing FeeAmazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule
VAT %VAT % used to calculate VAT $. This cell can be edited for custom % calculations
VAT $VAT tax applied per swttings in Additional Expenses settings

Was this article helpful?

Related Articles

Leave a Comment