How to unify POS, loyalty, and ecommerce data with a retail CDP

Most retail brands run their customer data across at least three separate systems: a POS for in-store transactions, an ecommerce platform for online orders, and a loyalty programme for rewards activity. Each one holds a different slice of the customer picture. None of them talk to each other.

The result is that a customer who buys in-store, earns loyalty points, and browses online is invisible as a single person. Your marketing team sees three partial records. Your loyalty platform doesn't know what they bought online. Your ecommerce platform doesn't know they exist in-store. And your campaigns treat them accordingly: generic, out-of-context, and easy to ignore.

Unifying POS, loyalty, and ecommerce data requires a Customer Data Platform that integrates with each system through native connectors or APIs, then applies identity resolution to match records across sources to the same customer. Once connected, the CDP maintains a single, continuously updated customer profile that your marketing team can segment and activate across any channel. For most mid-market retailers, the integration process takes 8 to 12 weeks from kickoff to a working unified customer view.

Why unifying retail data across channels matters for omnichannel strategy

According to a Harvard Business Review study of 46,000 retail shoppers, 73% engage across multiple channels during their buying journey. That means the overwhelming majority of your customers are touching your brand through a combination of in-store, online, and loyalty touchpoints before and after they purchase.

Yet most retailers are still managing these touchpoints as if they are separate businesses. The POS captures an in-store purchase but has no visibility into that customer's online browse history. The loyalty platform tracks points redemptions but cannot tell you what the customer bought ecommerce-only. The ecommerce platform tracks online orders but cannot attribute them to the same person who visited your flagship store last month.

According to a 2023 Statista survey of senior marketing executives, 48% cite unifying data sources as a major challenge in delivering personalised customer experiences, while 47% identify siloed data as a top obstacle. These are not technical problems. They are structural ones, and a retail CDP addresses them at the architectural level.

Research from Manhattan Associates' 2025 Unified Commerce Benchmark, conducted across 220 North American specialty retailers, found that only 5% of retailers have achieved unified commerce leadership. Those that have report 20% lower fulfilment costs and 20% lower cart abandonment rates compared to the industry average. The performance gap between retailers with unified data and those without it is measurable, and it compounds over time.

Step 1: Connecting your POS to your customer data platform

Point-of-sale data is the highest-value input for most retailers because it contains the ground truth of what customers actually bought, in real life, with real money. But POS data is also the most commonly excluded source from retail marketing programmes, because most POS systems were not designed to share data with marketing tools.

Connecting your POS to a retail CDP requires either a native integration (where the CDP has a pre-built connector for your POS system) or a data feed (where transaction records are exported on a scheduled basis and ingested into the CDP). For most mid-market retailers using common POS platforms such as Lightspeed, Square, or Shopify POS, native integrations are available.

The quality of your POS connection depends heavily on how much customer data your POS captures at the point of transaction. A POS that captures an email address or loyalty card scan for every transaction creates a highly matchable record. A POS that records most transactions as anonymous cash sales produces limited data for identity resolution. Before connecting your POS, audit your current email and loyalty capture rate at checkout. If it is below 50%, that is a commercial priority independent of any technology decision.

Step 2: Connect your loyalty programme to build a complete customer engagement picture

Loyalty data is valuable for two reasons: it is often the richest source of named customer records in a retailer's data estate, and it captures engagement behaviour (points earned, rewards redeemed, tier status) that reveals customer attitudes beyond transactional history.

A customer who consistently earns but rarely redeems is different from one who redeems at every opportunity. A loyalty member who was previously in a high tier and has recently dropped is worth understanding differently from one who has always been mid-tier. These nuances are invisible in POS data alone.

Connecting a loyalty platform to a retail CDP means mapping loyalty member IDs to the same customer profile as purchase and engagement data. Most loyalty platforms expose customer data through an API or regular data exports. The key is ensuring that the loyalty identifier (typically a card number or member ID) is treated as a primary matching key during identity resolution, alongside email address and phone number.

