How To

Business Rule Expressions

Business Rules are unique customized text functions or expressions that allow you to manipulate and transform inventory data to meet your specific needs. There are various expression types of functions that you may utilize to build your rule depending on what you are trying to accomplish.

 

Prerequisites


You should be familiar with the following topics:

 

Business Rules Expressions


An expression is the working part of the Business Rules and defines what should be done within a particular Rule. Expressions allow you to dynamically filter which products are going to which provider. Below you will find brief descriptions of the three components of Business Rule Expressions: Fields, Operators and Functions.

Type Description Example Reference
Fields

Designates that a data field is used or referenced in the Business Rule. The syntax to reference a field names is a $ character followed by the field name

$itemtitle

$manufacturer

You'll find a complete list of all available fields in the Business Rule editor. Just click the tab inventory fields in the section Reference on the right-hand side of the editor.

Operators

Allows for value comparisons and math operations within a Business Rule. Operators available are similar to the ones used with Excel formulas and include +, -, >, <, >= and <=.

To filter items where price is less than $25.00 use "$PRICE < 25".

Use one of the following: +, -, *, /, >, <, >=, <=, =, <>

Functions

The Excel-like formula that defines the action of the rule. Functions can be Numeric, Text, Logical, or Lookup.

TOUPPER() FORMATCURRENCY()

See the Business Rules Functions table below

 

Business Rule Functions


Business rule functions are the Excel-like formulas that define the action of the rule. Below is a list and description of many of the functions available.

FunctionsType Description Reference
Text Functions

Allows you to dissect, combine, and format text using business rules.

Using Text Functions in Business Rules

String Functions

Allows for searching or manipulating field values that should be treated as text values (also known as strings). String functions are commonly used.

Using String Functions in Business Rules

Numeric Functions

Allows for formatting and truncating numbers.

Using Numeric Functions in Business Rules

Logical Functions

Allows decisions about what to put in a field based on some criteria. If-Then style Rules are created with Logical Functions.

Using Logical Functions with Business Rules

Lookup Functions

Perform queries using Lookup Lists that you defined in your account.

Using Lookup Functions with Business Rules

GETCONTEXTVALUE Function

Get information about the currently running feed export, such as the destination site, or the number of items exported.

Function in Business RulesUsing the GETCONTEXTVALUE

Business Rules are unique customized text functions or expressions that allow you to manipulate and transform inventory data to meet your specific needs. There are various expression types of functions that you may utilize to build your rule depending on what you are trying to accomplish.

 

Prerequisites


You should be familiar with the following topics:

 

Business Rules Expressions


An expression is the working part of the Business Rules and defines what should be done within a particular Rule. Expressions allow you to dynamically filter which products are going to which provider. Below you will find brief descriptions of the three components of Business Rule Expressions: Fields, Operators and Functions.

Type Description Example Reference
Fields

Designates that a data field is used or referenced in the Business Rule. The syntax to reference a field names is a $ character followed by the field name

$itemtitle

$manufacturer

You'll find a complete list of all available fields in the Business Rule editor. Just click the tab inventory fields in the section Reference on the right-hand side of the editor.

Operators

Allows for value comparisons and math operations within a Business Rule. Operators available are similar to the ones used with Excel formulas and include +, -, >, <, >= and <=.

To filter items where price is less than $25.00 use "$PRICE < 25".

Use one of the following: +, -, *, /, >, <, >=, <=, =, <>

Functions

The Excel-like formula that defines the action of the rule. Functions can be Numeric, Text, Logical, or Lookup.

TOUPPER() FORMATCURRENCY()

See the Business Rules Functions table below

 

Business Rule Functions


Business rule functions are the Excel-like formulas that define the action of the rule. Below is a list and description of many of the functions available.

FunctionsType Description Reference
Text Functions

Allows you to dissect, combine, and format text using business rules.

Using Text Functions in Business Rules

String Functions

Allows for searching or manipulating field values that should be treated as text values (also known as strings). String functions are commonly used.

Using String Functions in Business Rules

Numeric Functions

Allows for formatting and truncating numbers.

Using Numeric Functions in Business Rules

Logical Functions

Allows decisions about what to put in a field based on some criteria. If-Then style Rules are created with Logical Functions.

Using Logical Functions with Business Rules

Lookup Functions

Perform queries using Lookup Lists that you defined in your account.

Using Lookup Functions with Business Rules

GETCONTEXTVALUE Function

Get information about the currently running feed export, such as the destination site, or the number of items exported.

Function in Business RulesUsing the GETCONTEXTVALUE

0
Your rating: None Average: 2.4 (5 votes)
0
Your rating: None Average: 2.4 (5 votes)