Using Royal Mail Despatch Manager Online (DMO) with Actinic

Using Order Processing for Actinic you can export all of your Actinic orders to Royal Mail Despatch Manager Online (DMO).

This guide will explain how to setup Order Processing and Royal Mail Despatch Manager Online (DMO). You will need our order processing software, available from http://www.mole-end.biz . There is a 30 day free trial of the software. You will also need to signup to Royal Mail's service. More information at: http://dmo.royalmail.com.

Setting up Order Processing

If not installed you can download the software from http://www.mole-end.biz/download/ME_1StopOrders.exe . The software includes a 30 day free trial.





1 Select the RoyalMail DMO (Despatch Manager Online) view

If the RoyalMail DMO (Despatch Manager Online) view is available you can go to item 2. If the view isn't available you should import the view. If it is installed into the installation folder (by default C:\Program Files\MoleEnd\1StopOrders\V10\RoyalMailDespatchManager.mev). If this is not available you can download it from here. Once the view is on your PC you can import the view by clicking on the Select Columns button. To import the new view click on the Import button in the displayed window, shown below:




2 You can then tick the orders to export (using filters based on any fields shown, for example, pending and not shipped orders).

3 Click on the Export Orders button to create the CSV file to import into Royal Mail Despatch Manager Online (DMO), This is shown below:





4 This will create a CSV in C:\ called DMO.CSV. If required, you can change the name and location of the file before exporting. You can also add a comment to the order to show that this order has already been exported (and if required use this text as a filter to see which orders have not been exported to Royal Mail Despatch Manager Online (DMO).



Setting up Royal Mail Despatch Online (DMO)

1 Go to the Royal Mail Despatch Manager Online website at https://www.rmdmo.co.uk/login.epl and login using details provided by Royal Mail.





2 Under the Shipping Services menu option select Import Shipments, shown below:





3 If the 1StopOrders format is available go to item 10. If not follow the next steps to set the 1StopOrders format. On the Import Shipments screen select the New button, shown below:

4 Select the import format as Delimiter-separated values and click on Next, shown below:




5 In the Separated Values File Specification make sure the Separator is set to a comma (,) and Delimiter of a double quote (").

You then need to click on the fields to use in the exact order that will appear in the file. If you click on the fields in the Field area in the order shown below:

Service Reference
Service
Recipient Contact Name
Recipient
Recipient Address line 1
Recipient Address line 2
Recipient Address line 3
Recipient Post Town
Recipient Postcode
Recipient Country Code
Reference #
Items
Weight (kgs)
Safe Place
Signature
Service Enhancement
Service Format
Service Class

This will product the following in the Representation of File Layout area:

"Service Reference","Service","Recipient Contact Name","Recipient","Recipient Address line 1","Recipient Address line 2",
"Recipient Address line 3","Recipient Post Town","Recipient Postcode","Recipient Country Code","Reference #","Items",
"Weight (kgs)","Safe Place","Signature","Service Enhancement","Service Format","Service Class"

This is shown below. When the information looks correct click on Next.




6 Ignore the Date Format as this field is not used. Change the Weight Format to the same format that you use for your product weights. For example, if you use kilogrammes select the 12.00 kg option. Click on Next. This is shown below:

7 You can now setup the mappings to your Royal Mail Services. You can use the exact text that they use (or their default mappings). The mappings provided in the guide have been used to make it easier to use Macros in Order Processing where different service enhancements and services are needed for different orders.

To add the different mappings

a Click on Service, Service Reference, Service Class, Service Enhancement or Service Format on the left hand side of the window

b For each mapping table add each of the mappings shown below (if available). To add a mapping type in the code in the Your code box and select the value in the Transform to box and click on Add.

Each of the mappings for the relevant fields is shown below in a table with how the windows should look after adding the mappings. If you make a mistake you can click on the Remove button and reenter the mapping (or click on an item to amend it).

Country Code

The country codes do not need to be mapped as Order Processing produces the correct codes.






Service

Service Reference

Service Class

Service Enhancement

Service Format

8 When the mappings have been added click on the Next button.

9 The following definition is shown below. In the Layout Name enter the name for the layout, 1StopOrders and click on Save. This is shown below:




10 To import the delivery details for the orders:

1. Select a file format
Select the 1StopOrders format

2. Select file to import
Type in C:\DMO.CSV

3. Import File
Tick Use the postcodes in the batch file to determine the post town.

Click on the Import button.

This is shown below.





Setting up different delivery options in Order Processing

By default the view has options for

Using the same value for all shipments
1 Amend the view (click on the Select Columns button).
2 Select the field to change Selected: box on the right hand side.
3 Click on the Amend field details button.
4 In the Amend field details window type the required value in the Default field value box and click on OK.


Using different values for shipments

You can amend on an individual order by amending the order and changing the value on the Custom Values tab.

If you want to automate this process you can use the following approach:

1 Amend the view (click on the Select Columns button).
2 Select the field to change Selected: box on the right hand side.
3 Click on the Amend field details button.
4 In the Amend field details window type the required macro in the Default field value box.

Example macro to use:

To use fields in the macros they must be added to the view. For example, you may want to check the total postage paid. To check this add this to the view. This can then be checked in a macro.

Use 1st Class post for orders that have paid £3.50 or more for shipping

[%Shipping Total Cost%][<]3.5[1STACCOUNT][2NDACCOUNT]

For information on how to setup macros click on the Help button or go to http://www.mole-end.biz/actalog/1StopOrdersDefFF.html.