How to send different IOSS numbers to Royal Mail Click and Drop

How to send different IOSS numbers to Royal Mail Click and Drop

To send the IOSS number to Click and Drop you should add a new value for each order. This article explains how to set this up.

1. Make sure you are using the Click and Drop Export view RoyalMailClickAndDropExportComplete.mev, set in the Click and Drop Courier Options.

If you have a altered your existing view you just need to add the IOSS Number field to the end of your existing view file. To do this open the file (using notepad, the file is in the C:\OSOP\Main folder) and copy the last field and add it onto the end, with the field number increased by 1.

For example, if the last field is :

[Field27]
Name=Shipping Cost
LookupSQL=
NoExport=0
Total=0
ID=26
SortType=5
Edit=0
ListID=0

You should add a new field to end, as below:

[Field28]
Name=IOSS Number
LookupSQL=
NoExport=0
Total=0
ID=131
SortType=1
Edit=0
ListID=0

This will allow you to add in a macro (in the LookupSQL field) or amend an order and change the Custom Entered field 13 to add in a specific value (e.g. AMC7838485).

NOTE : If you have to add in this field you will have to remap your click and drop files in Click and Drop online.

2. Once you have the IOSS Number field setup, you can either manually change the name for each order or write a macro to automatically set it.

To amend the value manually, you can open an order and in the custom values tab amend field 13 to change the value. You can also add the field to the main display and right click (or Press F2) when you are on that field and amend the value (or updated multiple values by right clicking and updating all ticked orders).

3. If you are writing a macro you will need to amend the Click and Drop View file and update the LookupSQL field (for example, if you are using the RoyalMailClickAndDropExportComplete.mev file you should open the file and find the 37th field, shown below:

[Field37]
Name=IOSS Number
LookupSQL=
NoExport=0
Total=0
ID=131
SortType=1
Edit=0
ListID=0

You will need to amend the LookupSQL field.

The IOSS number for Amazon and Ebay is put into the Order VAT number.

To display the Orders IOSS number on the screen/view add the Order->VAT Number to your current view, shown below:



If you want to use this in a macro use the [%VAT_NUMBER%] macro.

If you want to change the value based on the value passed from Ebay or Amazon, you could use the following macro:

LookupSQL=[%VAT_NUMBER%]

If you want to change the value based on other criteria, e.g. sales channel, you could use the following macro:

LookupSQL=#!#[%SALES_SOURCE%][=]Ebay[EbayIOSS][[%SALES_SOURCE%][=]Amazon-SC[AmazonIOSS][MyIOSS]]#!#

What this macro does is set the IOSS Number to EbayIOSS for Ebay, AmazonIOSS for Amazon and MyIOSS for any other order types (e.g. your own website). You should replace these values with the number that Ebay, Amazon etc. provides you with.

For more details on the macro values that can be used use the following link: