I have CiviCRM deployment in which many events are created each week with unique price-sets. The staff using the back-end often goes in and makes typos, edits, and generally tweaks price-sets often. Each time they make an edit, the price-set is saved as a copy, and they piling up in a serious way.
The price-set listing page takes minutes to load, and has no pager, and the drop down to select a price-set in the Event Configuration page is becoming quite unusable.
Some questions: 1. Is it necessary for Price sets to be duplicated on each edit? 2. Can price sets be deleted without consequence to the events, registrations, and payments (IE, how do price sets work?) 3. Is there a "safe" way to purge these old, unused price-sets, without having to go through each one, perhaps via direct DB manipulation? We would be willing to simply purge all price sets if we could do it without losing event,registration,payment data.
Any ideas would be much appreciated!