< < BACK
Home

       Help Resource Center

Support Contact Us Company Polls and Surveys
 
Amazon Bulk Listing Instructions 

 Set Print margins to .25 inches for best printing results.  
Tutorial or scroll down                 
 Index

WARNING!  If you use this method to add or match listings to Amazon for new records 
then you also have to upload Sold records via a UIEE file through the website. 
BookTrakker MUST have the ASIN or ISBN in the record with either Marketplace  
checked for Amazon.com or a shipping choice for Amazon.ca or Amazon.co.uk 
other than No CA or No UK for BookTrakker to be able to update the record via the 
OneClick upload, direct to Amazon.

Adding New Books to the Amazon.com  or Amazon.co.uk Catalog

From the Amazon Information Page. 

Amazon.com's Bookloader enables the bulk listing of books for sale. The Bookloader will create a 
new product detail page if none exists. For example, you can now use the Bookloader to create 
product detail pages for books that do not have ISBNs.

If you provide enough data in the upload file 
(author, title, publisher, place and date of publication, edition and binding type etc.)
,
Bookloader will create a new product page automatically. If the system does not have enough information
to create a new page, you will receive an error message in the error report following your upload.

This version creates books directly in the Amazon catalog and displays the seller's listing in 
Marketplace automatically.

There is no new report that will notify you of new ASINs created. The ASIN will be listed in your 
open listings report after a page is created, but you should not need to upload your items with 
ASINs (unless there is a matching conflict).

Although your new detail pages will be searchable by ASIN within a few minutes after the pages 
were created, they won't show up in search results right away. It can take 1-4 days for pages to be
searchable on our web site.

Amazon REQUIRES that there be content in author, title, publisher, place and date of publication,
edition and cover in order to create a new listing page. Amazon further requires that date be four
digits only, any listings from BookTrakker with more information will be rejected. 

Cover is limited to Hardcover, Paperback, Spiral-Bound, Leather Bound, Pamphlet, 
Ring-Bound, Board book, Comic, Hardcover Comic or Map. Any other terms used will be 
cause for rejection. 

Because of these requirements you will need to upload any changed records, then close
BookTrakker/GrabIt, then Backup your database before creating the Hit Lists for creation 
of new listings on Amazon. You may need to make global changes to your data to make it 
compatible with Amazon. For instance, if you used Softcover in Cover then you will need to 
change this to Paperback. When you are done with the file creation process you can 
restore from your last Backup file to return to your original database.

Start out by creating a new Hit List named Amazon Bulk Master. Click the Hit Lists tab on the 
left side of the Inventory screen in BookTrakker. Click New, name it Amazon Bulk. Click OK. 
Set up your Hit List to look like this:
Note that the Not column is checked for both Author and Publisher. This creates a Hit List of All Available
records where the ISBN field is blank, but neither the Author or Publisher field is blank.
For the moment we cannot do anything about date, so any records with N.D. or extra
characters will be rejected. (This will be remedied in the next update.)

Next, you need to verify Cover, and if necessary, make changes to Cover so Amazon will process into
new listings.

Click into the Hit List, below Publisher, and add Cover, and select Hardcover under Search Criteria:
 
Click Execute. Verify results. Click the Hit List tab left side. Click the Action tab, upper right:
Click on Status over on the left side, inside the Action frame:
Click Execute. Confirm. Doing this will set your records for Upload.
Repeat as necessary to get all records that qualify for Amazon listing creation. You do this by going 
back to the Hit List definition and changing the Cover from Hardcover to Softcover, etc. 

If you used Paperback for Paperbacks and Softcovers then change the Hardcover search term in 
the Hit List to Paperback, and repeat the process.
To change Cover to a term Amazon will accept, find the Cover records that do not qualify, and change 
to what is acceptable to Amazon. For instance, if you used Softcover for most oversized Paperbacks, 
then create the Hit List for Softcovers, then modify the Cover field to Paperback. Instead of doing 
Status you would select Change, then Change Softcover to Paperback:
Click Execute. Click Confirm. List View will be blank after you Confirm, since the original Search Criteria 
will no longer match.  Repeat as necessary for such terms as Stapled Wraps, etc., until all possible records 
are changed to match the Amazon requirements for Cover (Binding)
If you used a lot of extra characters in Date, such as c. 1965 or ca 1965 then these records will not qualify 
for Amazon BASIN matching or creation of new records on their system. To fix this you will need to take 
advantage of the extracted Date field in BookTrakker, which contains only a four digit date, derived from 
the last four digits in the DataAlpha field, which is what you see for Date on the Inventory  Detail View.
Decide on which Optional field you want to use, or a field you are not otherwise using. for purposes of 
this tutorial, I will use Optional field 1 for the instructions. You can substitute any other field you are not 
currently using for Field 1.  

If you are using 2.0 or 2.1 then none of the Optional Fields are available for upload. You will have to use 
one that is. You can check File > Export > UIEE/Online > Map Export Fields, to see what is available 
for upload. Click on the DateAlpha selection, click the dropdown button, and scroll through the list of 
available fields to see if there is one you are not using. I believe Source, Shelved and Spine are available
for upload. 
Using a Hit List of Status = Available, do an Action Hit List of Copy, Copy From: Date, Copy To: Field 1. 
Click Execute, Confirm. 

