3.0.X Migration Guide

Our latest version of Price Checker 2 (3.0.8) uses Amazon’s all new Selling Partner API.

As of 14th October 2022 Amazon have disabled the previous MWS API, so all users need to upgrade.

Due to significant differences, here are the highlights to be aware of:

Download

Installers are available at: https://www.dailysourcetools.com/price-checker/download/
Platforms: Windows x64, MacOS (Intel), MacOS (ARM/M1)
If exceptionally Windows x32 or Linux/Unix builds are required, please get in touch.

Marketplace Setup

The new API uses a different authorisation model. If you are upgrading from an older version of PC2 your account should be moved over seamlessly, however, if for any reason you do not see your usual marketplaces with a green tick mark, please follow these simple steps to get connected again:

  1. Go to https://www.dailysourcetools.com/price-checker/sp-api-authorization/

  2. Login with email and password

  3. Select your marketplace from dropdown menu e.g. ‘Amazon.com’ and click “Authorize

  4. Now inside Seller Central, check the box and click ‘Confirm’ button.

That’s it!

On returning to PC2 software you’ll now see green ticks for each market that you can access (inside Marketplace Setup in menu on left). Please don't forget to select “Refresh” if you had PC2 running while going through the above process.

** Repeat these steps for each separate selling region (North America or Europe) you require **

Your authorisation will be saved in the cloud and it is no longer necessary to pass your token to a VA or each machine. This will happen automatically once they log in with your account.

Speed considerations

  • Price Checker 2 version 3.X can run about twice as fast as version 2.X. There have also been several improvements so that historical data is no longer necessary for a number of relatively ‘basic’ data points (see below).

  • Hazmat and inbound eligibility checking is now accurate (matches Seller Central) and no longer produces obscure inventory entries.

  • Amazon sets API speed per user. This means that you may exceed these guideline speeds.

  • Multi-machine users: If you are using PC2 on more than one device, please be aware that the Amazon-enforced API restrictions mean that you continue to be unlikely to see any advantage when running multiple jobs on multiple machines, as they will end up competing with each other. This could lead to slower running than if you’d just use a single device. The exception is browser runs where extraction time could be slower than actual runtime.
    A suggested setup for such a situation is to run the browser extraction with only source columns on the one machine(s), then feed it to the other for actual analysis.

  • Care has been taken to time all API calls to optimise throughput, nevertheless we do recommend using the Filters menu to discard unsuitable or irrelevant items. This will avoid PC2 making unnecessary API calls during the run and will lead to even faster results.

Fees

Fees are specific to your selling account and provided directly by the Amazon API, which means that they will always be accurate as far as the reference offer is concerned, and they should always match the official Revenue Calculator.

Important: Amazon states that “The estimated fees returned by this API are not guaranteed. Actual fees may vary.”
As such, queries relating to actual fees not matching those returned by the API are best directed at Amazon directly.

Small and Light Fees

The Small and Light (S&L) program offers reduced fulfilment fees in certain markets based on certain eligibility criteria. While unfortunately the Amazon API does not allow us to check eligibility directly, Price Checker will indicate program ‘suitability’ by checking the price (reference offer) and dimensions against the documented criteria in each marketplace. This is indicated by a new column “Small & Light Suitable?”.

To get an S&L Fee estimate you need to select the new Small and Light option in your cost profile, found under “Costs (Prep, Ship, VAT)”, which will return S&L fees if the item is suitable as determined by the above, or regular FBA fees otherwise.

Please be aware that at this moment in time PC2 is unable to check criteria involving:

  • Category, Product or Content Restrictions

  • FBA prohibited products

  • Meltable/temperature sensitive FBA inventory products (such as chocolates)

As a result you may receive an S&L Fee in your results when in actual fact a product is ‘suitable’ but not actually eligible.

Please check the product against the full set of documented eligibility criteria in the selected marketplace before shipping in. You may then prefer to run the ASIN through PC2 again using a standard FBA cost profile.

Historical Data no longer required

The following data points will no longer require historical data:

Column

Notes

Column

Notes

Date First Listed

 

Amazon EAN

 

Amazon UPC

 

Amazon Sells At

 

Amazon is a seller

 

BuyBox Seller

 

BuyBox Seller Type

AM only shows for Amazon, not for Warehouse deals. Use historical data or enable Used Offer retrieval (always on at the moment) to catch cases where Amazon Warehouse is selling, but Amazon is not.

e.g. Amazon.com B07GJBBGHG - the Amazon Warehouse Seller ID is A2L77EE7U53NWQ

AZ Product Description

 

AZ Bullet Point 1-5

See Changes to Individual Columns

AZ Bullet Points

See Changes to Individual Columns

Number of Sellers within 2% of BB

 

Number of Images

Please note that due to an API issue not all images may actually be counted. We have reported this to Amazon and expect it to be resolved in a future release of their API.

