Data Cleanup Pro

This user manual provides step-by-step instructions to install, configure, and validate the ICTECH DataCleaner Pro plugin in Shopware 6.
The extension helps merchants safely clean obsolete and unused store data including products, customers, abandoned carts, promotions, CMS pages, media files, logs, and more to improve store performance and maintain database health.

1.1 - Install the Plugin

Log in to the Shopware Admin Panel

Go to:
Extensions → My Extensions

Click:
Upload Extension

Upload the ICTECHDataCleanerPro plugin ZIP file

Click:
Install

After installation, click:
Activate

The plugin is now installed and ready for configuration.

2.1 - Access Plugin Settings

Go to:

Settings → Extensions

Locate:
ICTECH DataCleaner Pro

Click:
Configure

2.2 - General Configuration Options

General Settings

Enable Logging

Toggle to enable or disable cleanup activity logging.

Default: Enabled

When enabled:

• All cleanup operations are recorded

• Manual, CLI, and scheduled cleanups are logged

• Cleanup history is available under Cleanup Logs

Notification Email

Enter an email address to receive notifications after cleanup execution.

Default: Empty

If configured:

• A notification email is sent after cleanup completion

• Useful for scheduled and automated cleanup monitoring

Click Save to apply changes.

The plugin provides multiple cleanup modules.
Each module contains configurable cleanup rules and scheduling options.

Navigate to:

Settings → Data Cleaner

You will see the following cleanup sections:

• Products & Variants

• Customers & Accounts

• Orders, Carts & Checkouts

• Categories & Navigation

• Promotions & Discounts

• CMS Content & Pages

• Reviews & Ratings

• Marketing Lists

• Media Management

• Logs, Cache & Technical Data

4.1 - Product Cleanup Configuration

Go to:
Settings → Data Cleaner → Products

Configure the following options:

Remove products not sold in months

Deletes products with no sales activity within the selected timeframe.

Default: 6 months

Delete products never sold

Deletes products that have never appeared in any order.

Default: Enabled

Remove inactive products older than months

Deletes inactive products older than the selected timeframe.

Default: 6 months

Schedule Frequency

Select:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automatic scheduled cleanup for this module.

Default: Disabled

Click Save after configuration.

5.1 - Customer Cleanup Configuration

Go to:
Settings → Data Cleaner → Customers & Accounts

Configure the following options:

Remove guest accounts after months

Deletes guest customers with no recent order activity.

Default: 12 months

Remove inactive customers after months

Deletes registered customers who have not logged in or placed orders.

Default: 12 months

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated scheduled customer cleanup.

Default: Disabled

6.1 - Orders and Cart Cleanup Configuration

Go to:
Settings → Data Cleaner → Orders, Carts & Checkouts

Configure the following options:

Remove abandoned carts after days

Deletes inactive abandoned shopping carts.

Default: 30 days

Remove cancelled orders after months

Deletes cancelled or failed orders older than the configured period.

Default: 12 months

Remove old transactions after months

Deletes old payment transaction records.

Default: 12 months

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated scheduled cleanup.

Default: Disabled

7.1 - Category Cleanup Configuration

Go to:
Settings → Data Cleaner → Categories & Navigation

Configure the following options:

Remove empty categories

Deletes categories without assigned products.

Default: Enabled

Remove categories with no sales in months

Deletes categories with no sales activity.

Default: 6 months

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated category cleanup.

Default: Disabled

8.1 - Promotions Cleanup Configuration

Go to:
Settings → Data Cleaner → Promotions & Discounts

Configure the following options:

Remove expired promotions after months

Deletes expired promotions older than the selected timeframe.

Default: 6 months

Remove unused vouchers after months

Deletes unused voucher codes.

Default: 6 months

Remove orphaned cart rules

Deletes cart rules no longer linked to promotions.

Default: Enabled

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated promotion cleanup.

Default: Disabled

9.1 - CMS Cleanup Configuration

Go to:
Settings → Data Cleaner → CMS Content & Pages

Configure the following options:

Remove unpublished CMS drafts older than months

Deletes old unpublished drafts.

Default: 6 months

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated CMS cleanup.

Default: Disabled

10.1 - Reviews Cleanup Configuration

Go to:
Settings → Data Cleaner → Reviews & Ratings

Configure the following options:

Remove unapproved reviews older than days

Deletes pending product reviews older than the selected period.

