From WhatsApp and Email to One Deal Record: Designing Enquiry-to-Order in Odoo

Illustration showing how trading businesses move from manual operations using spreadsheets and documents to a connected Odoo ERP system with a shared database.

Key takeaways

  • Most of TAM Trading’s business communication ran through WhatsApp and email. The fix starts with logging every enquiry on one record, not with banning chat apps.
  • Odoo 19 can create leads from an email alias, schedule follow-up activities, set quotation expiry dates and send WhatsApp messages from records [1][2][3][4].
  • For TAM, we designed an enquiry record with mandatory fields, a 7-day quotation clock with escalation on days 3, 5 and 7, and automatic closure after 30 days without activity.
  • A digital version of TAM’s existing pre-sales review form makes Sales, Supply Chain and Finance check each deal before a quotation is drafted.
  • An uploaded customer PO is compared with the approved quotation. A different product, packaging or Incoterm blocks the order.

Overview

At TAM Trading, enquiries arrived by WhatsApp and email. Some were entered into a system late, some not at all, and nobody could see which leads were waiting for a reply. After a quotation was sent, there was no reminder to follow up, so deals sat idle while customers bought from faster competitors. The TAM Trading case study gives the background to this project, and trade terms used here are defined in our trading and distribution glossary.

Messaging apps are fast and spreadsheets are flexible. The trouble starts as volume grows, when nobody can see the whole deal.

This article explains the enquiry-to-order design we documented for TAM, which kept the useful parts of the existing process and added the missing controls. It also shows which parts standard Odoo 19 covers. It describes the agreed design, not results from a live system.

Signs a trading business has outgrown chat and spreadsheets

SignWhat it looks like in a trading business
Work is too complex for spreadsheetsSeveral warehouses, currencies and landed costs cannot be tracked reliably in Excel
Admin grows faster than salesEach new customer or supplier adds hours of manual matching
Manual updates cause errorsSales quotes stock the warehouse cannot ship
Decisions wait for reportsManagers see last month’s numbers, not today’s
Every step needs a personNothing moves without an email, call or WhatsApp message
Five signs a trading business has outgrown spreadsheets

If three or more of these apply, adding more people rarely fixes it. The problem is that each deal is spread across many places.

Step 1: log every enquiry the same way

Leads come in by email, WhatsApp, phone, exhibitions and referrals. In TAM’s design, every enquiry gets a system-generated number and the same mandatory fields: customer, contact person, country, industry, product, quantity, packaging, Incoterm, assigned salesperson and a summary of the requirement.

Customer RFQs are uploaded as PDFs only, with automatic version numbers. The latest version is highlighted and used everywhere downstream, so nobody prices an old request by mistake.

How to capture leads in Odoo 19

Odoo’s CRM can create a lead automatically from every email sent to a sales team address [1]:

  1. In CRM › Configuration › Settings, tick Leads.
  2. Go to CRM › Configuration › Sales Teams and open a team.
  3. Set an Email Alias, for example [email protected], and choose who can send to it.
  4. Every email to that address becomes a lead, with the message kept in the lead’s chatter.
Sales team email alias setting in Odoo 19 CRM
The email alias on a sales team in Odoo 19 [5].

Enquiries that arrive by phone or at exhibitions are entered by hand on the same form, so every lead has the same fields.

Step 2: a clock on every enquiry

A 7-day quotation clock starts when the enquiry is logged:

DayWhat happens
Day 3Alert to the salesperson, by email and WhatsApp
Day 5Escalation to the reporting manager
Day 7Escalation to the Commercial Head, and the enquiry turns red on the management dashboard
Day 25 without activityFinal warning to the salesperson
Day 30 without activityEnquiry closed automatically as Lost
Seven-day quotation clock: enquiry logged, alert on day 3, manager on day 5, Commercial Head on day 7, closed as Lost on day 30
The 7-day quotation clock in the TAM design.

