Import Template for Bold Subscriptions V2 Migrations

Overview

If you are interested in migrating your active subscribers to Bold Subscriptions V2, please ensure that you have been approved by Bold and meet the eligibility requirements in our Migrating to Bold Subscriptions V2 article.

 Pro-Tip

Please note that this article is only for stores that have already been acknowledged for the Bold Subscriptions V2 migration. For more information on requesting this process for your store, please visit our Migrating to Bold Subscriptions V2 article.

Once you are ready to migrate to Bold Subscriptions V2, please download and complete the Bold Subscriptions V2 Import Template CSV File (2 KB). Our Migrations team will be able to review this information, and import it to our app.

Note: This is only required for stores leaving a different platform to coming to Bold. If your store is currently using Bold Subscriptions V1, this will not be required. Please read and follow this guide before submitting your import template to our team. Mis-filled templates can result in a delay to your import process.

Please also note that full or partial migrations cannot be performed without the help of our Migration team. If you have any questions about filling out the form, please see our detailed explanation of the import template CSV columns, here:

 


 

A - order_id

Unique subscription identifier used for grouping line items together. Has to be unique, except where multiple lines should be part of the same subscription. In that case, they would be required to have the same group ID. 

Note: If multiple rows have the same order ID, then all entries in those rows should be the same except for the product information. (For example, platform_product_id, price, quantity, etc)

This information is required.

 

B - line_item_id

The line item id must be unique. Used to identify a row within the CSV. Best to be used in ascending order (1, 2, 3, etc)

This information is required. 

C - first_name

First name of customer who will be receiving the subscription. This information is required.

 

D - last_name

Last name of customer who will be receiving the subscription. This information is required.

 

E - company

This information is not required. When your customers input a company name within the checkout, this information could be added here. 

 

F - customer_email

Email address for the customer. Needs to be the same email address provided for the billing_email column. This information is required.

 

G - address1

This information is required.

 

H - address2

This section can be used for your customers apartment number, or other shipping information that was entered within the order. This information is not a requirement for the template.

 

I - city

This information is required.

 

J - province

This information is required for countries that ask for province/state during the Shopify checkout process.

Note: Do not abbreviate American states or Canadian provinces; they must be the full province or state name.

 

 K - country

This information is required.

Note: Do not use abbreviations. The full Country name should be filled out. (For example, Canada instead of CA) Here

 

L - zip

This information is required.

If you are in the US and your Zip code is 9 digits long, please put a dash in between. For example, 64735-1234

 

M - phone

This information is not required unless you require phone numbers for your orders in Shopify. This setting is found under Settings > Checkout in your Shopify admin.

 

N - billing_first_name

This information is required. First name on the customer's credit card.

 

O - billing_last_name

This information is required. Last name on the customer's credit card.

 

P - billing_company

This information is optional. The company included with the billing information.

 

Q - billing_address1

This information is required, as the spreadsheet has to match the address stored on file for the customer's credit card.

 

R - billing_address2

This information is optional, but has to match the address stored on file for the customer's credit card.

 

S- billing_city

This information is required, and has to match the address stored on file for the customer's credit card.

 

T - billing_province

This information is required for countries that ask for province/state during the Shopify checkout process, and has to match the address stored on file for the customer's credit card.

Note: Please do not abbreviate American states or Canadian provinces, as the spreadsheet must be the full province or state. Has to match the address stored on file for the customer's credit card.

 

U - billing_country

This information is required. Has to match the address stored on file for the customer's credit card.

Note: Do not use abbreviations. All Countries should be written out in full. (For example, United States instead of US.)

 

V - billing_zip

This information is required. Has to match the address stored on file for the customer's credit card.

If you are in the US and your ZIP code is 9 digits long, please put a dash in between. For example, 64735-1234

 

W - billing_phone

This information is not required unless you require phone numbers for your orders in Shopify. This setting is found under Settings > Checkout in your Shopify admin.

X - subscription_group_id

This information is required. Our migration specialists will help provide this information to fill out the template.

 

Y - platform_product_id

