Ranking factors
This section describes settings used for configuring ranking factors.
You can find it in the System -> Ranking Factors -> Add new/Edit.
General information
- Name: defines the name of the ranking factor.
- Active: switches the state of the ranking factor (enabled or disabled).
- Global: defines whether this ranking factor will be global. The global ranking factor means it will be applied on any category automatically and will sort product collection even before any sorting criteria is applied.
- Weight: appears when Global is enabled. Sets the number of the points for the factor.
We strongly recommend avoiding the use of multiple ranking factors as global factors simultaneously. Global factors provide a significant number of score points for products. If, for example, five global ranking factors are used, products that meet the conditions of all five factors will always be at the top of the category. This makes sorting by sorting criteria inefficient and, in some cases, can block sorting work at all.
Types of ranking factors
- Type: defines the type of the ranking factor. This dropdown contains the following types:
Alphanumeric
- Alphanumeric: sorts products based on alphanumeric (natural) sort order. This type of sorting orders alphanumeric strings as a human would, taking into account both letters and numbers. For example,
Z1.1
,Z2
, andZ11
strings will be sorted asZ1.1
,Z2
,Z11
.
Date
- Date: ranks products based on Creation/Updating/New From date:
- Creation date: ranks by the date of product added to the database.
- Updating date: ranks by the date of product's last modification.
- New from date: ranks by the value in the first field of product's Set product as new from configuration. Products with a more recent value will receive a higher ranking.
- Zero point: sets the number of days Creation/Updating/New From date influences the products ranking.
It is highly recommended to use a value between 1 and 100. For example, if the zero point is set to 100, products created or updated more than 100 days ago will receive a positive score (the earlier, the higher), while products created or updated less than 100 days ago will receive a score of zero.
Attribute set
- Attribute set: ranks products based on an attribute set.
- Mapping: list with available attribute sets, where:
- Attribute set: the name of the attribute set.
- Weight: sets the number of the points for the corresponding attribute set.
Attribute
- Attribute: ranks products by their attribute's values.
- Attribute: dropdown selector that contains attributes available for mapping. An attribute must be of type
Dropdown
orMultiple select
. - Mapping: list with the values of the selected attribute, where:
- Option: the name of the attribute's value.
- Weight: sets the number of the points for the corresponding value.
Image
- Image: ranks products based on the availability of images, where products with images get a higher rank.
It is commonly used as a global factor to place products without images at the end of the product list.
Product rating
- Product rating: ranks products based on their overall rating, where the highest rating receiving the highest rank.
It is commonly used for sorting criteria such as Sort by Rating
or as a part of the Featured
sorting criteria.
Bestsellers
- Bestsellers: ranks products based on the number of purchases within the period:
- Past days: sets the number of days during which the order date influences on product ranking. Default value is 60 days.
Profit
- Profit: ranks products by the gap between product's cost and product's price. The higher gap means the higher rank.
Rule
- Rule: ranks products by the custom rule. Calls Conditions menu where the rule is configured.
Stock status
- Stock status: ranks the products by their stock status, where in-stock products get a higher rank.
It is commonly used as a global ranking factor to move out-of-stock products to the end of the product listing.
Stock quantity
- Stock qty: ranks products based on their stock quantity. Products with higher stock quantities will receive a higher ranking.
- Mapping: list with quantity ranges, where:
- Qty from: sets range start number.
- Qty to: sets range finish number.
- Weight: sets the number of the points for the corresponding range.
This factor can be useful for highlighting popular or high-selling products that are in stock and readily available to customers. Additionally, it helps ensure that customers are shown products that are more likely to be in stock, thereby improving their overall shopping experience.
SPV
- SPV: ranks products by the number of sales divided by the number of product page views. Products with the ratio 1 get the highest ranking.
- Zero point: sets the number of days that influence the products' ranking.
This factor can be a useful metric for identifying products that generate high customer interest and have a good conversion rate.
Popularity
- Popularity: ranks products based on number of product page views.
Discount
- Discount: ranks products based on the difference between the regular price and any special prices.
This factor can be useful for highlighting products with significant discounts and encouraging customers to make a purchase. By sorting products based on this factor, you can also help customers find those that offer the best value for their price.
New product
- New product: ranks by the value in the first field of product's Set product as new from configuration. Adds a fixed value of points to products unlike the Date -> New from date factor.
Backorders
- Backorders: ranks products based on their backorder status, where products with backorder status get a higher ranking.
Number of child products in stock
- Number of child products in stock: ranks products based on the number of child products available in stock.
Formula
- Formula: ranks products based on a custom formula. The syntax of the formula is the same as that of spreadsheet formulas. The formula should always start with
=
and return a numeric result. Non-numeric results will be treated as NULL.
The formula can be customized to take into account various product attributes such as price, rating, and stock quantity, as well as other factors such as shipping time and location.
- Allowed variable types:
- {product_[attribute_code]}: product attributes variable like {product_price}, {product_color}. Attributes of types
gallery
andmedia_image
are not allowed in the formula. - {factor_[id]}: ranking factors' variables. Calculations of the already created ranking factors can be used in the formula. Ranking factors based on the formula can't be used as an argument in the other formula.
- {product_[attribute_code]}: product attributes variable like {product_price}, {product_color}. Attributes of types
Examples:
={product_cost} / {product_weight}
: this formula calculates the unit cost for each product.=IF({product_cost} > 50, 100, 0)
: formula with the condition, where the first number is the value to compare with, the second number is the quantity of points if condition is met, the third number is the quantity of points if condition is not met.=IF({product_brand} = "Adidas", 100, 0)
: formula with the attribute of the typeselect
.=IF(ISNUMBER(FIND("Gym", {product_activity})), 10, 1)
: formula with the attribute of the typemultiselect
.
When using attributes of the type multiselect
the recommended formula is ISNUMBER(FIND([needle], [variable]))
.
The part FIND([needle], [variable])
is responsible for searching needle in the variable's value. If the needle is not found, the FIND()
function returns #VALUE! which makes the IF()
function return the same.
The #VALUE! will be considered as NULL.
For making this formula work as expected the FIND()
function should be wrapped in ISNUMBER()
function. In this case, the whole formula will return correct results.
Operators that can be used in formulas described on the operators page.
Functions that can be used in formulas listed on the functions page.