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 |