Default: 30 days

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated review cleanup.

Default: Disabled

11.1 - Newsletter Cleanup Configuration

Go to:
Settings → Data Cleaner → Marketing Lists

Configure the following options:

Remove bounced newsletter recipients after months

Deletes newsletter recipients with bounced email status.

Default: 12 months

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated newsletter cleanup.

Default: Disabled

12.1 - Media Cleanup Configuration

Go to:
Settings → Data Cleaner → Media Management

Configure the following options:

Remove orphaned media after days

Deletes media files not linked to any entity.

Default: 60 days

Schedule Frequency

Options:

• Weekly

• Monthly

Enable Scheduled Cleanup

Enable automated media cleanup.

Default: Disabled

13.1 - Technical Cleanup Configuration

Go to:
Settings → Data Cleaner → Logs, Cache & Technical Data

Configure the following options:

Remove system logs after months

Deletes old Shopware system logs.

Default: 6 months

Flush cache during cleanup

Automatically clears Shopware cache after cleanup execution.

Default: Enabled

Remove orphaned custom field sets

Deletes unused custom field definitions.

Default: Enabled

14.1 - Preview Cleanup

Before deleting any data:

1. Open the desired cleanup module

2. Configure the cleanup settings

3. Click:
   Preview Cleanup

The system will:

• Analyze matching records

• Show a preview of items to be deleted

• Display deletion counts

• Make no database changes

14.2 - Run Cleanup

After reviewing the preview:

1. Click:
   Run Cleanup

2. Review the confirmation popup

3. Confirm cleanup execution

The plugin will:

• Delete matching records

• Execute cleanup safely using transactions

• Record the cleanup activity in logs

⚠ Important:
Cleanup operations permanently delete data and cannot be reversed.

15.1 - Enable Automated Cleanup

Each cleanup module supports automated scheduling.

To enable:

1. Open a cleanup module

2. Select:

   • Weekly

   • Monthly

3. Enable:
   Enable Scheduled Cleanup

4. Click:
   Save

15.2 - Scheduled Task Requirement

Shopware Scheduled Tasks must be running on the server.

Recommended command:

bin/console messenger:consume scheduled_tasks --time-limit=3600

Alternative cron configuration:

* * * * * php /var/www/html/bin/console scheduled-task:run

16.1 - Access Cleanup Logs

Go to:

Settings → Data Cleaner → Cleanup Logs

The log section displays:

• Cleanup execution date

• Trigger source

  • Manual

  • CLI

  • Scheduled

• Cleanup mode

  • Dry-run

  • Real cleanup

• Result summary

The plugin also supports command-line execution.

17.1 - Run Full Cleanup

bin/console ictech:cleanup:run

17.2 - Run Dry-Run Cleanup

bin/console ictech:cleanup:run --dry-run

17.3 - Run Specific Cleanup Module

Example:

bin/console ictech:cleanup:run productCleanup

Available modules:

• productCleanup

• customerCleanup

• orderCleanup

• cartCleanup

• categoryCleanup

• promotionCleanup

• reviewCleanup

• cmsPageCleanup

• newsletterCleanup

• mediaCleanup

The plugin includes multiple safety mechanisms to prevent accidental data loss.

Included Safety Features

✔ Preview Cleanup (Dry-run Mode)

✔ Confirmation Dialog before deletion

✔ Transaction-safe deletion

✔ Batch processing for large datasets

✔ Detailed cleanup logging

✔ Scheduled cleanup support

Recommended workflow:

1. Always take a database backup before first cleanup

2. Start with conservative cleanup thresholds

3. Run Preview Cleanup before actual cleanup

4. Review cleanup logs regularly

5. Schedule cleanup during off-peak hours

6. Use CLI commands for large datasets

Issue

Solution

Plugin not visible

Run bin/console plugin:refresh and clear cache

Preview shows 0 items

Check cleanup thresholds and existing data

Cleanup not deleting data

Ensure Run Cleanup was confirmed

Scheduled tasks not running

Verify Shopware scheduled task runner

CLI command not found

Run bin/console cache:clear

Foreign key constraint error

Some records cannot be deleted due to linked data

Cleanup timeout

Use CLI cleanup instead of Admin UI

After cleanup execution:

• Selected obsolete records are permanently removed

• Cleanup activity is logged

• Cache may be automatically cleared

• Scheduled cleanup continues based on configuration

• Store database becomes cleaner and more optimized