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 databse, 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.