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 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 |
|