DocumentationOrder / Coupon / Subscription Export Import Plugin for WooCommerceHow to Export WooCommerce Orders and Import Them Back into New Website

How to Export WooCommerce Orders and Import Them Back into New Website

When migrating an existing website to a new website, you will need to export the data from the older website and import it into the new website. Order/Coupon/Subscription Export Import Plugin for WooCommerce will help you easily import and export all the orders and order metadata with great ease.

Using the plugin you can easily migrate hundreds or even thousands of orders and order data between WooCommerce websites. You can even easily import the order data from other e-commerce platforms as well. To know all about the plugin and its features visit the product page of the plugin.

Things to consider before the migration of orders:

When exporting and importing orders, special care has to be taken since orders are linked with WooCommerce data like users, products, etc. These data may be connected using their corresponding IDs.

When you are migrating the orders to the new site, you will need to move all the other data like users, products, coupons, etc. So make sure to import all the data that are linked to the orders before importing the orders.

The relationship between the orders and other post types are established when the import takes place when using the Order/Coupon/Subscription Export Import Plugin for WooCommerce. So, you have to make sure that all the related post types are already present or added to the new website.

How to Export WooCommerce Orders

To export the orders from your existing WooCommerce store to a CSV or XML file, go to the admin side of the website. From the WordPress dashboard, navigate to WooCommerce > Order Im-Ex. This will take you to the plugin page. Now go to the Export Orders in CSV/XML format section.

Using this plugin you can export the orders to either a CSV file or an XML file. Let us export the orders into a CSV file in this example.

WooCommerce Order Export

WooCommerce Order Export

You can export all the required 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:order statuses
  2. Products: To export orders of only specific products, select required products from this field.
  3. Coupons: Enter coupon codes separated with commas to export those orders to which the specified coupon codes are applied.
  4. Offset: Enter the order row number at which you wish to start the export.
  5. Limit: Enter the maximum number of orders that you wish to export.
  6. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  7. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
  8. Delimiter: With this field, you can change the comma-separated file to ‘|’ or ‘.” separated file according to your requirement.
  9. 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 CSV file. To do that, simply enter the required column name for the specific column.
  10. Click Export Orders, the CSV file gets auto-downloaded to your computer. The sample orders CSV file is as shown below:Exported field

Now that you have your CSV at hand, you can now proceed to import the file with orders and order data in the new WooCommerce website.

How to Import WooCommerce Orders

The Order/Coupon/Subscription Plugin for WooCommerce for WooCommerce allows you to import orders into a website in a CSV or XML file. To import the data into the new website go the admin side of the website and navigate to WooCommerce > Order Im-Ex. From the plugin page, go to the Import section. The plugin page looks as shown in the screenshot:

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

Import Orders

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

WooCommerce Order Import

WooCommerce Order Import

  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 the server, then to import it,  you need to do FTP settings as given 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.
    8. Select the checkbox to enable passive mode.
    9. Select the checkbox to update the orders an order if it already exists in the store.
    10. Select the checkbox to create a new user, if the user corresponding to an order is not found in the store while exporting.
  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:Mapping-file
  4. Enter the delimiter which separates the mapping values.
  5. Click Upload file and Import. The import window appears as shown below:order import mapping
  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:
    Mapping Field
    Select the required option from the drop-down list. Here, the Order ID is mapped to order_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 fix/update the required value for the particular field. The settings to modify the field are as given below:Sample Evaluation fields

    Note: Hover the mouse on ‘?’ (Help), you can see the information about Evaluation field. For more information on Evaluation field, See Evaluation field in Order Export Import Plugin for WooCommerce article.

  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 to CSV file, the order(s) gets added to your online store. The import window appears as shown below:Imported orderWhile importing orders with the applied coupon, the plugin connects coupon if the same coupon exists in the online store.
  • Was this article helpful ?
  • YesNo