Mole End Order Status Checker

With the Mole End Mole End Order Status Checker you can automatically change orders and update courier information in your Actinic orders. You can run the program as a standalone program using its own scheduler or run it in batch mode (and either run it using One Stop Automation or the windows scheduler).

There are 2 parts to the product.

1 Automatically look at the couriers website and check the delivery status of orders.
2 Create options (rules) to change order details.



To change the options click on the Options button.




Rules
The rules are run in the order that they are shown. You can change the order using the Move Up and Move Down buttons.

You can add, remove and change a rule using the Add, Delete and Edit buttons. Details are shown further down


All rules can be exported and imported. This can be useful when testing and then transferring to the main PC. Example rules are provided in the installation and can be imported.

Website to check deliveries from
You can enter the website to check orders from. At the current time only UKMail (Business Post) is supported. This is the default value.

http://www.business-post.com/scripts/wsisa.dll/ws_refquickpod.html?lc_SearchValue=[%ORD_NUM%]


Creating rules




Name
Enter a name for the rule

Orders to find
You can decide how to find orders. Predefined orders have been given. Select the one required from the list. For some rules you can enter text. You can enter the value (or values required). If you want to store the values required, for example, a list of product codes, in a file, enter the filename to read the information from preceded by !!. For example to read all the customers to hilight from a file enter a value of !!C:\Customers.txt. The values in the file can be comma separated or on a separate line in the file. See Advanced options on how to create your own rules.

After the orders have been found that match the selection method you can use the courier website link to see if it has been delivered by ticking the Also check if orders have been delivered option. Using this option you can also retrieve the delivery details about the order. This includes date and time delivered, who signed for the goods and how many items signed for. Also if there is any other useful information this is retrieved (e.g. not delivered as the customer wasn't in). You can choose to add these to the memo (journal) page in Actinic (or One Stop Order Processing). If you are using One Stop Order Processing this information can be added to the Custom Entered values (fields 21 to 25). These can then be used in invoices, emails etc. and can also be used for filtering orders.

If an order has been found and delivered
If an order has been found (and delivered) you can choose the action to take. Predefined actions have been defined. See Advanced options on how to create your own actions.


If an order has been found but nor been delivered
You can use the same choice of actions as in the previous section. For example, you may want to set the order colour to blue if the order has not been delivered.



Advanced Options

Running the Mole End Order Status Checker from other programs (e.g. One Stop Automation)

If you are using Mole End One Stop Automation you have to tick Order Status Checker on the Order Processing Options (and on the task to run). This will work on the current site being processed.

You can use the following command line options to check orders at regular intervals from other programs.

-B Use the program in batch mode.

-S {Sitename} Check orders from a specific Actinic site. If this option isn't used the current Actinic site is checked.
-A {Sitename} Check orders from a specific Actinic version, e.g. 10. If you do not use this option version 10 is checked.
-W {Window} Send all output to the window specified. If using One Stop Automation this information can automatically be passed in to display all the information in One Stop Automation.
-I {Indent} Indent all information at the level given. If using One Stop Automation this information can automatically be passed in to display all the information in One Stop Automation.
-U {Username}If using Actinic Enterprise and using SQL server logins use the database username.
-P {Password} If using Actinic Enterprise and using SQL server logins use the database password.

-D Check delivery options only
-N Check non delivery options only


Adding your own rules and Actions

Several Rules and Actions have been defined in the file ME_OrderStatus.ini. This is installed and read from the same folder as the program (by default C:\Program Files\MoleEnd\Utilities\OrderChecker\V10, for Actinic V10). You can use this guide and also look at the existing rules to see how to create your own.

NOTE: Adding new Rules and Actions requires knowledge of the Actinic databases and should only be done after backing up the databases and reading any relevant Actinic documentation.

To define a new Rule

This example defines a new rule to turn all orders with delivery instructions to red

1 If you look for the last rule in the file and add a new one after that one. In this example, it is assumed the last rule is Rule 21.

2 Create a new rule lineafter the last one with a higher number

[Rule22]

3 Define the ID for the rule (used as an ID to store in the saved rules). This will always be 1 less than the rule number.

ID=22

4 Define the name for your rule. This is the name shown in the program.

Name=Check for Delivery Instructions

5 Define the SQL to find these orders. If you use One Stop Order Processing you can use the 'Use Current Filter for Command Line Export (with options)... menu option to view the required SQL fields after creating the same filter (in One Stop Order Processing). You can get this menu option by clicking on the logo in the top left hand corner of the main screen. If a value is needed for the rule use '%s' where the text will appear (for text) or %ld for a number.

SQL=[Order].[sUserDefinedShipping] <> ''

6 You need to define the type of rule that is being setup. This can be one of 3 values

1 Select a colour to use with the rule.
2 Allow text to be typed in.
3 No input required

In this example the type is 3 (no input required)

Type=3

To define a new Action

The definition works in exactly the same way as Rules except that the IDs relate to the Action list and not the Rule lists. The SQL line is simply value to set the order to.

The following example shows how to set up a new action to set custom field 7 to 'Shipped'. This assumed that the last action defined is Action 3.

1 Define the new Action

[Action4]

2 Define the ID for the action (used as an ID to store in the saved rules). This will always be 1 less than the action number.

ID=3

3 Define the name for the action. This is the name shown in the program.

Name=Set Order Text as Shipped

4 Define the SQL for the action. As with the Rules you will need to be careful when putting in SQL here as it may change your orders in an unsatisfactory way. Always take a backup before testing a new action.

SQL=[ME_QOP_OrderDetail][C7] = 'Shipped'

5 The type of the Action. This is the same as the Rule types

1 Select a colour to use with the action.
2 Allow text to be typed in.
3 No input required

In this example no input is required

Type=3

You can then save the file and restart the program. The rules are read when the program is started, so if you have added a new rule or action you will need to restart the program.