Once connected, loyalty data adds a tier dimension to your segmentation. You can build audiences based on loyalty status combined with purchase frequency, identify high-spenders who are not enrolled in loyalty (and therefore not earning points for purchases they are already making), and trigger personalised communications based on points balance thresholds.

Step 3: Connect your ecommerce platform to complete the omnichannel customer profile

Ecommerce data is typically the easiest to connect because modern ecommerce platforms (Shopify, Magento, BigCommerce) are built with API access as a default. Ecommerce transaction records usually include a customer email address, which is the most reliable matching key for identity resolution.

Beyond transactions, ecommerce platforms also generate browse and session data, which can be connected to the CDP through a tracking tag. Browse data adds a pre-purchase dimension to the customer profile: what categories a customer is exploring, what products they view but don't buy, and what search terms they use. This signals intent that transactional data alone cannot capture.

The combination of in-store purchase history (POS), loyalty engagement (loyalty platform), and online behaviour (ecommerce and browse data) produces a materially different customer profile from any single source alone. A customer who buys womenswear in-store, browses footwear online, and has a high loyalty tier is a meaningfully different marketing target from a customer with the same in-store spend who is not a loyalty member and has no online engagement.

Step 4: Apply identity resolution to merge records across all three sources

Connecting three data sources to a CDP does not automatically produce a unified customer profile. It produces three sets of data in one place. Identity resolution is the process that merges those records into a single profile per real customer.

Identity resolution works by matching records across sources using shared identifiers. The simplest case: a customer uses the same email address at the ecommerce checkout, on the loyalty programme sign-up, and when prompted for a receipt at the POS. All three records share a common key and merge cleanly.

The harder case is where identifiers are inconsistent. A customer who provides a loyalty card number at the POS but uses a different email address online, or who uses a personal email for their loyalty account but a work email for online orders, will appear as two separate customers without probabilistic matching logic. Good identity resolution applies matching rules across multiple identifier types, handles inconsistencies, and maintains a confidence score for matched records.

Most retailers have between five and fifteen systems that hold customer data, and identity resolution is only as good as the identifiers available. If your POS system captures email for only 30% of transactions, that gap needs to be known before expecting unified profiles for every customer.

Step 5: Activate the unified retail customer profile across your marketing channels

A unified customer profile produces value when it informs action. The final step is connecting the CDP to your marketing execution tools so that segments built from the unified profile flow through automatically to every channel where you run campaigns.

For email and SMS, this means syncing audience segments from the CDP to your email service provider and SMS platform, so that campaign audiences stay current without manual exports. A customer who crosses from "active" to "at-risk" exits the standard email flow and enters the re-engagement sequence automatically.

For paid social, connecting the unified profile enables you to push suppression audiences (recent purchasers you should not be paying to acquire) and lookalike seed audiences to Meta and Google. A seed audience built from your top-quintile customers by lifetime value, drawn from a complete cross-channel profile, produces stronger lookalike matches than one built from ecommerce data alone.

For in-store teams, the unified profile accessible through a clienteling tool gives sales associates visibility into a customer's full history, loyalty status, and preferences before and during the interaction. THE UPSIDE, a leading sportswear brand, used Lexer's in-store tool to achieve a 75% conversion rate improvement and a 13% increase in average order value across their flagship stores by equipping store teams with this complete customer view.

For a deeper look at how to structure your implementation from kickoff to first segment, read the 5-step CDP implementation checklist for retail.

‍

FAQs

How do I connect in-store and online customer data for retail?

Connecting in-store and online customer data requires a Customer Data Platform that integrates with your POS system, ecommerce

What is the best way to unify POS, loyalty, and ecommerce data?

The most effective approach is to use a retail CDP with native integrations for each of your three data sources. A CDP handles data ingestion, identity resolution, and activation in one platform, which is faster and more maintainable than building custom integrations between individual systems.

Does a retail CDP integrate with Shopify and common POS systems?

Yes. Most retail-focused CDPs, including Lexer, offer native integrations with Shopify for ecommerce data and connectors for common POS platforms such as Lightspeed and Square.