I am very inexperienced with SharePoint, but I was tasked with following project. Have our Company store moved online to sharepoint. The idea is to have an excel spreadsheet with all of our items on sharepoint site. It would have 3 set culumns: Part number, Name of item, price, and one interactive column with checkmark, if they want the item, and another with quantity.
When they would select the items, by checkmarking them, and selecting the quantity, they would hit submit/workflow and an email with the selected items would be delivered to a specific warehouse org email. Then the warehouse personel could prepare the item and our delivery personel would deliver the item to the individual.
How can I make this reality? Can anyone help please?
For now I have very basic sharepoint store... I just copy/pasted line by line into the Inserted table, and have customers copy and paste the line and send it to the warehouse using their email.
I would like to automate this as much as possible without the users having to start a new email, copy and paste the lines, and then sending it to the warehouse.
Thank you very much