Bulk Update Salesforce Quotes: How to Save Hours a Week

To bulk update Salesforce quotes, use list view inline editing for up to 200 records or Data Loader for larger volumes. If your organization uses a supported custom quote object, you may use the Data Import Wizard. The wizard does not support standard Quote or Quote Line Item objects.

Select a method based on the number of records, whether Quote Line Items need updating, and if the quote is synced with an opportunity.

List view inline editing allows you to update multiple records at once. Filter the list, select up to 200 records, click the pencil icon next to an editable field, enter the new value, and apply it to all selected records.

In Lightning Experience, inline editing is available only when the object, field type, page layout, and user permissions support it. Users must have Edit permission on the object and access to the field.

List view inline editing is not available for Long Text Area fields, controlling or dependent picklists, or when selected records have different record types.

If list view inline editing is not supported, use report inline editing to update supported fields directly from a report.

Use a schedule-triggered Flow to automate recurring quote updates when you identify target records with filter conditions. A schedule-triggered Flow can query up to 50,000 records and process them in batches of up to 200 (configurable from 1 to 200). Salesforce limits schedule-triggered Flow interviews to 250,000 per 24 hours or 200 times the number of eligible user licenses, whichever is greater. Each record retrieved by the flow creates one interview.

For recurring updates that exceed these limits or require complex processing, use Batch Apex, Data Loader, or another scalable integration solution.

Use Data Loader to update more quotes than list-view editing allows or when you require a repeatable, file-based process.

Follow these steps:

The Record ID identifies which quote Data Loader updates. Unlike an import, Data Loader matches each CSV row to an existing Salesforce record using the Record ID. If the Record ID is missing or invalid, Data Loader cannot update the record. If your CSV contains the Record ID of a different record, Data Loader updates that record instead.

Some quote fields are calculated automatically and cannot be updated directly. To change these values, update the underlying records or fields Salesforce uses for calculation.

If your source system uses a unique identifier, create an External ID field and use the Upsert operation. Upsert matches records by External ID instead of the Salesforce Record ID. You can designate Text, Number, Email, or Auto Number fields as External IDs. Mark the field as Unique to prevent duplicate matches.

Note for Salesforce CPQ users:

• Salesforce CPQ stores quotes in SBQQ__Quote__c and quote lines in SBQQ__QuoteLine__c. Updates with Data Loader don’t run the Quote Line Editor, so price rules, discounts, and quote totals may not recalculate. Recalculate affected quotes after the update.
• The SBQQ__Quote__c object is custom, so you can use the Data Import Wizard if it meets the requirements. For large data loads, Salesforce recommends Data Loader.
• The Calculating Fields field set controls which field changes trigger recalculation. If you update a field outside this set, Salesforce CPQ doesn’t recalculate pricing or quote totals. Update a field in the set or add the required field if recalculation is needed.
• Test bulk updates in a sandbox before updating production. For large CPQ updates, use smaller batches because recalculating many quotes at once can increase processing time and may hit Apex governor limits or timeouts depending on your CPQ configuration.

Most articles about bulk updating Salesforce quotes focus on the Quote record. Sales teams often need to update Quote Line Items like quantities, discounts, unit prices, service dates, or other fields across multiple products on the same quote.

Salesforce supports inline editing in list views and reports, but Quote Line Item (QuoteLineItem) records lack a native list view with spreadsheet-style editing. Quote line items appear as a related list on the Quote record, so Salesforce does not provide a native grid to review and edit multiple quote line items at once.

Salesforce offers several ways to update QuoteLineItem records in bulk, including Data Loader, Flow, and the API. However, these tools are designed for administrative tasks, not quick updates by sales reps during quoting.

Edit Salesforce quotes and quote line items in bulk from Excel or Google Sheets with XL-Connector. Skip CSV exports, record ID matching, and Data Loader imports. Update records in a spreadsheet while Salesforce permissions, validation rules, flows, and Apex run.

The Data Loader can update QuoteLineItem records, but the process involves multiple steps. Users must export records, retain record IDs, prepare a CSV file, map fields, and import updates back into Salesforce. Salesforce recommends backing up data and testing updates in a sandbox before updating production.

Choose the update method based on the number of records. Use list view inline editing for small updates and Data Loader for larger or recurring changes. Before bulk updating, export a backup and use record IDs to match the correct records.

Quote Line Items need a different approach. Use Data Loader to update standard QuoteLineItem records. If you use Salesforce CPQ, recalculate affected quotes after updating SBQQ__QuoteLine__c records to keep prices, discounts, and totals accurate.