We need to add an order form to our website for 3 products.
Need the following fields
Product 1 (input quantity, in multiples of 8)
Product 2 (input quantity, in multiples of 8)
Product 3 (input quantity, in multiples of 8)
The above could be drop downs, 64 pieces would be the max
Select Territory (there are 30)
We need to keep track of inventory in an odd way, we need to track how many of each of the 3 products we have left for each territory.
We need to track all orders so that we can list them and mark them as shipped, we would also like this to email us each order with the above details
We have MySQL that we can use for this if required.
This will be attached to an existing site and besides making the page easy to read and clean, we just need 2 logos on the page.