Do you have incomplete listings or have you received warning notices from Amazon claiming you have items listed with incorrect ASIN? Perhaps you've sold a book only to find the customer expecting a different Title than what you have shelved. Or maybe you are finding items that are not repricing because the pricing data can not be found. Each of these situations is rooted in ASIN changes that Amazon does in its database to account for updates from Publishers.
Being sympathetic to the changes to ISBN/ASIN/UPCs and how they can affect your inventory listing, we created a report that you can run yourself to compare your inventory as AOB has it against what Amazon reports as having.
Inventory Comparison
- You will find this option on the Tools menu of your AoB account.
- Locate the link for Amazon Inventory Comparison at the bottom Useful Links section and click the link to start the process.
- Depending on the size of your inventory the process could take anywhere from an hour to a few hours. You will know it's still running by '[Inventory comparison running]' replacing the link on the Tools menu.
- Once the process is complete you will see the Comparison link in Tools has returned.
What this will do for you:
- It will compare your listings in AOB against what is listed on Amazon. This is limited to SKU and ISBN/ASIN/UPC for the comparison; quantity is not considered.
- Send a report to the email address you have listed in your AOB Personal Settings. The subject of the email will be [AOB] Amazon Inventory Comparison Report.
- The body of this email is broken into two main parts:
In the topmost portion of the body you will find a list similar to the following:
- <Your SKU here> had a mismatched ASIN, updating AOB's record (B000HNR99A) to Amz's record: 0870683551
- <Your SKU here> is not on Amazon
- <Your SKU here> is not on Amazon
- <Your SKU here> is not on Amazon
- The second portion of the email body will be a summary similar to the following example:
- 5113 are matched
- 1 had missing ASINs but that were filled in
- 2 had mismatched ASINs that were updated
- 16 are not listed on Amazon
- AOB will automatically update your items in the database with the correct ASIN, as reported by Amazon, to allow for successful future updates when these ASIN get merged.
Curious about those entries entered as 'not on Amazon'?
The Upload History in AoB is about to be your best friend. You can track uploads to your venues from your AoB account for a timeframe of typically about two weeks. To locate this page navigate to History > Uploads History > Show your past venue uploads and use the SKU to search your uploads and then be able to locate the Amazon Processing Report as described in our Help Center article discussing how to use the Venue Upload History.
If you can not find a recent upload for an item you can click the Update Listing button from the item's Listing Page to resend the item to your venue and you can then find the Processing Report on your next search of the Upload History. It's important to note that you should allow approximately an hour for Amazon to have the Processing Report ready to be viewed via our links.
Comments