Skip to content
Hypamoon

For teams that run on Odoo

Odoo inactive customers: who stopped ordering

Odoo keeps every order per customer, so the history is there. Spotting the regular customer who usually orders every two weeks and has now been quiet for six means filtering orders per customer and comparing dates by hand.

How it goes today

  1. Group the sales orders by customer and by month.
  2. Compare the last order date with how often they usually order.
  3. Keep a list of customers to call in a spreadsheet.
  4. Notice a lost customer only when their revenue is gone.

How it can go

See which regular customers stopped ordering while you can still call.

Every Monday the salesperson gets the customers who usually order regularly and are now overdue by more than their normal interval, with the last order date, their usual rhythm and revenue over the last twelve months, plus customers whose order value dropped by more than the percentage you set. You get the combined list.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Odoo key in the portal, never in the chat.

Your request

With Hypamoon, every Monday, look at the confirmed sales orders in Odoo of the last two years. List the customers who usually order regularly but whose time since the last order is more than one and a half times their normal interval, and the customers whose revenue in the last three months fell by more than the percentage I set. Show the last order date, usual interval and twelve-month revenue, and email each salesperson their customers and me the combined list.

You create an Odoo API key yourself under Preferences, Account Security, for a user with the access you want to give. A key lasts at most three months, so you renew it in the portal. On Odoo Online and Odoo.sh this needs the Custom plan. It stays yours.

More for teams on Odoo