Export Orders from Shopify to UPS WorldShip®

With the Shopify App Matrixify, you can now export your Orders to the UPS WorldShip® XML file, and here we will go thru the process.

Make sure that you contact UPS WorldShip support in your country to set up your WorldShip application and shipping profile.

Steps in short:

1. Contact Matrixify support to set up WorldShip details for your export.
2. Create new export and select UPS WorldShip XML format.
3. Select to export Orders in the Matrixify.
4. Apply filters if needed.
5. Export the file.
6. Import the file in the UPS WorldShip.

1. Contact Matrixify to set up WorldShip export details

Since there are some store-specific details in the export, then for the export to work correctly in the WorldShip, first we would need to set up your store parameters on our end.

We would require the following details about your store for the UPS WorldShip:

• Your store *.myshopify.com domain:
• DescriptionOfGoods:
• Telephone:
• Email:
• ShipperNumber:
• ShipperNumberForAccessPoint: (optional – that is if you have implemented a shipping feature to UPS Access Points, and are saving it to Billing Address 1 as “#APID:<number>“)
• Do the product prices already include the VAT or are they without VAT in the store:
• Add the Quantum View Notify Block “<QVNOption>” for those customers who provide the e-mail
• Europe VAT exempt: optionally your IOSS (EU), HMRC (GB), VOEC (NO) numbers for shipments below 150 EUR; or we should assume you have exempt – then those numbers are not needed. Those are the XML file elements “<VendorCollectIDNumberExempt>” and “<VendorCollectIDNumber>“.

When you have all of the above details, you can look into Matrixify “Contact Us” page for various ways to reach us.

2. Create new export and select UPS WorldShip XML format

When you have opened the Matrixify app, create new export in the app.

First, you will see the format drop-down list. In this list select “UPS WorldShip XML”.

2. Select Orders in the Matrixify export

The app will automatically select Orders with Basic Columns to be Exported:

3. Apply filters if needed

You can apply multiple filters to export only the Orders that you need. There are various filters for orders that you can apply, for example, by Created, Updated, or Processed At dates, Fulfillment Status, Payments Status, and others. List of all available filters and their descriptions you can find in our “Export Filter” documentation page.

In our Example we use two filters:

• Created At
• Fulfillment Status

5. Export the file

Now all the setup has been done and you can export the file. To export press the “Export” button.

Once the export is finished you can click on the “Download Exported File” button to download your file.

6. Import the file in the UPS WorldShip

Our recommendation is to set up the UPS WorldShip® to automatically take the XML file from your Downloads folder. That way the Shipping label is printed automatically as soon as the file is downloaded.
To set up the Automatic Import please consult with the UPS WorldShip® Support.

UPS WorldShip® Access Points

Matrixify can export also UPS WorldShip® AccessPoint data in the same XML file.

The Access Point address is taken from the Order “Billing Address”. The “Address 1” field of the Billing Address should have the “#APID:” string, followed by the Access Point ID.

For example, the Billing “Address 1” field can look like this:

Borner str. 76 #APID:U12154364

It contains the street address, and the Access Point ID, which is being extracted and inserted into the required WorldShip AccessPoint fields.

What to do next?

• Install the Matrixify App.
• Check other Shopify Orders related tutorials.
• Contact Matrixify support if you run into any issues or have additional questions.
• If you do require to change some of the fields in the exported format then please Contact Matrixify support.