Page History

To Display a Checkout Message When a Product in a Specific Category is on the Current Order:

• 'Sort Code/Mask': Enter the Category code. i.e. SX123456
• 'Override Query': Leave blank.

To Display a Checkout Message When a Product under a higher level Category is on the Current Order:

• 'Sort Code/Mask': Enter the Parent Category code and add a percentage sign to indicate any categories under that tree. i.e. SX12%
• 'Override Query': Leave blank.

To Display a Checkout Message For a Specific Customer:

• 'Sort Code/Mask': Leave blank.

• 'Override Query': Enter the following query and substitute ABC123 for the customer code.

  Code Block
  sql sql
  Code = 'ABC123'

To Display a Checkout Message When a Certain Product is on the Current Order:

• 'Sort Code/Mask': Leave blank.

• 'Override Query': Enter the following query and substitute AB-12345 for the product code.

  Code Block
  sql sql
  productcode = 'AB-12345'

To Display a Checkout Message When the Current Order Amount is Greater than $200.00 Ex Tax:

• 'Sort Code/Mask': Leave blank.

• 'Override Query': Enter the following query.

  Code Block
  sql sql
  (soOrderTotalAmount-SoOrderTotalTax) > 200