WooCommerce Subscriptions Importer and Exporter

Import subscriptions to WooCommerce via CSV, or export your subscriptions from WooCommerce to a CSV.

• Importer Documentation
• Exporter Documentation

Support

The WooCommerce Subscriptions Importer and Exporter is released freely and openly to help WooCommerce developers migrate subscriber data to WooCommerce Subscriptions. Even with this plugin, migrations involve a lot of manual work to format subscription data correctly and test imports. Neither Prospress nor WooCommerce provide services to complete a migration with this tool.

For help with a migration, please contact WisdmLabs, an official partner for this extension.

You can learn more about the migration service WisdmLabs offer and contact them via their WooCommerce Subscriptions Migration page.

Prospress do not provide support for migration issues. This means Prospress can not help with CSV formatting, fixing broken renewals or other issues with subscriptions imported incorrectly. Similarly, issues with subscriptions created with this plugin are not supported via the WooCommerce support system.

If you think you have found a bug in the extension, problem with the documentation or limitation in the data that can be imported, please open a new issue to report it.

Subscriptions Importer

With the WooCommerce Subscriptions CSV Importer, you can import subscriptions from a CSV file into your WooCommerce store. This is particularly useful when migrating stores from a different eCommerce platform.

The subscriptions will be setup with the WooCommerce Subscriptions extension to process future recurring payments.

Before you Begin

Importing your subscriptions to WooCommerce is a complicated process.

To maximize your changes of success with an import, please read through this documentation in its entirety.

There is no substitution for this step. Fully understanding the details of the import process will save you time by avoiding mistakes that may become serious issues in the future.

Importer Usage Guide

To import your subscriptions to WooCommerce via CSV, you need to:

1. Create a CSV file with all your subscription data formatted for import (this is by far the most complicated step). The CSV Formatting Guide details the options and requirements for your CSV's content.
2. Go to WooCommerce > Subscription Importer
3. Upload your CSV file
4. Select Import Options:
   1. Check Run in test mode to validate your CSV file without creating corrupted data
   2. Check Email Passwords to email customers that are newly created their account details
   3. Check Add memberships to grant subscribers any membership/s plan corresponding to subscription products
5. Click Upload and file and import
6. Review each column of data in your file to make sure the Importer has mapped it to the correct column header.
7. Click Test CSV
8. If there are errors, fix up the CSV file and return to step 1.
9. If there are no errors, click Run Import
10. Review the Import Completion Table and Import Logs for uncover any issues with the import

While these steps may sound simple, the devil is in the details, especially in creating your CSV. The rest of this guide will provide you with the details. Please be sure to read this in its entirety.

Import Options

When uploading your CSV file, the Importer also provides you with a few options to customise the behaviour during the import process.

Import options:

• Run in Test Mode
• Email Passwords
• Add Memberships

Run in Test Mode

Running the import in test mode will analyse each row of your CSV and notify you of any warnings or errors with that data.

It will not import any subscription data in your store's database, like users or subscriptions.

After running test mode, the Importer will provide you with an Importer Test Results table. This displays the issues with your CSV. If there are issues, you can safely abort the import process to fix up the CSV. If there are no issues, you can continue the Import.

We strongly recommend you continue to run the importer in test mode until you have correct all warnings and errors. Unfortunately it's not possible to catch all errors that will occur when actually importing your subscriptions. The good news though is that even during an actual import, exceptions and other errors that can only be discovered at the time of import will be logged and the corresponding subscription will not be created.

Email Passwords

When a CSV files includes a username or email address, and the Importer can not find an existing user with either of those details, it will create a new WordPress user.

You can also specify a password to use on the user's account in the CSV, otherwise, the account is created with the secure password generated by WordPress.

When the Email Passwords option is enabled, if the Importer creates a new user account, it will also email that user a registration email with their login details and a temporary password.

If left unticked, the new users created will need to go through the "forgot your password" process which will let them reset their details via email.

Please note: the minimum requirement for creating a new user is an email address. If no username is given, the importer will to create a username from the email. Say you you need to create a new user and have only given the email address, [email protected], the importer will try a new user with username janedoe. If this username is already taken, we then try the username janedoe1, janedoe2 and so on; until it finds a free username (i.e janedoe102).

Add Memberships

If you have WooCommerce Memberships active on your site, you will also be presented with the option to Add Memberships.

