|QuickBooks Commerce is no longer available for purchase as a stand-alone product.|
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.
Learn how to spot and fix duplicate records when working on spreadsheets.
Duplicate records can sometimes happen, especially when working with large amounts of data in spreadsheets. They can mess up your processes and workflows. Here’s how to check and fix duplicates when uploading spreadsheets to QuickBooks Commerce.
Note: Make sure there are no duplicate product names, variant names, SKUs, barcodes, or other identifiers before you upload your data.
Remove duplicate records in Google Sheets
Here’s how to remove duplicate entries in your Google Sheets.
Remove duplicate records in Microsoft Excel
Here’s how to remove duplicate entries in Microsoft Excel.
Both processes will select any duplicate records on your spreadsheet. You can now remove or change them accordingly.