< < BACK
Home

       Help Resource Center

Support Contact Us Company Polls and Surveys


Amazon Data Entry (New Record Mode) and Setup for Initial Upload from Previous Data
Book Loader instructions for records without ASIN's or ISBN's here. Read below as well. 

Click link(s) to jump to section(s) below:
North American Marketplace Accounts

Amazon Canada or United Kingdom Booksellers

Using Hit Lists to Set Amazon Fields 
Setting records for Amazon Condition
Setting records for Amazon FBA

Hit List Help: Users should read about Hit Lists in Help at the top of BookTrakker, then click the Hit Lists selection in green. Alternatively you can click the Hit Lists tab on the left side of BookTrakker, then press F1 for Help. (If Help in BookTrakker does not work email support@booktrakker.com at once. there is a fix from Microsoft)

Online Hit List Help Here.

Condition is the Amazon condition used on Marketplace only, whether it be Amazon.com, Amazon.ca o Amazon.co.uk.  The list of choices is as follows:  

1 = Used; Like New  
2 = Used; Very Good (default)  
3 = Used; Good  
4 = Used; Acceptable  
5 = Collectible; Like New  
6 = Collectible; Very Good  
7 = Collectible; Good  
8 = Collectible; Acceptable 
11 = New 

BookTrakker will match these conditions automatically based on using the Book field on the main data entry form. As you select from the Book field one of the choices, BookTrakker will set Condition on the Amazon tab according to the following equivalence table:
           
AN, F+, F, NF = Used; Like New
VG+, VG, VG- = Used; Very Good
G+, G = Used; Good
Fair, P = Used; Acceptable
If you want to use any other selection then you need to manually change the choice to what you want. There is no capability within BookTrakker to distinguish between Used or Collectible during data entry, the default is Used, unless you select New for the book, in which case New is selected on the Amazon tab. You have to change the dropdown manually for Collectible.
Marketplace - Must be checked for all Amazon.com uploads.  If you type or scan in an ISBN into the ISBN or an ASIN in the ASIN field on the Keywords tab in New Record mode then Marketplace will be checked automatically upon leaving the field. You can uncheck it if you want to use the ISBN field for other services but not as an Amazon listing. Or, if you have both an ISBN and an ASIN then use both, BookTrakker will upload the ISBN to other services and the ASIN to Amazon. Canadian and UK dealers need to set their shipping choices 
Expedite - Amazon.com only - Tells BookTrakker to upload this record as "Expedited shipping available" for Amazon.com only. You can set defaults for Expedite in Tools > Options > Records in the middle of the form.
International - Amazon.com only - Tells BookTrakker to upload this record as "International shipping available" for Amazon.com only. You can set defaults for International in Tools > Options > Records in the middle of the form.  
North American Marketplace Accounts (NAM)
If you list on one of the North American Marketplace (NAM) sites (Amazon.com, Amazon.ca or Amazon.mx) and have a North American Unified Account then you can upload to both Amazon.com or Amazon.ca through the same Pro Merchant account.  See NAM instructions to understand what the NAM is all about. So if you have either an Amazon.com or Amazon.ca Pro Merchant account you can upload to Amazon.com and/or Amazon.ca to manage listings. For Mexico you can only manage through your Amazon dealer page. BookTrakker does not directly upload to Amazon.mx.
Shipping choices for booksellers in Canada (CA) or the United Kingdom (UK) 
You MUST be a seller listing on Amazon.ca or Amazon.co.uk to use the shipping options for CA or the UK. These settings DO NOT apply to Amazon.com  (USA) sellers.

No CA: Do not upload this record to Amazon.ca
CA Only: Shipping within Canada only
CA, US: Shipping within Canada and to the United States
Any Amz: Worldwide shipping, all countries Amazon.ca allows shipping to

No UK: Do not upload this record to Amazon.co.uk
UK Only: Shipping within the UK only.
UK, EU Only: Shipping within the UK as well as the European Union
UK, EU, US: Shipping within the UK as well as to the European Union and the United States.
Any Amz: Worldwide shipping, all countries Amazon.co.uk allows shipping to.

BookTrakker 3.7 adds in Expedite capability for Amazon UK and CA. If Expedite is checked over on the right side of the Amazon tab in BookTrakker and one of the Amazon UK or CA choices other than No UK or No CA is selected then Expedite is enabled for those uploads. See your respective dealer pages on Amazon for an explanation of what Amazon remits for Expedited Shipping.

