How to Export and Import Orders XML from Stamps.com using Order / Coupon / Subscription Export Import Plugin for WooCommerce

By Documentation, Getting Started, Order / Coupon / Subscription Export Import Plugin for WooCommerce, WooCommerce Comments Off

This tuto know more about the plugin features.

Overview

Order / Coupon / Subscription Export Import Plugin for WooCommerce allows you top Application. You can export/update 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 download/” target=”_blank” rel=”noopener noreferrer”>Stamps.com application which contains information about the orders along with the Order ID.

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 Stamp orders

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

Export order(s) from Order Page

You can directly to Dashboard > WooCommerce > Orders. The Orders listing page appears as shown below:

Orders Page

Click Download to an XML file.

To export bulk orders, select them. From Bulk Action drop-down list, select Download as Stamps XML and click Apply. It is shown as shown below:

Update Orders by Importing XML File

The plugin takes Stamps 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 Stamps Order XML import file, navigate to Help tab. It is as shown below:
[caption id="attachment_6341" align="aligncenter" width="578"] Sample Import File

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

The Import Screen appears as shown below:

Click Update Orders, the window appears as shown below:
[caption id="attachment_72480" align="aligncenter" width="947"] Import order page

Select XML type as Stamps.com.

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 do FTP settings as given below:

Select the checkbox to enable FTP import/export.

Enter FTP Server Host/IP.

Enter FTP User Name.

Enter FTP Password.

Enter FTP Server Path.

Select the checkbox to use FTPS.

Click Upload file and Import. The import window appears as shown below:

You can see the order gets updated with custom fields as shown below:
[caption id="attachment_6363" align="aligncenter" width="864"] Individual Order Page

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