The Workflow Library

Library / Data quality / data-quality-050

Set the product plan on contacts from paid line items (payments and invoices)

Data qualityContactData Hub ProfessionalIntermediate~45 min to buildFull spec

Outcome. Every paying contact carries the plan they actually bought and the date it started, read from the line items behind their payment or invoice, so segmentation and onboarding stop relying on a rep remembering to set the field by hand.

Workflow map Enrollment, branches and actions at a glance data-quality-050
flowchart TD
    A[Contact has a paid payment or invoice] --> B[Custom code: associations to line items to products]
    B --> C{result_code}
    C -->|found| D[Set Product plan, Plan start date, source]
    C -->|not_found| E[Set source = Not found]
    C -->|error| F[Create task for the operations owner]
action or delay branch public on every spec, paid or not

When to use it, when not to

  • UseUse it when you collect money inside the CRM through payments or invoices, and the plan a customer bought is visible on the line items attached to that payment or invoice.
  • UseUse it when marketing and service need plan-level segmentation (upgrade campaigns, plan-specific onboarding, plan-specific SLAs) and the plan today lives only in the billing system.
  • SkipDo not use it when billing happens entirely in an external system with no payment or invoice records synced into the CRM. In that case, sync the plan as a contact property from the billing system directly, and skip the workflow.
  • SkipDo not use it as your revenue source of truth. It copies a label for segmentation. Amounts, proration and refunds stay in the billing system.
The preview ends here. Six sections are in the library. counted, not blurred
PrerequisitesEvery property with its label, internal name, type and options, plus the assets the workflow needs before you start.7 items
EnrollmentThe trigger, the criteria exactly as they are ticked in the UI, the re-enrollment rule and the suppression list.6 parts
StepsEach action in order with its parameters, its branches and its delays, written as you tick them.7 numbered actions
Known pitfallsTraps seen in production, each with what breaks and what to do instead.6 pitfalls
Test plan, variants and build specHow to prove it works in a test portal, where to look when it does not, the variants for other objects or tiers, and the YAML build spec.4 variants, 3 sections
FilesThe properties JSON creates the fields in one API call, the workflow JSON documents the build, and the custom coded action ships as a ready-to-paste .js file.PDF, Markdown, JSON, code
Install1 click. The installer creates the properties this spec declares and the workflow itself, switched off, then opens a task for the prerequisites that are assets rather than properties, such as a team, a static list or a marketing email. What it created is listed on the install page.1 click, switched off
Unlock the full library, 149 EUR

or the data quality pack, 39 EUR

One-time, excl. VAT. 30-day refund, no questions asked. Founding prices until 31 October, then 199 and 59 EUR. Includes every spec added later, up to the full 500, and the one-click installer on the full library. Building on client portals? The agency licence at 449 EUR covers unlimited client portals.