Product Macros. You can display more details for each product on an order line by using the following macros. Where n is the orderline to display. n can be from 1 to 100

[+]

The two values either side are added up

[-]

The value to the right is taken away from the value on the left.

[/]

The value on the left is divided by the value on the right.

[*] 

The two values are multiplied together.

[<]

Compares the value and if it is less than the value given show the first value otherwise show the second value.

For example, to show Parcel Force for orders less than £100 and UKMail for

orders over and including £100 use:

[%ORD_SUB_TOTAL%] [<] 100 [Parcel Force] [UKMail]

[>]

Compares the value and if it is greater than the value given show the first value otherwise show the second value.

For example, to alert someone (by adding text into a certain field) to check all orders over £200 use:

[%ORD_SUB_TOTAL%] [>] 200 [Check Order]

[=]

Compares the value and if it equals value given show the first value otherwise show the second value. This can include text aswell as numeric values.

For example, to change the drop shipper depending upon a certain product use:

[%ITEM_SKU1%] [=] IL42 [SmartShipper][We Ship]

[U]

Make the field UPPERCASE. You should put the opertaor after the field value.

This can be useful for making certain fields more visible.

For example, to make the Delivery company name UPPERCASE use:

[%DEL_COMPANY%] [U]

[l]

Make the field lowercase. You should put the opertaor after the field value.This can be useful for making certain fields more readable when joined with other fields.

For example, to make the built up sentence (which is itself made up from other fields) more readable use:

[%CUSTOM_ENTERED1%][l]

[$] 

Display a portion of a field. The 2 values following the operator are the position to start in the text followed by the number of characters to use. This can be useful when values have to be a fixed length for certain export functions or using certain characters in a value as a code to another system.

For example, to use the first 3 characters of a product code as a warehouse location (or dropshipper) use the following. You can then base other fields on tests on this field.

[%ITEM_SKU1%][$][1][3]

If you put a ! before the second value you can take the portion of the string before the text given. For example, to include all the text before a space in the item title use the following:

[%ITEM_TITLE1%] [$][1][! ]

You can also search for certain words, not just single characters.

[.]

Take the absolute value of the number. For example, 19.21 would be shown as 19. This is very useful for any Inland Revenue figures where only the £ (GBP) number is required.

For example:
[%ORD_GRAND_TOTAL%] [.]

[#]

Replace a letter or word with another word. This can be useful if you wish to replace certain words (for branding) or to remove unwanted.

To replace the word Free with Additional use:
[%ITEM_TITLE1%] [#][Free][Additional]

To remove all commas from an address line:
[%INV_ADD_LINE1%] [#][,][]

[D]

Display the date (if a date field) in the format YYYY-MM-DD. This is useful when some export formats need the date in a different format. The formats supported are:

1 - yyyy-mm-dd
2 - dd/mm/yyyy
3 - dd/mm/yy
4 - mm/dd/yy

If you use nothing or 1 after the [D] it will use the format YYYY-MM-DD.

For example, to display the date as day/month/year use.

[%INV_DATE%] [D]2

[?]

Find a word within a field. If the text is found show the first value otherwise the second value. For example, to look for the word Fast in the shipping instructions use the following:

[%DELIVERY_INSTRUCTIONS%] [?]Fast[UPS][DHL]

This will display UPS if the word fast is used in the shipping instructions or DHL if it is not. This can be used to display order processing information based upon the order's choices.


If you want to find the location of a the value winthin the first text you should put ? in both the possible returned values. This can be useful if you want to extract certain text from another word. For example,

The quick brown fox jumped over the fence[?]jumped[?][?]

This would return

21

as this is the position in the text of the work jumped.

A more complex example is to use the returned value to extract the text from the sentence.

For example, if you want to only display the text after a # in the Order item's SKU you can find the location of the # and show all characters after the #.

[%ITEM_SKU1%][$][[%ITEM_SKU1%][?]#[?][?][+]1][15]

This is applied to the SKU

Door Handle#419C

this shows

419C

To see how this macro works this can be broken down into several parts

1 The [%ITEM_SKU1%][?]#[?][?] looks for a # in the SKU and returns the location of it, in the example, 12.
2 Then the [+]1 is used, which adds 1 to the location, which then makes the value 13 (12 +1).
3 The 13 is then used in the [$] macro, which is Display a portion of a string. This would then use

[%ITEM_SKU1%][$][13][15]

This shows up to 15 characters from the 13 position in the string. The 15 is abitary number, if your SKUs are longer use a higher value (e.g. 254).

<!>

You can access the underlying data using SQL directly. You will need to know information about the underlying data. You can use the following values in the SQL to reference the current order being displayed:

Round a number to the nearest number of decimals places. For example, if you use the

3.1415926[r]3

This will show

3.142

As the number has been rounded to the nearest whole number (in the decimal places).

The Zone of the text used (i.e. postcode), for example

[%DEL_POSTCODE%][Z]

The returned value is shown below:

1 - Mainland UK
2 - Anglesey
3 - Cornwall
4 - Dyfed
5 - Gwnedd
6 - Powys
7 - Scotland (Main)
8 - Scottish Highlands
9 - Scottish Islands
10 - Isle of Wight
11 - Isle of Scilly
12 - Isle of Man
13 - Northern Island
14 - Channel Islands

This value can be in used in calculations for finding the best courier (for scottish islands)

For example, to see if not Mainland UK delivery you could use

[%DEL_POSTCODE%][Z][>]7[UPS][Royal Mail]