GrabIt! for BookTrakker - Set Prices                                                                    Index

  Set Prices Tab. Used to set prices for ASIN/ISBN lookup or when Repricing is performed. All pricing is based on the return of prices from Amazon controlled by the Number of Offers on the Settings tab, lowest to highest. GrabIt! calculates Lowest, Average or Highest price based on all prices returned, not all prices actually available. The larger the Number of Offers selected, the larger the range of possible prices. Keep in mind that as the Number of Offers requested gets larger, there is a performance hit on the system: More results require more time to retrieve and process.


A.    Minimum Price. The minimum price that you want to use, overriding any other formulas in place.

B.    Default Price.  Use this price if no other price is available on Amazon. No offers available, and Amazon does not have a copy for sale.

C.    Use Pricing Formula. If box is checked, then pricing is based on the formula within the Pricing Formula frame.

D.    Use Exclusion Formula. If checked, then Exclusion formula is used as outlined in the Exclusion Formula frame. This box must be checked for Exclusion to work. Applies when minimum price is higher than [Exclusion Formula]. Exclusion is used for ASIN/ISBN lookup to eliminate books you do not want to list, either because there are already too many copies below your minimum price threshold, or the Sales Rank is too high to likely generate much interest in the book. Do keep in mind that many books sell with a very high sales rank, but if space is at a premium then Sales Rank can separate the better selling books from the slow movers.

E.     Pricing Formula frame: 

1.    Price Qualifier. Ranges from Lowest to 5th lowest, Average, and Highest to 5th highest.

2.    Amount. How much to add or subtract from the offer prices. Positive number to add (.50), negative number to subtract (-.50). Zero (0) if you want to match the price.

3.    Condition Qualifier. Less Than or Equal To, Equal To, or Better Than or Equal To:

4.    Condition. New, Like New, Very Good, Good or Acceptable.

5.    Category. Which Category you are searching on for Price results, based on your Category selection on the Settings tab.

6.    BT Price Field. Which Price field in BookTrakker you want to use as your primary price for setting prices. You also have the option of setting one or both of the other two fields by using the markup below:  

7.    Amount. A number to either Add to or Multiply by based on the default price field used in BT Price Field.

8.    Action. Either Add to or Multiply by. Add to adds the amount in the Amount field to the BT Price and puts the result in the field selected by Field. Multiply By multiplies the BT Price by whatever you have in the Amount field and puts the result in whatever field you have selected in Field.

9.    Field. Pick which of the other two available fields you want to use other than the BT Price field. You do not have to use either field.  

F.     Exclusion Formula frame: 

1.    Exclusion Qualifier. Same as  Price Qualifier.

2.    And Offers Exceed. The number of offers at which point the record is excluded from listing or repricing.

3.    And/Or Sales Rank Exceeds. Used to further qualify Exclusion based on a high sales rank. 0 in this field means you do not use Sales Rank at all. 


So how does all this work? Letís start with a pricing example: 

Suppose you want your listings, which are all in Very Good condition, Used, to be priced at a nickel below the third lowest price, in Very Good condition or better, Used only, with the Dealer price to be modified in BookTrakker? You also do not want to sell for less than $6.00, and if no price is found then you want a default of $25. You would do your set up as follows: 

On the Settings tab you would make sure Used was selected. On the Set Prices tab you would set it up like so:

  If you wanted to Exclude any results where your Minimum Price exceeded the 5th Lowest price based on your condition qualifiers, and offers exceeded 20, then you would set it up as:
  If this is still not enough, and you wanted to include Sale Rank in your calculation, and you wanted either the Exclusion Qualifier/Offers or Sales Rank to determine the outcome, and any Sales Rank above 500000 means no sale, then you would select Or and type in 500000 into the Sales Rank field:

In either of these examples, for the Exclusion Formula to go into effect, you must have Use Exclusion Formula checked. 

What happens when you do an ASIN/ISBN search using the Exclusion Formula? Records that are disqualified end up in the Reports tab on either the ASIN or Reprice tabs for Results, in the middle section. 

If you wanted to set prices in the other two fields based on the BT Price selected (Dealer), and you wanted Store to be 25% higher, and Retail to be $3.00 higher then you would do the following:


    Copyright © 1998-2004 
All company and product names may be Trademarks of their respective owners.