How to Import and Export WooCommerce Subscriptions Orders

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

This article explains how to Import and Export WooCommerce subscription orders by using Order / Coupon / Subscription Export Import Plugin for WooCommerce. Please refer to the product page to know more about the plugin features.

Overview

The WooCommerce Order / Coupon / Subscription Import-Export plugin allows you to import Subscription Orders from WooCommerce store. It exports Subscription Orders from WooCommerce store to the CSV file. Under Subscription Import / Export tab, you can import/export/merge (update existing subscription order) hundreds, even thousands, of Subscription Orders using one file which saves your effort and time of manually adding information of Subscription Orders.

For importing Subscription Orders to your online store, you must create a CSV (Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create a CSV file by using a spreadsheet program, such as  Excel, or Google Spreadsheets. Save this file with extension.CSV.  After entering all details about Subscription Orders in the spreadsheet, you can import Subscription orders to your online store. With this plugin, you can also export Subscription Orders details as a CSV file.

Subscription Orders Import/Export tab

The plugin takes CSV file as input. It maps each field of CSV file to the field of Subscription Order.

For example, Subscription_Id field gets mapped to the identification number of the Subscription Orders and the order_total field gets mapped to the total subscription amount. If you want the plugin to work correctly, you must map headers of all of the column correctly and you must ensure that all of the fields you enter must be in the correct format.

Note:

  1. If there is any mistake in your import file, your Subscription Order import may not work as expected.
  2. The CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?
  3. After the import of the subscriptions has been completed, the admin has to perform a one-time manual renewal for all the imported active subscription. All the rest of the renewal will occur automatically after the first manual renewal.
To get started you must have CSV file. You can create the one, export the Subscription order to get the format of CSV or download Subscription Sample CSV.
You must enter the subscription order details in CSV file in the structured format as given below:
  • The first row must contain the column headers which are used for mapping the fields. The details about the mapping fields are given as below:
    Column Heading Explanation Accepted value or format
     subscription_id  Identification number of the Subscription order   Numerical
     subscription_status  Status of the Subscription order  Text

    e.g. Active, Pending, etc.

     customer_id  Identification number of customer  Numerical
     customer_username  Username of customer  Text
     customer_email  Email ID of customer Text

    e.g. test1@gmail.com

     start_date  Starting date of the subscription  MM/DD/YYYY H:i:s
    e.g  8/25/2016  7:28:19
     trial_end_date  Ending date of the trial period MM/DD/YYYY H:i:s
    e.g  8/25/2016  7:28:1
     next_payment_date  Due date of the next payment  MM/DD/YYYY H:i:s
    e.g  8/25/2016  7:28:19
     last_payment_date  date on which the last payment is done  MM/DD/YYYY H:i:s
    e.g  8/25/2016  7:28:1
     end_date  Ending date of the subscription  MM/DD/YYYY H:i:s
    e.g  8/25/2016  7:28:1
     post_parent Order  ID of the parent order  Numerical
     billing_period The time period used for calculating renewal payment dates. Must be either: day, week, month, year. An invalid or empty billing period will cause an error during the import and the subscription will not be imported  Text

    e.g. Monthly, Weekly, etc.

     billing_interval The interval used for calculating renewal payment dates. Must be an integer value to represent how many subscription periods between each payment  Numerical

    e.g. Number 2 in this column and week for the billing_period will create subscription processes a renewal payment every two weeks

     order_shipping Total cost of shipping the subscription order  Numerical
     order_shipping_tax  Tax applied on total shipping cost  Numerical
      fee_total  An additional fee (any kind of charge) to order total  Numerical
     fee_tax_total  Tax on total fee  Numerical
     order_tax  Total tax on the order  Numerical
     cart_discount  Discount on the cart amount  Numerical
     cart_discount_tax  Tax on Cart Discount  Numerical
     order_total Order total after addition/deduction of tax/discount  Numerical
     order_currency  Currency of the order  Text e.g. USD
     payment_method  payment method used for paying the order amount  Text e.g. Credit Card
     payment_method_title  Title of the payment method which is visible to customer  Text
     payment_method_post_meta  Payment gateway metadata required to process automatic recurring payments  Text
     payment_method_user_meta  Payment gateway metadata required to process automatic recurring payments  Text
     shipping_method  This can be either the shipping method ID or specific format as shown in the next column Mixed: Text and Numerical

    e.g. method_id:flat_rate:10|method_title:Flat Rate|total:15.00

     billing_first_name  The first name to use on the billing address for the subscription and renewal orders  Text
     billing_last_name  The last name to use on the billing address for the subscription and renewal orders  Text
      billing_email  The email address to use on the billing address for the subscription and renewal orders  Text
     billing_phone  The phone number to use on the billing address for the subscription and renewal orders  Text
     billing_address_1  The street address to use on the billing address for the subscription and renewal orders  Text
      billing_address_2  The street address to use on the billing address for the subscription and renewal orders  Text
     billing_postcode  The postal or zip code to use on the billing address for the subscription and renewal orders  Text
      billing_city  The city to use on the billing address for the subscription and renewal orders  Text
     billing_state  The state or county to use on the billing address for the subscription and renewal orders  Text
     billing_country  The 2 letter country code to use on the billing address for the subscription and renewal orders  Text
      billing_company  The name of the company to use on the billing address for the subscription and renewal orders  Text
     shipping_first_name  The first name to use on the shipping address for the subscription and renewal orders  Text
      shipping_last_name  The last name to use on the shipping address for the subscription and renewal orders  Text
     shipping_address_1  The street address to use on the shipping address for the subscription and renewal orders  Text
     shipping_address_2  The street address to use on the shipping address for the subscription and renewal orders  Text
     shipping_postcode  The postal or zip code to use on the shipping address for the subscription and renewal orders  Text
     shipping_city  The city to use on the shipping address for the subscription and renewal orders  Text
     shipping_state The state or county to use on the shipping address for the subscription and renewal orders  Text
     shipping_country  The 2 letter country code to use on the shipping address for the subscription and renewal orders  Text
     shipping_company  The name of the company to use on the Shipping address for the subscription and renewal orders  Text
     customer_note  An optional to include on the subscription from the customer that is shared with for store managers  text
      order_items  The product line items on the subscription used to set the line items on renewal orders. Can be a product or variation ID  Text
      order_notes  A string of order notes separated by the ; symbol  Text

    e.g. Payment received.; Status changed from Pending to Active.

     coupon_items  Add coupon line items to the subscription and renewal orders  Text
     fee_items  Add fee line items to the subscription and renewal orders  Text
     tax_items  Add tax line items to the subscription and renewal orders  Text
     download_permissions  Can be either  1 to grant download permissions for product line items on the subscription or 0 to not grant download permissions  Numerical

    e.g. 1

  • Each row contains the single Subscription order.
Subscription import window
Subscription import window

The Import Screen appears as shown below:

You can import subscription orders from CSV file or merge the subscription orders with already existing by importing updated CSV file.

Import Subscription orders

Subscription import page
Subscription import page

You can import all the required subscription orders by using Import. Click Import Subscription orders, the window appears as shown below:

    1. Method 1: Select a file from your computer. Click Choose File to browse a required CSV file from your computer.
    2. Method 2: Provide FTP Details. If your CSV file is on a server, then to import it,  you need to do FTP settings as explained below:
      1. Select the checkbox to enable FTP import/export.
      2. Enter FTP Server Host/IP.
      3. Enter FTP User Name.
      4. Enter FTP Password.
      5. Enter FTP Port number.
      6. Enter FTP Server Path.
      7. Select the checkbox to use FTPS.
    3. You get the mapping file option(s) for auto-mapping only if you save the mapped fields with a user-defined file name while Mapping the fields. Select the required mapping file from the Select a mapping file drop-down list as shown below:
      Select a mapping file
      Select a mapping file
    4. Enter the delimiter which separates the mapping values.
    5. Click Upload file and Import. The import window appears as shown below:
      Subscription import map fields
      Subscription import map fields
    6. You can map the fields(Woocommerce fields) with column headings ( CSV file header). Map a particular field of Map to column by using Column header  drop-down list as shown below:
      Subscription import map column header
      Map column headers for subscriptions

      Select a required option from the drop-down list. Here Subscription ID is mapped to subscription_id.

      Note: Mapping is very helpful if you are importing CSV from some other e-Commerce platform like Magento.

      Evaluation field

      Settings for Evaluation fields
      Settings for Evaluation fields

      It is used to fix/update the required value for the particular field. The settings to modify the field are as given below:

      • Assign any required constant value to field (=)
        For Example: Suppose, you want to assign Pending to Subscription Status. Under Evaluation field, write =Pending in  Subscription Status row.
      • Add any required value to the field (+)
        For Example: Suppose, you want to add 5 to Total Shipping. Under Evaluation field, write +5 in Total Shipping row.
      • Reduce any required value from the field (-)
        For Example: Suppose, you want to reduce 5 from Cart Discount. Under Evaluation field, write -5 in the Total Discount row.
      • Multiply by any required value to the field (*)
        For Example: Suppose, you want to multiply to Order Total by 1.05. Under Evaluation field, write *1.05 in Subscription Total row.
      • Divide by any required value to field (/)
        For Example: Suppose, you want to divide Billing Discount by 2. Under Evaluation field, write /2 in Billing Discount row.
      • To Convert the trial end date to WooCommerce format, provide your CSV date format in the evaluation field.
        For Example: In CSV,  If you have entered the date in correct PHP format as @ d/m/yy H:i:s ( @ 13/07/2016 4:24:25) , then under Evaluation field, you must maintain the same date format as @ d/m/yy H:i:s  in the Trial End Date row. Then the plugin internally converts it in WooCommerce format as 2016-07-13 4:24:25.
      • Append any field by the required value
        For Example: Suppose, you want to append Billing Company by Pvt Ltd. Under Evaluation field, write &Pvt Ltd in Billing Company row.
      • Prepend any field by the required value
        For Example: Suppose, you want to prepend Billing First Name by Mr/ Mrs. Under Evaluation field, write &Mr/Mrs[VAL] in Billing First Name row.

      Note: Hover the mouse on? (Help), you can see the information about Evaluation field.

    7. After mapping all the required field, you can save these mapping and evaluation fields in a file (user-defined) by using the Mapping file name field.
    8. Click Submit.
  • According to CSV file, the subscription order(s) gets added to your online store. The import window appears as shown below:woocommerce orders xml importTo see the imported Subscription orders, navigate to Dashboard > WooCommerce > Subscriptions, the window appears as shown below:
    Imported Subscription Orders
    Imported Subscription Orders

Merge Subscription orders

Suppose your existing Subscription order got modified. To reflect that modified order into your online store, you can update the current Subscription orders by importing modified CSV file. This is called a merging of the subscription orders.

Steps to merge Subscription orders

  1. Select Merge Subscription Order if exists checkbox for modifying Subscription orders as shown below:
    Merge existing subscription window
    Merge existing subscription window
  2. Click Import Subscription Orders, you get Merge Order window as shown below:
    Merge subscription orders page
    Merge subscription orders page
  3. Browse the updated CSV file by clicking on Choose file or by using FTP.
  4. You get the mapping file option(s) for auto-mapping only if you save the mapped fields in a user-defined file while Mapping the fields. Select the required mapping file from the Select a mapping file drop-down list as shown below:
    Select a mapping file
    Select a mapping file
  5. Enter the delimiter which separates the values.
  6. Click Upload file and Import. The Merge Order Window appears as shown below:
    Subscription orders map fields
    Map subscription fields
  7. Re-Map the fields if required.
  8. Click Submit.
  9. According to CSV file, the Subscription Orders gets merged with existing. The window appears as shown below:
    Merge Order Window
    Merge Order Window

    Note: If Subscription ID does not exist, then the subscription order is imported as a new.

Export Subscription orders

Export subscription orders in CSV format
Export subscription orders in CSV format

If you export Subscription orders using the plugin, you get the CSV file which contains the data about all the Subscription orders of the WooCommerce online store.

You can export all the required Subscription orders by using the Export orders option. The window appears as shown below:

  1. Order Statuses:  Select order statuses for which you want to export orders from the given list:
    Subscription order statuses
    Subscription order statuses
  2. Offset: Enter the order row number at which you wish to start the export.
  3. Limit: Enter the maximum number of orders that you wish to export.
  4. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  5. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
  6. Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
  7. Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
  8. Click Export Orders, the CSV file gets auto-downloaded to your computer. The sample exported CSV file is as shown below:
    Sample Exported CSV
    Sample Exported CSV

    Note: You can download the Sample of Exported Subscription order CSV.

Export Subscription order(s) from Subscriptions Page

Subscriptions Page
Subscriptions Page

You can directly download the export file with all the fields. To do that, navigate to Dashboard > WooCommerce > Subscriptions. The Subscriptions page appears as shown below:

  • To export single Subscription order, select Download as CSV from Bulk Action drop-down list and click Apply. All the information about selected Subscription order gets auto-downloaded to CSV file.
  • To export bulk Subscription order, select them. From Bulk Action drop-down list, select Download as CSV and click Apply. All the information about selected Subscription orders gets auto-downloaded to CSV file.

Check out our Order / Coupon / Subscription Export Import Plugin for WooCommerce.

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *