PassEntry, Klaviyo, Shopify Loyalty Integration

Ophsides is a streetwear brand that also holds weekly free events to play soccer. We use a digital wallet loyalty card for these free events, operated by PassEntry. Each person gets a stamp for every event they come to. We would like to integrate this with our CRM, Klaviyo, for better customer tracking and communication and to trigger rewards sent via email and/or SMS when customers reach a certain number of stamps (e.g., a special discount, link to limited edition/private product, etc) Ultimately we want to create a real member database outside of PassEntry’s dashboard, sequential member ID numbers, reward automation, weekly SMS RSVPs, a simple Shopify user profile from their ID, and member referral codes Existing Ophsides Platforms: - Klaviyo (CRM/database) - Shopify (Ophsides website) - PassEntry (digital pass): https://passentry.com/?hubspotutk=fd8ffa33c9b268987b876bd3fd9f5398 Our Needs: - Create a chronological external ID numbering system (e.g., Member 001, Member 002, etc) - The pass generates a Shopify user/sign in via their email - The number of stamps the attendee has triggers rewards emails when they reach 5, 15, 30 stamps, etc - An SMS attendance system: ability to blast out texts that say “Reply Y to confirm your attendance for tomorrow’s game” (way to track this in Klaviyo like in a column or something who confirmed attendance) - Member referral codes (each member gets their own referral code) - Create a way to analyze customer retention (how many people with an existing stamp are repeat/return customers)