Clienteling SPI Field Mapping
Use the Clienteling SPI to create, search, update, and retrieve details of a specific customer. This guide summarizes how Clienteling SPI fields map to customer-related information tags. For specification details, see Clienteling SPI.
For more information on tags, please read PS Tags.
| PS Tag on Layout | Backend SPI Field | CMS Grouping |
|---|---|---|
| profile.salutation | User Profile | |
| profile.firstName & profile.lastName | User Profile | |
| profile.firstName | User Profile | |
| profile.lastName | User Profile | |
| profile.email | User Profile | |
| profile.gender | User Profile | |
| profile.phoneMobile | User Profile | |
| profile.phoneHome Note: "If configuring this field on any clienteling layouts, the "profile.phoneHome" field should be configured in NetSuite. Alternatively, you can map it to the phone attribute in NetSuite using "profile.phone". | User Profile | |
| profile.birthday | User Profile | |
| profile.address.city | User Profile | |
| profile.address.countryCode | User Profile | |
| profile.preferredLanguage | User Profile | |
| profile.taxInfo.taxId | User Profile | |
| profile.alternateCustomerId | User Profile | |
| orderCount | User Profile | |
| addressList | User Profile | |
| orderList | User Profile | |
| cardList | User Profile | |
| products | User Profile | |
| profile.address.addressLine1 | User Profile | |
| profile.address.addressLine2 | User Profile | |
| profile.address.city | User Profile | |
| profile.address.state | User Profile | |
| profile.address.postalCode | User Profile | |
| profile.address.countryCode | User Profile | |
| profile.phoneMobile | User Profile | |
| consents.newsLetterSignUp | consents.newsLetterSignUp | Form Field |
| consents.eReceipt | consents.eReceipt | Form Field |
| consents.smsSignUp | consents.smsSignUp | Form Field |
| consents.agreeToTC | consents.agreeToTC | Form Field |
| consents.directMailSignUp | consents.directMailSignUp | Form Field |
| consents.phoneSignUp | consents.phoneSignUp | Form Field |
| consents.loyaltySignUp | consents.loyaltySignUp | Form Field |
| loyaltyProfile.currentStoreCredit | User Loyalty Profile | |
| loyaltyProfile.currentTier.name | User Loyalty Profile | |
| loyaltyProfile.currentTier.title | User Loyalty Profile | |
| loyaltyProfile.currentTier.subTitle | User Loyalty Profile | |
| loyaltyProfile.currentPoints | User Loyalty Profile | |
| loyaltyProfile.currentTier.memberSince | User Loyalty Profile | |
| loyaltyProfile.currentTier.expiryDate | User Loyalty Profile | |
| loyaltyProfile.currentTier.display | User Loyalty Profile | |
| loyaltyProfile.nextTier.display | User Loyalty Profile | |
| loyaltyProfile.nextTier.name | User Loyalty Profile | |
| loyaltyProfile.nextTier.title | User Loyalty Profile | |
| loyaltyProfile.lifetimePoints | User Loyalty Profile | |
| loyaltyProfile.customAttributes | User Loyalty Profile | |
| loyaltyProfile.accountNumber | User Loyalty Profile | |
| loyaltyProfile.cashRewards | User Loyalty Profile | |
| loyaltyProfile.nextTier.points - loyaltyProfile.lifetimePoints | User Loyalty Profile | |
| loyaltyProfile.rewards | User Loyalty Profile | |
| loyaltyProfile.currentStoreCredit | User Loyalty Profile | |
| loyaltyProfile.nextRewardPoints - loyaltyProfile.currentPoints | User Loyalty Profile | |
| loyaltyProfile.rewards.amount | User Loyalty Profile | |
| Sum of loyaltyProfile.rewards[].amount and if loyaltyProfile.rewards.status | User Loyalty Profile | |
| Sum of loyaltyProfile.rewards[].amount and if loyaltyProfile.rewards.status = AVAILABLE | User Loyalty Profile | |
| Sum of loyaltyProfile.cashRewards.amount if loyaltyProfile.cashRewards.status = AVAILABLE | User Loyalty Profile | |
| Sum of loyaltyProfile.cashRewards.amount | User Loyalty Profile | |
| loyaltyProfile.accountNumber OR loyaltyProfile.loyaltyId | Wine Loyalty | |
| loyaltyProfile.tierLevelValue | Wine Loyalty | |
| loyaltyProfile.loyaltyId | Wine Loyalty | |
| loyaltyProfile.currentTier.name | Wine Loyalty | |
| profile.companyName | Wine Loyalty | |
| loyaltyProfile.title | Wine Loyalty |