Skip to contentVerifycate
ImprovedRecipientsNo. 036

Find duplicate recipients before you issue

Duplicate rows in an import are identified and skipped, so the same person does not receive two certificates or spend two credits.

By Ashwin Shenoy · Founder and engineer

Duplicate recipients usually come from combining lists. The registration export has one row, the walk-in sheet has another, and the department spreadsheet has a third. Import all three and the same student appears twice.

The import now identifies duplicates and skips them.

Where it happens

During the import review, rows that match an existing recipient are marked rather than silently added. You can see which rows were skipped and why before the batch is prepared. The same check applies when a recipient is added individually: an address already on the certificate is caught.

Why it is worth the extra step

A duplicate is not just untidy. It can mean two emails, two certificates, and two credits for one person. It also makes the recipient list harder to reason about during closeout: which record is the real one, and which link should the person share?

What it does not do

The check is based on the recipient data it can see. Two different email addresses for the same person will look like two people. If identity matters, use one email column and reconcile the source lists before importing.

Related

← Back to all updates

Start issuing

Certificates people can prove.

Design once, issue in bulk or from your LMS, and give every recipient a public page anyone can verify.