Affiliate Marketing Secrets

My company currently only has a very basic online retail website, and we would like to redevelop this to boost our online sales. We are a small-mid sized re-distributor for various manufacturers, and currently handle the vast majority of our orders via phone/fax.
We need a customizable Ecommerce platform that will allow us to create a very functional website with a lot of personalization for the users . We are in a unique niche, and our users require some non-standard features & ordering processes that we would need built into the site.
I am looking into various solutions. Ideally, we would like a system that offers CRM, accounting, inventory, POS integration, and other enterprise management tools.
I’ved looked into Oracle, but frankly, it all confuses the hell out of me. They offer so many products/solutions, i’m not sure if this is even what we need. Do they offer an ecommerce platform, or how would it be integrated into a website?
As a redistributor we only currently carry a small inventory of product. Generally we receive orders, put in an order to the manufacturer, receive the product, and then ship it almost immediately. However, as our online business grows, eventually we’ll expand our inventory to hold products we find are most desired through sales analysis/metrics.
Do you have any suggestions on good enterprise software for us? Have you had any bad experience? Is Oracle the way to go? Where can I find a good developer/IT guy that would aid in the implementation of this?