I run an online Japanese website selling contact lens. I need a simple backend database with web front for stock/inventory control.
10 main products with 20 subcategories per product.
I need to:
1. add stock
2. amend/delete stock items ( manual adjustment)
3. view entire stock on hand per product. ( table format )
4. Add a sale (which minuses from the stock on hand) Should be able to select product and quantity from drop down box. Preferable to add many sales at one time.
5. Keep a running track of sold items.
6. Download button to download data from 3 & 5
Preference given to webdesigners who already have some sort of online admin function availiable for demo.