When this option is enabled, subscriptions imported with product line items linked to a membership plan will also grant the subscriber's user account with corresponding membership access.

Column Mapping

During step 2 of the import process, each column header found in the CSV will be listed as a row in the table on the Map Fields to Column Names page.

You can use the dropdown menu to find and match each piece of data to a value known by the importer. You must not have the same fields mapped more than once unless it's found under the custom group.

The full list of fields, with an explanation of each, are available in the CSV Columns section of this guide.

Import Completion Table

After an import has been completed, you will be provided with a table displaying the result of each row's import.

This table will display the success of failure of the import for each row, as well as any warnings or errors that occurred when importing that row.

Review this table carefully after running your import to identify any potential issues with each subscription.

Import Error Logs

In addition to the output displayed in the Import Completion Table, the Subscriptions CSV Importer will also log issues into a special log file.

These log entries can be reviewed to see what when wrong during the import and therefore, what needs to be fixed up after the import (if anything).

These logs may contain issues not identified during test mode which relate to plugin conflicts, database issues or other errors that only occur during the live import. Becuase of this, we strongly encourage you to review the log files even if your CSV had no issues during test mode.

Exception Logger

The importer will catch all PHP exceptions thrown during the import and log them along with with the line in the CSV that was being processed when the exception occurred.

To view the exception logs:

1. Go to the WooCommerce > System Status administraction screen
2. Click the Logs tab
3. Click the select box for log files
4. Click file prefixed with: wcs-importer-
5. Click View

Example Exception Log Entry

01-15-2016 @ 05:30:26 - Row #2 failed: Array (
    [0] => Could not create subscription: Invalid Subscription billing period given.
)

Fatal Error Logger

When a fatal error occurs during the import process, the importer will log the row of data from the CSV that caused the issue and a stack trace of where the error occurred.

To view the shutdown logs:

1. Go to the WooCommerce > System Status administraction screen
2. Click the Logs tab
3. Click the select box for log files
4. Click file prefixed with: wcs-importer-shutdown-
5. Click View

Example Fatal Error Log Entry

01-12-2016 @ 05:52:16 - CSV Row: Array
(
    [product_id] => 5078
    [status] => cancelled
    [customer_id] => 1
    [start_date] =>
    [next_payment_date] =>
    [end_date] =>
    [shipping_method] => free_shipping
    [coupon_items] => code:recurring_discount|amount:10.00
)

01-12-2016 @ 05:52:16 - PHP Fatal error Call to undefined method WCS_Importer::add_coupons() in /Users/Matt/Dropbox/Sites/subs2.0/wp-content/plugins/woocommerce-subscriptions-importer-exporter/includes/class-wcs-import-parser.php on line 425.

Import HTTP Error Handling

While the Import Error Logs handle PHP errors that can be caught and logged, the Importer will also attempt to handle HTTP errors from Ajax.

To this, it will:

1. catch a HTTP error code returned by the request and
   1. display the HTTP error in the Importing Results table
   2. output the full xmlhttprequest object to the console
2. wait for 20 seconds
3. resume the import by attempting the next set of rows

Importantly, the set of rows with a failure will not be reattempted as there is no way to know which subscriptions were imported successfully. The subscriptions in the rows with HTTP errors need to be manually checked.

To aid in checking these rows, the Importer will provide:

1. the rows affected during the import when the HTTP error code is detected
2. a list of all rows affected during the entire import once the import process completes

Screenshot of CSV Import affected by various HTTP errors

CSV Formatting Guide

By far the most difficult aspect of migrating your subscriptions using the CSV Importer is formatting a valid CSV with all required data.

A subscription is created from a variety of different pieces of data, from customer details like billing and shipping address, to product details, like quantity, taxes and totals, shipping details, like shipping method, tax and cost, as well as billing schedule details, like recurring billing period, next payment date and end date. To import your subscriptions, you must create a CSV with all of this data in a valid form.

This section provides you with an overview of all the fields your CSV can contain (and in some cases, must contain).

CSV Requirements

Please follow these general rules when formatting your CSV file:

