Build Sales and Inventory Tracking Spreadsheet with Analytics
- Status: Closed
- Prize: $200
- Entries Received: 28
- Winner: tushchak0716
Looking for a Google Sheets file or set of files that are all connected together that will include:
A customer order form that I am able to send to customers and they select the items they want, how they want to pay, and collect their information.
The items they want should show up as a RFQ or something similar with a sales tab and look at which customers need attention.
Sales should have a grapic of a map that pins a location on the map based on shipping address.
Customer information should be collected in the form and then sent into a page with all customer data.
Sales rep's should be tracked on who is performing the best and who brings the most profit or loss.
Product profit/loss should be tracked.
A inventory checklist form that when I receive inventory my helper checks it in and gets initials from delivery driver.
Shipment drop off proof. etc etec.
All of these files should be Google Based, and scaleable. I should be able to add or delete entries without having formatiing issues. If someone knows of a better system that will accomplish what I desire I am open to change.
Some points of reference who have platforms similar to what I like is: