将定价表简化为多种不同的格式？ [关闭]

Question

At my company we have a master pricing sheet in Excel that we keep updated. However, we have marketing materials in InDesign, Excel, on our website (with a MYSQL database), and 3rd party websites. Every month we update our prices, we have to update all of them by hand which is a lot of work, and prone to errors.

I am sure with all that is out there today, there is a way to streamline all of this from our master sheet, so we only have to update the master, and the rest can be automatically updated..

Can anyone suggest a solution for me, or at least a good direction?

Answer 1

The approach i would take is to move the master sheet into a database. This would allow me to create a simple web based gui that uses web services and role based authentication. The web services would generate xml, csv, etc. This would further allow for central management of pricing which in turn prevents rogue managers / sales people from hurting the company's bottom line.