updated as of: June 3, 2014
last author: Andy Theuninck

CORE supports a number of ways of calculating an item's price beyond simply assigning an item a static price. These methods do not all have a direct user interface in Fannie so this document will include discussion of the underlying database.

There are two sets of four columns used for price calculations. The first set is for regular pricing: pricemethod, normal_price, groupprice, and quantity. The second set is for sale pricing: specialpricemethod, special_price, specialgroupprice, and specialquantity. The remainder of the document will use the first set of column names for brevity. The second set are exactly equivalent, respectively, for sale items. One other column of note is mixmatchcode which is used to define groups of items.