Run this query to see a list of duplicate part numbers.


  1. Navigate to Settings\System\SQL
  2. Paste in the below query
  3. Click Execute to view list or Export to export to CSV


SELECT Part_No, Description, Barcode_no, COUNT(*) FROM STORE1 GROUP BY part_no, description, barcode_no HAVING COUNT(*) > 1