How to Export and Import Orders in XML File from UPS WorldShip

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 tutorial explains how to Export/import UPS WorldShip Order XML file using Order / Coupon / Subscription Export Import Plugin for WooCommerce. Please refer to the product page to know more about the plugin features.

Overview

Order / Coupon / Subscription Export Import Plugin for WooCommerce allows you to easily export or update metadata of orders of your store into the XML file format required for printing the labels, shipment tracking, existing hundreds, etc. by using order XML  of UPS WorldShip application. You existing hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information.
The plugin also exports individual orders from Orders listing page, export all orders or specified orders by offset/limit with a certain date range in bulk.

For updating orders to your online store, you must import the XML file which is a reply from UPS WorldShip which contains information about the orders along with the Order ID / Order number.

Order Import/Export

Under Order Import/Export tab, you can export/update the order.

Export Orders

If you export order using the plugin, you get the XML file which contains the data about all the orders of your online store.

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

Export Orders in XML Format
Export Orders in XML Format
  1. Select the Order Export Type as UPS WorldShip.
  2. Order Statuses:  Select order statuses for which you want to export orders from the given list:
    Order statuses
    Order statuses
  3. Offset: Enter the order row number at which you wish to start the export.
  4. Limit: Enter the maximum number of orders that you wish to export.
  5. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  6. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
  7. Click Export Orders, the XML file gets auto-downloaded to your computer. The sample orders XML file is as shown below:
    Exported XML
    Exported XML

Export order(s) from Order Page

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

Download individual UPS WorldShip order in XML
Download individual UPS WorldShip order in XML
  • Click Download to UPS WorldShip XML button to export single order to an XML file.
  • To export bulk orders, select them. From Bulk Action drop-down list, select Download as UPS WorldShip XML and click Apply. It is shown as shown below:
    Bulk Actions drop-down list
    Bulk actions drop-down list

    All the information about selected Orders gets auto-downloaded to an XML file.

Update Orders by Importing XML File

The plugin takes UPS WorldShip Order XML file as input. It updates all metadata of the orders by importing XML file.

Note: If there is any mistake in your import file, your order update may not work as expected. For Sample UPS WorldShip Order XML import file, navigate to Help tab.

Please make sure that Order ID exists in your online store to update that particular order. otherwise, you get a warning message during the update.

The Import Screen appears as shown below:

Import orders in XML window
Import orders in XML window

Click Update Orders, the window appears as shown below:

Order import window
Order import window

Select XML type as UPS WorldShip.

Method 1: Select a file from your computer. Click Choose File to browse a required XML file from your computer. Click Upload file and Import.

Method 2: Provide FTP Details. If your XML 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 Server Path.
  6. Select the checkbox to use FTPS.
  7. Click Upload file and Import. The import window appears as shown below:
    Import successful
    Import successful

You can see the order gets updated with custom fields as shown below:

Edit order page
Edit order page

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!

5 thoughts on “How to Export and Import Orders in XML File from UPS WorldShip

  1. Kevin
    Kevin says:

    I got the impression that I could automate the XML export in WorldShip format – is that possible, and how would I accomplish it? I cannot select a XML format when setting up automated export.

    Thanks!
    Kevin

  2. Darren
    Darren says:

    Hi, the issue I have so far is that the xml file I get is not recognized by the worldship software. I do have an option to upload a csv but if I choose xml it asks me to upload a folder, not a file. So I can’t get the exported file to work. What can we do? Do you have a csv export option that will put it in the correct format?

  3. Veeresh
    Veeresh says:

    Hello Mark,

    Thank you for reaching us.
    in our plugin, sender details are pulling from admin user (User ID 1) billing details.
    ‘Address1’ => get_user_meta(1, ‘billing_address_1’, true),

    Hope this helps. Please let us know if you have any queries.
    Please raise a request here for further queries: https://support.xadapter.com/hc/en-us

  4. Mark
    Mark says:

    Hello I am trying to export the Worldship UPS xml file but in the file the sender information is wrong. It is specifying a business name and address I used to perform a test transaction in the past.

    Where is it pulling the sender information from?

Leave a Reply

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