|
|
If you are having problems
uploading to Amazon using 3.1, 3.2 or 3.3 you may want
to update to the current version, 3.4.930. Help >
Check for Updates.
|
| |
To
change settings on the Amazon tab for Amazon.ca and
Amazon.co.uk go Here,
then return to this page for upload instructions. |
|
|
1.
Set up new Amazon service REQUIRES
AMAZON EMAIL ADDRESS
2.
Set Amazon Field Mapping
3.
Set upload options
4.
Uploading to Amazon
5.
Upload failure
6.
Checking your upload status
7. Purge/Replace
|
|
|
Setting up a new
service for Amazon using the Online
Service Wizard.
|
|
|
Click the Online button
at the top of your screen:
|
|
|
|
|
|
Click the New Service
button at the bottom left of your
screen:
|
|
|
|
|
|
The Online Service
Wizard form will appear. You want to
click the dropdown
button on the
upper right for the new service:
|
|
|
|
|
|
Notice
there are five choices for Amazon.
1.
Amazon US MP is Amazon.com Marketplace
2. Amazon US SC is Amazon.com Seller Central
3. Amazon.ca MP is Amazon Canada Marketplace
4. Amazon.co.uk is Amazon UK Marketplace
5. Amazon.co.uk is Amazon UK Seller Central
You
have to ask Amazon.com or Amazon.co.uk to migrate you to Seller
Central
if you wish to sell on Seller Central directly. They are very
different platforms.
Everyone is going to be migrated eventually, so the only difference
from the
seller's perspective is which user interface do they see for the
dealer page.
|
|
|
Place your cursor over
the Amazon selection:
|
|
|
|
|
|
Left Click once. You
should get:
|
|
|
This
method applies for whatever Amazon selection you choose to use,
or
even if you setup multiple Amazon accounts.
|
|
|
Amazon uses a fixed URL
that cannot be changed by the user,
thus the field
for this, which is
visible for the other services,
disappears when Amazon is
selected.
Click the Next button, lower right
corner:
|
|
|
|
|
|
You
MUST use your email address and
password combination you use to
login
to your Amazon Account pages. You
type the email address into the
top
field and your password into the
bottom field, exactly as you do to
login to Amazon. Click Finish when
you are done.
Amazon is NOT an FTP service like the
other sites, thus you cannot test the
setup.
If you see the Test button
then click the <<Back button,
reselect Amazon from
the dropdown
list, click Next, fill in your Amazon
Email and Password, and click
Finish.
After
you click the Finish button you will
see Amazon appear in the
Online
Services table below:
|
|
|
|
|
|
To set Amazon as an
Active service, place your cursor
over the check box in the
Active
column, and left click once to
activate the service.
|
| |
|
|
|
Amazon
Field Mapping
|
|
|
Next,
you need to set up the Export Field
Mapping for Marketplace. Default
Mapping is supplied
with 3.4. Click the Inventory button at the top
of your
screen:
|
|
|
|
|
|
Click
on File at the upper left, then
Export, followed by Amazon Field
Mapping:
|
|
|
|
|
|
To get this:
|
|
|
|
|
|
This dialog box allows
the user to set up Field Mapping to
map various Inventory
Fields into the
Amazon Item Note Field (Seller's Comments) in the Amazon
upload file, AmazonUpload_1.txt. (AmazonUploadCA_1.txt
for Canada and
AmazonUploadUK_1.txt for the UK)
If you use the Item-Note field on the
Amazon tab for this purpose then
BookTrakker
ignores the Amazon field
Mapping and gets the Item-Note
content
(Seller's Comments) for the upload file from the
Item-Note field on the Amazon tab.
Most users who have imported from
either an Amazon Open Listings Report
or Seller
Engine will start out using
the default Item-Note field on the
Amazon tab, you only
need the Amazon
Field Mapping if you use the other
fields in BookTrakker, and do
not
update the Item-Note field on the
Amazon tab for new listings. This is
NOT
automatic on manual data entry.
A variety of fields may be mapped for
concatenation into the Amazon
Item-Note field
in the Amazon upload file by
clicking on the dropdown arrow at the
right of the column
in the grid.
To delete a field from the mapping
simply click on the gray square on
the left of the
row to be deleted and
press the 'Delete' key on the
keyboard.
The Field Separator provides a Text
Box to indicate what character
should be inserted between fields.
|
|
|
To set your Field Order
for Marketplace listings do the
following:
|
|
|
|
|
|
Select the first field
you want to add into the Item-Note
field in the upload file,
followed by
the next, and the next, and so on. An
example of a finished field
mapping
is:
|
|
|
|
|
|
NOTE:
Amazon increased the Comments to 1000
characters, which for most users
probably means you can use any or all
of the larger description fields, as
well as
additional fields. A
suggested order might be: Place,
Publisher, Date, Edition,
Printing,
Size, Cover, Type, Book, DJ, Defects,
Features. As long as the combination
does not exceed 1000 characters then
all of the information will be
included in
Comments on Marketplace.
The purpose of Amazon Field Mapping
for Marketplace is to provide the
buyer with a description of the book
you are listing. So you want to
restrict what you put in here to
descriptive fields ONLY. You do not
need Author, Title, Subtitle, Status,
ISBN or Price. Amazon supplies the
first five, and Price is uploaded
separately.
If you want to use
Item-Note instead, you can. You
want to confine your selection to
that which will fit into 1000 characters and include what you
consider most important
from the
viewpoint of a potential buyer.
Condition should be included, but NOT
from the Amazon Condition field on
the Amazon tab, this is uploaded
separately by BookTrakker.
Amazon will clip off from the end of
this field any characters exceeding
their 1000
character limit for
Marketplace. You have to decide what
field is least important to
you and
make that the last field. Keep in
mind that you are limited to 1000
characters; so do not add in all of
the available fields, since most will
not be utilized
by Amazon.
|
| |
|
|
|
Amazon
Defaults in
Options
|
|
|
Click on Tools >
Options:
|
|
|
|
|
|
To bring up the Options
form:
|
|
|
|
|
|
Options are where you
set many of the defaults for
operations in BookTrakker.
Click on
the Pricing tab at the top to bring up
the Pricing tab, then look in the
middle of the form for the Amazon
Price field dropdown lists. There are three
choices, one each for each Amazon service. Click the
dropdown button to select
which price field
to upload to each Amazon service. (If you only upload to one
then select for that one only. If you upload to more than one then
you can
select a different price field for the second or third choice,
which allows you to
use a different price because of currency differences or postage remuneration.
We set the Retail field for default, since most
users will use the Retail price for
Amazon listings, either by design or
because this is the field used when
importing from an Open Listings Report or Seller Engine.
|
|
|
|
|
|
Click the OK at the
bottom, click Yes to close
BookTrakker. Restart BookTrakker.
|
| |
|
|
|
Uploading
Your Book Records to Amazon
|
|
|
What should happen with
a successful upload to Amazon and/or
other services:
|
|
|
1. Click Online button
2. Click Process and Upload Records
button.
3. Loading Amazon Upload Engine box appears.
4. Exporting Amazon Records box appears, Amazon Upload file(s) are created.
5. Uploading to Amazon box appears, upload
goes through.
6. Export form appears, yellow bar
moves across bottom of form.
7. Process ends, unless you have
other active services, in which case:
8. BookTrakker connects to each
service, uploads the file for that
service,
verifies success, and moves
on to the next service.
9. When the upload is done BookTrakker takes you the the Export Log
screen
so you can check the success of your uploads.
|
|
|
1. Click on the Online
button at the top of your screen:
|
|
|
|
|
|
2. Over on the right,
center, you will see a large,
turquoise green button:
|
|
|
|
|
|
Below this button is a
list
of Upload Options followed by
check boxes. For your
first upload
using the OneClick upload system
you should place a check in
the top
option, All Online Inventory, then
click the Process and Upload Records
button. (This presumes that you have
your Amazon services set up and
checked
as Active in the table below
and to the left)
You may want to also check the
Purge/Replace Amazon check box, as
your records
out of BookTrakker may
have different record numbers then
what you have on
Amazon, and may also be in a different format.
Both of these choices are done just
once, in the future you need on click
the
Process and Upload Records button
without checking any of the boxes,
BookTrakker
will "know"
which records to upload.
|
|
|
|
|
|
3. After you click the
Process and Upload Records button the Loading Amazon
Upload Engine file box will
appear, followed by another box
indicating that
BookTrakker is exporting your records to the Amazon upload file:
|
|
|
|
|
|
4. Followed by:
|
|
|
|
|
|
This usually takes a
lot less time than creating the
upload file; there is less work
to
do. But sometimes it seems like it is
going to take forever, especially if
you
already did an upload and want to
follow with another. Uploading
directly to Amazon
using HTTP has
limitations:
1. Bandwidth - sometimes a lot of
booksellers are all uploading at the
same time,
so your upload may not get
through.
2. Repeating or doing another upload
on the heels of the first upload -
Amazon
does not seem to like this.
3. Internet errors between
BookTrakker and Amazon.
With experience gained through
uploading to Amazon you will get a
pretty clear
idea of how long any
given upload should take, and if it
seems like it isn't working,
then it
probably isn't.
If you think the upload is not going
to go through then click the Cancel
Upload button:
|
|
|
|
|
|
Like so:
|
|
|
|
|
|
And
the upload process to Amazon will be
aborted. It probably would not have
worked anyway, this saves you time
waiting and waiting. You will have to
test this by trial and
error, all
systems are different, and uploads
depend not only on what processor and
memory you have but connection speed
as well.
|
|
|
5. After you either
allow an upload to finish or you
cancel, the Exporting Records form
appears:
|
|
|
|
|
|
This is the actual
process that clears out your database
of records to be uploaded during
this
upload session. The Amazon file has
already been created.
After this form goes away BookTrakker
will proceed to upload to any other
services you list on, one after the
other, until you get a completion
message in the middle window on the
Online page:
|
|
|
|
|
|
If your upload was
successful you can verify this by
clicking on the Export Log tab along
the left side of your screen:
|
|
|
|
|
|
The first line says you
started the Amazon upload process,
followed by confirmation of the
Amazon upload. Then BookTrakker began
the upload process for other services
you might be listing on, in this case
ABE and MyOwnBookshop.com. First, the
current records in the inventory
database are exported into the UIEE
upload file, (the same records that
were uploaded to Amazon) then
BookTrakker connected and uploaded to
each service in succession, verifying
that the upload was successful each
time.
|
|
|
Amazon
Upload Failure
|
|
|
If the Amazon upload
failed and you do not have BookTrakker Version 3.3 or later then you will need to upload
the AmazonUpload.txt file found in
C:\BTPro\Transfer folder through the
Amazon Upload
page.
If you are using 3.3 or later then select the Amazon service:
Then
click the Manual Transfer to Selected Service button if you use 3.3
or Reupload File to Selected Service button above if you have 3.4. The
Loading Amazon Upload Engine will reappear, followed by Uploading
to Amazon. With 3.3 it will open up the website so you can upload
direct to Amazon, as per the instructions.
If you decide to upload through the Amazon website from your dealer
account then make sure you select Inventory Loader format.
|
|
|
|
|
|
Verifying
Your Amazon Upload Results
|
|
|
If your upload to Amazon through
BookTrakker was successful, then you
need to connect to your Amazon
account to confirm your upload
success, or click on the Browser
button in BookTrakker:
|
|
|
|
|
|
Then click on the a to
bring up the
Amazon upload page, after you login.
This may take a few moments, but once
you do get to the Amazon Upload
Results page you select the file you
want to view or download for further
analysis:
|
|
|
|
|
|
To find out what the Amazon Error messages
mean, please go here.
|
| |
|
|
|
Amazon Purge/Replace using BookTrakker
3.4
|
| |
WARNING!
If you have created new pages on Amazon via the
Create a new product page system, or by bulk uploads
of UIEE data then check All Online Inventory on the
Online page in BookTrakker, select Amazon in your
list of services, then click Process/Upload to
Selected Service. If you have 3.3 or earlier you
have to uncheck as Active all of your other
services, then click the Process and Upload Records
button.
If you have not created new pages on Amazon then
follow these instructions:
Since the usual
Purge/Replace often fails on Amazon you need to do
it by doing the Purge followed by Replace with one
listing that is already on Amazon. Once you
are down to one listing you can then upload your
Available Amazon inventory by checking All Online
Inventory and do a second upload.
Do your usual upload
to all services, then go back to Inventory, find a
record
that is Available and has an ASIN or ISBN on the
Keywords tab and the
Marketplace box is checked on the Amazon tab, that
is also listed as Available
in your Amazon inventory account online. Press A on
your keyboard, followed
by Enter if your Rec# is numeric,
or CTRL-A, followed Enter if your Rec# is
alphanumeric. This sets that record for upload.
Then do the following:
1. Set Amazon as an
Active service (Should be checked at all times by
default) 2. Select Amazon by clicking on the service
name in the list, so the black arrow is pointing to
Amazon > .
3. Place a check in Purge Amazon.
4. Click
the Process/Upload to Selected Service button:
5. Loading Amazon
Engine box appears, followed by Exporting to Amazon,
then Uploading to Amazon. May happen so fast
you don't see it all.
7. Export form appears, yellow bar
moves across bottom of form.
8. Export Log screen appears, so you can check
the success of your upload.
Check your Inventory account on Amazon to make
sure all but one record is
present.
9. Go back to Online Control Panel page, check
All Online Inventory, then
with Amazon selected, click Process/Upload to Selected Service
button.
This will add back all records that are set
for Amazon Marketplace listing in
Inventory, that are also Available. |
| |
|
