Update price by Catagories

[Shady]

I was asked by a company I do work for that uses squirrelcart if I could I could write a PHP page to update prices based on the category the products are in. It needs to be able to update their cost and the new cost to the customer. Is this possible?

Thanks for any advice you can provide

[Jamie]

Anything is possible, but we do not have a feature that does this. You would need to be proficient in PHP and write custom code to accomplish this.

[Shady]

I understand that I would have to write the custom page, and thats the plan. But I am not seeing within the DB structure how the products are referenced to the catagories. Any pointer in that direction would be great.

[Jamie]

That is handled via the REL_Products__Categories table.