White Unicorn Books Home
BOOKTRAKKER
Hit Lists and Catalogs
  1. Introduction
    1. Some general "rules"
    2. Tips for Making Hit Lists
  2. Hit List Examples
    1. Author Hit List
    2. Append Text to End of Field to All Records
    3. Copy Retail Price to Field 1 for Available Items
    4. Copy Prices From One Field to Another
    5. Check for Sold books with an Available Status
    6. Check for Available Books With No ISBN nor ASIN
  3. Catalogs [Exporting a Hit List]
  4. Webpage from Hit Lists

 

Introduction

 

Note that there is generally more than one specific way to create a Hit List.  The items generally come from suggestions made on the BookTrakker Board but might also come from other places such as the Chrislands board [both are Yahoo Groups].

At present the wiki is public and the subjects tend to be in alphabetical order.  If the list becomes large, it may, at some point, even become more organized. Until then, the simple TOC at the top will have to do.  BTW: Would you like a link to your store/business.  Just provide us with a set of hit list directions and a link to your store will be given at the end of the hit list write up [up to maximum of two per page].

Typically the procedures below will assumme that you are already on the hit list page [see Number 4 in the list of General Rules below] and are ready to input criteria. It is also assummed that you have read the help provided in the BookTrakker program on hit lists [click on the Help tab after clicking on the New tab to create a new hit list]

Some general "rules"
  1. DO NOT MAKE CHANGES TO YOUR DATA BASE WITHOUT BACKING UP FIRST!
  2. Capitalization does not matter but spaces do.
  3. You should always run your hit list the first time with no action.
  4. A new hit list can be accomplished in the following manner
    1. Click the Hit Lists tab on the left side of the Inventory screen
    2. Click New. A pop-up prompt window appears. You can create a unique name and enter that name in the field next to "name" [this save the hit list with that name] or just accept the name [typically Temporary List]. Click OK to close the pop-up.
    3. The "Set Field Criteria" tab displays with your cursor positioned in the "Search Field" column.
    4. There should be a drop-down button in this first line, if there isn't, just click anywhere inside the field.
    5. Fill in at least one line of criteria, i.e. chosing Author in Search Field, le guin in the Search Critria field, and Any Part of Field as the Search Type.
    6. Click on the Action tab and check that None is chosen.
    7. Click execute. The records are processed and a list of all your records in the Hit List opens in List View.
  5. After running the hit list with no action, you can then, if necessary for your particular hit list, go back through and choose the particular action needed [under the Action tab]. If you want your hit list sorted, sort criteria can be chosen under the Sort tab.

 

Tips for Making Hit Lists
  Submitted by Gwen Foss Alan's Used Books


What is a Hit List? A Hit List is an isolated group of records. Hit Lists are invaluable tools for organizing, manipulating, and modifying your data in a time-saving manner.)

