cancel
Showing results for 
Search instead for 
Did you mean: 
cornerstone-plum
Level 1

Can I change multiple customers info at one time in QBs online?

 
18 Comments 18
Kirill - CloudBusiness LLC
Level 3

Can I change multiple customers info at one time in QBs online?

Hello, 

  As a workaround, you can use third party app to update multiply customers at a time, for example Business Importer,

  It works with .csv and .xlsx files and will help you to update everything properly. That will definitely save you a lot of time!

ShiellaGraceA
QuickBooks Team

Can I change multiple customers info at one time in QBs online?

Hi there cornerstone-plum,

 

In addition to Kirill - CloudBusiness LLC's post, you can export the customer's information to MS Excel. Then, re-import to edit multiple customers. I'll help you with the steps.

  1. Click Sales, and then click Customers.
  2. Click the Export icon beside the Print icon.
  3. An MS Excel Spreadsheet will open, edit the customer's information and then Save.
  4. Once you're done, go back to your QuickBooks account and then click Gear.
  5. Click Import Data under Tools.
  6. Click Customers. Then, click Browse to locate the saved MS   Excel file.
  7. Click Next and then Map your data correctly. Click Next.
  8. Before importing, un-checked the customers that has no changes to avoid duplicate entries.
  9. Click Import.

Feel free to read this article for more information: Move your lists to QuickBooks Online.

 

This article will also help you for future reference: Create and manage statements.

 

Leave a post anytime if you have other questions. We're always here to help you.

export1.JPGexport2.JPG

thebehive
Level 1

Can I change multiple customers info at one time in QBs online?

This solution doesn't actually work, QBO won't let you override data for a customer that already exists in the system. See screenshot from help article.

 

Unless I'm missing something? The error message that fires is:

"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.", with the highlighted field being my customer names.

Kristine Mae
Moderator

Can I change multiple customers info at one time in QBs online?

You're right, Thebehive. You're unable to override the customer data. Thus, the error message. 

 

You'll have to manually change the customer's info one at a time. Here's how:

  1. Click Sales.
  2. Go to the Customers tab.
  3. Select the customer, then click Edit.

I know it's convenient to edit customer info by batch. I'll share your concern to our management team. This will be submitted to our software engineers for review.

 

If you have additional questions, feel free to let us know. 

gsb06
Level 2

Can I change multiple customers info at one time in QBs online?

Is this still an issue in QBO? 

thanks 

Jovychris_A
Moderator

Can I change multiple customers info at one time in QBs online?

Hi gsb06.

 

Currently, the feature to update multiple customers' info all at once is unavailable in QBO.

 

Though, you can follow the steps given by my colleague, Kristine Mae, in changing the customer's info manually one at a time.

 

In the meantime, I'd like you to visit our blog site to stay current with our products and feature updates in QBO.

 

You can always place a comment here if you have more questions. I'll be right there to help. Take care!

Fiat Lux - ASIA
Level 15

Can I change multiple customers info at one time in QBs online?

@gsb06 

You may export your Customer List data to XLS, modify them, and reimport back to replace the old one.

https:// transactionpro.grsm.io/qbo

 

NeedingGuidancePls
Level 1

Can I change multiple customers info at one time in QBs online?

I'm systematically going through customers A-Z to add tags, or add notes etc..

 

When I get mid alphabet, hit save and then go back to customer list, it reverts back to A. Meaning I have to scroll down to the bottom of the screen hit "Next" (page), then scroll down AGAIN to the bottom of the screen, and hit "Next" (page) to get back to where I was in the list.

 

Is there anyway to get around this?

LieraMarie_A
QuickBooks Team

Can I change multiple customers info at one time in QBs online?

I've got your back, @NeedingGuidancePls.

 

You can expand the customer's list from the left navigation bar. This allows you to select any customer with ease.

 

Here's how:

  1. Go to the Sales menu and select Customers.
  2. Select any customer's name.
  3. Click the right arrow beside the customer's name to expand the list.
    Capture.PNG
  4. From there, you can scroll down and select the customer you need to update the information of.
  5. Click Edit.
    Capture.PNG

 

Doing this will help you save more time as you won't need to scroll back and forth.

 

