Detect new orders
The workflow checks ERPNext every 3 minutes for newly submitted Sales Orders.
LIVE WEBINAR · 18 NOV: Make your SAP Business One ready for Black Friday — live demo 18 November. Save my seat
Use AI to predict each customer's next reorder date from ERPNext sales order history, update the matching HubSpot contact and add a call task for large orders
Apps used in this template
About this template
Repeat buying patterns sit in ERPNext, so sales and marketing teams working in HubSpot can't see when a customer is likely to reorder. This template checks ERPNext every 3 minutes for new submitted Sales Orders, has OpenAI predict each product's next reorder date from 12 months of order history (at least three purchase dates needed), and writes the reorder date, likely product and latest order value to the matching HubSpot contact.
Key benefits
Inside the flow
Every 3 minutes, the workflow picks up new ERPNext Sales Orders, pulls each customer's order history and has OpenAI estimate the next reorder date per product. It then updates the HubSpot contact with the same email and creates a call task when the latest order is above a set value.
The workflow checks ERPNext every 3 minutes for newly submitted Sales Orders.
It reads the customer's email from the ERPNext Customer record and skips customers without one. Several orders from the same customer in one run are handled once.
It retrieves the customer's submitted Sales Orders with products, order dates and values, and groups them by customer and product. The most recent new order becomes the reference order.
OpenAI looks at each product's purchase dates over the last 12 months, works out the typical gap between orders and estimates the next reorder date. Products need at least three purchase dates, and customers with no prediction stop here.
It finds the HubSpot contact with the customer's email and updates the reorder due date, likely product and latest order value. If no contact matches, nothing is created or changed.
When the latest order is above the set value threshold, it creates a high priority call task linked to the contact and due on the predicted reorder date.
Reorder timing from ERPNext, ready for sales and marketing in HubSpot
01
Buying patterns from ERPNext reach HubSpot automatically, so sales and marketing see when each customer is likely to reorder without opening the ERP.
02
Marketing gets a timing signal per customer, so lists and campaigns can follow real buying rhythms instead of one schedule for everyone.
03
Customers approaching a likely reorder are visible early, so your team can reach out before they buy elsewhere.
04
Reorder dates come from actual orders over the last 12 months, and only products with at least three purchase dates are predicted, which avoids guesses from thin data.
05
Larger orders create a high priority call task, so account owners know who to call and when.
01
Buying patterns from ERPNext reach HubSpot automatically, so sales and marketing see when each customer is likely to reorder without opening the ERP.
02
Marketing gets a timing signal per customer, so lists and campaigns can follow real buying rhythms instead of one schedule for everyone.
03
Customers approaching a likely reorder are visible early, so your team can reach out before they buy elsewhere.
04
Reorder dates come from actual orders over the last 12 months, and only products with at least three purchase dates are predicted, which avoids guesses from thin data.
05
Larger orders create a high priority call task, so account owners know who to call and when.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every trigger and action this template uses is available in the appse ai builder, so the same flow can be rebuilt with your own routing, thresholds and destinations.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.