question

Robin Walmsley avatar image
Robin Walmsley asked rachel Deactivated answered

Are customer records unique across the platform?

The Customer table has a unique ID field. Are customers and therefore their IDs unique for a merchant, or constant across the Clover network. If it's the latter then the implication is that Customer data could be duplicated on the Clover network.

Example. John Smith buys from Store A, and is a new customer of the store and to Clover. He is allocated an ID of "xxxx" John then buys from Store B using the same Debit card, also on the Clover network Is there a new Customer record created for John for the new store or is his ID the same as it was for Store A?

This is an important question for us, as we hold unique customer records across our platform for all stores (Customers table) and Store specific data against each store (StoreCustomer table). Each store a customer visits may offer a different discount structure to that customer. So uniquely identifying the customer is important for us.

Thanks Robin

10 |2000

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Miguel avatar image
Miguel Deactivated answered

Customer IDs are unique to a single merchant, but there's no guarantee that they will be unique between multiple merchants. However, since there are 3.6893488e+19 possible variations, collisions are very unlikely.

10 |2000

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rachel avatar image
rachel Deactivated answered

Customers are merchant-specific, so if Store A and Store B have separate merchant IDs, then John would have two customer records.

10 |2000

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Welcome to the
Clover Developer Community