Im looking to create a simple ordering system for a greetings card company. Currently paper order forms are filled in and faxed to a warehouse for processing. I need someone to create a database backend so that an admin can :
Add a card (image, name, card code)
Edit a card
Delete a card
Suspend a card (temp out of stock)
Change card display order
needs to make automated thumbnail from uploaded image.
Next I want a front end for users, they can :
View cards in the same way as attached PDF document, when they hover over the card code a small mouseover image pops up to display the cards image. They have a section to write Order quantity next to each card, then write address and name at the bottom of the form. clicking submit stores the order in a database and emails a packing slip.
An admin can also go online to print the packing slip again AND/OR Delete the order from the system.
Its important the admin can change the order of the products on the stocksheet, Ajax drag and drop would be good. Please see current PDF for an idea of the layout needed.
Each range of cards needs to be stored on a seperate stocksheet, so either this is incorporated into the solution or I will duplicate the code for each range of cards.
Thanks for your time in quoting.