Any way to distribute serial numbers via squarespace commerce?

1 hour ago, MJC123 said:

If I have a sheet of license keys on a CSV/excel sheet. Is there a way I can distribute these to customers using squarespace commerce? I currently use a custom sendowl button

This is what SendOwl is designed to do and, as it is self-contained, is often a good reliable choice. 

There isn't a built-in Squarespace feature that can do this but it is possible using a number of third party tools in combination with Squarespace. Note that it isn't straightforward and so isn't something that I can cover comprehensively in a forum post but here's a summary of how it can be achieved.

You'll need at least one Robotic Process Automation (RPA) tool like Parabola, Make and/or Zapier, as well as a cloud based productivity tool with email and online spreadsheets, like Google Workspace.

Here are some example steps:

1. Create an "Orders" sheet to store new Squarespace orders.

2. Create a "Licence Key" sheet to store the licence keys.

3. Create a workflow to pull each new order from the Squarespace Orders API and create a new row in the "Orders" sheet.

4. Create a workflow to:

  (a) look for new rows (orders!) created in the "Orders" sheet and read the email address of the customer.

   (b) lookup the next available licence row in the "Licence Key" sheet.

   (c) read the licence key.

   (d) send a new email to the customer containing the licence key.

   (e) delete the row containing the key.