• The first row must include column headers - this is so the plugin knows where to map the fields.
• Each subscription needs to have its own row.
• Not all columns need to be filled in for each row, unless the field is labelled required in the CSV Columns section.
• Most fields are not required. However, to avoid creating subscriptions with unintended default data applied, specify as many fields as possible in your CSV.
• Two-letter country and state/county abbreviations should be used for all country, state or county data.
• Date values should always be in UTC/GMT timezone.
• Date fields can be in any string format handled by PHP's strtotime() function. However, strtotime() is a strange beast that on occasion creates unexpected date strings. It also doesn't always handle timezones as expected. Becuase of this, we encourage you to always use MySQL format for dates, e.g. YYYY-MM-DD HH:MM:SS or in PHP's date formatting terms y-m-d H:i:s). For example, 1970-01-01 00:00:01.
• All dollar amounts can be either an integer or decima/float value. For example, 5.65, 3 and 127.2 are all valid.
• Arrays are formated as key:value|key:value|key:value.

CSV Columns

If any of the above columns contains invalid data, the importer will display these during in the test run. If you choose to ignore the errors and continue to import with invalid data, no subscription will be imported for that row.

Importing Payment Gateway Meta Data

You can import payment gateway meta data, like customer or credit card tokens, in your CSV file to link a subscription with a payment method for processing recurring payments automatically.

Properly importing payment gateway meta data is a difficult, yet crucial part of the import. It's important to take the time and get this right otherwise your subscription may not renew properly. It is also much faster to set this data in bulk on import than to set it on each individual subscription after the import.

Supported Payment Gateways

The Importer can support any payment gateway that supports the new woocommerce_subscription_payment_meta filter introduced in WooCommerce Subscriptions v2.0.

Each payment method requires different meta data to process automatic payments. Because of this, we are not able to provide documentation on what meta data is required for every possible payment gateway.

However, here is a list of the column headers and meta data description for three popular payment methods:

• PayPal Reference Transactions: _paypal_subscription_id must be mapped to payment_method_post_meta column. This value needs to be the customers billing agreement (will start with I-**************).
• Authorize.net CIM: _wc_authorize_net_cim_credit_card_customer_id and _wc_authorize_net_cim_credit_card_payment_token mapped to payment_method_post_meta column.
• PayPal Powered by Braintree: _wc_braintree_credit_card_customer_id and _wc_braintree_credit_card_payment_token mapped to payment_method_post_meta and payment_method_post_meta columns.
• Stripe: _stripe_customer_id mapped to payment_method_post_meta column and optionally, _stripe_source_id also mapped to payment_method_post_meta column if you want to charge recurring payments against a specific payment method on the customer's account. Only values beginning with cus_ and card_ will be considered valid tokens.

Note: the above information relates to the official Stripe, PayPal Powered by Braintree and Authorize.net CIM extensions. It will not work with other extensions for those payment gateways.

As long as the payment gateway extension for your payment gateway is active, the Subscriptions CSV Importer will validate that you have included the necessary payment gateway meta data.

For example, if you try to import a subscription with stripe set as the payment_method, but are missing the _stripe_customer_id, the subscription will not be created and the import will fail with a message explaining that a valid _stripe_customer_id is required.

If you need to import subscriptions using a payment gateway other than those above, please ask the gateway's extension developer for details of the post or user meta data required to process automatic payments. If you also let us know which meta data is required, we will include it in this documentation to help others in future.

Note: Only subscriptions using PayPal Reference Transactions are supported. Subscriptions using PayPal Standard has a number of limitations that make it impossible to migrate them using the importer.

Importing Subscriptions with the Pending Cancellation Status

There's a couple of things to note about which dates are used before you import a subscription with pending cancellation status.

1. If the CSV row has a next payment date column and a value that is in the future, this date will be used as the end date (or end of prepaid term) for the pending cancelled subscription.
2. If the row with pending cancellation status does not have a next payment date set, it will fall back to using the end date if that exists. If it doesn't exist, you will receive an error asking to set a valie end date when importing subscriptions with pending-cancel status.

To further explain, importing a subscription with pending cancellation status will require you to make sure an end date is set in the future and no next payment date is set, otherwise this next payment date will be used as the susbcriptions end date.

Importing Order Items

In WooCommerce, orders can have a number of different line items, including:

• product line items
• shipping line items
• fee line items

A subscription is a custom order type, and therefore, can also have each of these line items added to it.

Importing Product Line Items

The order_items column can be either:

• a Single Product ID for the product you want the set as the product line item on the subscription; or
• an array of Line Item Data, including line item totals and tax amounts.

Single Product ID

When using just a single product ID in the order_items column, all line item totals and subtotals will default to the product's price at the time of import.

