Rank a product group with the Product Marker service
Rank a group of products based on a specific attribute in your feed using the Product Marker service in Productsup.
Introduction
If you want to rank a group of products based on a specific attribute in your feed, use the Product Marker service. For example, use the Product Marker service to identify the three most ordered products under a category in your feed.
The Product Marker service lets you choose a value for your column or as an option, specifically group columns that you want to rank instead. You can define the number of marked products individually. Once the service completes processing, it creates a new column containing the results at the import stage.
Set up Product Marker service
To add and set up the Product Marker service:
Go to Data Services from your site's main menu and select ADD SERVICE. Then search for Product Marker and select Add.
You can give your Product Marker service a custom description in Name. In Column prefix, enter a common character that you want the platform to add as a prefix to all new columns when the service generates multiple columns. The default prefix is three underscores (
___).Select the affected data column stage, Import or Intermediate, for the added service in Service Data Level. Then select Add.
In Column containing the values, select the import column that contains the input data you want to use for this service. The value serves as the basis for the rankings.
You can optionally set a value to a product group using Import column that you want to group by (optional). If you choose not to set it, the ranking affects the full product catalog.
Enter a number of products that you mark for rankings in Number of marked products.
In Result column, set the name of the newly-added column after a run, which contains the grouping results. The platform adds three prefixed underscores (
___) in your import feed for all columns that use the Product Marker service.In Method, choose Ascending to mark products with the lowest values or Descending to mark products with the highest values.
The Delimiter (optional) input field is optional. It lets you view single parts of the column that you can group. For example, enter a right-pointing angle bracket (
>) if you want to rank a main and subcategory, such asShoes > Sneakers.Select Save.
After entering your desired settings, run an import and the service creates a new column using the name you entered in Result column. This new result column contains all the values you defined for ranking.
Rank import feed example
The goal is to identify the three most ordered products within your category feed. For the following table, here are some example settings in the input fields:
Column containing the values:
ordersImport column that you want to group by (optional):
categoryNumber of marked products:
3Result column:
most_orderedMethod:
Descending
id | category | stock | size | color | orders |
|---|---|---|---|---|---|
1 | Shoes | 4 | S | red | 10 |
2 | Shoes | 2 | S | blue | 15 |
3 | Shoes | 1 | L | blue | 25 |
4 | Shirts | 5 | 38 | black | 7 |
5 | Shirts | 4 | 38 | blue | 15 |
6 | Shirts | 7 | 38 | green | 5 |
7 | Shirts | 2 | 40 | green | 10 |
8 | Shirts | 5 | 42 | green | 17 |
9 | Pants | 7 | 28 | black | 26 |
As a result, you can see the rankings in the newly created column most_ordered:
id | category | stock | size | color | orders | most_ordered |
|---|---|---|---|---|---|---|
1 | Shoes | 4 | S | red | 10 | Shoes 3 |
2 | Shoes | 2 | S | blue | 15 | Shoes 2 |
3 | Shoes | 1 | L | blue | 25 | Shoes 1 |
4 | Shirts | 5 | 38 | black | 7 | |
5 | Shirts | 4 | 38 | blue | 15 | Shirts 2 |
6 | Shirts | 7 | 38 | green | 5 | |
7 | Shirts | 2 | 40 | green | 10 | Shirts 3 |
8 | Shirts | 5 | 42 | green | 17 | Shirts 1 |
9 | Pants | 7 | 28 | black | 26 | Pants 1 |
Note
If there are more categories than in Number of marked products, the service only marks the products you chose and leaves the remaining cells empty.