Data / Columns
List of built-in columns
This is a complete list of all built-in columns as of Price Checker version 2.2.48.
In this table, ‘highlighted’ refers to the yellow header highlight mentioned in https://pricechecker2.atlassian.net/wiki/spaces/PC2/pages/1179649 , and ‘Grouped under’ refers to the search grouping on the column chooser.
In addition you can create custom columns using Excel (or other spreadsheet software) formulas and customise the ordering of the output.
Also see: Add/Remove Columns Find a Column Description https://pricechecker2.atlassian.net/wiki/spaces/PC2/pages/688129
Title | Description | Highlighted? | Grouped under | Requires |
---|---|---|---|---|
Input ID | UPC or other ID from your input file. This column is required to be present somewhere in your output. |
| Input |
|
Cost $USD | Your Cost as taken from your input file (optional column). Assumed to be per single unit if you don't have a wholesale packaging column. This column is required to be present somewhere in your output. |
| Input |
|
Wholesale Pack Qty | Wholesale packaging from your input file, i.e. the quantity in which you are purchasing. This column is optional in your input, but must be present somewhere in your output. |
| Input |
|
Original Data | The complete original input data (including the columns that aren't processed by PC2). If in the same sheet you add both this and the Input ID/Cost/Wholesale Pack columns, they will be duplicated unless positioned immediately before this entry. |
| Input |
|
ASIN | Amazon's identifier, or "Product not found" |
| Core Attributes |
|
Amazon Title | Title of the product on Amazon. Please report incorrect products returned from a UPC directly to Amazon. |
| Core Attributes |
|
No# of sellers | Total number of Amazon sellers offering this product | y | Core Attributes |
|
AMZ Multi Pack Qty | Package quantity as returned by Amazon's API Please report mismatches directly to Amazon. | y | Core Attributes |
|
Product Group | As returned by Amazon's API Please report mismatches directly to Amazon. |
| Core Attributes |
|
Multi ASIN? | True if Amazon has more than one ASIN match for the given input ID. |
| Core Attributes |
|
Product Type Name | 'ProductTypeName' is a classifier in Amazon's API that may help to more correctly identify a product's category. |
| Core Attributes |
|
Parent ASIN | ASIN of the Parent item if applicable |
| Core Attributes |
|
Hazmat | True if the item's Hazmat status prevents shipment into FBA. |
| Core Attributes |
|
Image | Small image url |
| Core Attributes |
|
Shipment Restrictions | True if adding to an FBA shipment plan throws an error. |
| Core Attributes | Hazmat Disclaimer |
Trade-in Eligible | True/false whether this item is eligible for trade-in. Returns false if Amazon do not specify any value through the API. |
| Core Attributes |
|
Trade-in Price $USD | Trade-in price in marketplace currency. May be blank if no trade in price is available or if the item is not eligible. |
| Core Attributes |
|
Brand | Brand |
| Core Attributes |
|
Major Brand? | Whether or not the brand is considered "major", as determined by your brands file (see 'Filters'). The values in this column will be either 'true' or blank. |
| Core Attributes |
|
List Price $USD | List price in marketplace currency. This is the MSRP shown on Amazon. May be blank if no list price is available. |
| Core Attributes |
|
No# of variations | Number of variations (siblings), including self. For example, if a product is listed in colours Red, Green, and Blue, this would return 3. Doesn't take any account of actual availability. |
| Core Attributes |
|
Inactive/Redirects? | Whether or not this ASIN is inactive or redirects to one of its siblings. Sales and rank figures for such items must be taken with extreme caution. |
| Core Attributes | Historical Data |
Hazmat Type | The Hazardous Material Type, if present in Amazon's catalog |
| Additional Attributes |
|
Actor | Returns the "actor" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Artist | Returns the "artist" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Aspect Ratio | Returns the "aspectRatio" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Audience Rating | Returns the "audienceRating" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Author | Returns the "author" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Back Finding | Returns the "backFinding" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Band Material Type | Returns the "bandMaterialType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Binding | Returns the "binding" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
CERO Age Rating | Returns the "ceroAgeRating" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Chain Type | Returns the "chainType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Clasp Type | Returns the "claspType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Color | Returns the "color" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Creator | Returns the "creator" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Department | Returns the "department" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Director | Returns the "director" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Display Size | Returns the "displaySize" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Edition | Returns the "edition" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Episode Sequence | Returns the "episodeSequence" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
ESRB Rating | Returns the "esrbAgeRating" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Feature | Returns the "feature" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Format | Returns the "format" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Gem Type | Returns the "gemType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Genre | Returns the "genre" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Golf Club Flex | Returns the "golfClubFlex" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Golf Club Loft | Returns the "golfClubLoft" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Hardware Platform | Returns the "hardwarePlatform" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Is Adult Product | Returns the "isAdultProduct" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Is Autographed | Returns the "isAutographed" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Is Memorabilia | Returns the "isMemorabilia" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Issues Per Year | Returns the "issuesPerYear" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Item Part Number | Returns the "itemPartNumber" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Label | Returns the "label" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Languages | Returns the "languages" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Legal Disclaimer | Returns the "legalDisclaimer" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Manufacturer | Returns the "manufacturer" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Manufacturer Maximum Age | Returns the "manufacturerMaximumAge" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Manufacturer Minimum Age | Returns the "manufacturerMinimumAge" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Manufacturer Parts Warranty Description | Returns the "manufacturerPartsWarrantyDescription" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Material Type | Returns the "materialType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Media Type | Returns the "mediaType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Metal Stamp | Returns the "metalStamp" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Metal Type | Returns the "metalType" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Model | Returns the "model" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Number Of Discs | Returns the "numberOfDiscs" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Number of Images | Shows the number of images for this item. |
| Additional Attributes |
|
Number Of Issues | Returns the "numberOfIssues" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Number Of Items | Returns the "numberOfItems" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Number Of Pages | Returns the "numberOfPages" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Number Of Tracks | Returns the "numberOfTracks" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Operating System | Returns the "operatingSystem" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Part Number | Returns the "partNumber" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Platform | Returns the "platform" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Product Type Subcategory | Returns the "productTypeSubcategory" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Publication Date | Returns the "publicationDate" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Publisher | Returns the "publisher" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Region Code | Returns the "regionCode" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Release Date | Returns the "releaseDate" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Running Time | Returns the "runningTime" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Season Sequence | Returns the "seasonSequence" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Seikodo Product Code | Returns the "seikodoProductCode" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Size | Returns the "size" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Size Per Pearl | Returns the "sizePerPearl" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Studio | Returns the "studio" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Subscription Length | Returns the "subscriptionLength" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Total Diamond Weight | Returns the "totalDiamondWeight" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Total Gem Weight | Returns the "totalGemWeight" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Warranty | Returns the "warranty" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
WEEE Tax Value | Returns the "weeeTaxValue" attribute directly from the Amazon MWS API. |
| Additional Attributes |
|
Amazon UPC | Main UPC of the item as returned by Amazon - useful if only ASIN known. |
| Identifiers | Historical Data |
Amazon EAN | Main EAN of the item as returned by Amazon - useful if only ASIN known. |
| Identifiers | Historical Data |
AZ Product Description | Amazon product description. In many cases this will be limited to the first 2000 characters. |
| Identifiers | Historical Data |
MPN | Manufacturer's Part Number or Model number if and as available through the API. |
| Identifiers | Historical Data |
AZ Feature 1 | Amazon product feature no. 1. Bullet points as shown on the product details, limited to the first 1000 characters. |
| Identifiers | Historical Data |
AZ Feature 2 | Amazon product feature no. 2. Bullet points as shown on the product details, limited to the first 1000 characters. |
| Identifiers | Historical Data |
AZ Feature 3 | Amazon product feature no. 3. Bullet points as shown on the product details, limited to the first 1000 characters. |
| Identifiers | Historical Data |
AZ Feature 4 | Amazon product feature no. 4. Bullet points as shown on the product details, limited to the first 1000 characters. |
| Identifiers | Historical Data |
AZ Feature 5 | Amazon product feature no. 5. Bullet points as shown on the product details, limited to the first 1000 characters. |
| Identifiers | Historical Data |
Best Seller Rank | Current Spot Sales Rank. Only returned for top ranked category. | y | Ranking |
|
Ranked Category | Only returned for top ranked category |
| Ranking |
|
BSR % | Percentile that the item's Bestseller Rank (BSR) represents within its category, to 1 decimal place (e.g. 1.3%). Please note that this is based on an estimated total, as it is not directly provided by Amazon. |
| Ranking |
|
Launchpad? | 'Y' if this item is featured in Amazon Launchpad. |
| Ranking |
|
Date First Listed | Date the item was first listed on this Amazon marketplace. Not available for all items and may be blank if unknown. |
| Historic |
|
Average New Price (excl Shipping) Price 30d $USD | Average New Price (excl Shipping) Price over the last 30 days |
| Historic | Historical Data |
Average New Price (excl Shipping) Price 60d $USD | Average New Price (excl Shipping) Price over the last 60 days |
| Historic | Historical Data |
Average New Price (excl Shipping) Price 90d $USD | Average New Price (excl Shipping) Price over the last 90 days |
| Historic | Historical Data |
Average New Price (excl Shipping) Price 180d $USD | Average New Price (excl Shipping) Price over the last 180 days |
| Historic | Historical Data |
Average Used Price Price 30d $USD | Average Used Price Price over the last 30 days |
| Historic | Historical Data |
Average Used Price Price 60d $USD | Average Used Price Price over the last 60 days |
| Historic | Historical Data |
Average Used Price Price 90d $USD | Average Used Price Price over the last 90 days |
| Historic | Historical Data |
Average Used Price Price 180d $USD | Average Used Price Price over the last 180 days |
| Historic | Historical Data |
Average Amazon's Price 30d $USD | Average Amazon's Price over the last 30 days |
| Historic | Historical Data |
Average Amazon's Price 60d $USD | Average Amazon's Price over the last 60 days |
| Historic | Historical Data |
Average Amazon's Price 90d $USD | Average Amazon's Price over the last 90 days |
| Historic | Historical Data |
Average Amazon's Price 180d $USD | Average Amazon's Price over the last 180 days |
| Historic | Historical Data |
Average Buy Box Landed Price 30d $USD | Average Buy Box Landed Price over the last 30 days |
| Historic | Historical Data |
Average Buy Box Landed Price 60d $USD | Average Buy Box Landed Price over the last 60 days |
| Historic | Historical Data |
Average Buy Box Landed Price 90d $USD | Average Buy Box Landed Price over the last 90 days |
| Historic | Historical Data |
Average Buy Box Landed Price 180d $USD | Average Buy Box Landed Price over the last 180 days |
| Historic | Historical Data |
Average Rank 30d | Average Sales Rank over the last 30 days | y | Historic | Historical Data |
Average Rank 60d | Average Sales Rank over the last 60 days | y | Historic | Historical Data |
Average Rank 90d | Average Sales Rank over the last 90 days | y | Historic | Historical Data |
Average Rank 180d | Average Sales Rank over the last 180 days | y | Historic | Historical Data |
Est. Sales / Month (using 90DAR) | Est. Sales / Month based on Sales Rank over the last 90 days. |
| Historic | Historical Data |
90 Day Price Fluctuation % | Percentage Fluctuation of Buy Box Landed over the last 90 days. |
| Historic | Historical Data |
Est. Sales / Month | Monthly Estimated Total Sales based on Rank |
| Sales |
|
Est. Share of Sales / Month | Your estimated share of monthly sales. Only FBA BuyBox contenders are considered (+1 unless you are already a contender). |
| Sales |
|
Est. Profit / Month $USD | Your estimated total monthly profit based on estimated sales. |
| Sales |
|
Est. Buying Cost / Month $USD | Your estimated total buying cost (goods only) based on estimated sales. |
| Sales |
|
Est. Total Revenue / Month $USD | Estimated total monthly revenue based on estimated sales and the reference price. |
| Sales |
|
Est. Share of Revenue / Month $USD | Your estimated share of monthly revenue, based on estimated sales and the reference price. Only FBA BuyBox contenders are considered (+1 unless you are already a contender). |
| Sales |
|
Est. Sales / Month (Spot Rank) | Monthly Estimated Total Sales based on Spot Rank. |
| Sales |
|
Stock | Returns the stock availability of the first offer (buy box unless suppressed), if known. |
| Sales | Historical Data |
Total No# of Reviews | The total number of product reviews for this item across all its variations |
| Reviews | Historical Data OR Variation Reviews |
Avg Review Score | The average review score as returned by Amazon (may be weighted as per their algorithm) |
| Reviews | Historical Data OR Variation Reviews |
Is Global Ratings? | True if the product displays reviews as “N global ratings | N global reviews”. |
| Reviews | Variation Reviews |
Variation No# of Reviews | The number of product reviews for this specific item variation. These are “Global” reviews if the product displays reviews as such. Only returned with the “Variation Reviews” option |
| Reviews | Variation Reviews |
Variation No# of Global Ratings | The number of global product ratings for this specific item variation. May be blank if the product displays reviews in the “old” (non-global) style. Only returned with the “Variation Reviews” option and if the item |
| Reviews | Variation Reviews |
BuyBox Seller Type | Who owns the (new) BuyBox? AM = Amazon (if available data allows distinction) FBA = Prime Seller (or Amazon if data unavailable) MFN = Merchant Fulfilled Seller |
| Prices | Historical Data to distinguish between AM vs FBA |
Prime Sellers in BuyBox Contention | The number of Prime sellers in contention for the New BuyBox, including Merchant Fulfilled Prime (MFP). Excludes other MFN and those not qualifying for the Buy Box. |
| Prices | Historical Data |
MFN Sellers in BuyBox Contention | The number of MFN sellers in contention for the New BuyBox. Does NOT include FBA sellers or those not qualifying for the BuyBox. |
| Prices |
|
BuyBox Price New $USD | The New BuyBox Landed price (product + shipping) | y | Prices |
|
BuyBox Price Used $USD | The Used BuyBox Landed price (product + shipping) |
| Prices |
|
BuyBox Lead Time | Shows the maximum ship time of the BuyBox offer. |
| Prices |
|
BuyBox Listing New $USD | The New BuyBox Listing price (product only) |
| Prices |
|
BuyBox Shipping New $USD | The New BuyBox Shipping price (shipping only) |
| Prices |
|
Buy Box Suppressed? | Buy Box Suppressed? |
| Prices | Historical Data |
No# sellers within 2% of BB | The number of offers within 2% of the New BuyBox Price. NB: Slows historical data. |
| Prices | Historical Data |
New Offer List | List of New offers, pipe ' | ' delimited within a single cell |
| Prices |
|
Used Offer List | List of Used offers, pipe ' | ' delimited within a single cell |
| Prices |
|
FBA Offer List | List of FBA offers, pipe ' | ' delimited within a single cell |
| Prices |
|
Reference Offer $USD | The Reference Offer is the price (product + shipping) used in profit calculations. |
| Prices |
|
Reference Offer Type | The analysis options rule by which the Reference Offer was selected. |
| Prices |
|
Amazon Is Seller? | Whether or not Amazon offers this item directly. |
| Prices | Historical Data |
Amazon sells at $USD | The price that Amazon themselves sell at (if any). |
| Prices | Historical Data |
BuyBox Seller | The name or ID of the 'New' BuyBox Seller if available. NB: Slows historical data. |
| Prices | Historical Data |
Amazon Ever A Seller? | Whether or not Amazon has ever sold this item directly. |
| Prices | Historical Data |
FBA Seller List | List of FBA seller IDs, pipe ' | ' delimited within a single cell |
| Prices | Historical Data |
Lowest FBA New Price $USD | Lowest New FBA Landed price (product + shipping) |
| FBA |
|
Lowest FBA Used Price $USD | Lowest Used FBA Landed price (product + shipping) |
| FBA |
|
Lowest MFN New Price $USD | Lowest New MFN Landed price (product + shipping) |
| MFN |
|
Lowest MFN Used Price $USD | Lowest Used MFN Landed price (product + shipping) |
| MFN |
|
Dim. Weight | Volumetric/Dimensional Weight. User configured calculation if enabled in the selected Cost Profile, otherwise defaulting to Amazon's calculation. |
| Dimensions |
|
Item Height {unit} | Item height as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Item Length {unit} | Item length as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Item Width {unit} | Item width as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Item Weight {unit} | Item weight as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Package Height {unit} | Packaged height as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Package Length {unit} | Packaged length as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Package Width {unit} | Packaged width as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Package Weight {unit} | Packaged weight as returned by Amazon, in the marketplace unit (may be blank if not available). |
| Dimensions |
|
Total Amazon Fees $USD | Total Amazon Fees (the "cost-subtotal" on the FBA calculator) |
| Fees |
|
Total Ful- fillment Cost $USD | As per FBA calculator. |
| Fees |
|
Seller Proceeds $USD | As per FBA calculator. |
| Fees |
|
Order Handling Fee $USD | As per FBA calculator. Only relevant to CA marketplace. |
| Fees |
|
Pick Pack Fee $USD | As per FBA calculator. Only relevant to CA marketplace. |
| Fees |
|
Referral Fee $USD | As per FBA calculator. |
| Fees |
|
Single Ful- fillment Fee $USD | As per FBA calculator. Only relevant to US and European marketplaces. |
| Fees |
|
Monthly Storage Fee $USD | As per FBA calculator. |
| Fees |
|
Variable Closing Fee $USD | As per FBA calculator. |
| Fees |
|
Weight Handling Fee $USD | As per FBA calculator. Only relevant to CA marketplace. |
| Fees |
|
Size Tier | The size tier for this product, based on Amazon-supplied dimensions and weight |
| Fees |
|
Referral Fee % | Shows the fee percentage applicable to this item's category. |
| Fees |
|
Amazon Required Prep | Comma separated list of Prep Requirements imposed by Amazon. Possible values: Polybagging, BubbleWrapping, Taping, BlackShrinkWrapping, Labeling, HangGarment. |
| Fees |
|
Total COGS $USD | Total Cost of Goods Sold per single unit. i.e. Cost from your input divided by Wholesale Packaging (if available), multiplied with Amazon pack quantity | y | Costs |
|
Ship To Amazon $USD | Total estimated shipping cost for this item or pack, based on your cost profile and dimensions/weights returned by Amazon. For MFN shows "Ship to Customer". |
| Costs |
|
Ship To Amazon / unit $USD | Estimated shipping cost per unit for this item or pack, based on your cost profile and dimensions/weights returned by Amazon. For MFN shows "Ship to Customer / unit". |
| Costs |
|
Prep $USD | Prep cost based on your cost profile. |
| Costs |
|
VAT $USD | VAT based on your cost profile: - VAT element of sale price if VAT registered - VAT on Amazon fees if not VAT registered |
| Costs |
|
Supplier Shipping $USD | Supplier's shipping cost for this item or pack, using a percentage of product cost as per your cost profile. |
| Costs |
|
Net Profit $USD | Total net profit for this item or pack, taking into account package quantity, fees, and your Cost Profile | y | Profit |
|
Net Profit Per Unit $USD | Net profit per unit in this item or pack, taking into account package quantity, fees, and your Cost Profile | y | Profit |
|
Net RoI % | Return on Investment as a percentage (profit over sum of costs) | y | Profit |
|
Max Cost to Break Even $USD | The cost price for which you would Break Even, if selling at the current Buy Box Price. |
| Profit |
|
AMZ Price to Break Even $USD | The sales price at which profit would be 0.00. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
AMZ Price to BE + 5% $USD | The sales price at which profit would be 0.00, plus 5%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
AMZ Price to BE + 10% $USD | The sales price at which profit would be 0.00, plus 10%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
AMZ Price to BE + 20% $USD | The sales price at which profit would be 0.00, plus 20%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
Max Cost for 20% ROI $USD | The cost price for which you can achieve 20% ROI, if selling at the current Buy Box Price. |
| Profit |
|
Max Cost for 30% ROI $USD | The cost price for which you can achieve 30% ROI, if selling at the current Buy Box Price. |
| Profit |
|
Max Cost for 15% ROI $USD | The cost price for which you can achieve 15% ROI, if selling at the current Buy Box Price. |
| Profit |
|
Net Margin % | Net Margin as a percentage (Net Profit divided by sales price, which is the 'Reference Offer' as determined by your selection order). | y | Profit |
|
AMZ Price to 0% Margin $USD | The sales price at which margin would be 0%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
AMZ Price to 5% Margin $USD | The sales price at which margin would be 5%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
AMZ Price to 10% Margin $USD | The sales price at which margin would be 10%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
AMZ Price to 15% Margin $USD | The sales price at which margin would be 15%. The figure may be inaccurate if an item has stepped referral fees (e.g. 8% if under $15, 15% if over). |
| Profit |
|
Find on AbeBooks | Direct link to AbeBooks. Blank if not a book or if ISBN not known. |
| Links |
|
Find on Alibaba Wholesale | Link that searches for the item title on Alibaba Wholesale. |
| Links |
|
See Amazon Page | Direct Link to the item on Amazon |
| Links |
|
Find on CamelCC | Direct Link to this item on CamelCamelCamel |
| Links |
|
Find Completed on Ebay | Completed (sold) listings only. |
| Links |
|
Find on Ebay | Link that searches for the item title on Ebay. |
| Links |
|
Find on Google | Link that searches for the item title on Google |
| Links |
|
Find on HKTDC | Link that searches for the item title on HKTDC. |
| Links |
|
Find on Keepa | Direct Link to this item on Keepa.com |
| Links |
|
Find on Made-In- China.com | Link that searches for the item title on made-in-china.com |
| Links |
|
Inventory 'How Many' | Direct Link to the offers page on Amazon. Shows 'How Many' Inventory if you have the Chrome Extension. See 'Recommended Tools' for a link. |
| Links |
|
BuyBox Seller Page | Direct Link to the BuyBox seller's Seller Page on Amazon |
| Links |
|
Find on Walmart | Direct link to AbeBooks. Blank if not a book or if ISBN not known. |
| Links |
|
Out of Stock? | True when there are no offers on this item, or if it can be determined that the BuyBox seller has no stock. |
| Other |
|
Is Add-on Item? | Whether or not any current offer is as an Add-on item. Up to the first 20 offers are checked. |
| Other | Historical Data |
Has Been Add-on Item? | Whether or not any current or (known) past offer is/has been as an Add-on item. |
| Other | Historical Data |
OOS % 0-30 days | Percentage of time for which Amazon as a seller was out of stock of this item between the past 0-30 days. |
| Other | Historical Data |
OOS % 0-90 days | Percentage of time for which Amazon as a seller was out of stock of this item between the past 0-90 days. |
| Other | Historical Data |
OOS % 90-180 days | Percentage of time for which Amazon as a seller was out of stock of this item between the past 90-180 days. |
| Other | Historical Data |
Blank | Blank column |
| Other |
|
Notes | Blank column for comments or note taking. |
| Other |
|
ASIN Score | ASIN Score |
| Other |
|