Data Cleanup

The Cleanup Data section in Osclass allows administrators to efficiently remove outdated, unwanted, or redundant data from their classifieds website.

Data cleanup
Data cleanup

This feature helps optimize database performance, reduce spam, and keep the platform organized. Below is a breakdown of available cleanup options.

Inactive Listings

Inactive listings are those that have been published but not validated within the last 7 days. These listings are often spam or redundant and should be removed to maintain a clean and active database.

  • Action: Remove listings that have not been validated for more than 7 days.
  • Reason: Prevent clutter and unwanted data.

Blocked & Spam Listings

Blocked or spam listings are those that have been manually marked as spam or disabled by an administrator or moderator. Keeping such listings in the database can lead to unnecessary storage usage.

  • Action: Remove all listings marked as spam or disabled.
  • Reason: Keep the site free of inappropriate or malicious content.

Expired Listings

Listings that have expired for more than 7 days and were not removed or reactivated are considered expired. These listings are no longer visible to users.

  • Action: Remove expired listings older than 7 days.
  • Reason: Clear out inactive or outdated listings.

Inactive Users

Inactive users are those who registered but did not activate their accounts within 7 days. Such accounts are often created by bots or users who lost interest.

  • Action: Remove users who registered but did not activate their account for more than 7 days.
  • Reason: Free up user database space and remove inactive accounts.

Blocked Users

Blocked users are those who have been disabled by an administrator for policy violations or other reasons. This action also removes all listings published by blocked users.

  • Action: Remove users blocked for more than 7 days.
  • Reason: Maintain platform integrity and remove unwanted accounts.

Inactive Comments

Inactive comments are those that have not been activated for more than 7 days. Keeping these comments in the system can clutter the database.

  • Action: Remove comments pending activation for more than 7 days.
  • Reason: Improve user experience by clearing unapproved comments.

Blocked Comments

Blocked comments are those flagged or removed by administrators or moderators. These comments are not visible to users.

  • Action: Remove comments blocked by administrators or moderators.
  • Reason: Prevent inappropriate or offensive content from staying in the database.

Unsubscribed Alerts

Alerts that have been unsubscribed by users for more than 7 days are considered inactive and can be removed.

  • Action: Remove alerts that were unsubscribed more than 7 days ago.
  • Reason: Reduce unnecessary records in the alerts database.

Expired Ban Rules

Ban rules that have expired for more than 7 days should be removed to keep the ban list relevant.

  • Action: Remove expired ban rules older than 7 days.
  • Reason: Optimize system performance and maintain an effective ban list.

Old Osclass logs

Remove old Osclass logs older than XY months. Number of months is taken from Retention Months setting in Settings > General Settings.

  • Action: Remove old log data
  • Reason: Optimize system performance, remove redundant data

Summary

The Cleanup Data section helps maintain an efficient and high-performing Osclass installation by regularly removing obsolete data. Administrators should periodically review and execute cleanup actions to keep their classifieds platform optimized.