cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
qbo16
Level 1

How do i import a new list of products and services and delete the old/current list? current list is messed up with lots of duplicates, we need to re-import a new file

will the current list of products be overwritten or will it create more duplicates when a new csv list is imported?
3 Comments 3
LieraMarie_A
QuickBooks Team

How do i import a new list of products and services and delete the old/current list? current list is messed up with lots of duplicates, we need to re-import a new file

Hi there, @qbo16. I've got some information about handling products and services in QuickBooks Online.

 

Yes, you can import and overwrite the existing name items with new prices and other changes if you need. Before doing that, you'll have to delete the duplicates.

 

Here's how:

  1. Go to the Gear icon.
  2. Click Products and Services.
  3. Mark the items you'd like to deactivate.
  4. Click the Batch actions drop-down.
  5. Select Make inactive.
  6. Click Yes.

 

After that, you can import the file and overwrite the existing data to apply the changes. Here's how:

  1. On the Products and Services page, click the New dropdown arrow.
  2. Select Import.
  3. Click Browse to upload the file from your computer. Choose the file, and then select Open.
  4. Select Next.
  5. Map your information. Your Field represents the headers on your spreadsheet. From each drop-down menu, select the one that matches a field in QuickBooks Online.
  6. Select Next.
  7. If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
  8. Select Overwrite all values for each product or service with the same name. Make sure everything looks correct because this can't be undone.
    Capture.PNG
  9. Select Import.

 

As another option, if your account is less than 90 days old, you have the option to delete all your data and start from scratch. This feature is available to QuickBooks Online Plus or Essentials subscriptions. 

 

I'm always right here if you need further assistance with getting all your items entered into QBO. I'm happy to help.

Overwriting products per SKU
Level 1

How do i import a new list of products and services and delete the old/current list? current list is messed up with lots of duplicates, we need to re-import a new file

Can I overwrite based on the SKU instead of the "same name"?

RoseJillB
QuickBooks Team

How do i import a new list of products and services and delete the old/current list? current list is messed up with lots of duplicates, we need to re-import a new file

Hi there, Overwriting.

 

I can see that you posted a similar concern to the other thread where my colleague has already outlined her answer. If you’re not yet notified of her response, you can go to this link for it: https://quickbooks.intuit.com/learn-support/global/other-questions/re-inventory-tracking-of-same-pro...

 

Please let me know if you have more concerns with any QuickBooks-related matters. The Community always has your back. Have a good one!