(Examples of Hit Lists you may have a need to make at some time or other might be: all your items priced under $3, your periodicals and ephemera, your F/F mystery firsts published in the past five years, items shelved in the annex or display case, items on medicine or psychology or sports, nautical items published before 1900, items published in Spain or Kalamazoo, items still available of the first two hundred items you cataloged, children's books bound in orange cloth, or any number of other possible criteria.)

(A Hit List is created by setting specific criteria in specific fields, then isolating only the records matching the criteria, OR, by typing in a list of specific record numbers, then isolating those records. BT is capable of producing Hit Lists using an extremely wide range of criteria.)

To make a Hit List:

1. Click on the "Hit Lists" tab (sideways, on the left side of the window) OR hit Alt+H.

a. To return to the "Inventory: Detail View" mode (standard mode) from the Hit List tab, hit the "Detail View" tab (sideways, on the left side of the window, at the top) OR hit Alt+D.

b. The Hit Lists window contains four tabs across the top: Set Field Criteria, Catalog ID# List, Sort, and Action.

c. The Hit Lists window contains two tabs across the bottom: Hit Lists, and Catalog ID# List Manager.

d. An action hit list is a hit list on which you carry out a specific modification to every record on the list. Options for specifying modifications are found on the Action tab.

2. Click "New" (gray button at center left).

a. If you wish to make a Hit List based on catalog ID numbers, click the checkbox beside "Make Catalog ID List." Type in the record numbers, then go to step 11.

b. Name the Hit List. Naming the list is useful if you intend to keep this set of criteria or use this list again at some time in the future. Otherwise the default name, "Temporary List" (as shown), will suffice.

c. Click "OK."

3. The table on the "Set Field Criteria" tab is displayed and blanked for criteria to be input. On this table you set up the criteria for your Hit List.

4. Click in the first blank cell of the table, under the heading "Search Criteria." A down-arrow appears at the end of the field.

a. Click on the down-arrow. A drop-down menu of BT field names appears. Use the scroll-bar to see the entire menu.

b. On the drop-down menu, click on the field you want to specify criteria in. The selected field name is inserted in the first cell of the table.

5. Click on the next cell in the table, under the heading "Search Criteria." Type the criteria (text) you want to search for in the field you selected.

6. Click on the next cell in the table, under the heading "Search Type." Select the criteria for how the selected field is to be searched. The options available in this cell depend on which field you have selected to search.

a. When searching a field containing simple text, the three standard options are: Beginning of field; Entire field; or, Any part of field.

b. When searching the Status field, this option defaults to Entire field.

c. When searching a price field (Retail, Dealer, etc.), the options are: Greater than or equal to; Equal to; or, Less than or equal to.

7. Hit Lists may be narrowed and refined by having them take criteria from more than one field. To set criteria for an additional field, click on the first blank cell in the next row, select one of BT's fields, and type criteria for that field.

8. Hit Lists may also take multiple criteria in one field. Standard search commands, that is, <not>, <and>, and <or>, may be applied when multiple criteria are combined.

9. Examples follow.

a. Example: To make a Hit List of available items with "Wisconsin" in the title or subtitle:
 1) Set Status to <available>.
 2) Set Title field to search for <wisconsin> in any part of field.
 3) At the end of the row, under "And/Or," select "Or."
 4) Set Subtitle field to search for <wisconsin> in any part of field.

b. Example: To make a Hit List of available items authored by anyone named Wright other than Harold Bell Wright:
1) Set Status to <available>.
2) Set Author field to search for <wright> in beginning of field.
3) In the next row, set the Author field to search for <harold> in any part of field and click the "Not" checkbox.

10. Once criteria for one Hit List are set, these criteria are stored in the table of Hit Lists at the bottom of the window. The Hit List most recently designed is selected (gray button to the left has a triangle arrow).

11. The final step in creating a hit list is to execute. Click "Execute" (gray button at center). BT runs through your database and isolates the records matching the criteria. A window stating "Processing hit list; please wait" appears.

a. Once a Hit List has been executed, BT will display only the records that match the hit list. Navigate through BT in the normal manner to see all the matching records.

12. To execute a Hit List you created previously, select that hit list (on the Hit Lists table at the bottom of the window, click on the gray button to the left of the list) and click "Execute."

13. BT remembers the criteria laid down to create each hit list and stores it in the table of Hit Lists at the bottom of the window. This retention is particularly useful if, for example, you want print a catalog every six months based on a hit list, in which case the criteria for the hit list need only be set once.

14. To rename a hit list, select the list. Click "Rename" (gray button at center). Type the name you want. Click "OK."

15. If no records match the criteria, a message stating "No records fit the search criteria" is displayed. Try modifying the criteria, then execute again.

16. When you are done with the Hit List, the Hit List mode must be turned off so you can again see all your records. Turn it off by clicking the red Hit List button on the menu bar. This resets BT to show all your records again, and also changes the red Hit List button back to its regular gray color.

Hit List Examples

 

Author Hit List
  Submitted by De at White Unicorn Books
