UploadIt can be found by clicking Online in BookTrakker, then clicking the
dropdown button to the right of Apps.
Click How Amazon processes Product Detail page attributes to understand what Amazon does with the information you supply in your upload files. More specifically, images.
Templates. Inventory Loader, Book Loader, Listing Loader. Found in the
Inventory Loader files include only the ASIN or ISBN, Price, Quantity, whether its an add or delete, the Amazon condition Category (Used, Collectible or New), the seller's SKU (Rec #), shipping information plus the seller's description, be it compiled or direct from the Item Note field on the Amazon tab. It does not include any bibliographical information so the listings go straight to the offer page represented by the ASIN or ISBN. Inventory Loader uploads generate the least number of errors.
The Book Loader file includes all of the above plus Author, Title, Publisher, Cover (Binding), and Date, as well as multiple Image fields. It can also include optional fields such as Edition and Illustrator. The Book Loader template is used for Collectibles and when you need to create a new product detail page on Amazon for an ISBN that does not exist on Amazon. It is also used for when you are uploading the main Product Detail page image. Most errors derive from the Book Loader uploads, when data you have does not match data that Amazon has.
The Listing Loader
files are used to add Images to existing Used Offers on Amazon. You must
have an ASIN or ISBN for Image URLs to be included in the upload file. (See
If you sell books that are published in or after 1973 that do not have an ISBN/EAN, please contact Amazon to request an exemption.
All check boxes are located in UploadIt which is accessed off the Apps button in the Online window in BookTrakker. The check boxes in UploadIt are:
Date has to be four digits. BookTrakker will extract a four digit date from the date field if four digits are present. It will select the last four digits. So if you have  1963 then 1963 is what is uploaded to Amazon.
Matching is based on an exact match. 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.
The upload filename that is created will be named AmazonUploadBL_1.txt for Amazon.com, AmazonUploadBLCA_1.txt for Canada and AmazonUploadUKBL_1.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.
How Amazon processes Product detail page attributes:
Amazon takes the data (for the most part) on a first provided, first displayed, basis. In other words, if there is already a listing for a product, but some attributes have never been provided, then whoever/whatever data they receive for those fields will almost always be added and reconciled on the page straight away.
Each attribute is looked at independently, so you might provide 10 attributes. If you’re not the featured seller and 8 were already present, then your two that are new will most likely go right through to the display page (the rest will be stored as your contribution for potential use down the road). An example of this would be adding Weight to the page where it isn't already present.
When you provide a product-ID (ASIN/ISBN) that matches one for an existing listing, your contributions don’t have to match those that Amazon has, but if they’re too far off, your submission may get kicked back with a ‘matching error’ because Amazon is concerned that your product may not actually be the same as the one that Amazon has for that ASIN or ISBN.
There are options available in the UploadIt control panel:
Edition, Illustrator, Image URL, Include
ISBN, Main Image URL, Upload Collectibles and Upload ASIN Weights. These only apply to Book Loader uploads, for matching or
creation of new product detail pages on Amazon.
We have added another file format to add images to New or Used items: Listing Loader. This enables you to add images to New or Used items on Amazon providing you have an Image URL in the ImgURL field and a Prefix URL in Tools > Options > Online in BookTrakker. You only need the one URL on the Optional tab, if you have additional images in the BTPro\Data\Images folder and they have been uploaded to your hosting site then UploadIt will create additional offer image URLs on the fly and include them in the upload file.
and/or Illustrator adds
Edition or Illustrator to the Amazon Book Loader file for ASIN creation.
Checking Edition will also enable Edition to be included in the
bullet display for Edition for Collectible listings. 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. Edition must match what
Amazon has on the Product Detail page, otherwise you will get a processing
If you just want to add images to Used listings then check Image URL only. The record must have an ASIN or ISBN to upload images for Used listings.
have your Image URL prefix in the Image URL Prefix field in Tools > Options
> Online then BookTrakker will create the Main Image and/or Main Offer Image URL in the ImgURL field
on the Optional tab when you scan in the image. You only need the one URL
on the Optional tab, if you have additional images in the BTPro\Data\Images
folder and they have been uploaded to your hosting site then UploadIt will
create additional offer image URLs on the fly and include them in the upload
"Error SKU '1234' appears to correspond to ASIN X, but some of the information submitted does not match the product information that is already in the Amazon catalog for that ASIN."
You need to correct the information in your record so it matches Amazon's data. Or delete the ASIN or ISBN to create a new product detail page. Amazon is very unforgiving!
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.
When you do your first Amazon upload the Export Log Note will read something to
the effect of:
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.
Upload ASIN Weights uploads the Weight field at the lower right corner of the Prices tab to update the weight on the product detail page if it doesn't already have a weight. It does this through the upload of the Book Loader template, providing that the Weight field is a positive number, larger than 0. Upload ASIN Weights is unchecked after each upload.
You need to make sure you have your Weight Unit selected in Tools > Option > Records.
It takes Amazon awhile to process the change to the product detail page. As long as 30 minutes depending on what time of day the upload is done, and how busy the day is.
WARNING: The downside to this feature is when the bibliographical data in Author, Title, Publisher, Date or Cover does not match the product detail page for the respective ISBN or ASIN. Amazon being Amazon you invariably will get a NEW page created with just your one listing offered, and the page you were trying to update does not get updated. You then have to go into your Inventory on Amazon find the new record, click the Actions link, then click Delete Product and Listing. This will delete the new product detail page. You have to wait at least 24 hours before reuploading the record from BookTrakker after making changes to the field(s) that differed from the original product detail page you wanted to update. You can always change them back once the page has been updated.
Explanation of Dust Jacket and Signed By:
Signed-By: Used for collectible books to indicate the contributor role of the book's autographer. This is a text field limited to 50 characters. Possible options are: author, illustrator, editor, photographer, other, etc. For more information on this field, see: Amazon Collectible Attributes. If anything other than Author, Illustrator, Editor, Photographer is in the Signed By field in BookTrakker then Signed By in the offer will be Other.
Dust-Jacket: Used for collectible books. This field requires a numeric value. These are your options:
0 = No Dust Jacket