In need of a developer for email reminder workflow for custom-made conditions and variable data

Hi ​@Katandmouse 

are you saying that the below is done manually?

There is a “special offer” button. Currently it directs them to a Bigcommerce contact form that we customized to send the form, sku number and url to the admin. The admin then responds back in email. In that email they get a Bigcommerce coupon code and a link to the product. 

What is the admin doing to generate the coupon code?  

Below are mechanisms to send an automated email from Klaviyo to include the coupon codes:

Method 1: Static Coupon Codes

How it works:

1. Create a static coupon in your BigCommerce dashboard (e.g., via Marketing → Coupon Codes → Create a Coupon Code). This is a shared code like WELCOME20 that all recipients can use Klaviyo

2. Copy the code from BigCommerce.

3. Paste the code directly into your Klaviyo email or SMS templates—either in a text block or as part of a button. Format it to be easy to notice! 

Key points to remember:

• Klaviyo doesn't manage the metadata of the coupon (like expiration date or discount amount)—that's all handled by BigCommerce

• If the coupon spreads too widely, users may share it with non-targeted audiences.

• You can mitigate that by rotating expiration dates regularly and communicating clearly to your audience

Method 2: Unique (Dynamic) Coupon Codes

This is ideal when you want to send personalized, one-time-use codes to individual customers.

Steps involved:

1. Generate many unique codes, for example by using a tool like Mockaroo to create a CSV list of codes 

2. Upload those codes into both:

   • Your BigCommerce store using a third-party app that supports bulk coupon uploads (e.g., Coupon Buster)

   • Your Klaviyo account:

     • First, go to Settings → Other → Profile Maintenance in Klaviyo and enable the "Uploaded Coupons" tab 

     • Then, navigate to the Coupons section, click Add Coupon, set up metadata (like name, expiry), and import your codes via CSV 

3. Use the unique coupon in your messaging:

   • Inside your email or SMS templates, insert the code dynamically using Klaviyo’s templating tag:

     {% coupon_code 'CouponName' %}

   • Replace CouponName with the name you assigned when creating the coupon in Klaviyo

Important notes:

• If the number of recipients exceeds your available codes, emails will be skipped or blocked for privacy—Klaviyo will warn you in advance 

• For flows, messages with no available codes cannot go live; in campaigns, a warning appears if codes are insufficient 

• You’ll need to replenish codes in both systems when they run out

As far as knowing whether or not the user used the coupon codes, Inside the Placed Order event data, Klaviyo records the coupon under a property like:

{ "Event": "Placed Order", "Properties": { "Value": 120.00, "Coupon": "WELCOME20", "Discount Amount": 30.00, "Items": [...] } }

• Coupon → the code the customer entered (e.g. WELCOME20).

• Discount Amount → how much was taken off the order.

This means you can segment or trigger flows based on whether a customer used a certain coupon.

I am not 100% certain the BigCommerce Placed Order event looks like this but if you can determine this and turns out to be the case then above solution can apply.