Migrate from Plexus Software to Mailchimp

Plexus Customer records map directly to Mailchimp contacts. Email address is the primary key for duplicate resolution during import. Customers without email addresses are flagged and require manual email enrichment before import. All standard contact fields (name, email, phone, address) migrate to corresponding Mailchimp merge fields, preserving the complete contact profile from Plexus in the target system.

Street, city, state, postal code, and country map to Mailchimp's address merge fields (ADDRESS, CITY, STATE, ZIP, COUNTRY). Mailchimp renders these fields in formatted address blocks in campaigns. Address data from Plexus is validated for completeness and standardized before import to ensure accurate delivery information appears in Mailchimp campaign sends and customer profiles.

Primary phone number from Plexus Customer maps to a PHONE merge field in Mailchimp. Mobile and secondary phone numbers require additional merge fields if needed for SMS or segmentation. Phone field values can support future SMS marketing campaigns if the Mailchimp account has SMS capabilities configured and enabled for the audience.

Plexus Job records have no Mailchimp equivalent. Each job's key fields (Job ID, status, total amount, assigned employee count) are flattened into merge fields named JOBSTATUS, JOBTOTAL, and JOBEMPLOYEES on the contact record. Job ID stored as JOB_ID__c for traceability.

Plexus Quote records (proposals, estimates) map to merge fields QUOTESTATUS and QUOTETOTAL on the associated Customer contact. Historical quotes can be stored as comma-separated tag values or in a custom JSON-encoded merge field for reference. Quote metadata enables segmentation of customers by quote stage and estimated value for targeted follow-up marketing campaigns.

Plexus time entries linked to a Customer can be aggregated by contact into merge fields TOTALHOURS and LASTTIMEDATE. Tags named TIMECATEGORY-{category} are applied to contacts with logged time entries for segmentation in Mailchimp. This aggregation allows segmentation by service engagement level, enabling targeted communications based on hours logged for each customer.

Plexus Employees have no Mailchimp equivalent since Mailchimp does not model staff. Employee names and roles are not migrated as contacts. If employee email addresses exist in Plexus for notification purposes, those can be mapped as regular contacts with an EMPLOYEECONTACT tag.

Plexus Expense records track internal cost data with no marketing relevance. Expenses are not migrated to Mailchimp. If expense totals per customer are needed for segmentation (e.g., high-value vs. standard customers), aggregate figures map to a LIFETIMEVALUE merge field instead.

Plexus Customer notes migrate to the Mailchimp Notes field on the contact record. If notes exceed 255 characters, the note is split across a primary note and a secondary MERGE4 field. Notes with timestamps retain original create dates preserved in the note body.

Plexus Customer category assignments (e.g., 'Commercial', 'Residential', 'Priority') migrate as Mailchimp tags applied at import time. Tags enable segmentation for targeted campaigns and automation enrollment in Mailchimp. The tag taxonomy is preserved exactly as defined in Plexus, allowing immediate segmentation based on existing customer classifications without manual tag recreation.

Plexus Work Order status (Scheduled, In Progress, Completed) maps to merge field WORKORDERSTATUS. Next scheduled date maps to NEXTAPPTDATE. Contacts with upcoming appointments can be segmented for reminder automation in Mailchimp. This mapping enables automated appointment reminder sequences and follow-up communications triggered by scheduled service dates in Mailchimp.

Plexus Customer-specific pricing agreements flatten to a PRICELEVEL merge field indicating the pricing tier applied (e.g., 'Standard', 'Preferred', 'Contract'). This supports segmentation for tiered campaign content or discount-offer targeting. Pricing tier tags enable differentiated marketing campaigns that align with each customer's service level and negotiated terms.