The Best Woo Subscription Order Import Export Plugin

#1 in WooCommerce Import Export Plugin Development
#1 in Customer Satisfaction With Most 5 Star Reviews
XAdapter Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

This article explains how to know more about the plugin features.

Overview

The WooCommerce Order / Coupon / Subscription Import-Export plugin allows you 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 tore. 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 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: If there is any mistake in your import  file, your Subscription Order import may not work as expected.

• The first row must contain the column headers which are used for mapping the fields. The details about mapping field is 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 a 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) 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 tomer	Text
  payment_method_post_meta	Payment gateway meta data required tomatic recurring payments	Text
  payment_method_user_meta	Payment gateway meta data required tomatic 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 Nemurical 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 tore 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 download permissions	Numerical e.g. 1

• Each row contains the single Subscription order.

The Import Screen 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 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 audown list as shown below:
   

   Mapping File

4. Enter the delimiter which separates the mapping values.
5. Click Upload file and Import. The import window appears as shown below:
6. You can map the fields(Woocommerce fields) with column headings ( CSV file header). Map a particular field of Map down list as shown below:
   

   Map column headers for subscriptions

   Select a required option from the drop-to subscription_id.

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

   Evaluation field

   It is used to modify the field are as given below:

   

   Settings for Evaluation fields

   • Assign any required constant value to field (=)
     For Example : Suppose, you want to Subscription Status. Under Evaluation field, write =Pending in  Subscription Status row.
   • Add any required value to field (+)
     For Example : Suppose, you want to Total Shipping. Under Evaluation field, write +5 in Total Shipping row.
   • Reduce any required value from field (-)
     For Example : Suppose, you want to reduce 5 from Cart Discount. Under Evaluation field, write -5 in Total Discount row.
   • Multiply by any required value to field (*)
     For Example : Suppose, you want 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 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 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 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 Mapping file name field.
8. Click Submit.
9. According dow appears as shown below:
   

   Imported Subscription Orders

Merge Subscription orders

Suppose your existing Subscription order got modified. To reflect that modified order intore, 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

2. Click Import Subscription Orders, you get Merge Order window as shown below:
   

   Merge subscription orders

3. Browse the updated CSV file by clicking on Choose file or by using FTP.
4. You get the mapping file option(s) for audown list as shown below:
   

   Mapping File

5. Enter the delimiter which separates the values.
6. Click Upload file and Import. The Merge Order Window appears as shown below:
   

   Map subscription fields

7. Re-Map the fields if required.
8. Click Submit.
9. According dow appears as shown below:
   

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

Export Subscription orders

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.

[caption id="attachment_71889" align="aligncenter" width="1161"] Export subscription orders in CSV format