Magento Integration Suite:Royal Mail RMDMO Integration

From XTENTO Support Wiki
Jump to: navigation, search

Contents

Overview

The XTENTO RMDMO connector enables you to export your shipments to Royal Mail Despatch Manager Online. The connector consists of one package:

Using this package, you will be able to import your orders into RMDMO easily, making shipping using RMDMO a breeze.

Got questions? Feel free to contact us! Contact Form

Interested in this Magento integration?

Head over to our store to purchase this integration: Magento RMDMO Integration

Setting up the Integration

This guide will help you setting up the RMDMO integration.

Order Export / Shipment Import

Preparing Magento for Export

  1. Open the connector ZIP file downloaded after your purchase. (Located in our store at My Account > My Downloadable Products)
  2. Set up the Magento Order Export Module (located inside the Xtento_OrderExport ZIP file) following this guide: Installation Guide
  3. Log into the Magento backend and go to System > XTENTO Extensions > Sales Export Configuration and enter the license keys you received via email.
  4. Inside the downloaded connector ZIP file, look for a file called RMDMO Tabbed XSL Template.txt. Open this file and copy the contents. Create a new order export profile at Sales > Sales Export > Export Profiles, insert the XSL Template you just copied into the "Output Format" tab and save the profile.
  5. The export has been configured now and is ready to use. Go to Sales > Sales Export (or Sales > Orders directly) and export a couple of orders. If this succeeds, you've successfully installed the export module.

From now on, when you're ready to export shipments into RMDMO, just go to Sales > Orders or Sales > Sales Export and select a date range of orders you want to export, download the file, and import it into RMDMO.

Setting up the RMDMO Shipment Import

  1. Log into your RMDMO account at https://www.rmdmo.co.uk
  2. Go Shipping Services > Import Shipments
  3. Select New to create a new User Defined Format. A wizard window will be opened.

Step 1:

  1. Select Delimiter-separated values for the layout format.
  2. Set a default country code, if required.

Click Next

Step 2:

  1. Enter , for the separator (a comma)
  2. Enter " for the delimiter (a quote)
  3. At the very right of the wizard window, you will now have to map the file format to the Magento format. Just click on each field name, one by one, in the order supplied here:

Service Reference > Service > Recipient/ Tracked Returns > Recipient Complementary Name > Recipient/ Tracked Returns Address line 1 > Recipient/ Tracked Returns Address line 2 > Recipient/ Tracked Returns Postcode > Recipient/ Tracked Returns Post Town > Recipient/ Tracked Returns Country Code > Recipient Email Address > Reference > Items > Weight (kgs) > Service Format > Service Enhancement > Service Enhancement 2 > Service Class > Safe Place > Signature

(So, first click on Service Reference in the "Field" mapping, then click on Service, then click on Recipient, ... a mapping list will show up at the bottom at Representation of File Layout)

Click Next

Step 3:

  1. Date Format: DDMMYYYY
  2. Numeric fields format: 12.00 kg

Click Next

Step 4:

  1. Select "Service Reference" and map "Your code" 1 to "Your Company"
  2. If required, you can map the "Service" field to the exact shipping method names of Magento. You can find them when you open the CSV file exported by the extension, it's the second column in the file.
  3. Select "Service Format" and map "Your code" P to the Service Format used for GB shipments (normally "Inland Format Not Applicable")
  4. Select "Service Format" and map "Your code" E to the Service Format used for non-GB shipments (normally "International Format Not Applicable")

Click Next

Step 5:

  1. Confirm the file format looks good. It should look something like this:
  2. Enter a name for the file layout. We'd suggest using MagentoImport

Click Save to save the file format. You've successfully set up the import mapping.

Importing shipments into RMDMO

  1. In Magento, go to Sales > Orders and select the orders you want to ship. Then, select the "Export orders" action from the "Actions" dropdown and select the "RMDMO Export" profile. Click Submit.
  2. Log into your RMDMO account at https://app.rmdmo.royalmail.com/index.epl
  3. Go Shipping Services > Import Shipments
  4. Select the file format created above, called MagentoImport for example.
  5. Select the file you exported in step 1 in Select file to import
  6. Select Ignore File's First line and press Import
  7. Process the imported Shipments and select the appropriate option.

That's it! Your orders should now have been imported into RMDMO.

Tracking Import

Setting up the import in Magento

  1. Open the connector ZIP file downloaded after your purchase. (Located in our store at My Account > My Downloadable Products)
  2. Set up the Tracking Number Import Module (located inside the Xtento_TrackingImport ZIP file) following this guide: Installation Guide
  3. Log into the Magento backend and go to System > XTENTO Extensions > Tracking Import Configuration, enable the module and enter the license keys you received via email.
  4. Go to Sales > Tracking Import > Tools and import the "xtento_trackingimport_settings.json" file there.

Importing tracking numbers into Magento

Questions

Got pre-sales questions? Need to change anything in the connector or the output files? A field missing that you want to add? Feel free to contact us! Contact Form

Personal tools
Namespaces
Variants
Actions
General Information
Magento 1 Guides
Magento 1 Extensions
Magento 2 Guides
Magento 2 Extensions
Magento Integration Suite
Toolbox