Product
Store demo
Showcase
Features
Why for developers
Why for store owners
Industries
Fashion
Health & Beauty
Food & Beverage
Automotive
Industrial & Scientific
Furniture
B2B eCommerce
International
Downloads
Download nopCommerce
Marketplace
Translations
Copyright removal key
Mobile application
Web API
Support & services
Training
Documentation
Community forums
Premium support services
Request a quote
Contact us
Partners
English
English
Español
Deutsch
Russian
Français
Italiano
Português
Türkçe
简体中文
日本語
Tiếng Việt
Get started
Shopping cart
My account
Log in
Register
Home
>
Forums
>
General
>
General Support
>
Search for duplicate products in a database
Search for duplicate products in a database
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
toadman
Total Posts:
264
Karma:
1432
Joined:
11/1/2016
Location:
United Kingdom
Posted:
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 !
mhsjaber
MVP
Certified Developer
Total Posts:
668
Karma:
6076
Joined:
3/30/2018
Location:
Bangladesh
Posted:
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
sangeetshah
Certified Developer
Total Posts:
334
Karma:
3370
Joined:
12/28/2016
Location:
India
Posted:
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
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Still have questions or need help?
.
Premium support services
.
Get dedicated support from the nopCommerce team with a guaranteed response within 24 hours.
.
Online course for developers
.
Get the practical and technical skills you need to run and customize nopCommerce websites.