This information is 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 4457088254016.

Test_Store_URL_Product_ID.png

 

Z - platform_variant_id

This information is 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 bare, at the end of the URL. The variant ID, in this case, is 

Test_Store_Variant_ID.png

 Alert

If your product doesn't have variants, there is an alternative way to find this information. From within the Shopify product admin, enter .json or .xml at the end of the URL. This will take you to a webpage that will display the default variant ID information.

json_Variant_ID.png

AA - price

Price, no decimals in cents. This information is required, and should be the exact price you want to charge the imported customer for the product. 

Please 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 applicable shipping will be calculated based on the settings created in Shopify.

 

 Example

If you had an item that is sold for $200.00, then it would show in cents as 20000. If you offered a 50% discount on this product, then it would be entered as 10000

 

AB - charged_currency

For example, CAD, USD, GBP, etc.

 

AC - base_to_charged_exchange_rate

The intended exchanger rate between the shop's base currency and charged_currency provided.

 

AD - quantity

This information is required. This numerical value is how many of that specific product they had subscribed to.

 

AE - next_ship_date

This information is required for all subscribers. This is the date for their first Shopify order to be processed by Subscriptions. This always needs to be a date in the future, scheduled at least the following day after the import has been completed.

Formatting for these dates is key. The required date format is YYYY-MM-DD 00:00:00 and must be converted to UTC.

 

AF - gateway_customer_id

This information can be exported from the "Customers" page in your Stripe Dashboard. The Stripe IDs are found in column A of the export file that is created. This information is required when migrating from Stripe.

 Pro-Tip

This information usually is formatted as cus_123456ABC67

 

AG - gateway_payment_id

The customer's payment method token from the payment gateway. This information is optional when migrating from Stripe, and only identifies which payment method to use if a customer has multiple payment methods in Stripe.

 Pro-Tip

This information usually is formatted as pm_123456ABC67

 

AH - shopify_customer_id

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

 

AI - purchase_date

Original subscription date. This information is required.

Formatting for these dates is key. The required date format is YYYY-MM-DD.

 

AJ - internal_notes

Plain text of internal notes on the subscription. This information is not required.

 

AK - active

This information is required.

0 means subscription is archived and inactive.

1 means that the subscription is active and should generate orders moving forward.

 

AL - is_prepaid

Prepaid subscriptions are currently not available within Shopify. This column should be 0.

 

AM - prepaid_duration

Prepaid subscriptions are currently not available within Shopify. Please leave this column blank.

 

AN - prepaid_current_recurrence_count

Prepaid subscriptions are currently not available within Shopify. Please leave this column blank.

 

AO - prepaid_continue_as

Prepaid subscriptions are currently not available within Shopify. Please leave this column blank.

 

AP - interval_number

What number will associate with the frequency. For example: The number in the following: Every (1) week, every (15) days, every (3) weeks.

 

AQ - interval_type

This information is required. Needs to be one fo these values: day, week, month, year.

 

AR - interval_name

Any value the merchant would like to represent what the subscription frequency will be. This is text, and can be named anything and will display to the customer what their frequency is. Notable examples would be "Monthly Club", or "Shave weekly", etc.

AS - week_type

We will populate this field.

 

AT - week_day

We will populate this field.

 

AU - month_type

We will populate this field.

 

AV - month_day

We will populate this field.

 

AW - month_occurrence

We will populate this field.

 

AX - month_occurrence_day

We will populate this field.

 

AY - year_type

We will populate this field.

 

AZ - year_month

We will populate this field.

 

BA - year_occurrence

We will populate this field.

 

BB - year_occurrence_day

We will populate this field.

 

BC - note

This value is optional.

 

BD - order_rrule

This field is only required if no values were given for the interval fields.

The value provided here must include a DTSTART separated with a line break from the rest of the RRule. A timezone (TZID) is required, otherwise the subscription will be processed in UTC time.

          DTSTART;TZID=Europe/London:20190506T000000
RRULE:FREQ=DAILY

 

Was this article helpful?
0 out of 0 found this helpful