I would like to provide a list of prices and discounts for our products for internal and potentially external use. My original idea is to use an Excel spreadsheet with list of items, prices and discounts and a separate tab for each customer. Then I would have a front sheet whereby the user could search for a product to bring up prices, discounts. However this would only be used for internal use.
Another thought is some sort of online table using a mix of XML and DataTables jQuery Plugin which would make it very easy to bring up the latest items based on customer, price etc. The issue with this is it would take more time to set up this system and if we wanted it for external use it would require a login screen so suppliers can only see their own lists.
I’m looking for any tips or advice on the best way to accomplish this task with main constraints being time and setup. I can set up code it all myself.