Highlighting Orders with Stop Lights

In the Order Manager, you can program three "stop lights,"  small red, yellow, and green circles that appear in the bottom right-hand corner of the View Orders screen. You can use these lights to help you spot problem orders, orders that require special handling, etc.

Note: Programming stop lights requires some knowledge of "SQL Query Language." To obtain information about programming stop lights, try (searching or posting to) the Stone Edge User Forum.

Below is screen shot of the View Orders screen with the stop lights displayed in the lower right-hand corner of the screen:

In most cases, all three lights do not appear at the same time.

To program a stop light:

1. In the Program system parameters group, select either the parameter GreenDotFormula, RedDotFormula, or YellowDotFormula.

2. Enter a formula that evaluates to TRUE or FALSE condition. TRUE enables a light; FALSE disables it.

3. Put field references in your formula in square brackets, as in the examples below:

[FinalGrandTotal]>100
Turns on light if total price of order is more than $100)

 

[SourceOrderNumber] & "">""
Turns on light if the current order was imported from a Web store (see next example for Americart and Virtual Cart stores).

 

[SourceOrderID] & "">""
Turns on light if the current order was imported from an Americart or Virtual Cart store.

 

[Surcharge] > 0 AND [BalanceDue] > 0
Turns on light if the current order has any surcharges and also has a balance due.

 

Year([OrderDate])=Year(Date) AND Month([OrderDate])=Month(Date) AND Day([OrderDate]) between 10 and 20 and [ShipCompany] & "">""
Turns on light if the order date is between the 10th and 20th of the current month, and there is anything entered in the Ship To Company field.

 

dlookup("avs","transactions","ordernumber=[ordernumber]") & ""=""
Turns on light if the first transaction for the current order has no AVS data.

 

dlookup("avs","transactions","ordernumber=[ordernumber]")&"">"" AND instr("BEGNRSU",dlookup("avs","transactions","ordernumber=[ordernumber]")&"")>0
Turns on light if the first transaction for the current order has AVS data, and the AVS response can be found within the string of characters "BEGNRSU".

The following fields can be used in your formulas:

See Also

MaxMind.com Fraud Prevention

Updated 12/15/08