Jump to content

Check and delete duplicated combinations


Recommended Posts



because of a module I recently installed it created issues to my catalog. It duplicated combinations of many products. So I have duplicated skus for products with variations (sizes/colors) as you can see from image attached.

The products with duplicated combinations are too much...so cancelling manually one by one it's hard and takes too much time.

There is a SQL command to check duplicated combinations/sku and to delete them?

I hope so..because it is creating many problems to my website :/

Please help me


Best regards


Share this post

Link to post
Share on other sites

Making backups before installing new or unknown modules is always good option. However, the problem is here and we can't turn back the time. Cleaning up by SQL is possible but also not very easy.


Most likely you cannot delete with just one single SQL statement. Simply because it is too complex. There are several tables involved and you need to keep one unique combination for every product. I don't see another option than writing a small program which scans through all your products, checks combinations, compares the relevant keys (we don't know them yet) and deletes duplicates. Since there is some risk involved in this, I would test on another test instance before doing it on a live shop.


You can contact me if you wish to clean this up as a paid job. But to give an indication: It cannot be solved within an hour or two.

Edited by Scully (see edit history)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More