Adding a sortable field for case pricing and quantity

[zep]

I am putting together a site that will sell wholesale items. I need to add three fields, visible when searching products. The new fields will display not only the case price, but cost per item in the case, and the case number of items in each case.

There will be no option to purchase a single item, but I need to be able to sort the products by case price, and item price.

Is there a mod or thread that can help? Ive look all over.

I can calculate the item price in the case simply by dividing case price by the number of items.... but I don't think I can sort the calculation if it is not stored in the Database....

Am I correct to think the only way to do this is create DB tables for the new fields, and find a script that can sort by column? Then modify the admin area to populate the new fields?

Any help is VERY appreciated. Thanks

[zep]

I found a great thread:
http://www.zen-cart.com/forum/showthread.php?t=57924

Now I just have to figure a description sorter...and done!

[zep]

I found the thread to add the DB files and set up the vars, but I need to sort the products in hte product preview pane according to my new vars...Please Help