Jump to content

Any way to distribute serial numbers via squarespace commerce?

Go to solution Solved by paul2009,

Recommended Posts

Hey there, I sell digital products via squarespace. I have unique serial numbers for every purchase, which need to be delivered to the customer on purchase. 

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, but this feels unprofessional - I'd much rather they stay ON my site during the checkout process.

Any ideas much appreciated - thank you!

Link to comment
  • Replies 2
  • Views 2.2k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • Solution
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 ParabolaMake 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.

About me: I'm Paul, a SQSP user for over 18 yrs and a Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF.DIGITAL, providing high quality original extensions to supercharge your Squarespace website. 
Content: Views and opinions are my own. Links in my posts may refer to my own SF.DIGITAL products or may be affiliate links.
Forum advice is completely free. You can thank me by selecting a feedback emoji below. Buying a coffee is optional.

Book paid help with domains: Connect a GoDaddy domain. Connect a Squarespace Domain. Domain assistance

Link to comment
  • 2 months later...

Hi Paul...I just posted a forum topic I think is similar.  I want to trigger a Zapier task when someone makes a purchase of one of my products.  I have a custom form on my products, so I need to access the data from this custom form.  If I understand your solution correctly, I should:

1. Create a new Orders Sheet in Google to store Squarespace Orders

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

3. Create a Zapier workflow that will trigger when a new order appears.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment


×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.