|
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.
- Click
the Hit Lists tab, left side of
main Inventory screen in
BookTrakker.
- Click
New. Name it. Click OK.
- Click
in the empty field under Search
Field, just to the right of the *.
- Select
Status from the dropdown list.
- Click
again in the empty field, just
below Status.
- Select
ISBN from the dropdown list.
- Over
on the right, under Search Type,
you will see Beginning of Field
(most likely)
- 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.
- Select
Hit List from the dropdown list
selector on the BASIN tab.
- 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 |
