Available fields and conditions
Example Rules
One of the easiest ways of seeing how this app can be used is to view our example rules.
Available Fields
The available product fields that can be used to create category conditions are:
| Field | Notes |
| Brand | |
| Condition | New, Used or Refurbished |
| Custom Field | |
| Date Created | |
| Date Modified | |
| Description | HTML characters may need to be encoded, e.g. ® for ® to match. |
| GTIN | |
| ID | |
| Inventory Tracking | None, Product or Variant based inventory tracking |
| Inventory Level | i.e. stock level |
| MPN | |
| Name | |
| Price | This is the price that is entered into admin and may not include sales tax depending on your BigCommerce settings. |
| Purchasability | Can be purchased, Can be pre-ordered, or, Cannot be purchased |
| Sale Price | This is the price that is entered into admin and may not include sales tax depending on your BigCommerce settings. |
| Search Keywords | |
| SKU | |
| Type | Physical or Digital |
| UPC | |
| (Any) Variant Sale Price | |
| Weight |
Available Operators
The available operators that can be used to create category conditions are:
| Group | Operator | Notes |
| Text | Contains | Case insensitive. Does not support comma-separated keywords. Each word to be matched should be a separate condition. |
| Does not contain | As above | |
| Exactly matches | Case sensitive | |
| |
Does not exactly match | As above |
| Starts with | Case insensitive | |
| Does not start with | Case insensitive | |
| Ends with | Case insensitive | |
| Does not end with | Case insensitive | |
| Is in | A list of comma-separated values, e.g. SKU is in “ABC,DEF,XYZ”. Case insensitive. | |
| Is not in | A list of comma-separated values, e.g. SKU is in “ABC,DEF,XYZ”. Case insensitive. | |
| Number | Greater than | |
| Less than | ||
| Date | Before | |
| On or after | ||
| More than | Where the date is more than so many days ago | |
| Less than | Where the date is less than so many days ago | |
| Boolean | Is true | |
| Is false | ||
| Other | Exists | True if the product field has a value greater than 0 |
| Does not exist | True if the product field does not have a value or that value is "falsey", e.g. |
Multi-Condition Rules
The app provides support for multiple conditions to be evaluated when considering whether a product should be assigned to a category, using AND and OR.
For example, in the below example, a product will only be assigned to the Skateboards category if “Trucks” is mentioned in its Search Keywords OR it has “skateboard” in its SKU.
This is helpful when your product catalogue doesn’t have a single consistent way of identifying products.
Similarly, you can use AND conditions when there are multiple factors to consider when evaluating which products should be assigned, or perhaps reasons to exclude products.
The below example shows creating a sale category for all products with a sale price set, bar “purses” as denoted by the product name.
