Order Fullfillment Web Tool
Hello,
In summary, this tool will be comprised of a mySQL database, and a web interface.
Functionally, it will pull all order information from 2 different 1shoppingcart.com accounts using the 1shoppingcart.com API methods, and populate the database with all fields.
The tool will automatically assign one of four possible statuses, a “shipping method”, “shipping notes”, and “fulfillment method” to each order. (This will be done using a set of criteria that will be built into a simple admin screen. The user will have access to this screen and can make changes to these criteria as needed. All that is required here is a graphical way to set up “If, and, or, then” statements using any data in the fields of the orders)
In the main interface of the tool, the user will be able to search for orders in a variety of ways, and can manually edit some of the fields, and manually change the status of an order.
When the user triggers the “fulfill order” process (hitting a button), the tool will format HTTP GET requests for all “completed” status orders that will be fulfilled through the disk.com fulfillment house (based on the customizable criteria we can setup and modify). If an order fits a different set of criteria, it will be added to one of 3 different printable “fax sheets”.
The user will then be able to print out the fax sheets which contain the shipping information for the orders, and then manually fax these sheets to the vendors.
This ends the summary, detailed specifications will be laid out in the attachments.