T - Billing Phone

If a customer is subscribed to multiple products, we require a row created for each product. Duplicate the customer information for each row.

If the customer shipping and billing information, order frequency, and "Next Charge" line up exactly, they will be merged into one subscription following the import.

If the products have different order frequencies, this will result in multiple subscriptions being created for the customer.

U - Product Title

Required. The Product Title comes directly from Shopify when viewing the product. This needs to be exact, directly copied and pasted.

V - Variant Title

Required. The Variant Title comes directly from Shopify when viewing the product. This does not need to be exact, but is best just copy and pasted from Shopify. We pull the variant based on the ID provided, not the title.

Variant Title Example #1: XS, S, M, L, XL would be the variant titles in this example.

W - SKU

Not required, but can be provided. We rely on Product ID and Variant ID.

X - Product ID

Required. This is found when editing the product in Shopify, in your browser URL bar. You can copy and paste this directly from the browser bar. This is what we rely on to link the correct product.

In this example, the product ID is 8936794312.

Y - Variant ID

Required. This is found when editing the specific variant in Shopify, in your browser URL bar. You can copy and paste this directly from there. This is what we rely on to link the correct variant.

You would find the specific variant and select "Edit".

Then you would find the ID in the browser bar, at the end of the URL. The variant ID, in this case, is 32125539272.

Z - Price

Required. This should be the exact price you want to charge the imported customer for the product. It should be the product price-per-unit. You should incorporate any automatic discounts your previous platform would have applied to the product price. The price you enter can be different than the current Shopify listed price if the migrated customers are on a legacy plan.

Taxes and any applicable shipping will be calculated when Recurring Orders produces the order in Shopify.

AA - Quantity

Required. This numerical value is how many of that specific product they have subscribed to.

AB - Frequency Number

Required. Needs to be a numerical value. This column combines with the "AC" column.

AC - Frequency Type

Required. This column combines with the "AB" column.

Needs to be one of these values: Days, Weeks, Months, Years.

AB and AC columns combine to produce this:

1 Weeks

2 Months

6 Months

1 Years

Important

AD - Next Charge

Required for all subscribers.

This is the date of the first recurring order you'd like produced in Shopify, following the import.

Formatting for these dates is key.

The preferred date format is 2017-05-30, aka YYYY-MM-DD.

However, if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) then the European d-m-y format is assumed. If, however, the year is given in a two digit format only and the separator is a dash (-), the date string is parsed as y-m-d.

Here are some examples of correctly formatted dates:

2017-10-31 (YYYY-MM-DD)

2018-02-13 (YYYY-MM-DD)

12/30/2017 (MM/DD/YYYY)

04/26/2017 (MM/DD/YYYY)

31-04-2018 (DD-MM-YYYY)

25-12-2018 (DD-MM-YYYY)

If the subscription is prepaid, this doesn't necessarily mean the customer will be charged. Just consider this their next upcoming prepaid order date.

AG - Use Shopify Setting

AH - Payment Gateway Customer ID

This process depends on what payment gateway you have been using on your previous platform/app. We can only import active subscribers from our Supported Payment Gateways. We do not support PayPal.

If you used Stripe or BrainTree on your previous platform we require a customer token or customer ID for each subscriber.

For Stripe, we require the Stripe Customer ID.

This is how they are typically formatted:

cus_123456ABC67

For BrainTree, we require a BrainTree Customer ID.

This is usually a series of numbers.

If you are currently using a Recurring Orders supported payment gateway that is not Stripe or BrainTree, and are looking to import your subscribers into Recurring Orders, please Email our Support Wizards to discuss the process further. It may not always be possible, but we can provide next steps.

AI - Shopify Customer ID

Not required. You can insert your existing Shopify Customer IDs from your current Shopify store, which is exportable from Shopify.

AN - Notes

Not required. Put in any order notes you'd like to appear when the order generates in Shopify.

AO - Original Purchase Date

Required.

This is necessary for the Recurring Orders Stats to be accurate.

This is the date that the customer originally signed up for their subscription.

Formatting for these dates is key.

The preferred date format is 2017-05-30, aka YYYY-MM-DD.

However, if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) then the European d-m-y format is assumed. If, however, the year is given in a two digit format only and the separator is a dash (-), the date string is parsed as y-m-d.