What Odoo 19 gives you for follow-up

  • Activities. Any lead or quotation can carry a scheduled activity with a due date and a responsible user. Overdue activities show in red in the pipeline and in each user’s activity list [2].
  • Quotation expiry. Each quotation has an Expiration date, and quotation templates can set it automatically after a number of days [3].
  • Automation rules. Escalations such as “notify the manager when an enquiry has no quotation after 5 days” need automation rules on top of the standard features.
Scheduling an activity on a CRM lead in Odoo 19
Scheduling a follow-up activity on a lead [5].

TAM’s proformas were designed with a 7-day validity, after which they need authorised reactivation.

Expiration field on an Odoo 19 quotation
The expiration date on a quotation [5].

Step 3: the pre-sales review becomes a system step

TAM already used a paper pre-sales review form, TAM-F-004. In the design, the system creates a digital version as soon as the RFQ is uploaded and fills it with data from the other modules:

  • Supply Chain: stock on hand, incoming shipment ETAs, batch restrictions
  • Procurement: latest supplier price, lead times, container constraints
  • Finance: credit eligibility, exposure against the limit, overdue status

Quotation actions stay disabled, with a red “Pending Internal Checks” label, until the review is complete. Large corporate accounts handled directly by management skip the review, but their quotations still need approval from the CEO or Commercial Head. At this review, the deal also carries its landed cost on every deal, the credit checks before the quotation and the stock and incoming cargo at the review.

Keeping the form the team already knew made adoption easier. The difference is that the data now comes from the system instead of being copied by hand.

How the review can work in Odoo

Standard Odoo does not include a pre-sales review form, so it is configured or developed. A common approach:

  1. Add a review section to the quotation or opportunity, with a part for each department.
  2. Fill the Supply Chain and Procurement parts automatically from stock, incoming receipts and the latest purchase prices.
  3. Give each department a scheduled activity to complete its part, so overdue reviews are visible.
  4. Keep the quotation in a blocked state until all parts are complete, unless the customer is on the exempt list.

The result is the same form the team used on paper, but nobody has to chase three departments by email to fill it in.

Step 4: check the customer PO against the quotation

When the customer sends a PO, Sales uploads it as a PDF with automatic versioning. The system compares it with the approved quotation:

  • A different product, packaging or Incoterm is a hard block. The PO must be revised or the quotation formally amended and re-approved.
  • A different price or quantity is allowed only with a written justification, and can be routed to Finance.

Operations then re-checks feasibility (stock, vessel, schedule, packaging, documents, LC alignment), and Finance and Supply Chain confirm before the PO is marked as a valid customer PO. Order accuracy beyond the PO check, including weighbridge records, is covered in order accuracy in bulk trading. Once the PO matches, the deal moves on to LC and trade documents.

Standard Odoo does not compare a customer’s PO document with the quotation. For TAM, this check was specified as development.

What one deal record holds

The goal is that anyone in the company can open one record and see the whole deal. In TAM’s design, that record links:

StageWhat is linked to the deal
EnquirySource, mandatory fields, RFQ PDFs with version numbers
Pre-sales reviewStock and ETA, supplier price and lead time, credit position
QuotationApproved price, Incoterm, packaging, validity
Customer POPO PDFs with version numbers, the comparison result, justifications
Proforma and paymentApproved proforma, LC drafts and advice, or advance payment
SupplySupplier PO, shipment status, ETD and ETA
Delivery and invoiceDelivery records, weights, documents and the customer invoice

When a customer calls to ask about an order, the salesperson answers from this record instead of asking three colleagues.

If your enquiries still live in chat threads, we can map one real deal with you and show how it would look in Odoo.

What about WhatsApp?

TAM’s requirements call for WhatsApp and email to be captured on the record. The principle is to make sure each conversation that changes a deal ends up on that deal’s record, without forcing customers off WhatsApp. We designed a similar enquiry flow for a manufacturer, where the order starts with a technical form: see the same flow for a packaging manufacturer.

Odoo 19 has a WhatsApp app that connects a WhatsApp Business account through Meta. It sends messages from Odoo records using approved templates [4]. It needs a Meta business account and approved message templates, so plan the setup time. Messages sent from a salesperson’s personal WhatsApp are not captured, which is why the rule matters as much as the tool.

