There are some serious failings of the Subscription service that need to be addressed by the developers. I attempted to contact the support chat team, but I was blown off with a "we'll bring that up to the developers". ...I'm in I.T., and that means "go away" in polite speak. Yes, this is a bit of a rant but I hope someone from the development team spends two seconds reading it and fixing it.
Let's start with the lack of data transparency specific to subscriptions. There is no way to obtain an export of any of the subscription data. Not through the products export, not through the profiles export. At least with the products export, you can look for the sku and the purchase date to know when the subscription was initiated, but there is no method to determine renewal nor cancellation of the subscription. Well, that is not 100% true, you receive an email, but since the order number that was canceled is not included in the email notice, just the subscribers email address, you have no way to determining what order was canceled; especially since they might be subscribed multiple times to multiple items.
The User export is even worse. "Subscriber Since" is blank for everybody, even if they are a subscriber. The data is simply not available export, even though it is listed in the csv file; this was stated by the support agent. Even if it were, the table is not constructed in a manner that lets you determine what they subscribed to, how many subscriptions they have, and most importantly, if they canceled (any of) those subscriptions.
I am expecting to have hundreds of subscribers through my website, and per their chat support representative, the only manner I have of determining any of that data is to walk through each persons profile on their website, look to see if they have any recurring charges deep into their profile, then go into there to determine the status of said subscription. ...so I'll need to have me and/or my staff spend hours upon hours per day looking for updates to the subscriptions we will be selling through a web GUI, and then manually update external spreadsheets to keep track of what we own to whom.
I am sorry, but that is a completely unusable product. How in the h*** are we expected to run a business in that manner?
So, for any dev's still reading this, here is how to fix this issue. Write code to generate the following csv report specific to subscriptions:
Order ID, so we can cross-reference the purchase to the orders csv export.
Customer first name
Customer last name
subscription product ordered - lineitem sku
subscription product ordered - product description
date/time this Order ID was initially ordered
date/time this Order ID was last renewed
date/time this Order ID was canceled
The usual shipping data always included in export reports
Each line in the export should use the Order Number as the primary key to let a single customer have multiple subscriptions listed and tracked separately.
Without this report, it is impossible to use the subscription model on SquareSpace because it is impossible to feasibly track all the customer & sales data through your web interface.
Provide this report and we can easily automate our entire subscription model in the store. Fail to provide it and your subscription product is pretty much useless as it does not give us a means of determining who our customers are, what we owe them, and if they are no longer paying for our services.