How to Export Multiple Quotes with Refactoring in PqW
Learn techniques for exporting multiple quotes in PqW while streamlining your code through effective refactoring.
Introduction
Once pricing, supplier assignment, and validations are complete, the next step in the quoting process is generating a customer-facing document.
Export Quote in StrataVAR PqW allows you to:
- Generate a PDF or Excel version of the quote
- Apply a selected PqW Template
- Control which sections appear in the exported document
- Share a structured, formatted proposal with the customer
- Export multiple related PqW Quotes into one combined Excel/PDF (Multiple Export Quote), where each quote is exported into its own worksheet(s), depending on the template
This article explains how to export multiple quotes together using the refactored Export Quote experience — including how to enable Multi mode, select additional quotes, configure the export, and understand the underlying rules and limitations introduced as part of the refactoring effort.
For the standard single-quote export process, refer to the Export Quote article.
What Changed with Refactoring?
The Export Quote screen was refactored to support multi-quote selection within the same dialog, replacing the earlier approach where each quote had to be exported individually and merged manually.
Area |
Before Refactoring |
After Refactoring |
|---|---|---|
Export scope |
One quote per export |
Up to 10 quotes per export |
Mode switching |
Not available |
Single / Multi toggle on the same screen |
Quote discovery |
Manual navigation to each quote |
In-dialog search with Active / Current Account / Opportunity filters |
Ordering |
Manual merge in Excel |
Drag-and-drop reorder before export |
Template handling |
Any active template |
Templates must have SupportMultipleQuotes enabled for Multi mode |
Large exports |
Synchronous only |
Asynchronous processing with email notification for large datasets |
Main Quote handling |
N/A |
Main Quote always included; cannot be removed |
When to Use Multiple Export Quote
Scenario |
Why Multiple Export Quote Helps |
|---|---|
Customer needs to compare multiple quote options side-by-side |
All options are combined into one downloadable document |
An Opportunity has multiple related quotes (e.g., Standard + Renewal) |
Consolidates related proposals into a single file |
Sales team needs to present grouped pricing across different configurations |
Each configuration gets its own tab, organized in a single workbook |
Internal review requires all quotes under one Account visible together |
Reduces manual effort of exporting and merging separately |
Prerequisites
Before exporting multiple quotes together, ensure the following:
- Quotes are in exportable state: Pricing is finalized, supplier and Ship-To assignments are complete
- PqW Template supports multi-quote: The template must have SupportMultipleQuotes = checked/true. Templates without this will show an error if used in Multi mode
- Additional quotes exist: At least one other quote must be available under the same Account or Opportunity for multi-selection to be useful
- Total item count ≤ 45,000: The combined total of quote items across all selected quotes must not exceed 45,000 item
Understanding the Refactored Export Quote Screen
To export the quote, click on the Export Quote button in the Quote details page. It will open the Export Quote dialog box as shown.

