CheckIt 1.2.202

If you set all Available records with no ISBN's or ASIN's to Marketplace for Amazon.com or something other than No UK for Amazon.co.uk or Amazon.ca (How-To) then the new CheckIt Book Loader will upload records to Amazon to match against  existing records if you also have Author, Title, Cover, Publisher and Date. If no match is found then a new product detail page will be created. For Cover to be included it must contain one of the following words (or part of a word) to be included, or, for non-book media, in Type:

If none of the above are present in Cover or Type then the record will not be included in an upload.  

If Author or Publisher or Date is missing the record will not be included in an upload. 

This upload system only allows for default Media Mail or optional International for Amazon.com. Expedite is not available. Purchase of CheckIt will allow you to update ASIN's or ISBN's so you can reupload with Expedite checked.

The upload filename that is created will be named AmazonUploadBL_1.txt for Amazon.com and AmazonUploadUKBL_.txt for Amazon.co.uk. After the upload is complete move your mouse over the Note field across from Amazon Upload Processed on the Export Log page, and wait a few seconds. A tool tip should appear giving you the full details of the upload. BookTrakker uploads an Inventory Loader file with ASIN's/ISBN's and a Book Loader file without, if any were set for upload.

This method will also manage New, Modified, On Hold or Sold records just like regular Amazon records that have ASIN's or ISBN's. If you want the ASIN or ISBN for these records you can use any of these three methods to get them:

1. Copy/Paste one by one from your Amazon Dealer Inventory into BookTrakker.
2. Use GrabIt's BASIN system to acquire the new ASIN's.
3. Purchase CheckIt.

There are new options available in the CheckIt control panel:

Edition, Illustrator, Image URL, Include ISBN and Upload Collectibles. These only apply to Book Loader uploads, for matching or creation of new product detail pages on Amazon. 

Checking Edition and/or Illustrator adds Edition or Illustrator to the Amazon Book Loader file for ASIN creation. Caveat: If either of these two boxes are checked when you do an Include ISBN or Collectibles upload, then the data you have must match Amazon's exactly to avoid a reject or create a new product detail page. 

Checking Include ISBN adds the ISBN to the file so you can create product detail pages with an ISBN that is not in Amazon's database. Include ISBN unchecks itself after the upload. We recommend that you do ISBN product detail page creation by itself, not with the upload of other records to Amazon. So do your upload to all services, then create the new records with an ISBN in BookTrakker, check Include ISBN in CheckIt, upload again to all services, just the new records to create new ISBN product detail pages on Amazon.

Image URL is available in CheckIt. For sellers approved to sell Collectibles on Amazon only. You can upload one image that includes a full URL in the ImgURL field on the Optional tab in BookTrakker. Image must be uploaded to your hosting site prior to the Amazon upload. Records must be set for Collectible on the Amazon tab. For this to work you check both Image URL and Upload Collectibles.

Upload Collectibles does just that. Any records set for upload that are also Collectible on the Amazon tab will be uploaded as a Book Loader file only, to include the ASIN or ISBN if present, as well as Author, Title, Publisher, Cover and Date, as well as Edition, Signed by and DJ information. As noted above, if your data does not match Amazon's data then one of two possible results will happen: The record is rejected or a new product detail page is created. You need to check Upload Collectibles for it to work.

For best operation you should do all uploads of records with ASIN's/ISBN's that exist on Amazon as well as records without ASIN's/ISBN's, then do an upload of records where you want to create product detail pages with a real ISBN. We may decide later to improve this depending on feedback from users.

CheckIt also adds in two new fields in the Book Loader file for Collectible books: Signed by and DJ. If the book is signed then Amazon will post that on the offer page. Ditto for DJ, according to the following fixed mapping: 

None = No Dust Jacket
AN, F+, F = Like New Dust Jacket
NF, VG+, VG, VG- = Very Good Dust Jacket
G+ and G = Good Dust Jacket
Fair and P = Acceptable Dust Jacket.  

When you do your first Amazon upload the Export Log Note will read something to the effect of:
Uploaded 0 New, 0 Modified, and X Sold/Removed, and 0 Repriced Records. Inventory Loader File Created. Total Records Exported: X; Uploaded 0 New, X Modified, and 0 Sold/Removed, Book Loader Upload File Created. Total Records Exported: X where X = the number of records. since X = X nothing has changed with respect to the number of listings on Amazon, other than you may have added more, depending on how many new records are created.

Because of the design of the AmazonUploader control before we added in the new Book Loader process Book Loader records will show up as Sold in the Inventory Loader file, but will not be processed as such on Amazon, since there is no ASIN or ISBN for Amazon to process.

WARNING: Be careful not to set ARC's or Proof copies to upload to Amazon if you are not approved for Collectible selling. If you are approved, ARC's or Proofs are only allowed if the book is out of print.

Here is a Hit List to find all records where ASIN and ISBN are blank, and no Advance Review copies. Repeat the Edition selection below the Advance Review Copy for Proof and any other items where you have ARC. (Some users have Advanced Reading Copy (ARC) that was imported from Homebase.) Make sure you check the Not column for the Edition exclusion selections. 

To set these records for upload to Amazon:

Click the Hit Lists tab on the left again. Click the Action tab, upper right. Click on Amazon on the left. Click the dropdown button under Amazon under the Action tab, upper right. Select Marketplace. (Amz UK Ship for UK. Set the choice in the Values field below) Check the Yes box. click Execute. Confirm. Upload to Amazon. This same procedure is used to set shipping options, such as Expedite or International.

Copyright © 1998-2009 BookTrakker.com. 
All company and product names may be Trademarks of their respective owners.