Upload order data
Uploads give you the option to do two things:
- Import subscriptions sold on a selling platform that doesn’t support Subsail’s automatic imports
- Import current or old subscriber data, so that all your subscriptions can be managed and viewed within your Subsail account
Imports are done by uploading a CSV file of order data. There are specific format requirements to make sure Subsail can import your data correctly.
The supported options for uploads are:
- Squarespace exports
- Custom and Subsail-formatted data
Full instructions for importing Squarespace orders are on the Squarespace page.
Custom data (in Subsail’s column format)
This option is for when you have your subscription data in a custom spreadsheet. The import process is quite flexible, but there are some required columns. If any of the following is confusing, please email firstname.lastname@example.org.
→ Please look at the Subsail import template for an example.
- The example above shows columns and their names but you can label them however you want; after you have uploaded your file, you can assign columns to match Subsail’s requirements.
- Dates in the CSV file must match the format you provide in the upload form’s “Date format” field. This field tells Subsail how you have formatted your dates. Example dates and respective formats:
Start issue (required)
Numerical value of start issue.
How many issues are included in this subscription.
Price and Currency (both required)
How much the customer paid.
In the Currency column, use the ISO 4217 code (for example,
EUR for Euro,
AUD for Australian dollar,
GBP for British Pound).
Order ID (required)
Original order ID (eg. the order number generated by your selling platform).
Should be unique.
Dates in the CSV must match the date you define in the upload form (information above).
Payment or transaction ID.
If a full or partial refund has been made, list the amount.
A code used in a subscription campaign, or a discount code used for this order.
When using the “Promo code” column for a discount, the amount discounted for this order.
Important: The “Price” column should reflect the total paid after the discount, if the “Discount amount” column is used.
The subscriber’s email address.
Email is what Subsail uses as a unique identifier. Multiple subscriptions for the same email address will be grouped under a single subscriber record.
First name and Last name (both required)
The subscriber’s name.
Also used in the shipping address.
Address columns (required)
Shipping address for the subscription.
- Address 1
- Address 2 (optional)
- State (optional)
- Country – use the ISO 3166-1 Alpha-2 code for each country (for example,
GBfor United Kingdom,
USfor United States)
Denotes if this subscription has a recurring payment on a different platform.
This is important because non-recurring subscribers will be sent automated emails for lapsing subscriptions.
No (default) or
Denotes if this subscription has been gifted as a “comp” (complimentary subscription).
When used together with the “Recurring” column, this can generate recurring comped subscriptions.
No (default) or
Sent issues and Sent dates
“Sent issues” and “Sent dates” are special fields that you can use to tell Subsail if you have already sent out issues. This can be really helpful to add this extra information in bulk.
List more than one item in these two fields using a pipe character (
|), like this:
- Sent issues column:
Sent dates column:
20-08-2015|20-12-2015|20-04-2016(make sure these dates match the format you specify in the form’s “Date format” field!)
Note: You can use the “Sent issues” without the “Sent dates” field, but if you don’t specify data in the “Sent issues” column, the “Sent dates” column will be ignored.
A free-form field to add any extra information to a subscription.
Gifter first name and Gifter last name
The name of the purchaser of a gift subscription.
The email address of the purchaser of a gift subscription. Gifter email is required when saving a gifter.
Upload from other platforms
Other popular e-commerce platforms are supported with automatic imports, which is a much easier and simple process. There are currently no plans to add other platforms for use with uploaded imports.