Hi, @ducrot64. I appreciate your efforts in looking for a way to batch-edit customer custom fields in QuickBooks Online (QBO) Advanced. I'm here to assist you further 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:
- Select Manage records in your Spreadsheet Sync panel.
- In the Records to create or edit section, choose the Vendors and Customers template.
- Pick the Company from the Company or group dropdown.
- Toggle on Bring in existing records from QuickBooks? and look for the custom field headers and edit them.
- When done, hit Post data to QuickBooks.
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:
- Sign in to your Spreadsheet Sync.
- Select Help.
- Click on Contact Us.
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.
If you have further questions about batch-editing customer records using Spreadsheet Sync to QBO, we'll be here in the Community to help you 24/7. Take care!