Opencart E-commerce Database De-duplication

Job ID: 38209916

Budget: $30 – $250 AUD

I have a large database of 1 million products in my Opencart E-commerce store. I need a skilled freelancer to help me eliminate all duplicate products from this database.

Key Requirements:
- Identify duplicate products: The de-duplication process needs to be based on product names and SKUs.
- Delete duplicates: The duplicate products should be permanently removed from the database.
- Record keeping: A separate file should be created to maintain a record of all the deleted duplicates for future reference.

Ideal Skills and Experience:
- Proficiency in Opencart E-commerce platform.
- Expertise in database management and de-duplication.
- Experience in handling large databases and optimizing performance.

This project requires meticulous attention to detail and the ability to work with a significant amount of data. The freelancer should be able to work efficiently and provide a reliable solution for de-duplicating the products in my Opencart database.

Examples of duplicate products
HP COMPAQ PAVILION 14-B114SS
HP PAVILION 14-B114SS
HP PAVILION 14 14-B114SS

We will give you some rules to work with. For example, in this instance, just the last product should be kept.
Related categories: MySQL Open Cart