No amount will be added for tax, regardless of the store's tax settings.

Note: to import a variation of a variable prodcut, you must use the variation's ID, not the parent variable product's ID.

Line Item Data

To add tax or other custom information to your product line items you need to follow strict formatting for it to properly import. Each product line item needs to follow the following format: product_id:5179|quantity:1|total:9.09|tax:0.91.

The table below provides a full list of line item data that can be used when importing line items.

An example order_items column content to import a product line item would look something like this:

product_id:123|name:Product to Import|quantity:3|subtotal_tax:3.00|subtotal:30.00|tax:3.00|total:30.00|meta:size=Large+shirt-colour=Midnight Black

Line Item Meta Data

When importing a product line item, by default, the Importer will set the variation attributes (if any) of the product with a matching ID for the imported line item as line item meta data.

If you would prefer to set different attributes, or need to import meta data that does not originate from the variation attributes, you can use the meta field in the order_items colum.

The meta field can include one or more piece of meta data and must be formatted using = to delimit the meta key and value, and + to delimit each piece of meta data.

For example, to import a product line item with an Size and Shirt Colour meta with Large and Midnight Black values respectivately, the meta field would look like: meta:size=Large+shirt-colour=Midnight Black.

Notice the Shirt Colour meta key is in lowercase and uses a - instead of a space (i.e. ' ') while the Midnight Black is capitalised with a space. The meta keys in your meta field should be raw values to store in the database, not the formatted value returned by WC_Order_Item_Meta::display() or WC_Order_Item_Meta::get_formatted().

Multiple Product Line Items

To import a subscription with multiple product line items, separate each line item data with a ;. You can use a combination of the single product ID method and full line item data array method.

For example, an order_items column value for two products could look like: "product_id:5179|quantity:2|total:9.09|tax:0.91;product_id:2156|total:30". See the Sample CSV for an example of importing multiple product line items using the importer.

Importing Subscriptions with Coupons

The importer provides the coupon_items column header to apply coupons to your imported subscriptions.

You can only apply valid coupon codes that exist in your store at the time of the import. If you attempt to use a coupon code that doesn't exist, you will see the error Could not find coupon with code "<your_code>" in your store. and that row in your CSV will not be imported.

When formatting your coupon_items row, use the array syntax, for example: "code:summerdiscount2016|amount:15.00". You can attach multiple coupons/discounts to your imported subscription by separating each coupon item by the ; character. For example: "code:summerdiscount2016|amount:15.00;code:earlybird|amount:5.00".

Importing Subscriptions with Fee Line Items

The importer provides the fee_items column header to add fee line items to your imported subscriptions.

To attach fees to your imported subscriptions, the minimum requirement is the fee name field.

An example of the fee_items column could look like: "name:Handling|total:7.00|tax:0.70".

You can attach multiple fees to an imported subscription by separating the fee items with the ; symbol.

Importing Subscriptions with Tax Line Items

The importer provides the tax_items column header to add tax line items to your imported subscriptions.

If you're importing one tax rate, you can use a valid tax ID (int) or tax code (e.g. VAT) from your WooCommerce store in the tax_items column. If need to include more than one tax line item, you can use the more complicated array format.

The minimum requirement for attaching tax items is to have either the ID or the tax code field. An example tax_items column would look like: code:VAT or id:3.

There's a few simplifications when it comes to how the importer manages taxes. If you only provide the tax code in your CSV, the importer will query your available taxes and choose the tax with that code with the highest priority (i.e. if you have multiple taxes codes with VAT then it's possible the incorrect tax rate may be attached to your subscription). The alternative and more accurate workaround is to import tax items using the unique tax rate ID (found in {$wpdb->prefix}woocommerce_tax_rates table under column tax_rate_id).

When the tax rate is successfully added to your subscription, this rate is then used as the tax class for all tax values for things like line items, shipping lines, fees etc.

Sample CSV

A Sample CSV file is included in the Importer's folder with the file name wcs-import-sample.csv.

This CSV includes a number of rows to provide examples for the many different acceptable values for CSV column content. It uses almost all the available CSV column headers (though not all rows fill in all columns).

The CSV file also includes a column headed Row Description (Do not import) which provides a brief description of the example that row provides. However, in addition to the specific feature mentioned in that column, each row also provides examples of many different types of column values, like order_notes, customer_notes, totals, line items and download permissions. It also provides a good demonstrate of how to format complex data, like multiple order_items with custom meta data associated with them.