Search Field: Author
Search      : name of author, i.e. le guin
Search Type : Any Part of Field

If you want the list organized by title or some other way, click on the Sort tab and choose your sort. You should always run your hit list the first time with no action taken so click on the Action tab and make sure None is chosen under the Action section. Click on Execute. You can now look at your results by clicking on the List View and/or Detail View tabs on the left.

 

Append Text to End of Field to All Records

 


 
BACKUP!

 Search Field: (blank)
 Search      : (blank)
 Search Type : (blank)

 

 Range Type

  Type       : Numeric

  Field      : Book ID

  From       : 1

  To         : (last Book ID)

 

 

Check under the Action Tab and make sure none is chosen as the Action. Click on Execute.  Examine the records to se that you got those you wanted. Go back to the Hit List (click on Hit List tab), click on the Action tab.

 

 Action     : Append
 Append To  : Notes (or choose field from drop down list)
 Append Text:
(text to be appended)

 

Execute.  Check that what you wanted was done.  If not, Restore your data base and try again.

Submitted by De at White Unicorn Books

 

 

Copy Retail Price to Field 1 for Available Items

 

BACKUP!

 

 Search Field: Status
 Search      : AVAILABLE
 Search Type : Entire Field

 

If you want the list organized by title or some other way, click on the Sort tab and choose your sort. You should always run your hit list the first time with no action taken so click on the Action tab and make sure None is chosen under the Action section. Click on Execute. You can now look at your results by clicking on the List View and/or Detail View tabs on the left.  If you got what you wanted, click on the Action tab and

 

 Action   : Copy
 Copy From: Retail
 Copy To  : Field 1

 

Note that if you also wanted to save the current information present in Field 1, you would choose Append as the Action.  However, if were doing this in order to "save" the Retail price in order to be able to copy it back to Retail (say after a sale), you should choose Copy as the Action.

Submitted by De at White Unicorn Books

 

 

Copy Prices From One Field to Another

 

The very FIRST thing you should do is make a backup of your existing inventory. That's probably a natural given, but sometimes I'm forgetful so I have a tendency to assume others are as well.

You need to move the price to a field you don't use, nor is uploaded - for example, one of the 4 user fields, or the source or shelved fields. Or maybe the S&H field below the retail, store and dealer price fields.

 

To do that, you make your hit list of the records you want to put on sale. Name it Books On Sale or something. After you run that Hit List, click on the Action tab (the fourth one on the top half of the Hit List screen). This will then become your "Action Hit List" where you tell BookTrakker what action you want it to take.

On the left upper section, under "Action", click on "copy".

In the Fields box, click in the "Copy From" Box to pull up "retail" (or whatever price field you are copying).

In the box below, click in the "Copy To" box to pull up the desired field you want the price copied to (for example, "source").

You will then have "moved" by copying the price to another field. You can then do an action hit list to revise your retail price to whatever sale price you are using. Once your sale is over, you do the above in reverse: Do an action Hit List to "copy" the "source" field to your "retail" field. - or whatever field you selected.

Note: moving dollars into a non-dollar field shows the number as a decimal point. All is well when you move it back to retail. To then remove the amount from the "source" field, do another action hit list CHANGING the "source" field to nothing (leaving the values field blank will accomplish this).

Submitted by Lera at Aunt Teek's Novel Shoppe 

 

 

Check for Sold books with an Available Status

 

The reason for running this Hit List is that sometimes, for a reason not yet determined, books are sold but the status does not change to Sold. Running this Hit List on a regular basis may help to avoid sales of books that have already been sold.

  Search Field  : Status
  Search        : Available
  Search Type   : Entire Field

Also
  Range type    : Date
  Field         : Sold
  To & From     : Fill in Appropriate Date Range

Click Execute.

The results of this hit list will show you any books in your database that have a Status of Available but also have a date in the Sold Date Field. The only books to which condition should apply to are those that had a status of more than one. For exaqmple if you have 5 books in the quantity and sold one the Sold Date will reflect that date.
Submitted by Sandi at
Mostly Romance  

 

 

