{"id":11265,"date":"2026-06-05T16:29:47","date_gmt":"2026-06-05T10:59:47","guid":{"rendered":"https:\/\/tenthplanet.in\/blogs\/?p=11265"},"modified":"2026-06-07T12:15:47","modified_gmt":"2026-06-07T06:45:47","slug":"link-odoo-contacts-to-mailing-lists-data-consent-setup","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/link-odoo-contacts-to-mailing-lists-data-consent-setup\/","title":{"rendered":"Link Odoo Contacts to Mailing Lists: Data + Consent Setup"},"content":{"rendered":"\n
\n

The problem most Odoo marketing setups have<\/h3>\n\n\n\n

Most Odoo email marketing setups force a bad choice: either you target res.partner<\/strong> directly (which gives you data-driven segmentation but no topic-level consent), or you target mailing.list<\/strong> (which gives you consent management but no easy access to customer data). The truth is you need both<\/em>. This guide shows you how to link the two tables so you can run consent-compliant campaigns that filter by customer data \u2014 install date, product type, purchase history, and any custom field you’ve added<\/p>\n<\/blockquote>\n\n\n\n

The Five-Minute Summary<\/h3>\n\n\n\n
    \n
  • Odoo stores contacts in two tables: res.partner (customer data) and mailing.contact (marketing subscribers). They aren’t linked by default.<\/li>\n\n\n\n
  • For most businesses with topic-based consent needs (Newsletter, Promotions, Tips, Service Reminders), the right setup is linked tables<\/strong> \u2014 every res.partner has a matching mailing.contact connected via a partner_id reference.<\/li>\n\n\n\n
  • Marketing campaigns then target mailing.contact, filter by mailing list subscription (consent), and traverse partner_id to access res.partner data (segmentation).<\/li>\n\n\n\n
  • Enforce unique email on both tables. Use Automation Rules to auto-create and auto-link. Configure mailing lists with “Show in Preferences” so customers manage topics individually.<\/li>\n\n\n\n
  • Operational emails (orders, invoices, tickets) continue to flow through res.partner and bypass the marketing blacklist \u2014 always delivered.<\/li>\n<\/ul>\n\n\n\n

    1. Why Odoo has two contact tables<\/h2>\n\n\n\n

    If you’re new to Odoo email marketing, here’s the surprise you’ll discover within your first week: Odoo stores your customers in two completely separate tables<\/em>, and they aren’t linked.<\/p>\n\n\n\n

    res.partner<\/strong> is the master contact table used by Sales, CRM, Invoicing, Inventory, Helpdesk, Field Service, eCommerce, and almost every other module. When a customer buys something, books an appointment, or submits a contact form, they live here.<\/p>\n\n\n\n

    mailing.contact<\/strong> is a separate table that exists only inside the Email Marketing module. It holds newsletter subscribers, imported marketing contacts, and anyone added to a mailing list. By default, it has no foreign key to res.partner.<\/p>\n\n\n\n

    This separation was a deliberate design choice \u2014 newsletter subscribers from a public website don’t need billing addresses, tax IDs, or customer ranks. They just need an email and a few preferences. But for businesses with real customers who also need marketing, the lack of an automatic link causes:<\/p>\n\n\n\n

      \n
    • The same person stored in both tables with no connection<\/li>\n\n\n\n
    • Marketing campaigns missing customers (because they’re in res.partner but not in any mailing list)<\/li>\n\n\n\n
    • Newsletter campaigns hitting customers twice (once as res.partner, once as mailing.contact)<\/li>\n\n\n\n
    • No way to filter marketing campaigns by sales data (orders, install date, product type) when targeting a mailing list<\/li>\n<\/ul>\n\n\n\n

      2. Decision Tree: which architecture do you need?<\/h2>\n\n\n\n

      Before choosing an architecture, answer two questions about your business:<\/p>\n\n\n\n

      \n

      Architecture Decision Tree<\/h4>\n\n\n\n

      Q1: Do customers need to choose which<\/em> topics of marketing they receive?<\/p>\n\n\n\n

      Examples:<\/strong> “I want product tips but not promotions” \/ “Send me service reminders but not newsletter”
      If YES<\/strong> \u2192 you need a mailing.list-based consent layer<\/strong> \u2192 continue to Q2.
      If NO<\/strong> (one-size-fits-all marketing) \u2192 simpler architecture: target res.partner directly with the global blacklist as the only unsubscribe option.<\/p>\n\n\n\n

      Q2: Do your marketing emails need to filter by customer data (orders, install dates, product type, custom fields)?<\/p>\n\n\n\n

      If YES<\/strong> \u2192 linked-tables architecture (this guide)<\/strong> \u2014 target mailing.contact, filter by list subscription, traverse partner_id for segmentation.
      If NO<\/strong> (purely list-based campaigns) \u2192 traditional mailing.list targeting works fine, no linking needed.<\/p>\n\n\n\n

      <\/p>\n<\/blockquote>\n\n\n\n

      If you answered yes to both questions \u2014 which most B2C and service businesses do \u2014 the rest of this guide is for you.<\/p>\n\n\n\n

      3. The Linked-Tables Architecture in Detail<\/h2>\n\n\n\n

      In the linked-tables architecture, every res.partner with an email automatically gets a paired mailing.contact, connected via a partner_id Many2one field. The mailing.contact subscribes to mailing lists for topic-level consent, and any campaign can traverse partner_id to access res.partner data.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      The Three Roles Each Table Plays<\/h3>\n\n\n\n
      Table<\/th>Role<\/th>What it stores<\/th><\/tr>
      res.partner<\/td>Customer master + segmentation source<\/td>Identity, sales history, custom data fields (install date, product type, etc.)<\/td><\/tr>
      mailing.contact<\/td>Marketing bridge + subscription holder<\/td>Email, partner_id link, list memberships, per-list opt-out flags<\/td><\/tr>
      mailing.list<\/td>Topic-level consent grouping<\/td>List name (Newsletter, Promotions, etc.), Show in Preferences setting<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      <\/p>\n\n\n\n

      4. The Recommended Rules and Auto-Linking<\/h2>\n\n\n\n

      You need a partner_id field on mailing.contact \u2014 this is the keystone of the architecture.<\/p>\n\n\n\n

      Rule 1 \u2014 On res.partner Create: Auto-Create and Link mailing.contact<\/h3>\n\n\n\n

      Linking res.partner \u2194 mailing.contact?
      \u2014 A one-directional link for segmentation is fine. A mandatory bidirectional 1:1 is not.<\/p>\n\n\n\n

      Rule 2 \u2014 On res.partner Email Change: Propagate to mailing.contact<\/h3>\n\n\n\n

      If a customer updates their email, the linked mailing.contact must update too. Trigger: On Update, watching the email field.<\/p>\n\n\n\n

      Rule 3 \u2014 On mailing.contact Create: Reverse-Link to Existing res.partner<\/h3>\n\n\n\n

      If a newsletter signup matches an existing customer’s email, link them.<\/p>\n\n\n\n

      5. Configuring Mailing Lists as Your Consent Layer<\/h2>\n\n\n\n

      The mailing.list table is your topic-level consent layer. Each list represents one category of marketing emails customers can opt into or out of.<\/p>\n\n\n\n

      The Standard Four-List Structure<\/h3>\n\n\n\n

      Almost every business should start with these four lists:<\/p>\n\n\n\n

      List Name<\/th>Email Types<\/th>Default Subscribe?<\/th><\/tr>
      Newsletter<\/td>Monthly updates, blog roundups, education<\/td>Yes<\/td><\/tr>
      Promotions & Offers<\/td>Seasonal deals, discounts, sales<\/td>Yes (easy opt-out)<\/td><\/tr>
      Product Tips & Care<\/td>How-to content, maintenance, best practices<\/td>Yes<\/td><\/tr>
      Service Reminders<\/td>Renewal, maintenance, reorder prompts<\/td>Yes (clearly labelled)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Add the x_default_subscribe Field<\/h3>\n\n\n\n

      Add a custom Boolean field x_default_subscribe on the mailing.list model via Studio. Tick it for the lists you want every new customer to be auto-subscribed to. The Automation Rule from Section 5 reads this field and subscribes new customers accordingly.<\/p>\n\n\n\n

      6. Campaign Targeting \u2014 The New Pattern<\/h2>\n\n\n\n

      The targeting pattern in the linked architecture is fundamentally different from the traditional res.partner-direct approach. Here’s the formula:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Worked Example 1 \u2014 Cross-Sell Campaign<\/h3>\n\n\n\n

      Send a cross-sell email to customers who own Product A but not Product B, and who have consented to Promotions:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Worked Example 2 \u2014 Service Reminder<\/h3>\n\n\n\n

      Send a service reminder to customers whose next service date is in 30 days, who have consented to Service Reminders:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      7. Operational vs Marketing Emails (Still Relevant)<\/h2>\n\n\n\n

      The linked architecture is for marketing<\/strong> emails. Operational<\/strong> emails \u2014 order confirmations, invoices, delivery notifications, support tickets \u2014 continue to flow directly through res.partner via the mail.message pipeline. They bypass the blacklist and are always delivered.<\/p>\n\n\n\n

      Aspect<\/th>Operational<\/th>Marketing<\/th><\/tr>
      Trigger<\/td>Business event (sale, invoice, ticket)<\/td>Marketer \/ automation rule<\/td><\/tr>
      Pipeline<\/td>mail.message \/ chatter<\/td>Email Marketing \/ Marketing Automation<\/td><\/tr>
      Target<\/td>res.partner directly<\/td>mailing.contact (linked architecture)<\/td><\/tr>
      Respects blacklist?<\/td>NO<\/td>YES<\/td><\/tr>
      Respects per-list opt-out?<\/td>N\/A<\/td>YES<\/td><\/tr>
      GDPR basis<\/td>Contract performance<\/td>Consent (opt-in)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      8. Unsubscribe, Blacklist, and GDPR<\/h2>\n\n\n\n

      Two unsubscribe mechanisms work together in the linked architecture:<\/p>\n\n\n\n

      Per-List Opt-Out (Topic Level)<\/h3>\n\n\n\n

      When customers click unsubscribe in a marketing email, they land on a preferences page showing every mailing list with “Show in Preferences” enabled. They can toggle individual lists \u2014 opt out of Promotions while staying subscribed to Service Reminders. This is the everyday consent tool.<\/p>\n\n\n\n

      Global Blacklist (All-Or-Nothing)<\/h3>\n\n\n\n

      The blacklist (model mail.blacklist) is the customer’s nuclear option. Once their email is on the blacklist, all marketing across every list and every campaign is blocked. Transactional emails (orders, invoices, tickets) still flow through.<\/p>\n\n\n\n

      Enable in Email Marketing \u2192 Configuration \u2192 Settings \u2192 Blacklist Option when Unsubscribing.<\/p>\n\n\n\n

      \n

      Common misunderstanding:<\/strong> Some practitioners think the blacklist doesn’t block marketing to res.partner-targeted campaigns. It does. Odoo checks the blacklist by email address regardless of which model is targeted. The blacklist applies equally to mailing.contact-targeted and res.partner-targeted campaigns. What it cannot do is differentiate between topics \u2014 that’s what mailing.list subscriptions are for.<\/p>\n<\/blockquote>\n\n\n\n

      8. Challenges to accept<\/h2>\n\n\n\n