I need to build an internal ordering system in google sheets
Budget: €8 – €30 EUR
I have a bakery business producing a large range of products. I need to create a streamlined way for cafes to order from me I am currently using google sheets in which customers place weekly/daily orders . I need to create a way to pull information from each individual sheet into a daily report to give to the bakery in order to break down the total order qties for each product.
I am attaching a sample of the sheet that just one location is currently using to place orders. I will need this replicated for 4 other locations Each week a new tab is added and they can adjust the orders daily if needed. I am also attaching a sample of the report I need generated from all sheets.
I am attaching a sample of the sheet that just one location is currently using to place orders. I will need this replicated for 4 other locations Each week a new tab is added and they can adjust the orders daily if needed. I am also attaching a sample of the report I need generated from all sheets.