You can use the CSV on a test site to see the Importer in action. To use the CSV you need to first:

• make sure a customer exists with user ID 1 (for the first row of the CSV which creates a subscription based on user ID)
• update the product_id:1 and product_id:2 values in the order_items column to link to use the post IDs of real products

Because the Sample CSV file uses almost all the available CSV columns, it is a great place to start in creating your own CSV file.

List of Warnings and Errors

Warnings

• Shipping method and title for the subscription have been left as empty.
• The following shipping address fields have been left empty: [ LIST_OF_FIELDS ].
• The following billing address fields have been left empty: [ LIST_OF_FIELDS ].
• No subscriptions status was specified. The subscription will be created with the status "pending"
• Download permissions cannot be granted because your current WooCommerce settings have disabled this feature.
• Tax line item could not properly be added to this subscription. Please review this subscription.
• Missing tax code or ID from column: [row from CSV]
• The tax code "<tax_code>" could not be found in your store.

When a warning is included in the Import Completion Table, a link to edit the subscription administration screen is provided alongside the subscription.

Errors

• The product_id is missing from CSV.
• No product or variation in your store matcges the product ID #.
• An execpected error occurred when trying to add product "<item_name>" to your subscription.
• An error occurred with the customer information provided. Occurs when the user_id provided doesn't exist, the email doesn't exist, the username is invalid.
• The <date_type> date must occur after the <date_type>.
• Coudl not create subscription
• Invalid payment method meta data
• An error occurred when trying to add the shipping item to the subscription
• Fee name is missing from your CSV
• Could not add the fee to your subscription

Any exceptions thrown during the import process will be caught and appear as a fatal error and the subscription will not be imported.

Importer FAQ

Is it possible to make sure the active subscriptions will still process automatic payments?

Yes. If your subscriptions payment gateway supports automatic recurring payments, it may also be able to have its payment method meta data imported to link the subscription to the payment gateway to process future automatic recurring payments.

When importing active subscriptions, it's important that the correct payment method meta data is provided in the CSV. Depending on the payment gateway being used, the information required varies. For details, see the section on Importing Payment Gateway Meta Data.

Can subscriptions using PayPal Standard be imported?

No. Due to PayPal Standard limitations, the importer can not migrate subscriptions using PayPal Standard as the payment method.

The same limitations do not apply to PayPal Reference Transactions. Therefore the CSV importer can migrate subscriptions which use a PayPal Billing Agreement to process recurring payments via Reference Transactions.

If you have subscriptions with PayPal Standard and you're interested in getting your customers to use a different payment method, you can import the subscriptions with a dummy payment method, as mentioned below, and request that your customers change the payment method on those subscriptions.

Can subscriptions still be imported with a payment gateway that doesn't support migrating automatic payment meta data?

Yes. There are two possible options:

• switch the subscriptions to use manual renewals; or
• force the first payment to fail and allow the customer to pay for renewal, which will update their payment details for future payments

To switch the subscriptions to use manual renewal, you can leave the payment_method column empty.

To import the subscription in a way that the first automatic payment fails, you need to:

1. import using a temporary, valid payment method (e.g. stripe)
2. set a valid column value for the payment method meta data (e.g. set _stripe_customer_id to cus_12345)

When Subscriptions attempts to process the next renewal payment, the transaction will fail and Subscriptions failed payment handling process will begin.

If the later approach is taken, we strongly recommend that you notify customers about the change to avoid confusion.

PayPal Standard Note: Unfortunately, this approach isn't suitable for PayPal Standard. With PayPal Standard, if no valid PayPal subscription ID is provided, exceptions will be thrown whenever you or the customer changes the status of the subscription with your store, meaning its impossible to change the status of imported subscriptions. This is because Subscriptions attempts to communicate this state change to PayPal, but is unable to connect it to a valid subscription there. If you need to take this approach for customers using PayPal Standard, temporarily use Stripe or a fake payment method instead.

How can I check if a payment method can be imported with automatic payments?

WooCommerce Subscriptions v2.0 introduced a new way for payment gateways to register the payment meta data they require for processing automatic recurring payments.

To support this method, the payment gateway extension must use the filter: 'woocommerce_subscription_payment_meta'.