Check for Available Books With No ISBN nor ASIN

 

You might want a list to create pages on Amazon, either manually or with Grabit or the Amazon Bulk Uploader.

  Search Field  : Status
  Search        : Available
  Search Type   : Entire Field

AND

  Search Field  : ISBN
  Search        : DO NOT CLICK IN THIS FIELD, LEAVE BLANK
  Search Type   : Entire Field

AND

  Search Field  : ASIN
  Search        : DO NOT CLICK IN THIS FIELD, LEAVE BLANK
  Search Type   : Entire Field

 

Click Execute

 

Note.  This is only part of the process of using the Amazon Bulk Uploader to create new ASINs.  To see the complete process look at www.booktrakker.com/GrabIt!/AmazonBulk.htm

Submitted by De at White Unicorn Books 

 

Catalogs [Exporting a Hit List]

 

Webpage from Hit Lists

 

Here are some more places to look around our site:

  • Arkham House, Mycroft & Moran, and Fedogan & Bremer Books
    At the request of several of our customers, we started a page for the books of Arkham House and related publishers. We try hard to keep it up to date with news and a list of forthcoming books and a list of those books we have of these publishers - both new and used.

  • Author Web SSites/Fan Sites
    A list of Authors and their websites or fan sites. Unfortunately, I haven't kept up with the sites going out or changing although a recent check with a program showed no broken links. One can hope right?

  • Book Care and other book information
    About Books includes items on Book Care as well as a How to Identify First Editions. It will include links, reviews, and all kinds of other interesting (to us at least) tidbits as we add to it.

  • Book Condition Description
    We use certain "bookseller" terms when we describe our books. Generally, they tend to mean what you think they would mean. For example Fine means basically without faults. The exact meanings behind what we mean are given on this page. As mentioned on the page, book condition is sometimes a subjective "call" by the book seller. We try to be objective, but might (in your opinion) fail. If so, you can return the book for any reason.

  • Book Inventory Programs The question of which book inventory program to use was always coming up on some of the forums I visit so I though I would put down some thoughts here. It is evolving and will eventually try to cover many aspects of inventory management (in the sometime distant future). In the mean time, if you have something you would like to see, let me know.

  • Book Reviews
    A slowly growing list of books we've reviewed. We would be happy to have your comments and, if you like, your reviews (with, of course, credit to you if you wish).

  • Chrislands Book Stores
    Chrislands is the company which hosts our site. We are very happy with them as are their other customers. This page gives links to many of the other Chrisland stores.

  • General Links; Other Book Stores, SF&F References, Detective/Mystery References, etc.
    Well, that about says it all. This is sort of a catch all for links which don't specifically belong anywhere else. Right now (about 6:41 pm Central US time, Oct. 16 2005), there are four sections, Science Fiction & Fantasy, Mystery - Detective, Arts and Crafts, and Book Related Links.

  • Glenn Larsen's Guide to First Editions
    Copied from Books-Rare, the book collector's home Copyright © 1997 by Glenn Larsen. Sadly, the original is no longer available., but we have a copy of it here with some corrections and additions.

  • Glossary of Terms Used in Literature and the Book and Printing Trades
    This page grew out of a request from a customer about book terms, a bookman's glossary so to speak. Now I could have just pointed them to the IOBA Book Terminology but I though it would be nice [and make our site more attractive] if we had a page of our own. Well now we do - at least the start of one

  • Help for on-line book buyers
    We hope this page will help you have a more pleasant on-line book buying experience. It also lists a few other places to get books - If we don't have the book you are looking for, of course :-)

  • IOBA Book Stores
    The Independent Online Booksellers Association, is dedicated to promoting internet bookselling by, in part, "Maintaining and enforcing high ethical and professional standards for our member booksellers, including a Code Of Ethics." White Unicorn Books is a proud member of the IOBA and on this page we list some of the other IOBA stores.

  • Liaden Universe of Steve Miller & Sharon Lee
    This page is for our Steve Miller and Sharon Lee books. It is mainly books set in the Liaden Universe® and has a list of books in that series, including the Chapter Books, as well as a set of references and links to other sites for the two authors.

  • Previously Featured Books
    Featured Books is where we list the books which have been featured on our home page - we may have more about the book than is in the normal catalog listing, so we decided to just keep track of them here. For example, when we featured the Chronicles of Narnia we listed "both sequences". The order in which they were originally published and "the preferred sequence of CS Lewis".

    We also have some special pages for books which are special in some way. It may be that the book itself is special or that a customer asked for more images, so we put up a page for the book. In any case we have these single pages for a particular book:
    • Butters' Richmond Directory 1855
      An interesting directory for 1855.
    • Crystallizing Public Opinion
      Bernays is considered by many as the originator of modern public relations and has been called the "Father of Spin". He was named one of the 100 most influential Americans of the 20th century by Life magazine.
    • Oxford Lectern Bible The Oxford Lectern Bible is a massive edition of the English Bible designed by American typographer Bruce Rogers (1870-1957). It is considered by many to be Rogers' masterpiece, and is recognized along with the other great Bibles, including the Baskerville Bible and the Doves Press Bible.
    • The Principles Of Judicial Proof
      Normally we don't put up our used books as a Featured Book on the home page they don't last long enough to stay here since we generally only have a single copy) but this one is such an absolutely beautiful book I had to put it up. So, of course, I had to build a page for it.
    • Sleeping Beauty, a Special Collectors Edition with illustrations by Dulac
      A page devoted to a special book. The 1910 limited edition of Sir Author Quiller-Couch's The Sleeping Beauty and Other Fairy Tales, illustrated by Edmund Dulac.
    • The Religious System of China
      First published over quite a few years, the initial volume was published in 1892 and the final volume was printed in 1910, The Religious System of China is a monumental work by Jan J M de Groot that "is an attempt at depicting the Chinese Religion as it is really practiced by the nation, and at sketching on a broad scale its influence on Domestic and Social Life. It is the fruit of an intimate contact with the Chinese race for several years." The work also contains a detailed study of China's funerary stelae, and the mythical animals used to decorate them.
    • Slovenly Peter's Story Book
      A classic 'what happens to bad boys and girls' from the late 1800's.

  • Ramblings/Blog/Book Reviews and whatever
    This is really a series of pages consistings of almost anything. On these pages I've written about Medicard Part D, about searching for information on a book on Google and at the Library of Congress, reviewed several books, and talked about the IOBA. No telling what will show up there. I'm sure we'll duplicate information on the rest of the site, but a lot of it will be unique. Hope you find it of interest.

  • Repricing
    A short look at some of the reasons for (semi)automatically repricing your inventory including a few Perl code snippets.

  • Setting Up an Internet Book Store
    An article I wrote for the IOBA. It presents a "first look" at some of the things one should think about in setting up an internet book store.

  • Transfer Homebase data to BookTrakker
    We use BookTrakker for maintaining and updating our main database of books we have listed here on our site. In talking to other BookTrakker users, they wanted to know how they could use someone to enter data which they could transfer to BookTrakker either in addition to or instead of using the network version of BookTrakker. Since we use both the network version and Homebase as "auxillary input systems", I though I would finally describe how we did the Homebase to BookTrakker part of it.





If you enjoyed White Unicorn Books, please let others know about it by reviewing our site for the Alexa search engine.
Review White Unicorn Books
Proud members of


 

Home  |  About Us  |  Contact Us  |  Store Policies  |  Privacy Policy  |  Links

Questions, comments, or suggestions
Please write to info@whiteunicornbooks.com

Copyright©2003, 2004. All Rights Reserved.
Created April 18, 2012
White Unicorn Books Home