I need to create an e-commerce solution for a client and will be programming an interface between the shopping cart and a SQL Server based inventory system.
It needs to be solid, have a good reputation, flexible, and relatively easy for experienced programmers to learn to work with (ie good community and/or documentation). I prefer the shopping card database be mySQL or SQL Server.
I don't want to pay a fortune because the client really can't afford that. And I don't want a 'hosted shopping cart' because I want to retain control of the server situation (because of the interface with inventory system).
Any guidance and personal experience would be extremely appreciated.