Skip to main content
Duplicate vendor products build up over time from repeated invoice uploads and catalog imports. When the same item is linked to a vendor more than once, it can show up twice during invoice review or when you’re building a purchase order. The Cleanup Duplicates tool finds these duplicate Vendor Products and merges them in bulk, so you don’t have to track them down one at a time. 🚨 Warning: This tool merges records in bulk. Review the matched duplicates carefully before committing — merged records can’t be split back apart.

Accessing the tool

  1. Navigate to Inventory & Supply Chain > Vendor Products.
  2. Click Cleanup Duplicates in the top right.
Vendor Products page with the Cleanup Duplicates button highlighted in the top right

How duplicates are matched

By default, two Vendor Products are flagged as duplicates only when all of the following match:
  • Item Code
  • Description
  • Product
If any of these fields differ, the two records are not flagged, even if they represent the same item. For example, two Vendor Products with the same item code and Product but a different description won’t be grouped together.

Narrowing the match with optional filters

To reduce risk and target your cleanup, add one or more of these filters:
  • Vendor (recommended if you only want to clean up one supplier at a time)
  • Barcode
  • Detected Brand
  • Each Cost
  • Case Cost
  • Pound Cost
  • Case Size
💡 Tip: Start with a single vendor filter and review the results before adding more filters or widening the scope.

Include Null Matches

This setting is on by default. When enabled, empty values count as a match — so if two records both have a blank description and everything else matches, they’re still treated as duplicates. If you want tighter matching, turn this off so records with missing data are left out of the merge.
  1. Filter to a single vendor first.
  2. Review the detected duplicates carefully — confirm they represent the same real-world item.
  3. Add match filters if you need to narrow the results further.
  4. Once you’re confident the matches are correct, proceed with the cleanup.

Running the cleanup

Once you’ve reviewed the matches:
  1. Click Commit Cleanup in the bottom right.
  2. You’ll be redirected to the Vendor Products page, where the button now reads Cleanup in Progress.
Vori merges the duplicate records automatically in the background — no further action is needed. Processing time depends on how many duplicates were found, and the merge isn’t instant, so avoid starting another cleanup while one is already running. ➡️ Next steps: For a closer look at individual duplicate matches — including side-by-side comparisons of Barcodes and Item Codes — see the Merging Duplicate Vendors and Products guide.