3.0.X Migration Guide
Our latest version of Price Checker 2 (3.X.X) 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:
Go to https://www.dailysourcetools.com/price-checker/sp-api-authorization/
Login with email and password
Select your marketplace from dropdown menu e.g. ‘Amazon.com’ and click “Authorize”
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 |
|---|---|
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 |
AZ Product Description |
|
AZ Bullet Point 1-5 | |
AZ Bullet Points | |
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 |
|---|---|
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) |
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 |
|---|---|---|---|
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 |
|---|---|
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. |