Identify Incorrect Case Quantities

Sell case items properly

This tool will compare two spreadsheets to identify mismatching case quantities. They will be exported to an .xlsx file for review before import.

Identify new products first!

Use your results on step 2 to remove these problematic items from the new vendor spreadsheet!

Otherwise you may undo your case quantity fixes if you end up importing these mismatches.!

First, products are matched based on a (default 'vpn') key.

Then, these matches will be compared based on a secondary (default 'caseqty') key. New mismatched spreadsheet data will be identified.

Upload your sheets!

Large file uploads will take a while to process, depending on your internet connection and server load.
You can set specific columns to use for matching. The default columns are listed below. Change to suit your needs.