I am new at this and needed someone to point me to right direction.
I have a client who has been updating his inventory list by updating and uploading a PDF to his server. (customer would dl this file)
His goal for his new site is to have a feature where he can upload an EXCEL file onto the server and have it update the inventory database. Can this be done? Here is his question, please let me know if this is possible. It looks to be a CMS question so any suggestion would be great.
"Inventory Upload – This is one of the main features that we want in order to make business function a little easier. We want to be able to take the values from our excel sheet and be able to upload them onto the inventory page while at the same time there being a date that states the latest inventory update."
"We want a search bar that does a good internal sweep of the inventory and any of the internal content on the pages. The search bar would be needed to pull from the inventory list."
This is the link he pointed to
Please any help would be awesome. I am willing to contract this part out if anyone knows how to proceed.
thanks a million guys