As of now, you can search for duplicates among products by exporting products and searching for duplicates in a file in Excel.
1. Go to the Inventory > Products and Categories page and click the Export button.
2. Open the downloaded file in Excel or Google Sheets. Highlight the column you want to search for duplicates in, for example, the Article or Code column. Then click Formatting and select Conditional formatting.
3. In the formatting rules, select Custom Formula and enter the following formula:
=countif(C:C, C1)> 1
Note that C is a column letter, so if you select a different column, replace the letter C with the one you want.
Click the Done button.
As a result, cells that contain the same information will be highlighted with the selected color.
If you have searched for duplicates to change the unique product identifier, you can change the information directly in this file.
Please note that you cannot change the value in the "ID" column for correct subsequent uploading.
After changing the information, save the file. Then you can upload it on the Warehouse > Products and categories page using the Import button.
We remind you that you can also merge duplicate products in Orderry. Learn more about merging duplicates in this article.