Overview
CheckIt is a BookTrakker App used to make sure that your Amazon records are consistent in various ways with your BookTrakker Database. (Amazon records ONLY) Several tools are provided on the Control Panel to help manage and maintain your Amazon records including the ability to make sure your ASIN and ISBN numbers are accurate and up to date, your prices are consistent between the two and that there are no records on Amazon which do not exist in your BookTrakker database. 

To find records that have been updated or changed you can do a Hit list on Upload = Yes or a Range Type: Date, Date Modified, From/To with the current date.

IMPORTANT: You should upload any changes made to BookTrakker prior to using CheckIt to update Amazon records so you do not inadvertently lose changes that should be uploaded to all services.

CAVEAT: If you have books Sold or Pending on Amazon you need to make sure they are Sold or On Hold in BookTrakker before using CheckIt 
to update your database. Listings Sold or Pending on Amazon but not in BookTrakker may be relisted as For Sale on Amazon or even removed altogether.

Quick Use Guide if you are already familiar with what CheckIt does. 

This User Guide can be printed by selecting the text, copying it and pasting it into a word processor or you can open the file located in the BTPro folder (Typically C:\BTPro") with the filename "CheckIt User Guide.rtf" and print it from your word processor. To copy from the results screen select the Item or the row and use Ctrl-C to copy. You may need to click twice to complete the selection the first time you click in the grid.

Operation
All Amazon related operations involve submitting a request for an Open Listings Report (OLR) to be generated which can be downloaded shortly thereafter. The time it takes for the Amazon system to generate these reports can vary from seconds to minutes and depends entirely upon the load on the Amazon system at any given moment. It can take as long as 30 minutes in some cases for an OLR  to be generated so please be patient. All operations require an active Internet Connection; if you are a Dial-Up user please make sure you are connected prior to using CheckIt.

It is highly recommended that you perform an Upload of your Amazon records after each operation that involves changes to your Database. This will ensure that you do not have mix-ups which can occur when certain data is updated without performing an upload before continuing to update other information.

Automatic Operation
In each row of the main operational frame there is a checkbox for Automatic Operation. Checking this box for a given operation will cause it to happen every time you download the OLR without need for pressing the corresponding Manual button. Use this option with care; it is suggested you become familiar with the behavior of the system before using this option.

Choose a Service
Before you submit a Request for an OLR you must choose among the Amazon services you use. If you use only one Amazon service then this will automatically appear in the Choose Service dropdown, otherwise you may need to select the appropriate Amazon service before proceeding.

Submit Report Request
To submit a request for an OLR to be generated simply press the Request Report button. An OLR file will be requested which will reflect the current state of your Listings on Amazon. If you perform an upload with record modifications, deletes or adds after pressing this button and before downloading the OLR the OLR may not accurately reflect these changes so please make sure you do not upload any records until you download the OLR.

Download the OLR
Amazon will send an email with a subject line that says " Notification of Open Listings Report availability" when the report is available. It is recommended that you check your email to see if this message has arrived before downloading the report. To download the OLR simply click the Download Report button.

Update ASINs
This operation involves replacing incorrect ASINs and ISBNs in your Database with the correct ASINs and ISBNs from the Amazon OLR. To process ISBNs you need to check ISBN under Option. This may be required due to processes that occur on Amazon intended to consolidate identical books under a single ASIN or ISBN and will help you ensure that your listings are accurate. There is an option to Copy the old ASIN or ISBN to a field chosen from the dropdown list at the right of this row; use this option to preserve the original ASIN for future reference.

Do this before you click the Update ASINs button. Click into the field on the right side to select the destination.

Show Amz Recs not in BT
This operation will compare the records found in the OLR against those found in your BookTrakker database and will produce a list of records that are either listed on Amazon and not found in your BookTrakker Database, or records that are on Amazon but not Available in BookTrakker. This is useful for making sure that your Amazon listings do not contain books you do not have thus preventing customers from ordering books you cannot provide. This helps to prevent unnecessary refunds which can damage your Amazon ratings. You can Execute a Hit List on “Status | Not | Available” to find everything that is not Available. To reduce the size you can add in a Range Type below to reduce the count. Then do an Action, Upload, Execute, Confirm to set them for upload. Or just do a Purge Amazon, All Online Inventory; after selecting Amazon, then press the Process/Upload to Selected Service button.

WARNING: If you have different SKU's than you have on Amazon you may get a list of almost your entire database. Stop and contact support@booktrakker.com for help with this. You should not get more than a couple hundred results at any one time. 

Reconcile Amz Prices
This operation will compare the records found in the OLR against those found in your BookTrakker database and will produce a list of records that have a different price on Amazon from what is found in your BookTrakker Database. This is useful for making sure that your Amazon listings are priced correctly thus preventing customers from ordering books at a price different than you intended. This helps to prevent unnecessary refunds which can damage your Amazon ratings. You have the option of updating Amazon with the prices in BookTrakker or updating BookTrakker's prices if the Amazon prices are correct. Either choice will set the records for upload, with or without a price change. This upload will not be visible when you click Process and Upload Records as the prices only upload is not posted in the Export Log. This upload is done "behind the scenes" 

Check ASINs
This operation will compare the records found in the OLR against those found in your BookTrakker database and will produce a list of records that are not listed on Amazon but are marked for Amazon in your BookTrakker Database. You are then given the option of either setting these records for upload or clearing the ASIN or ISBN so you can relist as a matched or new Product Detail Page.

If you select Set Records for Upload when you close this form BookTrakker will upload a hard delete file to remove these records from your account, then set them for upload in your next upload operation. 

CAVEAT: This process will not fix restricted records that get this error: "There is a restriction in effect at the item level (because of Item-Level gatings on an offer)"

Fix Condition

Fix Condition only works after you have downloaded the OLR, and goes away once you have closed CheckIt. Click Fix Condition to replace the Condition on the Amazon tab with the actual Condition you have on Amazon. You should then run a Hit List for Upload = yes to find records that have changed, and verify if the change matches what you want. If not, click Edit Record, change Status to something other than Available or Sold, click Done, then upload. Once the upload has processed you can set back to Available and change the Condition on the Amazon tab. 

Check Missing
This is a free operation which will show any record numbers that are not in your database. This sometimes happens when there are holes in imported data or when a record got lost for some reason and can help track down the cause of such events. If you feel there are any missing records it is suggested you contact Support to see if there may be an identifiable cause which can be addressed so it can be prevented in the future.