Bulk Updating/Spreadsheet Sync
As a home décor wholesaler with a catalog of over 10,500 items, we’ve encountered challenges using the bulk import feature to update our inventory. Currently, items appear to be matched and categorized by their name, rather than by their SKU. Since item names are often updated for clarity or marketing purposes, this causes issues—such as duplicate entries—when importing updated data. The SKU, however, remains consistent and is the most reliable identifier for our products.
It would be extremely helpful if QuickBooks could match and manage items based on SKU instead of name during bulk import. This would significantly reduce duplication errors and streamline item updates.
Additionally, we recently began using Spreadsheet Sync to help manage our large inventory. While it's a helpful tool, the 10,010-line limit prevents us from editing our full catalog in one session. On top of that, even within Spreadsheet Sync, we still have to manually copy and paste each updated item, which is time-consuming and inefficient for large-scale updates.
Expanding the line limit and improving SKU-based item matching would make a big difference for businesses managing extensive product catalogs like ours.