How to Search Quote and Search Quote Items – Finding and Managing Quotes in PqW
Learn to efficiently search, manage, and handle quotes and quote items in PqW for better organization and workflow.
Introduction
As quote volumes grow, finding and reviewing specific quotes or individual quote items becomes critical. The Search Quote and Quote Items console in PqW provides a dedicated interface for locating, filtering, and reviewing quotes and their line items across accounts, opportunities, and statuses — without opening each quote individually.
This article explains:
- How to open the Search Quote and Quote Items console
- How to use the Search Quote tab to find and filter quotes
- How to use the Search Quote Items tab to find and filter individual quote items
- What columns and filters are available on each tab
- How search results are grouped and sorted
- Tips for working efficiently with large datasets
This article focuses on navigating and searching. Actions you can perform from the Search Quote grid — such as activating or deactivating quotes — are covered in the article Activate/Deactivate Quotes from the Search Quote Page.
Prerequisites
For Search Quote and Quote Items, make sure:
- You have access to the Search Quote and Quote Items console/tab in PqW. Both Admin and PqW users have access by default.
- You have the appropriate PqW permission sets assigned (StrataVAR PqW for Standard users, or StrataVAR Admin PqW for Admins).
- You understand your organization's quote naming and status conventions, so you can build effective filters.
- If you are unsure about your access, check with your PqW administrator.
Understanding the Console Layout
The Search Quote and Quote Items console contains two main tabs:
Tab |
Purpose |
|---|---|
Search Quote |
Search for and review quotes at the header level — see quote numbers, names, statuses, pricing totals, and creation details. |
Search Quote Items |
Search for and review individual line items across one or more quotes — see part numbers, descriptions, quantities, pricing, and item types. |
Each tab has its own set of server-side filters (at the top) and a results grid (below). In the grid, you can perform certain actions like export, edit the applicable fields, and create new quote/quote items etc.
The server-side filters query the database and return matching records. The results grid supports additional column-level filters for further in-place refinement.
Search Quote- Step By Step Process to Access/ Search
Step 1 – Open the Console
- In Salesforce, open the StrataVAR PqW app.
-
From the App Launcher (9-dots), search for Search Quote and Quote Items and click to open it.
-
Make sure you are on the Search Quote tab.
Step 2 – Set Your Filters
The Search Quote tab provides the following server-side filters at the top:
Filter |
Description |
Default |
|---|---|---|
Account |
Dropdown of all accounts. Supports multi-select. Sorted alphabetically. |
All |
Opportunity / Project |
Shows related opportunities or projects once an Account is selected. Supports multi-select. Sorted alphabetically. The label adapts to your org type (OEM uses Project, others use Opportunity). |
Blank (populates when Account is selected) |
Quote Status |
All available status values from the picklist. Supports multi-select. |
All |
Total Extended List Price |
Numeric filter with operators: Equal, Not Equal, Less Than, Less Than or Equal, Greater Than, Greater Than or Equal. |
— |
Total VAR Cost |
Same numeric operators as above. |
— |
Total Customer Price |
Same numeric operators as above. |
— |
Created Date |
Date range filter (From X to Y). |
All |
Created By |
Dropdown of all users. Sorted alphabetically. |
Logged-in user |


Default behavior: When you first open the tab, the filters are preset to Account = All, Quote Status = All, Created Date = All, and Created By = your user. Results load only after you click the Apply (or Search) button.

To reset filters to the defaults, click Reset Filters.

Step 3 – Review Search Results
After applying filters, the grid displays matching quotes with the following columns:
Column |
Description |
|---|---|
Quote Number |
The system-assigned quote number (e.g., QT-000000102). |
| Quote Name | The user-defined quote name. |
Active |
Indicates whether the quote is currently active. (Added in PqW 3.9) |
| Quote Version | The version number of the quote. |
| Quote Category | The category of quote such as API/ Renewal |
Quote Status |
Current status (e.g., Open, Won, Approved). |
Total Extended List Price |
Sum of list prices across all items (rounded to 2 decimals). |
Total VAR Cost |
Sum of VAR costs across all items (rounded to 2 decimals). |
Grouping: Results are grouped by Account and Opportunity/Project, sorted alphabetically. You can use adjacent arrow to expand and collapse the group as needed.

Sorting: Click any column header to toggle between ascending and descending sort order.

