In two earlier posts, we looked at an increasingly complex set of merchandising requirements that a merchandising product must provide to a modern online retailer. In this post, we’ll further increase the complexity. My aim continues to be that product managers and merchandising managers get an insight into the use cases their tools need to be geared for.
Lets dive in!
-
- Create a landing page for a SEM campaign for deals on men’s accessories. The landing page must display only products from three sub-categories: wallets, belts and bags and show only 3 top-selling products from each category. Within the three products from each category, the products must be sorted in a descending order of discounts, i.e. highest discounts to least discount percentage.To understand the challenge behind executing such a rule, one needs to understand that the page must be rendered on-the-fly every time a visitor comes to the page. This is to ensure that:
- the top sales data is the latest from the latest transactions records for the selected products.
- that the page does not have to be manually recreated or edited every time a change takes place in the order of products or discounts on products.
- On the catalog navigation menu, when a visitor clicks on the the category Apparel, the results page must always display products from sub-category T-Shirts first. However, this rule must not apply when a visitor searches through the search box for products from the apparel store.The first challenge in this rule is to apply it to only the results page of the catalog navigation and not to the search results through the search box. This is more of an engineering problem and it needs to be communicated clearly to the engineering team.Second problem with such a rule is that it assumes that the underlying ecommerce platform, whether using a commoditized platform like Magento or an in-house one, enables you to change the way results are presented for catalog navigation clicks by the visitor. If it does not, there is simply no way to introduce such a rule. This could be a problem because most of the time, ecommerce platforms assume that the catalog navigation menus are simply supposed to extract the contents of the product database and display them on the web page. In reality, what we need the platform to do, is to let us apply some rules to the catalog before displaying them.The third challenge is to find some way of giving higher priority to the sub-category T-Shirts. Even though it sounds simple, it generally requires a restructuring of the database to allow such a priority attribute to be attached to a sub-category or the products belonging to the sub-category.
- Create a landing page for a SEM campaign for deals on men’s accessories. The landing page must display only products from three sub-categories: wallets, belts and bags and show only 3 top-selling products from each category. Within the three products from each category, the products must be sorted in a descending order of discounts, i.e. highest discounts to least discount percentage.To understand the challenge behind executing such a rule, one needs to understand that the page must be rendered on-the-fly every time a visitor comes to the page. This is to ensure that:
- During search, give highest priority to model-name field in mobiles store, book-title field in books store and for all other stores highest weight to brands field in the product catalog. In an earlier post, I spoke about the need to have a clear understanding of the product catalog to determine which parts or fields are more important than others. The reason I wrote that will be clear here.