Magento Integration Suite:Royal Mail RMDMO Integration
Please note this integration has been replaced with our new Royal Mail Click & Drop integration.
Contents |
Overview
The XTENTO RMDMO connector enables you to export your shipments to Royal Mail Despatch Manager Online. The connector consists of one package:
- Order export out of Magento - shipment import into RMDMO
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
- Open the connector ZIP file downloaded after your purchase. (Located in our store at My Account > My Downloadable Products)
- Set up the Magento Order Export Module (located inside the Xtento_OrderExport ZIP file) following this guide: Installation Guide
- Log into the Magento backend and go to System > XTENTO Extensions > Sales Export Configuration and enter the license keys you received via email.
- 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.
- 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
- Log into your RMDMO account at https://www.rmdmo.co.uk
- Go Shipping Services > Import Shipments
- Select New to create a new User Defined Format. A wizard window will be opened.
Step 1:
- Select Delimiter-separated values for the layout format.
- Set a default country code, if required.
Click Next
Step 2:
- Enter , for the separator (a comma)
- Enter " for the delimiter (a quote)
- 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:
- Date Format: DDMMYYYY
- Numeric fields format: 12.00 kg
Click Next
Step 4:
- Select "Service Reference" and map "Your code" 1 to "Your Company"
- 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.
- Select "Service Format" and map "Your code" P to the Service Format used for GB shipments (normally "Inland Format Not Applicable")
- 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:
- Confirm the file format looks good. It should look something like this:
- 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
- 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.
- Log into your RMDMO account at https://app.rmdmo.royalmail.com/index.epl
- Go Shipping Services > Import Shipments
- Select the file format created above, called MagentoImport for example.
- Select the file you exported in step 1 in Select file to import
- Select Ignore File's First line and press Import
- 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
- Open the connector ZIP file downloaded after your purchase. (Located in our store at My Account > My Downloadable Products)
- Set up the Tracking Number Import Module (located inside the Xtento_TrackingImport ZIP file) following this guide: Installation Guide
- 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.
- Go to Sales > Tracking Import > Tools and import the "xtento_trackingimport_settings.json" file there.
Importing tracking numbers into Magento
- To download the tracking file from DMO, please go to 'Archive' in RMDMO and select 'Archived Shipments'. Select your date, select all records and press "CSV Export" from the bottom of the page. Save this file on your computer.
- You can now upload the tracking file into Magento using the "Upload file" option at Sales > Tracking Import > Manual Import.
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
