Member Avatar for cassyjack

Hi,

I am working with a small business. They want to be able to provide users with a discount code that will work one time if the customer signs up for a emailing list. What they have been doing is once they get the email for the form...they have been generating the discount codes and replying to the customer with the code however they are getting slammed with emails for the codes. We want to optimize and stream line the process.

Make so that the codes go out via auto reply;
Make sure that the user can only request the code/sign up to put on the emial list once.

Any suggestions?

  • 3 Contributors
  • 2 Replies
  • 359 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by daniel.main.902

Dani AI

Generated

Quick summary: described a small business manually creating one‑time discount codes after signups and getting swamped. rightly pointed to automation via an ESP, and asked the crucial clarification: is the problem (A) automatic delivery, (B) customers requesting the code multiple times, or (C) customers redeeming the same code multiple times? Each failure mode needs a different control, so the solution below covers all three.

Suggested workflow (practical, low‑effort):

  • On form submit, check the subscriber table and refuse duplicate requests at submission time.
  • Require double‑opt‑in: only generate/send a coupon after the email is verified.
  • Generate a unique code (API call to the ecommerce platform or server-side generator), persist a mapping row (email, code, created_at, used_at = NULL), then fire a transactional email with that single code. If the ecommerce system cannot create single‑use coupons on the fly, pre‑generate a pool and consume one per verified signup.

Example code pattern (generation + storage):

const crypto = require('crypto');
function genCode(len = 8) {
  const chars = 'ABCDEFGHJKLMNPQRSTUVWXYZ23456789';
  const bytes = crypto.randomBytes(len);
  return Array.from(bytes).map(b => chars[b % chars.length]).join('');
}

Schema sketch:

CREATE TABLE coupons (
  id SERIAL PRIMARY KEY,
  code VARCHAR(32) UNIQUE NOT NULL,
  email VARCHAR(255),
  created_at TIMESTAMP DEFAULT NOW(),
  used_at TIMESTAMP NULL
);

Anti‑abuse and redemption controls: make coupons single‑use or tied to the checkout email/account and mark them atomically at redemption. Normalize emails (lowercase, trim, handle Gmail dot/+ aliases), block disposable domains, add CAPTCHA and IP throttling to the signup form, and set reasonable expiry and minimum order value. Transactional sends (not marketing blasts) reduce delivery lag and manual load.

Quick rollout checklist: enable transactional email, log create/send/redeem events for support, test with aliased addresses and repeat submissions, and show a clear “code already sent” message when duplicates are blocked.

Recommended Answers

All 2 Replies

Member Avatar for hericles

you might want to look at using a service like MailChimp. They have plenty of tools for auto responding emails, coupons, etc. There are quite a few options out there but I've used MailChimp a bit and it's a very good system (I'm not affiliated with them in any way).

Member Avatar for daniel.main.902

Is the issue you are having auto-replying to the emails, is it preventing the customer from requesting the discount code multiple times, or attempting to use the discount code multiple times once it has been requested?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.