Option to clear unused or old data from BP database

👍 Gathering votes

It looks like when we add services, service extras, staff, workhours and other items and then delete them, the deleted entires remain on the database and they are still counted in certain areas of BookingPress.

For example, while setting up BP for our usage, I have managed staff and services many times, adding new items, deleting, etc... I have also re-imported all the data from the staging site to the live site, using all of BP export options. This handling while setting up BP resulted in old entries on the BP database, and now I have 69 staff showing on the BookingPress main panel, when I really only have 20 staff available on the site.

All other 49 entries are items that have been deleted in the past, but they are still counting on the main BP dashboard.

It is visible from the content of the import/export feature that many deleted items remain on the database, or their relations like working hours, service custom durations, etc.....

Here is my dashboard showing 69 staff, and I think if I export, delete all of them and re-import, this will become an even higher number.

When the site is live, it becomes very complex to fix this sort of thing because there is real customer data associated to the staff, services, etc....

So an option to clear old entries and records from the BookingPress database would be useful to clear our current db and make it easier to export/import, when we need to do any fix in our setup, while not having so many old (unuseful) entries on the database or on the export/import files.

Maybe the import process could be improved, it looks like the main item entries like services and staff are not re-imported with the same IDs, becoming comepletely new items after the import.... this is not necessarily the best option in some cases, sometimes we want to re-import or reset a service, staff or location, with the same ID and relationships, for example.

But the main issue is that it looks like some parts of BookingPress are still reading this old data and counting items that do not exist anymore in the actual BP installation. There is no easy way to clear that data from the database manually necause there are a lot of relationships and both valid and invalid entries are found in the same places.

So a native feature from BP to clean up the database from non-existing entries would be very useful.

Global

1 week ago

No votes yet
Categories
🪲 Bug