I have in the works a basic inventory system, so far it does this.
- Signup (with captcha generated)
- Login
- Password reset
- Add basic items / Update counts of items
- Display of all inventory items(alternating row color) (non-paginated) so this is 10-20 pages long when loaded. Just using junk data as a test at the momment.
I am preplanning at the momment for tables/needs
I don't want to overplan, but definately don't want to underplan. I really only need to handle 10-20 customers, and most of them will have identical products in the database. I will be looking into making invoices and adding products by barcode scanner we currently use for another reason. A symbol PDT-3100
I have never worked with more then 2-3 tables for queries, and need more education on optimizing tables for searches. This could turn into a program used for years down the line, and want to make sure I design the functionality of it right so tables are not bloated.
My main question:
Is there an existing framework of a opensource inventory or classes that I can implement to do most of the work needed.
I have no issues putting time and effort into education but just looking for a direction to move into.