Knowledge base

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

Column Definition Chart

11 Likes
2280 Views
Tips & Tutorials Web 1 week ago
Available Columns Description
Amazon Link URL to Amazon product information page
ASIN ASIN of product as returned by Amazon API
Brand An product’s brand
Buy Box Cost The 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 Landed The active BuyBox sales price on listing + shipping charged to buyer of product (if any). Also see: BuyBox
CamelCC CamelCamelCamel.com chart
Color An product’s color
Cost Subtotal The 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
EAN EAN of product as returned by Amazon API
Estimated Number of Sales Estimated number of products are sold on the listing in a 30 day period
Fulfillment Subtotal The sum of Amazon FBA fullfilment fees charged to seller
Inbound Shipping Estimate Cost of shipping the product to an Amazon fulfillment center. This is expressed in program as an average cost per lb.
Is Amazon Fullfilled Returns whether there are any FBA sellers on listing
Is Sold By Amazon Returns whether Amazon.com is a seller on listing. Requires Product Advertising API credentials and settings options enabled
ISBN ISBN of product as returned by Amazon API
Item Height Product height
Item Length Product length
Item Weight Product weight
Item Width Product width
Keepa Keepa.com chart
Last Run Date and time the result was last processed. Results can be refreshed in program using the Refresh feature.
Low New FBA Price Lowest sales price on a product listing that is FBA fullfilled
Low New Mfn Price Lowest 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
Manufacturer Manufacturer of product
Margin % Profit Margin %. Profit / Sell Price
Model Model of product (often same as MPN)
New FBA Num Offers Total number of FBA sellers on listing selling new product (used listings are not counted)
New MFN Num Offers Total number of MFN sellers on listing selling new product (used listings are not counted)
Num Reviews Number of customer reviews on listing
Package Height Package height
Package Length Package length
Package Quantity Quantity of products in a package. Used for multi-pack calculations
Package Weight Package weight
Package Width Package width
Part Number Part number of product
Product Group The name of a product category, such as sporting goods, to which an product belongs to
Product ID Product 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)
Profit Sales 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
Publisher Publisher of product
Purchase Price The 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
Rating Average customer review rating on listing
Referral Fee Amazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule
ROI Return on Investment. Profit / Purchase Price
Sales Rank Indicates 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 Price Cost 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 Proceeds Sell price – Cost Subtotal. Previously known as “Margin Impact”, renamed 11/25/18.
Shipping Cost Shipping charges to buyer on listing in addition to sales price (if applicable)
Title Product name of Amazon listing
Total Offers Total number of FBA and MFN sellers on listing selling new product (used listings are not counted)
UPC UPC of product as returned by Amazon API
Variable Closing Fee Amazon 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