I've included some articles here that you can use when managing other list elements such as accounts, terms, classes, products, or services:

 

Let me know if this helps you in editing your customers' list. I'm always here to help you some more.

gennieosg
Level 3

Can I change multiple customers info at one time in QBs online?

I had this function in my QB desktop and I am extremely confused as to why it's not in the online version. We lost some major functionality when we transitioned from desktop to online and this is one of the more shocking ones. I have over 1,000 customer records/projects for one client and now that the contact person has changed I have to manually edit every single one? This is not only frustrating, it makes me sad. Please bring this function back, thank you. 

gennieosg
Level 3

Can I change multiple customers info at one time in QBs online?

I still cannot edit multiple customers/jobs at once. The desktop version had a function where you could search for a customer and all entries for them would come up, then you were able to change the information (like a contact name or address) and "copy down" to all other entries listed in an excel-like format. The accounting contact changed again for one of our clients and I am once again faced with either editing more than 1,000 entries manually (which entails finding the job, opening the edit field, changing & saving and then searching for the next one because for SOME REASON every time I save something the customer list goes blank and I have to search again) OR trying to remember to manually edit the contact name before I send out each invoice. This is so inconvenient and ridiculous, I just don't understand how this function was not carried over from the desktop version. Please bring this back to QB. 

RoseJillB
QuickBooks Team

Can I change multiple customers info at one time in QBs online?

Thank you for choosing QuickBooks Online (QBO) for your business, @gennieosg. We valued your time and opinion on having this feature in QBO.

 

Rest assured our product developers are always open to any suggestions from customers who want to add features and improve our products.

 

I suggest sending feedback straight to our product developers to add this feature in QBO.

 

Here’s how you can add your feedback:

 

  1. Go to the Gear icon.
  2. Under the Profile column, click on Feedback.
  3. Share your feedback. Then, click "Next."

 

I also suggest you utilize a third-party application that allows you to edit bulk profiles in QBO.

 

You can visit the QBO app store and choose your preferred application to help you with editing multiple customer records and projects.

 

Let me know if you need further assistance with editing multiple customer records. I’m just one post away. Have a great day!

Ammar100
Level 1

Can I change multiple customers info at one time in QBs online?

I need more understanding on it. I shall be grateful if you can share a tutorial for this work

AbegailS_
QuickBooks Team

Can I change multiple customers info at one time in QBs online?

Thanks for joining the thread, @Ammar100.

 

Can you please tell me more about the details of what you're trying to accomplish while working with your QuickBooks Online account? Any additional information you can provide me will help to ensure a timely solution.

 

 I'll keep an eye on your response and make sure to get back to you with any concerns you may have. Keep safe!
 

Ammar100
Level 1

Can I change multiple customers info at one time in QBs online?

Dear I want to edit already added customers at once.

JessT
Moderator

Can I change multiple customers info at one time in QBs online?

,Hi Ammar100,

 

Thank you for clarifying your concern. I'll be happy to continue to help you.

 

If you're using QuickBooks Desktop, you can edit your customer profiles in batches using these steps:

 

  1. Click the Lists menu and select Add/Edit Multiple List Entries.
  2. From the List drop list, select Customers.
  3. From the View drop list, select All Customers or only choose the active ones.
  4. Click the cell/s of the customer that you want to edit and enter the details you want to put in, and do the same thing to other cells and for the rest of your customers.
  5. Click Save Changes.

 

If you're on QuickBooks Online, you're unable to edit customers in batches. That's why we suggest sending feedback to our developers so this will be considered in future updates.

 

We're just right here if you need more help with your customers' list. Take care and have a good one!

Iceguy
Level 1

Can I change multiple customers info at one time in QBs online?

I was able to edit all customers using Transaction Pro.   I exported the entire customer list... did the edits... then re imported the list.

MGrechniw
Level 1

Can I change multiple customers info at one time in QBs online?

Its amazing that an outside app can figure out how to batch edit customers but Quickbooks online can not.  They had it available in desktop so what is the problem with online?  They want to get rid of desktop but it is a much better product than the online version.  Why get rid of a good product and not spend time making sure the only option available is atleast as good as desktop.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us