Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
February 7, 2019
Question

If i import products from twice will the originals stay?

  • February 7, 2019
  • 3 replies
  • 33 views
No text available

3 replies

MichaelDL
Level 4
February 7, 2019

Hello there, @lindak1119.

 

I have just the clarification you're looking for. When importing Products & Services into QuickBooks Online, the originals will stay and be combined with the new additions. However, there is an option to Overwrite all values for each product or service that you import with the identical nameDoing this will merge any imported Product or Service with the same name as an existing one. Here's how you can achieve this:

 

Importing Products and Services

  1. From QuickBooks Online, click the Gear icon (⚙) > Import Data.
  2. Select Products and Services. Click Browse and find the file containing your items.
  3. Follow the on-screen instructions to map and upload your data. On the screen that lists all of the Products and Services to be imported, check the box at the bottom if you'd like to Overwrite all values for each product or service that you import with the identical name.
  4. Once finished, click Import.

This information is also available from our awesome guide on importing products and services for your convenience. Using these steps, you can avoid getting duplicates while importing additional items. Please know you can always reach out to me here for anything you need, I'm always up to talk QuickBooks. Thanks for bringing us your question and best wishes.

December 16, 2020

Hi There, Just wanting to know if we followed the above steps and chose to overwrite all values for each product or service that was imported with the identical name-will the data ie sales history still be available?

 

Thank you

AlexV
Level 10
December 16, 2020

Thanks for joining us here, christina123.

 

Yes, the data won't be removed and will remain on the account. However, the system will create an automatic Inventory Adjustment if a different quantity is being imported.

 

Check this link for your reference: Import products and services from Excel. Also, you can use the audit log to see how it affects the existing product.

 

Leave a comment again if you need anything else. I'll be here!