Industries

Know what your customers are buying. And what they’re not.

Order history on every account in HubSpot or Pipedrive, so account managers see who is buying less, who is due to reorder and what else they could buy.

A distribution warehouse with stocked racking, pallets and a forklift

A wholesaler or distributor needs a CRM that shows what every account buys, not just who to call: which customers are ordering less than last year, which are due to reorder, and which product categories they have never bought from you. Flowbird connects HubSpot or Pipedrive to ERPs such as NetSuite, SAP Business One, Microsoft Dynamics 365 Business Central and Sage 200, and to order systems such as Linnworks, so that answer is on the account record. Spend that slips by a few per cent across hundreds of accounts adds up to a material loss long before anyone sees it in the monthly figures.

This page is for wholesalers, importers and exporters, and building materials and other trade distributors.

Illustration

What an account manager could see.

Order history from the ERP, laid out on the account the rep already uses. What appears depends on what your systems hold and the agreed integration design.

Account view: Ashby Building Supplies

Illustration · fictional data

  • Spend, last 12 months£184,200Down 12% on last year
  • Usual order cycle14 daysLast order 31 days ago
  • Open quotes3£22,400 in total
  • Categories bought5 of 8Similar accounts buy 7

Monthly spend, last 12 months

  1. November: £18,400
  2. December: £17,600
  3. January: £18,000
  4. February: £17,200
  5. March: £16,800
  6. April: £16,000
  7. May: £15,600
  8. June: £14,800
  9. July: £14,000
  10. August: £13,200
  11. September: £12,000
  12. October: £10,400

Range bought, against similar accounts

  • Fixings96%
  • Timber82%
  • Insulation64%
  • Tools40%
  • Sealants and adhesives0%

Prompts for the account manager

  • Reorder overdue: usual cycle 14 days, last order 31 days ago
  • Spend down 12% on the same period last year
  • Never bought sealants and adhesives, which 7 in 10 similar accounts buy
  • Insulation quote (£9,800) has had no reply for 12 days
Illustration built from fictional data to show the kind of account view a connected CRM can give. Not a real customer and not a real result.

Why do declining accounts go unnoticed?

Distributors carry hundreds or thousands of accounts and many more product lines. Most accounts order steadily without much attention, which is exactly why a slow decline goes unseen. By the time a customer stops ordering a range, the reason has usually been in the order data for months, while account managers call the customers they know best rather than the ones who are slipping.

How does connecting the ERP fix it?

How it works

Order history on every account, without the export.

  1. Your ERP or order system

    NetSuite, Sage 200, Linnworks or the system you run.

    • Customer accounts and branches
    • Order lines and invoices
    • Product categories
    • Stock and lead times
    • Price lists and account terms
  2. The connection

    • Branches and duplicate accounts matched
    • Order lines grouped by category
    • Updates on a schedule or as orders land
  3. HubSpot or Pipedrive

    • Spend trend by account
    • Reorder due dates
    • Range gaps against similar accounts
    • A task when an account slips
  4. What changes

    • Declining accounts caught early
    • Fewer missed reorders
    • Cross-sell lists reps will use
    • Promotions aimed at the right buyers
Mostly one-way into the CRM: orders, invoices, products, stock and pricing. The ERP stays the system of record. Where agreed, customer accounts and contacts are kept in step both ways. Which records move is set in the integration design.

What does it look like in practice?

Use caseHow the CRM finds itWhat it is worth
Declining accountsSpend this quarter against the same quarter last year, by accountA call while the customer can still be won back
Missed reordersEach customer's usual order cycle, set against their last orderReorders prompted before the customer buys elsewhere
Range gapsOrder lines by category, compared with similar accountsA short cross-sell list for each account manager
One-order accountsFirst and second order dates on the accountNew customers followed up before they lapse
Branches and buying groupsBranch accounts rolled up to the parent, with duplicates matchedOne view of what a customer is worth across every site
PromotionsCustomers who buy the category, and similar customers who do not yetPrice lists and offers sent to the buyers they suit

How do you find cross-sell gaps?

Compare each account with others like it. If most electrical contractors who buy cable from you also buy accessories, the ones who do not are a short, specific call list. The CRM builds that list from the order data and puts it in front of the rep who owns the account. The point is fewer, better calls, not more calls. There is a longer guide to cross-selling from the CRM.

What about stock and lead times?

For importers, exporters and anyone holding long-lead lines, stock shapes every sales conversation. When stock levels and expected arrival dates sit beside the account, a rep can tell a customer when their range will be available instead of promising and hoping, and can line up the reorder before the stock lands.

Which systems does it connect to?

The CRM is HubSpot or Pipedrive. Flowbird has advised on NetSuite and Microsoft Dynamics 365 Business Central integrations, and has connected HubSpot to Sage 200, Sage 50 and Xero, and Pipedrive to Xero and the Linnworks order system. Odoo and other ERPs can be connected where they offer an API, and the discovery call establishes what yours exposes before anything is built. The tool is whichever suits the job: a native connector, Make, n8n, BPA Platform or custom code. Where no off-the-shelf connector reaches the data, we build what it cannot: Flowbird Tunnel for systems on your own servers, and FlowFlex for reporting across sales and finance. Orders, invoices, product categories, stock and price lists reach the account record. See CRM and ERP integration.

The catch is that a link carries the ERP's data across unchanged. Accounts duplicated under different codes, or products with no category, distort every report that depends on them. A CRM data health check finds those before anything is built on them.

What does the business get?

  • Declining accounts caught while there is still time to keep them
  • More repeat orders, because a missed reorder is flagged when it is due
  • More of each customer's spend, from product categories they don't yet buy from you
  • A sales forecast built from real order patterns
  • Stock and pricing to hand, so account managers spend their time selling rather than looking things up

What changes for you: you stop chasing reps for account updates before the sales meeting, because the spend, the trend and the calls are already on the screen.

What comes first?

The Account Growth Audit: free, two weeks and a written report you own. It analyses two years of invoice data exported from your ERP: the accounts buying less than last year, the product groups customers have stopped buying, who is overdue a reorder and where your revenue really comes from. It ends with a plan for connecting your ERP and CRM, so your sales team sees this every day. It is written to take to your managing director or finance director.

If you already know what needs connecting, talk to an integration specialist instead.

To read more first, see what to look for in a CRM consultancy for distributors, or our guides for managing directors.

When is Flowbird not the right fit?

  • There is no ERP or order data to connect
  • You are not on HubSpot or Pipedrive and do not plan to move
  • You have so few accounts that everyone already knows what each one buys

For that stage, the free Data Health Calculator and the Customer Data Clarity Workbook cover most of what you need.

Questions wholesalers and distributors ask

Can the CRM handle thousands of accounts and product lines?

Yes. HubSpot and Pipedrive both hold thousands of company records. The work is in deciding what reaches the CRM: order lines summarised by category and month rather than every line of every invoice, so reps see trends rather than noise.

Can we see branch and head office accounts together?

Yes. Branches can sit under a parent company, so spend rolls up across sites while each branch keeps its own contacts and orders.

Will reps have to enter orders twice?

Not for the records you choose to synchronise. Orders stay in the ERP or order system and the agreed details are copied to the CRM automatically, so reps record calls and visits rather than retyping orders.