cancel
Showing results for 
Search instead for 
Did you mean: 
ducrot64
Level 1

Can I batch edit customer custom fields in QBO Advanced?

This was easy to do in QBDT but I can't find that capability in QBO, not even in Spreadsheet Sync or Import Data. Am I missing it?
1 Comment 1
AlverMarkT
QuickBooks Team

Can I batch edit customer custom fields in QBO Advanced?

Batch editing customer custom fields is indeed useful in QuickBooks Desktop QBDT, @ducrot64, and I can understand why you're looking for a similar feature in QuickBooks Online (QBO) Advanced. While QBDT and QBO have different functions and capabilities, I'm here to provide the options available and point you in the right direction.

 

Did you try using record templates to achieve your goal? Record templates are used as a format to import data to Spreadsheet Sync to QBO Advanced, and we can utilize the Vendors and Customers template. Just in case you haven't done it yet, you can follow these steps:

  1. Select Manage records in your Spreadsheet Sync panel.
  2. In the Records to create or edit section, choose the Vendors and Customers template.
  3. Pick the Company from the Company or group dropdown.
  4. Toggle on Bring in existing records from QuickBooks? and look for the custom field headers and edit them. 
  5. When done, hit Post data to QuickBooks.
    Spreadsheet Sync.png

 

For more details, check out this article: Import data using Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

 

If you performed the above steps and still need further technical help, I encourage contacting our Spreadsheet Sync Support team. Here's how you can reach out to them:

 

  1. Sign in to your Spreadsheet Sync.
  2. Select Help.
  3. Click on Contact Us.
    Spreadsheet Sync Contact Support.png

After this, you might need to pull up information about the things you buy and sell, refer to this guide: Use reports to see your sales and inventory status in QuickBooks Online.

 

We want to ensure we are assisting you every step of the way in the Community. If you have any additional questions batch editing customer custom fields in QBO Advanced, feel free to click on the Reply button. Have a great day!

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

Need to get in touch?

Contact us