If you sell on multiple Amazon sites and do not want to enable Expedite on any but your local Amazon site then do the following:

Click the Inventory button: Click on User Information at the top, then User Information again to bring up the form. Click the Other tab, 
then type in one of the following three letter currency codes in the Currency field: USD, CAD or GBP. You want to type in the three letter currency code for your native Amazon upload site. Click OK to close the form. 

Any upload to any of the Amazon sites other than your local site will not set Expedite in the upload file.

You can set defaults for Amazon CA and UK in Tools > Options > Records in the middle of the form.: 

Item Note - Used for the Comments field on Marketplace. Limited to 200 characters in BookTrakker 3.1, and 1000 characters in 3.2 and later versions. It will not allow you to enter more than 200 characters in 3.1, even though the field appearance may be larger.   NOTE: If Item Note is used then BookTrakker will get the data for Seller Comments in the upload file from this field. This field will allow you to use one description for Marketplace listings and a different description for the other services.   Leave it empty and BookTrakker will use your Marketplace Field Mapping choices for creating Seller's Comments on Amazon.
Using Hit Lists to Set Amazon Fields - You can use Hit Lists to change the Amazon fields globally. This is especially useful if you have imported data from another source before starting with data entry using BookTrakker.
A. Setting records for listing on Marketplace, and/or Expedite and/or International.
Click the Hit Lists tab, left side of screen. Click New. Click OK. Under Search Field heading click on the dropdown button, select Status. (Over on the right, under Search Criteria, the field will default to Available) Click again in the field below Status, select ISBN. Place a check in the check box under Not, just to the right of the ISBN selection. Leave the next field blank, under Search Criteria. Change the Search Type (next field) to Entire Field. Your Hit List setup should look like this:
Clicking the Execute button will create a Hit List of all Available records where there is an ISBN in the ISBN field on the Keywords tab. Check your results in List View. If they look correct, then click the Hit Lists tab on the left, then click on the Action tab, upper right. On the left side you will see a frame labeled Action. In the lower right corner of this frame you will see Amazon. Click this. Over on the right, below the Action tab label, you will see a dropdown list with Amazon above and Yes below. Click the dropdown, select Marketplace. Place a check in the Yes check box. Your Action Hit List setup should look like this:
Click the Execute button. You will see a message asking you if you want to run this Action Query, and that it will change XXX records. Click Yes to confirm, No to cancel. If you click Yes then all records with an ISBN will be set for listing on Marketplace. You can repeat the Action Hit List for Expedite and International, assuming you want all your records listed as such. Select Expedite or International from the same Amazon dropdown list, upper right, under the Action tab.

Repeat for ASINs by clicking into the Hit List setup on the ISBN field and selecting ASIN instead. The follow the same instructions for ISBNs above.

Setting Expedite:  

Select Amazon on the left side in the Action frame. Then click the dropdown under Amazon in the upper right and select Expedite. Below that is a Values frame, click the dropdown button to select which combination of Expedite you want. There are 20 to choose from. 

Click Execute. Confirm the change.

Unchecking International: Create the Hit List of records where you want to uncheck International. Check your results in List View. If they look correct, then click the Hit Lists tab on the left, then click on the Action tab, upper right. On the left side you will see a frame labeled Action. In the lower right corner of this frame you will see Amazon. Click this. Over on the right, below the Action tab label, you will see a dropdown list with Amazon above and Yes below. Click the dropdown, select International. DO NOT check the Yes box, it should be unchecked. Click Execute. Confirm. 

B. Setting records for shipping for Canada or the UK:

Click on Amazon on the left.
Select Amz UK Ship or Amz CA Ship from the dropdown list, upper right. Amazon must be selected on the left. In the Values frame below, click the dropdown to select which shipping method you want: 
Repeat as necessary for each class of books you want to set shipping for. Because of expensive international rates you may want to qualify books based on Size, if you use this field in Inventory.  
C. Setting records for Amazon Condition 

This can be more complicated, especially if you have DJ information. Ignoring DJ information, which can be included in the Comments on Marketplace, you will do a series of Hit Lists based on Book. These instructions assume you follow Amazon's convention of assigning condition as described above in Condition.  

