Skip to content
  • There are no suggestions because the search field is empty.

Error While Importing Sales Tax Locations : Some of the mapping is duplicate. Please select a one-to-one mapping.

This article explains how to resolve the Error 'Some of the mapping is duplicate. Please select a one-to-one mapping.' By removing any duplicate entries in the CSV file or in the Setup Tax Locations Mapping.

Error Prompt:

Troubleshooting:

  1. Verify any active duplicates in the CSV file, you may use the built-in Highlight Duplicate feature in Excel or use Chat GPT or any other AI tool to remove duplicates.
  2. Once duplicates are removed, import the CSV file into Webgility Desktop. You may also refer to How to Import Tax Mapping Through CSV File in Webgility Desktop.
  3. If you're still getting the same error when you're trying to save the mapping make sure there are no duplicate enteries in the entire list, attached SS below for reference.

  4. If you find any duplicate enteries as shown in the SS above, select one Entry from the Checkbox & click on Delete.
  5. Save the mapping & resume posting the orders and verify the Tax items in your QuickBooks Transactions.

If the issue still persists please reach out to Webgility Support or Chat Support for further assistance