Just dropped in on this conversation and it looks like most of us are struggling to find an elegant solution, me included.
I have over 6 years experience with Orderwise Stock Control and Order Processing Software as a previous forum member posted, and yes the sales team always say 'yes, yes, yes', however from my point of view, it is a thorough stock control and order processing system but it lacks speed and finess by being built on the foxpro framework. Overall, very clunky and reminds me of a Microsoft Access database feel. Orderwise 7 (just released) is now built on the SQL framework but I doubt very much that integration with Magento will be as smooth as we would like. I would love to hear if someone has this live, bug free and can tell us what information is posted back and forth.
Anyway, my reason for posting is because I am looking at using an all-in-one integrated solution, how much easier would it be? After hours and hours of research, days in fact and after years of Joomla-Virtuemart experience I feel the need for a simpler solution.
I want a solution that has an attractive frontend ecommerce shop that can be templated and styled easily (Magento) and has great SEO potential, easy backend administration with full stock control, shipping and order processing, and something that doesn't cost the earth.
I stumbled upon Opentaps communtiy edition (free) using a Magento Ecommerce (Free edition) frontend. Opentaps being a full CRM + ERP solution all in one with a web interface. Magento being Magento, a solid shopping cart system.
Open source means that there is plenty of community support and regular updates. There is also a connector available (On Magento Connect) that sends sales order information into Opentaps from Magento, Opentaps processes and captures that information via the connector and allows consignment information to get posted back to Magento. All customer information gets posted back and forth also as well does newsletter subscritpion info and other info.
On the face of it, it looks like a solution that could work, also check out the metapack API to handle the shipping headaches, on metapack.com and you could have yourself a tidy little system. Metapack already has an API for Magento.
I thought I would share my findings with you for those of you looking for a cost effective solution. If anyone has this setup currently, likewise I would like to hear your views.
Thanks