Search for duplicate products in a database

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
4 years ago
hi there
im testing my new site and found i entered a few duplicate products while browsing the website.
is there anything i can run via sql that would show me any more duplicates?
im running version 4.2
Thanks !
0
4 years ago
If product names are are exactly same then you can find using GROUP BY query. 

Select count(Id), [Name] from Product group by [Name] order by count(Id) desc
Thanks
Jaber Kibria
Solution Architect || Tech Lead || Brain Station - 23
Skype: live:jaber_270

nopStation: #1 nopCommerce Gold Solution Partner
Website: https://nop-station.com
We are one stop E-commerce solution provider
For any queries: [email protected]
Team Skype:  [email protected]
1
4 years ago
SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

Reference link for detail about this : https://stackoverflow.com/questions/2594829/finding-duplicate-values-in-a-sql-table
Pls up-vote the answer, if it helps you!

Thank's,
Sangeet Shah
====================================================
Need any professional assistance? Drop us your requirements on [email protected]
https://nopadvance.com
Your PERFECT nopCommerce GOLD Solution Partner
-1
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.