Column Filters: Each column in the results grid also supports its own filter (click the column header's filter icon). Numeric columns support operators like Equal, Not Equal, Less Than, etc. Text columns support Equal and Not Equal.

Step 4 – Take Action on a Quote
From the Search Quote grid, you can:
- Click a Quote number to navigate directly to the quote's header page.
- Activate or Deactivate quotes using the row actions or Active flag column — see the separate article Activate/Deactivate Quotes from the Search Quote Page for full instructions.
- Export the Quotes in Excel
- Refresh the Grid
Search Quote Items- Step By Step Process to Access/ Search
Use this tab when you need to find specific line items — for example, locating all items with a particular part number across multiple quotes, or reviewing pricing for a specific item type.
Step 1 – Switch to the Search Quote Items Tab
-
From the Search Quote and Quote Items console, click the Search Quote Items tab.
-
In Search Quote Items tab, you will see server filters with default value, click on the Apply button to load the data.
Step 2 – Set Your Filters
The Search Quote Items tab provides the following server-side filters:
Filter |
Description |
Default |
|---|---|---|
Account |
Dropdown of all accounts. Supports multi-select. Sorted alphabetically. |
All |
Opportunity / Project |
Shows related opportunities or projects when an Account is selected. Supports multi-select. Sorted alphabetically. |
Blank |
Quote |
When an Account or Opportunity is selected, shows available quotes. Supports multi-select. If Account = All, shows all quotes in descending order. |
— |
Quote Name |
Text filter with operators: Equal, Not Equal, Contains. |
— |
Part Number |
Text filter with operators: Equal, Not Equal, Contains. |
— |
Description |
Text filter with operators: Equal, Not Equal, Contains. |
— |
Item Type |
Dropdown of all item types. Supports Equal and Not Equal. |
All |

Default behavior: Filters are preset to Account = All and Item Type = All. Results load only after you click the Apply button.
To go back to the default settings, click on Reset Filter Option.

Step 3 – Review Search Results
The results grid displays matching quote items with the following columns:
Column |
Description |
|---|---|
Quote Item Name |
The system-assigned item identifier. |
Part Number |
Manufacturer part number or SKU. |
Description |
Item description. |
Quantity |
Number of units. |
Unit List Price |
List price per unit. (Added per enhancement) |
Total List Price |
Extended list price (List Price × Quantity × Term, where applicable). |
Unit VAR Cost |
VAR cost per unit. (Added per enhancement) |
VAR Discount (%) |
Discount percentage applied on the VAR side. |
Total VAR Cost |
Extended VAR cost. |
VAR Margin (%) |
VAR margin percentage. |
Unit Customer Price |
Customer price per unit. (Added per enhancement) |
Total Customer Price |
Extended customer price. |
Item Type |
Classification (e.g., Configurable, Non-Configurable, Service, SaaS). |
Manufacturer Name |
Name of the item's manufacturer. |
VIP Rebate |
VIP payout/rebate amount, if applicable. |
Grouping: Results are grouped by Account, Opportunity/Project, and Quote Number, all sorted alphabetically. Items within each quote group are sorted by Quote Item Number in ascending order.

Column Filters: Like the Search Quote tab, each column supports its own filter with appropriate operators (text columns support Contains; numeric columns support comparison operators).

Tips for Working in Search Quote and Quote Items
- Start broad, then narrow: Begin with a high-level filter (e.g., Account only) and progressively add more filters to zero in on the records you need.
- Use column filters for on-the-fly refinement: After the server returns results, use column-header filters to further slice the data without re-querying.
- Be mindful of large datasets: If your org has tens of thousands of quote items, loading all records at once can slow down the page. Use server-side filters to limit the initial dataset before clicking "Load All."
- Check the right tab: If you need quote-level summaries (totals, status, version), use Search Quote. If you need item-level detail (part numbers, line pricing, item types), use Search Quote Items.
- Reset Default to start fresh: If filters become confusing, click Reset Filter to return to the baseline filter configuration.
Summary
The Search Quote and Quote Items console gives you a powerful, centralized way to locate and review quotes and line items across your entire PqW system. By combining server-side filters with column-level refinements, you can quickly find the exact records you need — whether you're reviewing pricing across accounts, auditing item types, or preparing to take action on a specific quote.
Once you've found what you're looking for, you can navigate directly to quote detail pages, or perform inline actions (such as activating/deactivating quotes) right from the grid.
Related Articles
- Activate/Deactivate Quotes from the Search Quote Page
- How to Add BoM Items to PqW
- How to Apply Server Filters to Filter the Data in the Grid
In this article
- Prerequisites
- Understanding the Console Layout
- Search Quote- Step By Step Process to Access/ Search
- Step 1 – Open the Console
- Step 2 – Set Your Filters
- Step 3 – Review Search Results
- Step 4 – Take Action on a Quote
- Search Quote Items- Step By Step Process to Access/ Search
- Step 1 – Switch to the Search Quote Items Tab
- Step 2 – Set Your Filters
- Step 3 – Review Search Results
- Tips for Working in Search Quote and Quote Items
- Summary
- Related Articles