To get the Date from Field 1 to show up in the Amazon UIEE upload file you need to change
the Export Mapping. 

File > Export > UIEE/Online > Map Export Fields: 
From:

Click into the DateAlpha field, a dropdown button will appear, click that, and select the field you want:

To:



Click the X in the upper right to close the for, do the same for the form underneath.

DO NOT FORGET TO RESET BACK TO DateAlpha AFTER YOU DO YOUR EXPORT.

When you are done with the hit List changes, and you want to see what records will be uploaded to Amazon 
for possible listing creation, do a New Hit List where Search Field = Upload, then Execute. 
When you are done with the hit List changes, and you want to see what records will be uploaded to Amazon 
for possible listing creation, do a New Hit List where Search Field = Upload, then Execute. 
If you use a different Price for Amazon then you need to select that price for the next step, unless you have
a UIEE upload file setup that uses your Amazon price, in which case you can use that file. If not, then do
File > Export > UIEE > Export Setup and select the Price you will use for Amazon for the top row, which
has the default Upload_1.txt file. (Do not forget to change it back when you have created the file for Amazon 
Bulk Creation of listings)
To create the file for Amazon, in UIEE format, do the following:

1. File > Export > UIEE
2. Click Start.
3. Wait for the yellow bar to go across.
4. Click Close when finished.

The UIEE upload file Upload_1.txt, or similar, will be found in the C:\BTPro\Transfer folder.

You might want to review the UIEE instructions for uploading to Amazon.

To upload to Amazon.com for creating new pages, go to AmazonUpload

For Amazon.co.uk sellers you will want to go to the AmazonUkUpload page.

Amazon.com sellers: Follow instructions. When you click the Browse button to find your Upload 
file, it will be located in the Transfer folder under BTPro on the C drive, or whatever drive you 
have BookTrakker installed on. If you have it it Program Files then navigate to the BTPro\Transfer 
folder for the file to upload.

Amazon.co.uk sellers will need to click the Type of file dropdown and select UIEE, then click the Browse 
button to find your Upload file, it will be located in the Transfer folder under BTPro on the C drive, or 
whatever drive you have BookTrakker installed on. If you have it it Program Files then navigate to 
the BTPro\Transfer folder for the file to upload. You want Upload_1.txt if you are only using one price for 
all services.

Amazon will take up to four days to process the file.
UPDATING THESE RECORDS:

Listings on Amazon will be subject to the UIEE format rules. Used only, no control over Expedite 
or International. To update these records you must use this method going forward. OneClick uploads
will no longer work, Amazon changed the rules.

Don't I need the ASIN to make edits to my listings?

You can use the SKU to make edits to your listings in future uploads. You won't need to use the ASINs 
associated with your items. The applies only if you upload through the website via a UIEE file.

CAVEAT for using GrabIt to retrieve new BASIN's. We have only had limited success matching 
data in BookTrakker to the new BASIN listings on Amazon, to export back into BookTrakker.  If 
you do decide to use GrabIt to retrieve the new BASIN's, you will have to start out using the default 
conservative settings, then loosen them up to get all possible results. This may include allowing noise 
words in the search, or reducing the number of words to search on. 


Processing
a BookTrakker Hit List to Match Amazon for BASINís

A. Create a Hit List in BookTrakker. 

  1. Click the Hit Lists tab, left side of main Inventory screen in BookTrakker.
  2. Click New. Name it. Click OK.
  3. Click in the empty field under Search Field, just to the right of the *.
  4. Select Status from the dropdown list.
  5. Click again in the empty field, just below Status.
  6. Select ISBN from the dropdown list.
  7. Over on the right, under Search Type, you will see Beginning of Field (most likely)
  8. Change to Entire Field if it doesnít already have that selected.

You should end up with your Hit List setup looking like this:

Do NOT, under any circumstances, click into the Search Criteria field for ISBN, this will invalidate 
the setup, and you will have to do it over. 

You should end up with all Available records that do not have content in the ISBN field. 

If you want further Search Criteria, such as Cover, then select them before running the Hit List. 

Click the Execute button in BookTrakker to confirm your selection and make sure the records in List 
View are the ones you want. If so, click the red Hit List button at the top to return to Inventory:

B. Select this Hit List in GrabIt!, and process for ASINís. For our example, we have Export Single 
Results unchecked, so nothing will be exported to BookTrakker. 

  1. Select Hit List from the dropdown list selector on the BASIN tab.
  2. Do your setup for matching. For your first pass we would advise the following, which are the 
    defaults that ship with GrabIt!: 

    Word Count: Author, 2; Title, 5; Publisher, 2.  

    Matching: All three boxes checked:

    3. Click Get BT Records button. 

GrabIt! will retrieve all records without ISBNís that match Hardcover from BookTrakker, then parse 
out of Author/Title/Publisher all the words, left to right, up to the number specified in Word Count, 
minus the Words To Exclude. It will then report the number of results with a message box.