FBA Seller List

 

Columns and situations that still require historical data:

  • Inactive/Redirects?

  • Amazon Ever A Seller?

  • Is Add-on Item?

  • Has Been Add-on Item?

  • Average Price ...

  • Average Rank ...

  • OOS% ...

  • Avg Review Score (unless ‘Get Variation Reviews’ is selected)

  • Total No# of Reviews (unless ‘Get Variation Reviews’ is selected)

  • Any custom historical data columns

  • If your cost calculation or sales estimates are dependent on historical averages

Changes to individual columns

Column

Notes

Column

Notes

Product Group

The capitalisation may differ from what you may be used to from previous versions of PC2.

AZ Feature 1-5

Renamed AZ Bullet Point 1-5 (e.g. AZ Bullet Point 1)
There are bullet point columns 1 through 5, however, as the API is flexible on the number of supported bullets (With some test items having 8 or more), an additional column, AZ Bullet Points, will contain the data of all bullet points in a single field. This is formatted as a list with each bullet point separated by a single new line character (\n).

Product Type Name

Renamed Product Type

AMZ Multi Pack Qty

If not available will now fall back to using “Number of Items” (or otherwise 1 as before).

Image

Renamed Main Image

No# of sellers

Renamed No# of New sellers to clarify that this is for NEW condition only.

Shipment Restrictions

Moved into the new Eligibility group label

If there are multiple restrictions, these will be presented as a newline ('\n') separated list, i.e. one reason code per line.

Please see https://developer-docs.amazon.com/sp-api/docs/fbainboundeligibility-api-v1-reference#ineligibilityreasonlist for currently documented reason codes.

This column no longer shows information regarding gating or overstocked items. See the new column “Inbound Guidance” instead.

Hazmat disclaimer no longer needs to be checked and has been removed.

Hazmat

Renamed Is Hazmat (as of 3.0.8)

Moved into the new Eligibility group label

Hazmat disclaimer no longer needs to be checked and has been removed.

Amazon Required Prep

Moved to FBA group label as of version 3.0.3

New Columns

Column

ID

Description

Considerations

Column

ID

Description

Considerations

Discard Reason

998

The reason/name of the filter which caused this item to be discarded.

Adding this column will cause discarded/filtered items to remain in the output. This doesn’t affect speed.

Remove this column to cause discarded items to be removed completely.

Diagnostics

999

Displays a list of item specific events and/or errors to aid with debugging.

This may contain a lot of information and therefore dramatically increase the size of your file. We recommend use only when advised by support.

All Attributes (JSON)

1999

All attributes in JSON format, exactly as returned by the API.

Please note that this field can be very large in Excel.

This may be best used for debugging, if you intend to post-process this data programmatically, or to help suggest the addition of another directly accessible column for an attribute that you use.

AZ Bullet Points

720

All Amazon bullet points as a newline ('\n') separated list (i.e. the contents of one bullet point per line).

 

Inbound Guidance

143

Returns Amazon's reason(s) when inbound shipment is not recommended.

Examples include overstocked/slow moving items.

Returns 'InboundNotRecommended' if no reason given, or blank if inbound shipment is ok.

 

Small & Light Suitable?

144

True/false - Whether or not this item is Small and Light suitable.

Please note that this examines dimensions, price, hazmat and adult. It doesn’t account for any other criteria, such as goods that are restricted, FBA prohibited, temperature sensitive, etc.

Please check Seller Central for full eligibility criteria in your marketplace.

See “Small and Light Fees” above

Listing Restrictions

145

Blank if no restrictions.

If there are restrictions, displays the reason(s) for the restriction(s) as a new-line ('\n') separated list (i.e. one reason per line).

 

Hazmat Prevents Shipment

146

True if FBA shipment is not accepted due to the item’s hazmat status. For example if the item is currently under Hazmat review.

 

Prep Guidance

95

Item preparation instructions:

NoAdditionalPrepRequired - no additional prep beyond any applicable labelling.

SeePrepInstructionsList - refer to 'Amazon Required Prep' column.

ConsultHelpDocuments - Amazon may need to evaluate the item first.

 

Barcode Instructions

96

Barcode labelling instruction - one of:

RequiresFNSKULabel, CanUseOriginalBarcode.

MustProvideSellerSKU means that Amazon is unable to return labelling requirements.

 

Other changes

  • PC2 will no longer add products to your FBA inventory list when checking for Shipment Restrictions, so the Hazmat disclaimer no longer applies. It and the “FBA Item Archiver” Tool have been removed.

Known Issues

Version

Notes

Version

Notes

3.0.X (all)

Due to extensive remapping at Amazon’s end some of the Additional Attributes (column IDs 2000-2066) might not return a value. Please report issues with these columns with a particular ASIN so that they can be individually addressed.

The best way to do so is to add the “All Attributes (JSON)” column.