Login to edit MySQL table with over 2,000 entries!!!
I am designing a web site created using a MySQL Database with over 2,000 entries.
If the quantity in stock (stock control) needs changing for 100 products a week, I am not sure the best method. I am considering creating a login at the web site but am unsure what to ask the user to do...
...enter a product code to change the quantity?
...select from a selection of drop down boxes (perhaps 200 products in each list; could be annoying to choose correct one)?
...or, can the database be viewed? Besides the issue with scrolling up and down and left to right to find the right entry could the quantity be changed in a cell in the table and then saved?
...I have heard Excel can be used; is this as simple as uploading and downloading an Excel file?
Does anyone know what the common practice is?