Skip down to the research record

Product catalog: 7 rules for the weekly forecast

Quota Forecast Editorial Team · Published · 13 min read

A well-organized product catalog streamlines your sales process, reduces errors, and ensures consistent pricing across your organization, according to Microsoft.

Product catalog rules that prevent forecast errors

The seven rules that keep deal line items aligned with forecast totals are product creation, custom properties, access permissions, price logic, taxonomy structure, deal attachment, and financial adjustments. Each rule addresses a specific point where a misconfigured product record can distort the numbers you review in your weekly forecast.

Product creation establishes the base record for every item you sell. Without a clearly defined product entry, your deal line items lack a stable reference point for quantity and unit price. Microsoft describes a well-organized product catalog as a way to streamline the sales process and reduce errors, according to Microsoft.

Custom properties allow you to attach additional data points to a product record beyond the standard fields. These properties can capture internal codes, support tiers, or hardware specifications that your sales team needs to distinguish between similar offerings.

Access permissions control who can create, edit, or delete product records. Restricting these permissions to a small group of administrators prevents accidental changes that could alter pricing or availability across open deals.

Price logic defines how the system calculates the unit price for a product on a deal line item. This includes the default price list assignment and any rules for applying discounts or taxes at the line level.

Taxonomy structure organizes products into families or categories. Check whether your CRM can aggregate revenue by product line for your forecast rollups.

Audit your current product library to ensure every active product has a defined price and is assigned to the correct taxonomy family.

Key takeaways for how to set up product catalog fields for accurate forecast totals

  • Create distinct product records for each version or year of an item, such as adding a new entry for "T-shirt 2025" instead of reusing an older label, as advised by HubSpot.
  • Restrict property creation to users with Super Admin permissions, a requirement specified by HubSpot for managing custom fields.
  • Verify module availability for product families, which Microsoft notes are only available in the Sales Hub app.
  • Check price list associations because the system uses the default price list for calculations when the associated price list lacks a price definition, according to Microsoft.
  • Confirm user edit access, which Freshsales states is provided to all users who have edit access for the products module.
  • Apply financial adjustments by selecting between a discount or a fee when modifying deal line items, an option presented by Freshsales.

Creating and structuring product records

Start by defining how new items enter your system. HubSpot advises creating a new product in your product library and using that product moving forward, rather than reusing an outdated entry HubSpot. Their example illustrates this by suggesting that if you were selling t-shirts and your existing product was called T-shirt, you could add a new product called T-shirt 2025 HubSpot. This approach keeps your catalog current and prevents ambiguity when sales reps attach items to deals.

Microsoft offers a different structural option for organizing these items. According to Microsoft, you can create a standalone product or a product inside a family. This flexibility allows you to group related items under a parent category or keep them independent. However, note that product families are only available in the Sales Hub app Microsoft. If your team uses other modules, this specific grouping feature may not be accessible to them.

Beyond simple grouping, Microsoft states that your product catalog also supports product taxonomy, which lets you create a rich classification of products Microsoft. This taxonomy structure helps categorize items by attributes like type or industry, making it easier to filter and report on specific product groups. When setting up your catalog, decide whether you need this deeper classification or if a simple list suffices for your forecast rollups.

To structure your records effectively, first determine if you need standalone items or family-based groups. If you use Microsoft’s Sales Hub, you can leverage product families and taxonomy for a rich classification Microsoft. If you use HubSpot, focus on creating distinct, versioned products to avoid confusion HubSpot. Ensure every active product is assigned to the correct taxonomy family or standalone status before your next forecast meeting. This setup ensures that when you review deal line items, the products are clearly defined and categorized consistently.

Review your current product library to identify any items that lack a clear structure. For each product, verify if it should be standalone or part of a family. If you are using Microsoft’s Sales Hub, check if the product is assigned to the correct taxonomy classification Microsoft. If you are using HubSpot, ensure you have created a new product for any updated offerings rather than editing the old one HubSpot. This audit helps maintain accuracy in your forecast totals by ensuring every line item references a valid, current product definition.

A filled reference table of product rules by publisher

The table below lists the seven product catalog rules that keep deal line items aligned with your forecast totals. Each row names the publisher and ties the rule to its source.

#RulePublisher Detail
1Product creationHubSpot advises creating a new product in your product library and using it moving forward, such as adding "T-shirt 2025" if your existing product was called "T-shirt" according to HubSpot.
2Custom propertiesHubSpot states that Super Admin permissions are required to create custom properties according to HubSpot.
3Access permissionsFreshsales notes that edit access for this field is provided to all users who have edit access for the products module according to Freshsales.
4Price logicMicrosoft explains that the system uses the default price list for calculations when the associated price list in the opportunity or order doesn't contain a price definition for the product according to Microsoft.
5Taxonomy structureMicrosoft states that your product catalog supports product taxonomy, which lets you create a rich classification of products according to Microsoft.
6Deal attachmentFreshsales describes that clicking Add creates a new product and adds it to your deal according to Freshsales.
7Financial adjustmentsFreshsales indicates that the interface brings up an option to select between a discount or a fee according to Freshsales.

Audit your current product library in your CRM to ensure every active product has a defined price and is assigned to the correct taxonomy family.

Configuring custom properties and permissions