The importer also uses this filter in order to support a number of payment gateways with no extra code required in the gateway.

To check if subscriptions using a specific payment gateway can be imported with automatic recurring payments, you can search the payment gateway extension's codebase for the 'woocommerce_subscription_payment_meta' filter.

If that filter is being used correctly by the payment gateway then it should also work with the importer.

An alternative method to checking for importer support is to purchase a test subscription in your store using that payment gateway. Visit the WooCommerce > Edit Subscription page of the subscription you just created, and check if you can view and edit the payment method meta (see image below). If you can see these fields, the importer can import subscriptions using that payment gateway and process automatic recurring payments.

Why aren't my product line item attribute keys capitalised?

WooCommerce displays product line item attribute keys based on either:

• the attribute label in the store, if set; or
• the string key, if no matching attribute can be found.

If you have imported subscriptions with line items that have product attributes, you should also create matching product attributes in the new store.

Why aren't taxes showing on my fee line items?

Although the Importer provides a way to import tax data about fee line item, unfortunately, WooCommerce only displays tax line item data based on an array of tax data linked to the tax rate IDs. Becuase these are not imported, fee taxes will not be displayed on the on the WooCommerce > Edit Subscription and WooCommerce > Edit Order screens.

Subscriptions Exporter

With the Subscriptions CSV Exporter, you can download a comma delimited (CSV) file that contains all the details of the subscriptions in your WooCommerce store.

You can optionally filter the exported data to export only subscriptions with a specific:

• status, like active or on-hold
• recurring payment method, like PayPal or Stripe
• customer set as the subscriber

You can also choose which data to include in the CSV file.

Please note: this extension will not export any related orders for your subscriptions (this includes parent and renewal orders, etc); to export orders, you will need the WooCommerce Order CSV Exporter.

Exporter Usage Guide

1. Go to the WooCommerce > Subscription Exporter administration screen
2. On the Export Tab:
   1. Enter a name for the file (or leave as the default)
   2. Choose the status to filter exported subscriptions by, or leave all status checked to export subscriptions with any status
   3. Click the Export for Customer select box and use the search to find a customer via name, username, email or ID and then export only subscriptions for that customer
   4. Click the Payment Method select box and choose a specific payment method to export only subscriptions using a certain payment method
   5. Click the Payment Method Tokens checkbox if you want to include payment meta data, like customer or credit card tokens, in your CSV file
3. Click the CSV Headers tab
4. Click the radio fields under the Include column if you wish to exclude any subscription data from the CSV
5. Change the text in the CSV Column Header column to change the string used to identify each piece of subscription data
6. Click Export Subscriptions

Export Options

1. File name: the name used for the CSV file (defaults to subscriptions.csv).
2. Subscription Status: the subscriptions that are exported by status - untick any statuses you don't want exported (defaults to all statuses).
3. Customer: filter subscriptions that belong to a speific customer.
4. Payment Method: Use the dropdown to export subscriptions that were purchased with the chosen gateway (defaults to any gateway)
5. Payment Method Tokens: Select whether you want payment method tokens, like a customer or credit card token, to be exported in the CSV (defaults to false)

Custom CSV Headers

Before exporting, you have the option to modify the column names which are written to the CSV along with choosen which column headers are exported. For instance, you can choose to just export the customer's billing first and last name, along with the subscriptions order total.

Exported CSV Columns

FAQ

Can I export custom meta?

Sure can! You will need to:

1. Use the wcsie_export_headers to add your custom header so that it's exported in the CSV and;
2. Use wcsie_format_export_value to append the custom export data to each exported row.

/**
 * Add custom headers to the list of default headers exported in the CSV
 *
 * @param array $headers
 * @return array
 */
function my_custom_export_headers( $headers = array() ) {
    return array_merge( $headers, array(
        'shipping_code' => 'Shipping Code',
    ) );
}
add_filter( 'wcsie_export_headers', 'my_custom_export_headers', 10, 1 );

/**
 * Adds a custom meta value to the exported row
 *
 * @param string value
 * @param WC_Subscription $subscription
 * @param
 * @return string
 */
 function my_custom_export_values( $value, $subscription, $header_key ) {
    if ( 'shipping_code' == $header_key && empty( $value ) ) {
        $value = $subscription->shipping_code;
    }

    return $value;
 }
add_filter( 'wcsie_format_export_value', 'my_custom_export_values', 10, 3 );