Update your account for the Ferguson Product and Pricing Integration

Prev Next

Overview

ServiceTitan has introduced new enhancements to the Ferguson Product and Pricing Integration to help you manage pricing and purchasing more accurately. These updates improve how your Ferguson accounts and catalog items connect to ServiceTitan. Review and update your Ferguson integration setup to take advantage of the improvements.


Who uses this feature

  • Office employees

  • Applies to all business types

Benefits

With the updated Ferguson integration, you'll benefit from:

  • Multi-account mapping: Support for multiple Ferguson Main accounts in your ServiceTitan account.

  • Flexible catalog mapping: Easier linking of Ferguson catalog items to your pricebook, including flexible equipment/material categorization.

  • Contract pricing: If applicable, HVAC contractors can now receive their Ferguson contract-specific pricing directly in their pricebook.

Step 1: Update your Ferguson account mapping

ServiceTitan migrated your Ferguson Main Account to the new mapping format. During account mapping, verify that your Account Number and Zip Code are correct in Step 2.

  1. Go to the top toolbar and click Settings.

  2. In the side panel, click Integrations > Vendor Integrations.

  3. On the Vendor Integrations screen that opens, click Full ProcurementUser interface showing vendor integrations with highlighted 'Full Procurement' option.

  4. Select Ferguson and review the Integration Setup.

If your business works across multiple trades and uses more than one Ferguson Main account, you can map each account directly within ServiceTitan.

  1. In the Map Account step, review your existing Main Account. If you have additional Main Account Numbers, they will appear in this step.

  2. Map each account to the correct Business Units or Trucks & Warehouses.

  3. When finished, click Activate.

Step 2: Review and remap your pricebook items

ServiceTitan has introduced a more flexible catalog and contract pricing model. This new model ensures:

  • Flexible mapping: Ferguson has duplicated certain items across Equipment and Material categories to give you full control over how you classify items in your pricebook.        

    • You'll now see some items added in both the Equipment and Material categories—each with its own SKU—so you can select which version aligns best with your pricebook structure.

    • This lets you map items you used to manage manually so they'll now automatically get content and cost updates.

  • Contract pricing: If you have contractual pricing with Ferguson, the integration now provides your lowest contract price automatically, based on your Ferguson account credentials.        

    • Items you manually created to maintain contract pricing can now be mapped directly from the Ferguson catalog to your pricebook. When mapped, these items automatically receive your contract-specific pricing.

Upload purchase history for unmapped items

Remap any manually created items that were affected by Equipment/Material category type or contract pricing differences.

Caution: If you see inflated costs caused by unit of measure differences between the Ferguson catalog and your pricebook, continue managing those items manually. Only these specific items require manual cost management going forward.

Export your pricebook

  1. Go to the navigation bar and click Pricebook > Import/Export.

  2. On the Import / Export screen that opens, click the Export tab. User interface showing export options for pricebook and business unit selection.

  3. From the Export Type dropdown, select Pricebook (Settings, Materials and Part Link).

  4. Select a Business Unit (BU) from the dropdown to export all items assigned to categories linked to that BU.

  5. When finished, click Export.

Get Vendor Part Numbers (VPNs)

  1. Open the exported XLSX file in a spreadsheet application.

  2. Go to the Materials or Equipment tab.

  3. Locate the column Ferguson [vendor] part #.

  4. Use this list of Vendor Part Numbers (VPNs) to complete the purchase history template in the next step.

Note: This process only works if Vendor Part Numbers are already identified in your pricebook. If Vendor Part Numbers are missing, contact technology.solutions@ferguson.com to retrieve your purchase history and VPNs. Alternatively, you can manually locate the information in your pricebook.

Upload your purchase history

  1. Go to Pricebook > Pricebook Connect > Catalogs.

  2. Select Ferguson and click Upload Purchase History.

  3. In the Import File step, click Download Template to download a sample Excel file.

  4. Copy and paste all Vendor Part Numbers from your Exported pricebook file into the Import Purchase History template.

  5. Follow the Import Purchase History steps to review Supplier Matches and then map those items from the Ferguson catalog to those items you previously created manually in your pricebook.        

    Note: Example: You can now map items categorized as Materials or those with manually managed contract pricing, as updates will now flow automatically.

Instructions for importing purchase history with file upload and template download options.

Step 3: Enable catalog updates

When your mapping is complete, turn Auto Updates on to keep your pricing and catalog data current.

  1. Go to Pricebook > Pricebook Connect > Updates.

  2. On the Updates screen, click the Provider dropdown and select Ferguson.

  3. Review your available updates. If your account includes contract pricing, you'll see those updates listed here.

  4. Click Auto to manage update settings.

  5. Choose Auto Update for fields you want to update automatically.

  6. When finished, click SaveUser selects 'Auto Update' option in ServiceTitan Supplier settings interface.

You can view automatic and manual updates/dismissals in the History Log. See Update your pricebook with Pricebook Connect for more information.

FAQ

What if I have multiple Ferguson accounts?

You can now map multiple Main Accounts directly in ServiceTitan. Go to Settings A simple icon representing a settings gear. > Integrations > Vendor Integrations and map them to your Business Units or Warehouses.

What if I have the item set up in my Pricebook as ‘equipment’ and the vendor has it listed as ‘material’ or vice versa?

Ferguson offers flexible catalog mapping across both categories. You can map an item to the category that fits your Pricebook structure.

What if my costs show up as $0?

A $0 cost appears in the vendor catalog in Pricebook Connect until mapped or added to your Pricebook. If you still do not see the cost for these items, please follow the following steps:

  • Make sure the vendor is set as the default vendor for those items.

  • Check Pricebook Connect > Updates > Settings to make sure the Update settings are set up correctly (ie. not set to Auto Dismiss).

  • Item costs sync to the pricebook overnight. Allow up to 24 hours for costs to update after adding or mapping items.

Additional resources