Joan is an events organizer working with three teams involved in different projects, each one as varied as weddings, brand launches and charity nights.
Her suppliers’ contacts are managed – or rather, not managed – on slips of paper, notebooks, and mainly in her team leader’s mobile phone contacts. If one of them decides to leave the organization, then he’ll be taking with him a whole list of reliable caterers, photographers, florists, invitation printers, souvenir manufacturers, lighting crews and DJs – the backbone of Joan’s business.
Joan is not a fan of paperwork, but we think she’ll appreciate the ease of using Inventory Merge. It’s a Google Sheet add-on that wizy.io has developed to make collecting spreadsheet info much easier.
All Joan has to do is first make a spreadsheet with column heads containing the information she wants from her team leaders. She’ll probably write Service Provided, Supplier Name, Billing Address, Tel. No. and E-mail. Then she creates a hierarchy, where she organizes how she wants the info to flow. In this case, it’ll be pretty simple. She’ll want each of her three team leaders to fill up a copy of the spreadsheet, so her hierarchy will just be composed of a single level, with three people on it, almost identical to the figure on the left.
She starts her Inventory Merge add-on (it looks like the image on the right), and sends the spreadsheet out to her team leaders. The team leaders fill up their spreadsheet, crank up their Inventory Merge add-on, and send a note to Joan to tell her that the task is done.
To finish everything, Joan doesn’t have to take much time away from the networking tasks that she loves and that have made her such a success. All it takes is a few seconds. The time it takes for Joan to click on the Consolidate button and for her Inventory Merge add-on to put together those many years worth of data into a single spreadsheet and stock it in her Google Drive.
Now she has her main supplier directory. What she never had the energy for is finally done. What could have taken days of email and phone call back-and-forth is accomplished in a snap.
Try Inventory Merge right now by clicking here.
Or schedule a free demo.
You can also use Inventory Merge for:
- Hardware stocktaking
- Software and licences inventory
- Marketing campaigns results reporting
- Partners, resellers, sellers, main customers general information collection
- Points of sales inventory
- Students general information inventory
- So much more…