About This File
Removing duplicate products for OpenCart
The "Remove Duplicate Products" module for OpenCart allows you to automatically find and remove duplicate products in your database. It offers several options to check for duplicates: by Product Name, SKU, or UPC. This is a useful tool for store owners who want to keep their database clean and avoid product confusion.
Checking and removing duplicates:
You can select a field to check: Product Name, SKU, or UPC.
The module leaves only one product with the smallest product_id and removes other duplicates.
Support for large databases:
- The module processes data in parts using pagination (lots of 1000 products) to avoid server overload.
- The script works stably even with large databases thanks to (tested on a site with a database of 157,000 products):
- Removal of the execution time limit (set_time_limit(0)).
- Increasing the memory limit (ini_set('memory_limit', '512M')).
Preventing accidental deletion:
Before clicking the delete button, the user must check the box to confirm the action.
Multilingual support:
The module supports English and Ukrainian languages.
Requirements:
ocStore version 3.x
OpenCart version 3.x
Installation:
Copy the module files to the appropriate directories of your OpenCart store, the module does not replace the files of OpenCart itself.
Go to Extensions → Extensions → Modules and install the module.
Activate it through the admin panel.
How the module works:
Go to the module through the OpenCart admin panel.
Select the field to check and remove duplicates (Product Name, SKU, or UPC).
Check the box to confirm the deletion.
Click Remove Duplicates.
After completion, you will receive a message about the successful removal of duplicate products.
Advantages:
Helps avoid product confusion and improves database management.
Easy to use and set up.
Prevents accidental removal of products thanks to the confirmation mechanism.
