Non-Shopify Subscription Import Data Template

In order to migrate from a non-Shopify platform we'll need the subscription data from your previous platform. Below are definitions of the fields that you'll find in the migration data templates. We'll need the data in CSV format. There are 2 templates to fill out: Customer and Subscription Data.

Here are the templates for you to download as well as examples:

• Customer Data Template
  • Here is the template with an example row
• Subscription Data Template
  • Here is the template with example rows

Customer Data

• shopify_customer_id: Shopify Customer ID* (must be unique)
• email: Shopify Customer email address* (must be unique)
• first_name: Customer first name
• last_name: Customer last name

Subscription Data

• subscription_id: Subscription ID* (must be unique)
• status: Subscription status* (ACTIVE or PAUSED)
• shopify_customer_id: Shopify Customer ID*
• customer_email: Shopify Customer email address*
• price: Unit price of the item*
  • IMPORTANT This is the unit price - it will be multiplied by quantity.
  • If this is a prepaid line then the price should be the full prepaid cost
• currency_code: Currency code of the subscription*
• quantity: Quantity of the line*
• frequency_unit: Frequency unit* (DAY, MONTH, YEAR)
• frequency_value: Number of frequency_units between orders*
• total_shipping: Total cost of shipping (currency will be the same as price)*
• shipping_first_name: First name of shipping address*
• shipping_last_name: Last name of shipping address*
• shipping_address1: First line of shipping address*
• shipping_address2: Second line of shipping address
• shipping_city: City of shipping address*
• shipping_province: Province of shipping address*
• shipping_zip: Zipcode of shipping address*
• shipping_country: Country of shipping address*
• shipping_company: Company of shipping address
• shipping_phone: Phone number of shipping address
• next_billing_date: ISO Formatted date string* (ex: 2024-01-01)
• shopify_variant_id: Shopify variant ID*
• created_at: ISO formatted date string of when the subscription was created
  • if not provided we'll use the day of the migration
• note: Internal note for subscription (each line of the same subscription should have the same note)
• is_prepaid: true if the line is prepaid
• prepaid_orders_count: Number of orders that the customer prepaid for (only if prepaid is true)
• prepaid_successful_billings: Number of prepaid orders that the customer has already received. Should be 0 if the prepaid subscription is due for a renewal
• auto_renew: Only filled out if prepaid is true. Set auto_renew to true if the prepaid subscription renews at the end of its prepaid orders and false if it should expire