Before you can extend your product catalog with custom fields, verify that your user role holds the necessary administrative rights. According to HubSpot, Super Admin permissions are required to create custom properties. This restriction means that standard sales users or managers without elevated privileges cannot add new data points to the product definition. If your team needs to track specific attributes like hardware SKU numbers or software license tiers, only those with Super Admin access can implement these fields. Creating custom product properties requires Super Admin permissions.

Access to existing product fields operates differently from the creation of new ones. According to Freshsales, the edit access for this field is provided to all users who have edit access for the products module. For the particular field described here, Freshsales grants edit access to users with edit access to the products module. You should audit your team’s module permissions to confirm who can alter product data. Check access to each field your sales reps need to edit. Review field access during your permissions audit.

To maintain data integrity, review who has the ability to change product information. In HubSpot, restrict custom property creation to Super Admins to prevent unauthorized schema changes. In Freshsales, users with edit access to the products module receive editing access to the particular field described here. This approach keeps the catalog structure consistent while allowing necessary updates. Check your current user roles against these requirements before the weekly forecast. If a user lacks the required permission, they cannot perform the action, which protects the catalog from unintended changes.

Recommendation: Verify that your designated administrators hold Super Admin status in HubSpot and that your sales team has edit access to the products module in Freshsales. This ensures that only authorized personnel can alter the product catalog structure and data.

Handling pricing and financial adjustments

Price logic in your CRM determines whether a deal line item pulls the correct number from your catalog or falls back to a generic rate. Understanding how each platform handles missing prices, discounts, and value thresholds prevents silent errors in your weekly rollups.

Default price fallback A missing product price in the price list associated with an opportunity or order triggers calculations using the default price list. Instead, it automatically uses the default price list for calculations. According to Microsoft, calculations use the default price list when the opportunity or order's associated price list has no price definition for the product. You should verify that your default price list contains accurate, current rates for every active product, as this is the safety net your deal totals rely on when specific pricing is missing.

Discounts and fees Review discounts and fees as part of your deal pricing checks. Freshsales offers a choice between a discount and a fee. According to Freshsales, you can choose a discount or a fee. To modify these values after initial entry, you click the button to edit the one-time fees or discounts. According to Freshsales, a button lets you edit one-time fees or discounts.

Value thresholds and calculation properties Some platforms use calculation properties to categorize deals based on total amount, which can influence reporting and forecast segmentation. HubSpot defines these categories using specific numerical thresholds. According to HubSpot, a deal is labeled "Low" when the amount is greater than 0 and less than or equal to 200. According to HubSpot, a deal is labeled "Medium" when the amount is greater than 200 and less than or equal to 5,000. According to HubSpot, a deal is labeled "High" when the amount is greater than 5,000. These thresholds are examples of how calculation properties can segment your pipeline; you should define your own thresholds to match your firm’s revenue reality.

Enterprise pricing examples Pricing logic can also involve tiered or usage-based models. HubSpot provides an example where a customer’s fee changes based on user count and plan tier. According to HubSpot, if a customer reaches 30 users and transitions to Enterprise, the fee would then become $600/month. This illustrates that product pricing is not always static; it can depend on external variables like user counts or plan levels. Check and update deal pricing when a customer's usage or plan changes.

Blank product catalog checklist

Use this worksheet to audit your active product library before the weekly forecast. The goal is to confirm that every product record is correctly structured, priced, and accessible so that deal line items roll up accurately. Start by verifying that you can access the product management area in your CRM. In Freshsales, the products slider is the interface where you can add or edit products according to Freshsales. If you cannot open the products slider, you cannot use that interface for your catalog audit.

Next, confirm that you can create new products directly from a deal context. Freshsales allows you to create an entirely new product to add to the catalog by clicking the Add button according to Freshsales. This action creates a new product and adds it to your deal according to Freshsales. Ensure your team members have the necessary permissions to perform this action without manual intervention from an administrator.

Review your taxonomy assignments. Each product should belong to a defined family or category that supports your forecast rollups. While the specific taxonomy structure varies by platform, the checklist below helps you document the current state of your assignments. Compare your current setup against the rules defined in the reference table earlier in this post.

For each active product, record its structure, price, and access permissions during your catalog audit. Fill in the current state based on your CRM audit and specify the action required to align with the seven product catalog rules.

If a product is missing from the catalog but appears on a deal, investigate how it was added. Freshsales documentation notes that creating a new product from a deal adds it to the catalog according to Freshsales. Verify that these ad-hoc additions have been reviewed and assigned to the correct taxonomy family.

FAQ: How to set up product catalog fields for accurate forecast totals

Do custom product properties appear on line items?

This permission gate controls who can define the custom fields that may appear on product records.

Who can edit product fields in Freshsales?

Freshsales grants editing access to the particular field described here to users with edit access to the products module Freshsales. For this particular field, users with module edit access receive editing access.

What happens if a price list is missing a product price?

Microsoft’s system uses the default price list for calculations when the associated price list in the opportunity or order doesn't contain a price definition for the product Microsoft. This fallback behavior applies specifically to the Set up a product catalog walkthrough context.

Can you create a bundle inside a product family?

This option exists within the product catalog setup process described in their documentation.

How do you add a new product to a deal in Freshsales?

In Freshsales, clicking Add creates a new product and adds it to your deal Freshsales. This action combines product creation and deal attachment in a single step.

Sources