Website Order Management System

Site: [login to view URL] . Currently running Joomla CMS with Virtuemart ECommerce. Virtuemart Checkout is customised for nature of business. Need a backend order management system which will allow tranferring of orders (with attached files and notes) between departments (Admin, Production, Printing, Shipping). Also with intermediary step for Buyer Approval. Currently orders goto SQL database, need a secondary database for this management system, to take certain order details and allow internal order management. Current Order System: Order created in Virtuemart and stored in SQL database, email sent to buyer and to admin. Post order page captures specific information and allows buyer to upload pictures which are delivered to admin as attachments to form email. Orders are passed around internally between departments with the artwork as email attachments. Internal order tracking done on Excel spreadsheet. Required Order System: Order created in Virtuemart and stored in SQL database, email sent to buyer and to admin – Virtuemart system to be left intact. Post order page captures specific information as well as file attachments and creates a new order on New Order Management System (NOMS), validation checks on order details. Order then available by NOMS to production dept, production dept product artwork and upload to NOMS, NOMS generates emal to buyer to view and approve artwork, depending on approval NOMS sends order back to production dept with buyer comments or onto print/ship dept. Certain orders (defined by validation checks) sent direct by NOMS to buyer by email. Order Statuses: In Production, Awaiting Buyer Approval, Awaiting Editing (If not buyer approved), At Ship/Print, Shipped, Error. This whole system should be separate from Joomla & Virtue, It is a backend management system, only becoming frontend for buyer approval stage. Full info in attached file We need this ready for testing by 18th May Target price is USD500 and less We have been let down once on this project already and wasted 2 months, so we want a serious provider who can provide. If it is a small provider with less than 10 feedback we will only agree to pay 100% on completion of work. When submitting bids please demonstrate that you understand the project and how you plan to fulfil the requirements. Providers with good feedback will be preferred. Winner will be person who has a balance of lowest price and demonstrates best understanding and capability for the project.