How each role changes

RoleBeforeAfter
SalespersonChecks stock by phone and quotes in ExcelSees stock, price and credit position on the enquiry
Commercial HeadWaits for a weekly reportSees the pipeline, overdue enquiries and margins live
ProcurementHears about deals lateSees confirmed demand and raises POs with approved terms
FinanceApproves credit informallyChecks credit inside the pre-sales review
OperationsRe-types order details into shipping documentsWorks from the valid customer PO
How each trading role changes after moving to Odoo

How to start if you still work from WhatsApp and spreadsheets

  1. Collect your current flowcharts and forms, even if they are out of date.
  2. Pick five recent deals and trace every message and document each one needed.
  3. Mark the steps that are useful and the ones that exist only because information is scattered.
  4. Decide which rules the system must enforce: the quotation clock, the review, the PO checks.
  5. Agree the mandatory fields for every enquiry.

Three related guides help here: migrating your data, how we plan an implementation and what drives Odoo cost.

FAQ

Do we have to change our whole process to use Odoo?

No. For TAM, the existing pre-sales review form became a system step, and the useful parts of the current process were kept.

Can Odoo create leads from emails automatically?

Yes. Set an email alias on a sales team, and each email sent to it creates a lead [1].

Can Odoo set an expiry date on quotations?

Yes. Each quotation has an Expiration date, and templates can set it automatically [3].

Can Odoo escalate an enquiry that has no quotation after a few days?

Activities show what is overdue as standard [2]. Automatic escalation to a manager needs automation rules.

Can Odoo stop an order when the customer’s PO does not match the quote?

Not as a standard check. We specified a PO-to-quotation comparison with hard blocks for TAM.

See your deals in one place

If your deals still live in chat threads, we can map one real deal with you and show how it would look as a single Odoo record. See how we approach Odoo for trading and distribution projects.

References

[1] Odoo, Create leads (from email or manually), Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/sales/crm/acquire_leads/email_manual.html

[2] Odoo, Activities, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/essentials/activities.html

[3] Odoo, Quotation deadlines, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/sales/sales/sales_quotations/deadline.html

[4] Odoo, WhatsApp, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/productivity/whatsapp.html

[5] Screenshots: Odoo S.A., Odoo 19.0 documentation (CRM, Activities, Quotation deadlines), licensed under CC BY-SA 4.0 (https://creativecommons.org/licenses/by-sa/4.0/). https://www.odoo.com/documentation/19.0/

  • Kawser Ahmed is the Founder & CEO of Softeko, a global IT consultancy with offices in Dhaka and Dubai. A tech entrepreneur, investor, and AI enthusiast, he has led numerous software and web projects, including the successful ExcelDemy.com. Kawser holds an Odoo 18 Functional Certification and has deep expertise in business process management, finance, SEO, and software development. He's also a Technical Analysis trainer at Dhaka Stock Exchange Ltd., with popular online courses on AmarStock.com and Udemy. A lifelong learner, Kawser explores how business, technology, and global markets work.

    View all posts
  • Shafiuddin Haider is a Project Coordinator at Softeko, a leading software development company based in Dhaka, Bangladesh. With over 8 years of experience in the software development industry, Shafiuddin has built a versatile skill set through roles as a developer, system analyst, and project manager. His expertise spans multiple domains within software development, allowing him to communicate fluently with technical teams while maintaining a focus on client objectives. Recently, Shafiuddin completed his Odoo 18 certification, furthering his specialized knowledge in this enterprise management software. He is currently expanding his expertise in Odoo development, adding to his already impressive technical repertoire.
    View all posts

Want to write an article for our blog? Read our requirements and guidelines to become a contributor.

Leave a comment

Your email address will not be published. Required fields are marked *

Get Free Consultancy
Odoo Consultant
Get Free Consultancy
Book a meeting with an expert → Shafiuddin Haider, Odoo ERP Consultant
☰
Table of Contents