When creating Order Rules in Mintsoft, you can use specific condition fields and operators to define when a rule should apply. This article provides a complete reference of all available fields and the operators you can use with each one.
Important: The Order Rules module is an additional paid add-on. If you'd like to learn more about purchasing this module, please speak to your Account Manager.
Understanding Condition Types
When setting up an Order Rule, you must select a condition type that determines how multiple conditions are evaluated:
AND: All conditions must be met for the rule to apply.
OR: One or more conditions must be met for the rule to apply.
Understanding Operator Types
Operators are categorised based on the type of data they work with:
String Operators
Used for text-based fields such as names, addresses and product SKUs:
StartsWith: Field begins with the specified value.
Contains: Field includes the specified value anywhere.
Empty: Field has no value.
DoesNotContain: Field doesn't include the specified value.
DoesNotStartWith: Field doesn't begin with the specified value.
IsNotEmpty: Field has any value.
Decimal Operators
Used for numeric fields such as weight, value and item counts:
GreaterThan: Field value is greater than the specified number.
LessThan: Field value is less than the specified number.
EqualsOrGreaterThan: Field value is greater than or equal to the specified number.
EqualsOrLessThan: Field value is less than or equal to the specified number.
Shared Operators
Can be used with both string and numeric fields:
Equals: Field exactly matches the specified value.
NotEqual: Field doesn't match the specified value.
Condition Fields
When setting up an Order Rule in Mintsoft, you can use the following fields as conditions for the rule. Mintsoft offers support for the following fields:
Address1: The first line of the delivery address. All string and shared operators can be used.
Address2: The second line of the delivery address. All string and shared operators can be used.
Channel: The sales channel the order came from. All string and shared operators can be used.
CompanyName: The recipient's company name (if applicable). All string and shared operators can be used.
CountryCode: The two-letter ISO country code for the delivery address. All string and shared operators can be used.
CountryName: The full name of the delivery country. All string and shared operators can be used.
County: The delivery county or region. All string and shared operators can be used.
Courier: The courier company assigned to the order. All string and shared operators can be used.
CourierService: The specific courier service level selected. All string and shared operators can be used.
CourierServiceType: The type of courier service (e.g., standard, express, economy). All string and shared operators can be used.
DeliveryNotes: Any delivery instructions or notes on the order. All string and shared operators can be used.
Email: The recipient's email address. All string and shared operators can be used.
ExternalOrderReference: The order reference from the originating channel or system. All string and shared operators can be used.
FirstName: The recipient's first name. All string and shared operators can be used.
GiftMessages: Any gift message attached to the order. All string and shared operators can be used.
HasOrderItemNameValue: Checks for the presence of specific order item name values. All string operators except Empty/IsNotEmpty can be used.
HasOrderTag: Checks for the presence of specific order tags. All string and shared operators can be used.
MobileNumber: The recipient's mobile phone number. All string and shared operators can be used.
NationalAddressCode: The national address code for the delivery location. All string and shared operators can be used.
NumberOfParcels: The number of parcels the order will be split into. All decimal operators can be used.
OrderDateDayOfWeek: The day of the week the order was placed. All string operators except Empty/IsNotEmpty can be used.
OrderDateTimeOfDay: The time of day the order was placed (in hours). All decimal operators can be used.
OrderItemProductCategory: The product category of items in the order. All string operators except Empty/IsNotEmpty can be used.
OrderItemProductNames: The names of products in the order. All string operators except Empty/IsNotEmpty can be used.
OrderItemProductSKUs: The SKUs (Stock Keeping Units) of products in the order. All string operators except Empty/IsNotEmpty can be used.
You can only add one SKU per entry. If you need to enter multiple SKUs, please create a separate entry for each one.
OrderNumber: The unique order number assigned by Mintsoft. All string and shared operators can be used.
OrderValue: The total monetary value of the order. All decimal operators can be used.
OrderVolume: The total volume of all items in the order. All decimal operators can be used.
PackingNotes: Any packing instructions or notes on the order. All string and shared operators can be used.
PhoneNumber: The recipient's phone number. All string and shared operators can be used.
PostCode: The delivery postcode. All string operators except Empty/IsNotEmpty can be used.
ProductHazardousUnNumber: The UN number for hazardous materials (if applicable). All string and shared operators can be used.
RecipientType: The type of recipient (e.g., B2B or B2C). All string and shared operators can be used.
RequiredDeliveryDate: The date by which the order must be delivered. Only the Equals (excluding NotEquals) and Empty/IsNotEmpty operators can be used. When using "Equals", provide the date in YYYY-MM-DD format.
RequiredDespatchDate: The date by which the order must be despatched. Only the Equals (excluding NotEquals) and Empty/IsNotEmpty operators can be used. When using "Equals", provide the date in YYYY-MM-DD format.
ShippingTotal: The total shipping cost for the order. All decimal operators can be used.
ShippingZone: The shipping zone assigned to the order. Only the Contains (excluding DoesNotContain) operator can be used.
ShippingZoneIncludingPostCodes: The shipping zone with postcode information included. Only the Contains (excluding DoesNotContain) operator can be used.
SourceShippingName: The shipping method name from the originating system or channel. All string and shared operators can be used.
TotalItems: The total number of items in the order. All decimal operators can be used.
TotalWeight: The total weight of all items in the order (in kg). All decimal operators can be used.
Town: The delivery town or city. All string and shared operators can be used.
These fields can be used when creating an Order Rule Condition.