/
Data / Columns

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

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.
Inventory items will be created - requires the disclaimer to be accepted under 'Analysis Options'.

 

Core Attributes

 

Image

Small image url

 

Core Attributes

 

Shipment Restrictions

True if adding to an FBA shipment plan throws an error.
Examples include gating, hazmat, or overstocked 'non-essential' items.
Inventory items will be created - requires the disclaimer to be accepted under 'Analysis Options'.

 

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