How To Get The Data From My Existing Program

Depending on the software you're migrating from, you may have different options for retrieving or exporting your program data. 
The two most common options are:

From Your Existing Subscription Platform

  • Export files: this is the most common and approachable for any user however 3rd party tools such as Excel often auto format data (eg removes leading 0s from zip codes) which may cause errors or incorrectly imported data:
    • To use this method you'll need to export from your existing subscription software all the records for the following: 
      • Customers
      • Subscriptions
      • Payments used on subscriptions (it's not an issue if you have unused as well)
      • Shipping addresses tied to subscriptions (it's not an issue if you have unused as well)

Note: If the above data does not provide the next order date for your subscriptions, you'll need to export data that will provide this. Usually, that can be done by exporting all (or only all unsent) subscription orders.

  • APIs: While more complex, APIs are a more reliable way to extract your data. You will need to ensure the following is true to use this method:
    • You have access to engineering resources who will be able to write a script or program to extract the data via API
    • Your existing subscription software has all the necessary data accessible via API. Please see below for the required fields.

  • Support Teams: Unfortunately, sometimes your existing subscription platform may not provide all the tools necessary to extract the data you need. Most commonly, this is related to payment info and sometimes even the e-commerce customer ID associated with the subscriber.  In these cases, your only option is to contact the software's support team and ask for an export.  This usually works, it just takes time.


From Your Payment Gateway

If you're having trouble getting your payment tokens or display data, you may be able to get it directly from the payment gateway. There are three ways to accomplish this:

  • Export files: Export the data using tools provided by the gateway. While this is dependent on your gateway, there are one or more ways to export your data directly from your account.
    For example, when using Stripe's Stripe Sigma tool, you can easily export your data using the query below:
    SELECT id, email FROM customers;
  • APIs: Use your Gateway's API to download all of your data. This will require engineering resources who will be able to write a script or program to extract the data via API.

  • Support Teams: Contact the gateway directly and request an export of your data. This always works but it can take a long time.

 

We've made getting your data out of ReCharge easy. Here is what you need to do:

Step 1: Download and install the data extract tool

    • Visit the Migrations section of Ordergroove, and click on the ReCharge Export tab
    • Where it says Download Export Tool, select your operating system to download the export tool.
    • When finished downloading, install the exporting tool on your computer.

Step 2: Extract The Data

  • Open the og-data-extractor tool you installed above.  
  • Read the terms and accept the EULA by scrolling to the bottom and clicking the I Agree button.
  • Enter your ReCharge API key. If you haven't already created one, follow the instructions found here.

    mceclip7.png

  • If you wish to migrate your PayPal-using subscribers to Shopify Payments by using Braintree, provide your Braintree MerchantID, Public Key and Private Key in the respective fields.

    mceclip8.png

  • Select the location where you wish to download the files by clicking the Choose directory button.

    mceclip10.png

  • If you have already downloaded one of the three files, you may deselect it and the tool will skip it. By default, all three files are selected.

    mceclip11.png

  • To download the selected files, click the Download button. The amount of data being extracted may influence how much time the download takes.

    mceclip12.png


Step 3: Transform the Files:
With these files download, you can now transform these files into an Ordergroove migration file.
To learn more about the file transformation process, click here.