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,

  1. Go to Data Services from your site's main menu and select ADD SERVICE. Then search for Product Marker and select Add.

    Add the Product Marker service in Productsup
  2. 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 (___)

  3. Select the affected data column stage, Import or Intermediate, for the added service in Service Data Level. Then select Add.

    Give the Product Marker service a custom name in Productsup
  4. 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.

  5. 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.

  6. Enter a number of products that you mark for rankings in Number of marked products.

  7. 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.

  8. In Method, choose Ascending to mark products with the lowest values or Descending to mark products with the highest values.

  9. 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 as Shoes > Sneakers.

  10. Select Save.

  11. 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.

    Enter settings for Product Marker service in Productsup

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: orders

  • Import column that you want to group by (optional): category

  • Number of marked products: 3

  • Result column: most_ordered

  • Method: 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.