Click OK to continue. 

  4. Click Get Amazon Data button 

GrabIt! will connect to the Amazon database and retrieve all listings that match the Author/Title
combination from BookTrakker, subject to the Max Results Limit, and populate the pre-match 
database in GrabIt!.  For the setup above, if you have Export Single Records checked, GrabIt! will 
match your Publisher, Date and Binding data against all the records retrieved from Amazon. If a 
single result can be obtained by this process then GrabIt! will transfer the ASIN into the ISBN field 
in BookTrakker, then delete all input and results from the search for that record, then move onto the 
next one. 

If no single match can be generated from the  input data and criteria, then GrabIt! displays all the 
results into the Biblio Results table in the middle section, for further processing. 

At the end of this process GrabIt! reports the number of ASINís exported to BookTrakker.

For the records that resulted in multiple possible matches, you can see these in the Biblio list in the 
middle section. 

To process, do the following:

Select the first record in the Biblio input list at the top. In the middle section you will see all the 
records retrieved from Amazon that match the input but did not produce a single record for export 
back into BookTrakker.
To the left of each Result is a dark blue button under the Amz header:
Clicking this button will open up a small Amazon web page for this specific ASIN. To view the page 
full screen, or to enlarge it, either click on the square button at the upper right, or grab an the lower 
right corner and drag to a larger view:
Once you have the page the size you want, as long as you continue within this session of GrabIt! 
the Amazon window will remain at the size you set it at. If you maximize to full screen you need to 
click on GrabIt! in the task bar below to return to GrabIt!.
If you can decide which listing matches your book, click the green Add button. If you need 
further details from your BookTrakker database, the Details tab below will display the List View field 
at the bottom of List View in BookTrakker, which you can modify if there is not enough information
displayed:
 
In the above example, the second listing on the Biblio tab matches the book in BookTrakker, so we 
would click the green button to the left of the second listing:

This adds the ASIN to the ISBN field in BookTrakker for the respective record number, then deletes 
the input and output associated with this record, and moves onto the next result.

If none of the records from Amazon match what you have in BookTrakker, and you want to delete 
them, then click the red Del button to the immediate left of the input listing at the top:

Click the red button:
After you have transferred all ASIN's or BASIN's to BookTrakker you are going to want to know 
which records got them, whether Exported as Single Results or manually transferred.

Click the Hit List tab on the left side of BookTrakker when in Detail View. Click New. Name it A 
Upload. Click OK. Under Search field select Upload. Click Execute. You will get a list of all records 
set for upload, which will include all records you just added ASIN's or BASIN's to.

When you need to know which records got ASIN's or BASIN's again, just select the "A Upload" 
Hit List and click Execute. The list will empty every time you do an upload.

 
Doing a Manual search on Amazon for ASINís using GrabIt!

You can also do searches using Author/Title records that are typed in, rather than being derived 
from the BookTrakker database. The main difference between manual and automated ASIN 
matching is there are no matches taking place that are derived from BookTrakker data. Therefore, 
all you can do is perform a search on Amazon using GrabIt! to isolate the correct ASIN, then when 
you select your choice it feeds into the ASIN/ISBN lookup process to retrieve all of the available 
data associated with the ASIN. 

Data entry for ASIN Author/title search is done on the upper Biblio tab:
For manual searching Publisher, PubDate and Binding are not used. You can type in Publisher 
and PubDate for reference. Binding is unavailable. After typing in data:

You have two methods to acquire data: 

1. The green button on the left of each data entry row.

2. Click Get Amazon Data button on the BASIN tab. 

Either one will end up with the same results:

Export Single Results does not operate in manual lookup mode, there is no corresponding 
record in BookTrakker to export to. Nor does the Publisher or Date get used in input, this 
information is strictly for your own benefit to compare Results to input. Binding is not 
accessible at all. 

Click the Green Add button to the left of the result that matches your book to add the ASIN 
to the ASIN/ISBN lookup tab for further processing. Unlike automatic mode, GrabIt! does not 
delete the results when you click the Add button.   

When you click the Add button, notice the Book ID field on the Biblio tab at the top, it records 
the new Record Number in BookTrakker that will correspond to the BASIN you just added to 
the ASIN/ISBN lookup table.

For all operations, if you want to see Amazon results on their website, click the Blue Amz button, 
then click the maximize button upper right corner to make the Amazon website full screen. 

Once you are done with Author/Title lookup and have collected all ASINís for your session, go to 
ASIN/
ISBN lookup to finish the process. (Search tab.) You will need to click the Get ASIN/ISBN 
Data button, wait for GrabIt to retrieve the data from Amazon, then click Transfer to BookTrakker 
when the download is complete. Read the Help on
ASIN/ISBN lookup for more information on 
setting output for data lookup.

Index

Privacy   |     Support    |     Testimonials    |     Contact Us     |     Company     

Copyright © 1998-2016 BookTrakker.com.   All company and product names may be Trademarks of their respective owners. 
Last Modified:  March 28, 2013