Adding Items to PowerStore Products Table

hi. I have added an item to the products table for a 'wholesale Price'. I have customised some extra pages for wholesale customers - identified by a special login. I have updated the Products results & details pages to display this wholesale price if a 'member login' rule is passed. All works okay until I choose to select options. Then my price disappears.
I think my problem may be in the Amin area. If I add an item to the products table - when this items has options attached - how do I ensure the options are updated correctly for all new fields.
I hope this makes sence. I am sure this has been addressed before - some people must need to add to products table for other reason (eg : postage dimensions).

Thanks

Not sure exactly how you are doing this but I'll outline how I would approach this.

Set a wholesale flag in the user table.
Add a wholesale price or % off in the product table.
Every place a price is read, use something like this:

If wholesale get wholesale price
else
get regular price

You can search for all of the price variables by using this feature:
Find all instances of a variable in a site
185/

In the admin pages, just add the wholesale price field so you can manage both from the same pages.

Hi, I had done this. I have a wholesale flag and product price.
I actually duplicated the product_Results and Product_detail pages.

What I has missed was the Product__Detail_lookup.

Thanks - It all works beautifully now.