This blog promotes knowledge sharing through experience and collaboration. For more product information, visit our WebSphere Commerce CSE page. For easier navigation, utilize the Categories to find posts that match your interest.
Search 'n' Rescue: Sequencing
In this post, I will be showing you how to troubleshoot sequencing issues to allow you to display the products in your desired order. Sequencing allows you to set a predefined order for your products in a category by setting a sequence value for each product. When browsing categories, you will want to order products in a way that will drive the most sales. If the products aren't being sequenced in the expected order, this can result in less sales and worse user experience.
To investigate the sequencing issue further, we should first understand the different types of sequencing available.
Types of Sequencing
What type of sequencing am I using?
To figure out what type of sequencing is being used, you can simply look at your search query's sort parameter to see the sequencing function being used. For example:
If you have confirmed that you have the right sequencing function used, but are still seeing odd sequencing behaviour, make sure to also verify that you have the right sequencing function parsers defined for each sequencing function:
If you have verified that the right sequencing function and right parser is being used, then at this point, we can start to look at our indexed data to verify that the right sequence values are being indexed.
Do we have the right sequence values indexed?
You can now directly query the index by querying for products under the category in question and sorting based on the sequencing function:
This query allows us to get all the catentries under the category in question and return the sequence value associated to the catentry.
If the right sequence values are being indexed, then you can review the results to confirm that the sequencing function is sorting the results properly. If you can see at this point that there is an issue with the result order (ex. first = 99.0, second = 1.0, third = 6.0, fourth = 0.3, ...), then there is something wrong with the sequencing function itself and you may need to engage IBM Commerce Support to get a fix for this behaviour. If you are on Commerce v8, make sure that you are on the latest fix pack available for your mod level. If you are on Commerce v7, then you should make sure that you have the following fixes applied to be using the most up-to-date version of the sequencing function: Feature Pack 6: JR54466, Feature Pack 7: JR53713, Feature Pack 8: JR56287 (Cumulative Fix #3)