When the Export Quote screen opens, it defaults to Single mode. To enable multiple export quotes, toggle the Export Mode switch.
Export Mode Toggle
State |
Label |
Behavior |
|---|---|---|
OFF (grey) |
Single |
Standard single-quote export. Shows File Types, Optional Rows, and Optional Columns sections |
ON (blue) |
Multi |
Multi-quote export. Shows the quote selection panel with filter toggles, search bar, and Selected Quotes area |
UI Reference — Single Mode (Image 2): The Export Mode toggle is OFF (grey), labeled "Single." The screen shows Increase Quote Version, Template, File Types (Create Excel / Create PDF), Optional Rows, and Optional Columns sections.
UI Reference — Multi Mode (Image 1): The Export Mode toggle is ON (blue), labeled "Multi." The screen shows the quote selection panel with filter toggles, search bar, Additional Quotes search, and Selected Quotes drag-to-reorder area.
- Quote Information (Header): The dialog title confirms the quote you opened export from. Example, Quote Number and Version — e.g., Export Quote | QT-000000230 (v1)
-
Select Other Quotes to Export (Multi Mode Only): When Export Mode is set to Multi, a quote selection panel appears with the following controls.
- Filter Toggles:
Toggle |
Options |
Behavior |
|---|---|---|
Active |
Active / All Quotes |
When ON: shows only Active quotes. When OFF (All Quotes): shows all quotes regardless of Active/Inactive status |
Current Account |
Current Account / All |
When ON: shows only quotes belonging to the same Account as the Main Quote. When OFF: shows quotes from all Accounts |
Opportunity |
Opportunity / All |
When ON: shows only quotes under the same Opportunity. When OFF: shows quotes from all Opportunities |
- A text label indicates filtering context — e.g., “Additional Quotes (Showing only Standard Quotes)”
- A Search PqW Quotes text field allows searching for quotes by Quote Number or Quote Name. Matching quotes appear in a list and can be clicked to add them to the Selected Quotes area
- Selected Quotes: Displays all quotes selected for export (Main Quote is always listed first)
- Drag to reorder — the order here determines the worksheet order in the exported file
- Click 'x' to remove — any added quote can be removed, except the Main Quote (the Main Quote does not have a remove option, or if attempted, a blocking dialog will appear)
Increase Quote Version
- No (default): Export without changing the version number
- Yes: Increments the quote version before exporting
In Multi mode, this applies to the Main Quote. Version increment for all selected quotes may be supported depending on configuration.
File Types (Single Mode)
When in Single mode, the File Types section appears:
- Create Excel
- Create PDF
Both can be selected simultaneously.
Note: In Multi mode, the file type options may be determined by the selected template configuration rather than manual checkboxes.
Optional Rows and Optional Columns (Single Mode)
When in Single mode, these sections allow fine-grained control of what appears in the exported document:
Optional Rows:
- Total List Price
- Payment Term
Optional Columns:
- Unit List Price
- Extended List Price
- Customer Discount %
Note: The exact list of Optional Rows and Columns may vary by template and organization configuration.
Step-by-Step: How to Export Multiple Quotes
Step 1: Open Export Quote
- Open the Quote details page of the required quote
- Select the Export Quote button on the action toolbar
Step 2: Enable Multi Mode
- Locate the Export Mode toggle at the top of the dialog
- Click the toggle to switch from Single to Multi
- The toggle turns blue and the label changes to Multi and the quote selection panel appears
Step 3: Filter and Search for Additional Quotes
Use the filter toggles to narrow the list:
- Turn ON Current Account to see only quotes from the same account
- Turn ON Opportunity to limit to quotes under the same opportunity
- Turn ON Active to show only active quotes
- Use the Search PqW Quotes field to search by quote number or name
- Click on a quote from the results to add it to the Selected Quotes area
Step 4: Review and Reorder Selected Quotes
The Selected Quotes section lists all quotes to be exported.
- The Main Quote is always present and cannot be removed.
- Drag quotes to reorder them — this order determines the worksheet order in the exported file
- Click the 'x' next to any added quote to remove it
Step 5: Select PqW Template
- Click the Template lookup field
- Search for and select a template that supports multi-quote export
- Ensure the selected template has SupportMultipleQuotes enabled
If you select a template that does not support multi-quote, clicking Export will show an error.
Step 6: Configure Increase Quote Version
- Select No (default) to export without version change.
- Select Yes to increment the quote version.
Step 7: Export
- Click the Export button.
- The system generates the combined document. Each selected quote is exported into its own worksheet(s), following the order in the Selected Quotes list.
- Download the generated file and share it with the customer.
Rules and Behavior of Export
Main Quote Cannot Be Removed
The quote from which the Export Quote screen was launched is the Main Quote. It is always included in the Selected Quotes list and cannot be deselected or removed. If a user attempts to remove it, a blocking dialog will appear.
Maximum Limits
- Maximum quotes per export is 10
- Maximum total quote items across all quotes is 45,000. If the total item count exceeds 45,000, the export may fail or not process.
Worksheet Ordering
The order of worksheets in the exported Excel file matches the order of quotes in the Selected Quotes area. Drag-and-drop to reorder before exporting.
Sheet Name Length
Excel enforces a 31-character limit on worksheet names. If a quote name exceeds this limit, it will be truncated in the exported file.
Template Must Support Multi-Quote
Only PqW Templates with SupportMultipleQuotes enabled can be used in Multi mode. If an unsupported template is selected, the system displays:
"This template does not support export for multiple quotes"
Async Export for Large Datasets
For large multi-quote exports, the system may process the export asynchronously. In this case:
- The export runs in the background
- The user receives an email notification upon completion (success or failure)
- The exported file is attached to the relevant Quote record(s)
Single Mode vs Multi Mode Comparison
Feature |
Single Mode |
Multi Mode |
|---|---|---|
Export Mode Toggle |
OFF (grey) — "Single" |
ON (blue) — "Multi" |
Quotes exported |
Only the current quote |
Main Quote + up to 9 additional quotes |
Quote selection panel |
Not shown |
Shown — with filter toggles, search, and reorder |
File Types section |
Shown (Create Excel / Create PDF checkboxes) |
May be template-driven |
Optional Rows / Columns |
Shown — user selects sections to include |
May be template-driven |
Template requirement |
Any active PqW Template |
Only templates with SupportMultipleQuotes = true |
Output structure |
Single quote in one file |
Each quote gets its own worksheet(s) in one file |
Common Errors and How to Handle Them
Error |
Cause |
Resolution |
|---|---|---|
"This template does not support export for multiple quotes" |
Selected template does not have SupportMultipleQuotes enabled |
Select a different template that supports multi-quote, or ask an Admin to enable it on the template |
Export fails silently or shows "EXCEPTION" |
Template configuration mismatch or corrupt template |
Verify the template is valid; re-upload if necessary. Check Error Logs |
Exported file has incorrect quote order |
Quotes were not reordered before export |
Use drag-and-drop in the Selected Quotes area to set desired order before clicking Export |
Cannot find a specific quote in search |
Filter toggles are too restrictive |
Turn OFF the Active, Current Account, or Opportunity toggles to broaden the search |
Export times out or does not complete |
Total item count across selected quotes exceeds 45,000 |
Reduce the number of quotes or export in smaller batches |
Sheet names are truncated |
Quote name exceeds Excel's 31-character sheet name limit |
Shorten the quote name, or accept truncation (this is an Excel limitation, not a PqW limitation) |
Summary
The refactored Multiple Export Quote capability in StrataVAR PqW enables users to combine multiple related quotes into a single, professionally formatted Excel or PDF document — each quote in its own worksheet(s) — all from one unified Export Quote screen.
Key Takeaways:
- Toggle Export Mode to Multi to enable multi-quote selection
- The Main Quote is always included and cannot be removed
- Use filter toggles and search to find and add additional quotes
- Drag-and-drop to control worksheet order in the exported file
- Only templates with SupportMultipleQuotes enabled work in Multi mode
- Maximum 10 quotes and 45,000 total items per export
- For large exports, the system may process asynchronously with email notification
This refactoring eliminates the manual effort of exporting and combining individual quotes — delivering a single, consistent document aligned with template standards.
In this article
- Introduction
- What Changed with Refactoring?
- When to Use Multiple Export Quote
- Prerequisites
- Understanding the Refactored Export Quote Screen
- Export Mode Toggle
- Increase Quote Version
- File Types (Single Mode)
- Optional Rows and Optional Columns (Single Mode)
- Step-by-Step: How to Export Multiple Quotes
- Step 1: Open Export Quote
- Step 2: Enable Multi Mode
- Step 3: Filter and Search for Additional Quotes
- Step 4: Review and Reorder Selected Quotes
- Step 5: Select PqW Template
- Step 6: Configure Increase Quote Version
- Step 7: Export
- Rules and Behavior of Export
- Main Quote Cannot Be Removed
- Maximum Limits
- Worksheet Ordering
- Sheet Name Length
- Template Must Support Multi-Quote
- Async Export for Large Datasets
- Single Mode vs Multi Mode Comparison
- Common Errors and How to Handle Them
- Summary

