Skip to main content
T
tom235
February 4, 2024
Question

Why am I getting duplicate products when I import and select the overwrite box?

  • February 4, 2024
  • 1 reply
  • 0 views
I am exporting my list of inventory products to Excel. I make changes to the quantity on hand and then import the changes. When I import I tick the box to overwrite products with the same name. I have been doing this for as long as I remember to record end of month inventory changes in bulk. This last month, when I did the same thing, I ended up with every product duplicating. Needless to say it was a mess to go through and archive the duplicates, plus deal with the fact that QB recorded the quantity for each of the products as an separate opening balance entry. The first time, I thought I forgot to check the box. So I fixed everything and did it again and am 100% sure I ticked the overwrite box the second time and ended up with the same results. Does anyone know why this could be happening now when it has been working fine for me for years?

1 reply

K
Kurt_M
February 4, 2024

Welcome to the Community, @tom235. We'll share details about importing products and services inside QuickBooks Online (QBO).

 

Before we dig deeper into your query, know that we see the urgency of this matter and ensure we supply you with the details you need to address this situation and remove duplicate products when importing inside the program. Upon checking here on our system, there's an ongoing investigation similar to your situation, and our engineers are aware of it and working on a fix.

 

We recommend contacting our Customer Care Team so they can add you to the list of affected customers, and you'll receive a notification once a troubleshooting is available. We'll write down the steps to get you going:

 

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?).
  3. Select either tab to get started:
  • Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human.
  • Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
    • Start a chat with a support expert.
    • Get a callback from the next available expert.

 

For more details, please see this page: QuickBooks Online Support.

 

Additionally, here's an article to help you learn more about importing data into QBO: Common questions about importing data to QuickBooks Online.

 

Don't hesitate to comment below if you need further assistance managing products and services inside QuickBooks. We'll make sure to be around to help you out again with your queries. Stay safe.

Terms & ConditionsAccessibility statement