Import products to replace names not just SKUs

I'll shed some light on your queries about importing products in QuickBooks Online (QBO), ilovejwl.
 

Even if your SKUs are identical and you select the overwrite option, importing the file in QBO will not update the product names and bundles. Instead, it will create duplicates, as QuickBooks prioritizes the product names.
 

See this attached screenshot:


 

For additional information on how to import a list of your products and services in QBO, please refer to this article: Import products and services into QuickBooks Online.
 

Feel free to drop by if you have any further questions about importing data or any issues related to QuickBooks. We’ll be around the corner to lend a hand. 

Thank you.

Could you suggest a way that this can be accomplished without having to manually update names of products and bundles one by one? It seems very odd that a software wouldn't be able to overwrite names based on another 'anchor' data point, especially one as critical as a SKU.

For example, if we were to deactivate all current products and bundles and re-import them at the same inventory level numbers, would that work? Or do you foresee problems in the way inventory would be tracked for those items?

How would that affect current estimates, invoices and reports?

Hi there, @ilovejwl.

Currently, QuickBooks Online (QBO) doesn't support bulk editing of product names, meaning updates must be done manually for each item. Since product names take priority, importing items with identical SKUs can lead to duplicates if the names differ.

To enhance our product offerings, I encourage you to share your feedback with our development team. Here's how to submit your feedback: 

1. Click the Setting (gear icon) in the upper-right corner.
2. Under the PROFILE section, select Feedback.
3. Enter your request or suggestions in the Feedback box.
4. Hit Next to submit your feedback.

As my colleague mentioned, you can re-import your products and services while maintaining your current inventory levels. After re-importing, make existing products and bundles inactive to prevent duplicates.

Please note that deactivating items will not impact any past transactions; it only updates your product list. Existing estimates and invoices that include deactivated products will remain unchanged. However, these items will not be available for use in new transactions.

You can still generate reports that include inactive items since QuickBooks Online retains all historical data. Deactivated items will only be marked as inactive in those reports.

For your reference, you can check this article on how to merge duplicate items, remove unused items, or reactivate items in QBO: Remove a product or service in QuickBooks Online.

If you have any questions or need further assistance with importing products, feel free to Reply below. The Community Team is here to help!