MLom
Level 3
‎January 08, 2025 06:57 AM

Adding new additional data in QBO Adv using the Import Data tool. Problem.

  1. It is supposed that when Import Data Tool detects duplicates based on unique identifiers (like Vendor Name), QBO will prompt you to decide whether to:
      • Update existing records with new data.
      • Skip importing duplicate.
  1. But instead, I get "We didn't import some of your data because it's already in QuickBooks. If you still want to import it, change the info in the highlighted fields and try again."
  2. In short, does QBO Adv allow adding new additional data using Import Data Tool? Or is there a restriction?
  3. Thanks!
Reply Join the conversation
Tori B
QuickBooks Team
QuickBooks Team
‎January 08, 2025 07:25 AM

Account management

Good morning, @MLom.

 

Thanks for taking the time to reach out to the QuickBooks Community. I hope you're having a great day so far. 

 

This message means that when attempting to import data into QuickBooks Online, the system detected some of the data you were trying to upload already exists within your QuickBooks account, so it skipped those entries to avoid creating duplicates

 

When you have the same item, vendor name, or product name, be sure to select the Overwrite all values for each product or service box. This will make the error go away and allow you to import.

 

Here are some sample screenshots for reference:

 

 

For more information about the import process, check out: Import products and services into QuickBooks Online.

 

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Have a good one! 

Reply Join the conversation
MLom
Level 3
‎January 08, 2025 08:05 AM

Account management

Hello Tori,

Probably, I’m missing something here but “select the Overwrite all values all values . . .” option is not available in QBO Adv. The steps of importing data are block after click on “Import.”

I’m trying to import vendors and contractors.

I attached the screen sequence available in QBO Adv on my end.

Anyway, thank you for your comments.

ML

 

Reply Join the conversation