Have you ever managed a product price list for different regions or countries? I have; as a product manager for several years. It's horrible. Why?
Mostly because of how we have to work with lists today!
We cannot collaborate on region specific data unless we filter the data on region basis and save it as different sheets or files all together in Notepad, Excel or Google Docs. That’s not all - you have to work & update those multiple copies of price lists yourself if you are selling in multiple regions. It is next to impossible to get the information collated in a single master price list automatically.
To add to this don’t forget that sharing those files/sheets in Notepad & Excel in desktop mode is out of question simply because you really cannot share data in Excel without emailing the sheet multiple times and Google Docs does not offer a cell level share & collaboration capability for your price master sheet. Something these guys never thought about.
Look - all we need is a basic app level capability of finite share here. We have price data in rows and columns and the need is to share specific data items with specific users for them to (a) view (b) edit and (c) trigger work allocation based upon certain conditions.
Consider this scenario: Your product is marketed in US, China and UK and the VAT rates and prices of your product differ on a quarterly basis. You want to have a single master list and create partial data views from this list as shared views with specific users. Once they change their data, your master sheet or master list automatically gets updated. Vice versa, when you change they have their shared view automatically changed.
Isn’t it simple? Now if the guy from China adds a sudden spike in VAT rates in his shared view, would you like to setup an email notification to the country head and CFO? I would want to for sure. Isn't this scenario typical for working and collaborating on most lists today?
Well, good news is that we are making all this happen @ CollateBox.
I am, as always, interested to know how you achieve these today. What tools and possibly, which simple ways can I manage my price lists today...?