Knowledge base

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

Column Definition Chart

12 Likes
2321 Views
Tips & Tutorials Web 3 weeks ago
Available ColumnsDescription
Amazon LinkURL to Amazon product information page
ASINASIN of product as returned by Amazon API
BrandAn product’s brand
Buy Box CostThe active Buy Box sales price on listing.  The Buy Box is the sales price on the front page of product detail page where customers can begin the purchasing process by adding products to their shopping carts. Also see: BuyBox Landed
Buy Box LandedThe active BuyBox sales price on listing + shipping charged to buyer of product (if any). Also see: BuyBox
CamelCCCamelCamelCamel.com chart
ColorAn product’s color
Cost SubtotalThe sum of selling on Amazon fees (Referral Fee + Variable Closing Fee) and the Fullfilment Subtotal (FBA fees) charged to seller. Total fees charged by Amazon
EANEAN of product as returned by Amazon API
Estimated Number of SalesEstimated number of products are sold on the listing in a 30 day period
Fulfillment SubtotalThe sum of Amazon FBA fullfilment fees charged to seller
Inbound Shipping EstimateCost of shipping the product to an Amazon fulfillment center. This is expressed in program as an average cost per lb.
Is Amazon FullfilledReturns whether there are any FBA sellers on listing
Is Sold By AmazonReturns whether Amazon.com is a seller on listing. Requires Product Advertising API credentials and settings options enabled
ISBNISBN of product as returned by Amazon API
Item HeightProduct height
Item LengthProduct length
Item WeightProduct weight
Item WidthProduct width
KeepaKeepa.com chart
Last RunDate and time the result was last processed. Results can be refreshed in program using the Refresh feature.
Low New FBA PriceLowest sales price on a product listing that is FBA fullfilled
Low New Mfn PriceLowest sales price on a product listing that is not FBA fullfilled. These product listings are fullfilled by merchants directly. Includes extra shipping costs (if applicable), see Shipping Cost
ManufacturerManufacturer of product
Margin %Profit Margin %. Profit / Sell Price
ModelModel of product (often same as MPN)
New FBA Num OffersTotal number of FBA sellers on listing selling new product (used listings are not counted)
New MFN Num OffersTotal number of MFN sellers on listing selling new product (used listings are not counted)
Num ReviewsNumber of customer reviews on listing
Package HeightPackage height
Package LengthPackage length
Package QuantityQuantity of products in a package. Used for multi-pack calculations
Package WeightPackage weight
Package WidthPackage width
Part NumberPart number of product
Product GroupThe name of a product category, such as sporting goods, to which an product belongs to
Product IDProduct ID (UPC, EAN, ASIN or ISBN) used in the customer’s load sheet. This can be useful to matching results to original load sheet as Amazon listings may have multiple IDs for the same ID type (ie: two UPC’s may be corrolated to same product)
ProfitSales Price minus all costs associated with selling on Amazon, shipping and taxes (if applicable).  Seller Proceeds – Purchase Price – Inbound Shipping Estimate – Prep Fee Per product – Tax % on Sourcing
PublisherPublisher of product
Purchase PriceThe cost of acquiring the product from your supplier, or the cost required to manufacture/produce a single unit. Otherwise known as cost of goods sold (COGS). This is an optional field provided by the user in the product load sheet. Required for accurate FBA fee, Profit and ROI 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
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. Hovering your curser over this cell will display a Keepa Sales/Price history chart
Sell PriceCost program assumes will be the sales price of product. FBA fees, Profit and ROI calculations are based on this assumed sales price. Program will default Sell Price to either a) lowest New FBA Price or b) Low New Mfn Price if no FBA fullfilled sellers exist on listing. Previously known as “Cost to Estimate Fees”, renamed 11/25/18
Seller ProceedsSell price – Cost Subtotal. Previously known as “Margin Impact”, renamed 11/25/18.
Shipping CostShipping charges to buyer on listing in addition to sales price (if applicable)
TitleProduct name of Amazon listing
Total OffersTotal number of FBA and MFN sellers on listing selling new product (used listings are not counted)
UPCUPC of product as returned by Amazon API
Variable Closing FeeAmazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule
VAT $VAT tax
VAT %VAT % used to calculate VAT $. This cell can be edited for custom % calculations

Was this article helpful?

Related Articles

Leave a Comment