I have a website community/store at www.sweetquads.com Right now it uses PhpNuke and a version of oscommerce to work with nuke. I am wanting to move away from the nuke site and possibly into the UBB/Entrance.
I am looking for someone who can design me a site with the following specifications.

1. It needs to have a easy to use shopping cart system,one in which you add the product attributes at the same time you add the products themselves. It is a pain to add a product then have to go into a different part of the CP to add the options(colors, sizes ect)

2. The shopping cart must intagrate with the site, but not over power it. I would like to have a link to the store and have a fer items on the front page, but i want to keep the community aspect of it.

3. I would like to have the forum user database be the same or work together with the store. I dont want people to have to register twice.

4.It should look cool!
See thats not so hard is it?
I welcome all comments and look forward to seeing what you guys can come up with.
And if you think you can do all that, let me know.

OSCommerce rocks. The best e-commerce solution at zero cost with a huge supporting community. Honestly I would use OSC and I beleive there is a contribution for interfacing phpBB to it. Not that I want to stear you away from UBB but if it is already buily why reinvent the wheel.

I believe there was some work towards building an interface to ubb.threads as well. You might wanna check over at www.threadsdev.com - it's php/mysql like oscommerce and probably an easier bridge to build.