Data / Columns
- Thomas Timbul
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 Colour Highlights , 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 Using multiple Sheets
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 |
|