If you understand how Hit Lists work then you can do compound Hit Lists based on both Book and DJ to optimize the Amazon Condition settings. Obviously a VG Book with a Poor DJ is not really Used - Very Good.
1. Used; Like New
Click on the Hit Lists tab, left side. Click New. Click OK. Select Marketplace under Search Field. Search Criteria defaults to Yes. Under Marketplace click into the blank field and select Book. Over on the right, under Search Criteria, click into the field for the dropdown button to appear, click the dropdown button and select NF. Then, on the right, under Search Type, select At Least from the dropdown list. Your setup should look like this:
Click the Execute button. Next, click the Hit Lists tab on the left, then the Action tab, upper right. Click on Change, in the Action frame on the left side. Then select Condition from the Change dropdown list, and Used; Like New from the Change To field. Your setup should look like this:
Click Execute, confirm the changes. You can also set them to Collectible - Like New using the same process, providing they qualify under Amazon's guidelines for Collectible.
2. Used; Very Good Click on the Hit Lists tab, left side. Click New. Click OK. Select Marketplace under Search Field. Search Criteria defaults to Yes. Under Marketplace click into the blank field and select Book. Over on the right, under Search Criteria, click into the field for the dropdown button to appear, click the dropdown button and select VG+. Over on the right, select Less than or equal to. Click under Search Field, new row, select Book again from the dropdown list, then VG- under Search Criteria, then At Least under Search Type. Your setup should look like this:
Click Execute. You will end up with a list of all books where Book is VG+, VG or VG-. Next, click the Hit Lists tab on the left, then the Action tab, upper right. Click on Change, in the Action frame on the left side. Then select Condition from the Change dropdown list, and Used; Very Good from the Change To field.  Click Execute, Confirm. You can also set them to Collectible - Very Good using the same process, providing they qualify under Amazon's guidelines for Collectible. 
3. Used; Good. Repeat as above, except G+ = Less than or equal to, and G = At Least. Then select Condition from the Change dropdown list, and Used; Good from the Change To field.  Click Execute, Confirm. You can also set them to Collectible - Good using the same process, providing they qualify under Amazon's guidelines for Collectible.
4. Used; Acceptable. Repeat as above. except you select Fair, Less than or Equal to. Then select Condition from the Change dropdown list, and Used; Acceptable from the Change To field.  Click Execute, Confirm. You can also set them to Collectible - Acceptable using the same process, providing they qualify under Amazon's guidelines for Collectible. 
5. New . Similar to above, except you set the Hit List to search on New, Equal to. Then select Condition from the Change dropdown list, and New from the Change To field.  Click Execute, Confirm.
D. Setting records for Amazon FBA 

Two choices. FBA plus uploading to other sites or FBA only. 

1. If the FBA check box on the Amazon tab is checked and Status = Available then records will be uploaded for FBA management on Amazon as well as being offered on other sites. This means you have Amazon ship the books when they sell elsewhere. 

Click on the Hit Lists tab, left side. Click New. Click OK. Select Status under Search Field, defaults to Available. Select Marketplace under Search Field. Search Criteria defaults to Yes. Select what records you want based on your Search Fields and Search Criteria.

Once you have the records selected do an Action, Amazon. Under the Amazon box, upper right corner, click the dropdown and select FBA. Check Yes. Click Execute. Confirm. 

Click the red Hit List button at the top to get out of Hit List mode.

2. If the FBA check box on the Amazon tab is checked and Status = FBA then these records are only uploaded to Amazon. If previously uploaded records were changed to this choice then they would be removed from the other services while being uploaded to Amazon.

Click on the Hit Lists tab, left side. Click New. Click OK. Select Status under Search Field, defaults to Available. Select Marketplace under Search Field. Search Criteria defaults to Yes. Select what records you want based on your Search Fields and Search Criteria.

Once you have the records selected do an Action, Amazon. Under the Amazon box, upper right corner, click the dropdown and select FBA. Check Yes. Click Execute. Confirm. 

Click on the Hit Lists tab, left side. Click the Action tab, upper right. Check Status on the left. Where is says To: Available over on the right, click the dropdown button and select FBA at the end of the list. Click Execute. Confirm. (You will get zero results) 

Click the red Hit List button at the top to get out of Hit List mode.

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:  July 12, 2015