Catalog index building
The Lucene searchable index file contains denormalized item data that has been extracted from the Sterling Order Management System Software database. The index file stores all the item data that is required for performing fast, scalable searches.
Additionally, the index file is stored on the server, further enhancing the performance of the search. For example, if a customer searches for red shirts, the Lucene search engine uses the index file to quickly locate all the item information pertaining to shirts with the attribute value of red.
The Create Catalog Index time-triggered transaction builds an index file for each supported locale. The transaction can be configured to perform the following tasks:
- Build a full or incremental index file for each locale
- Run scheduled index builds or enable user-initiated index builds
- Activate the index
The transaction refers to an XML configuration file for instructions about building the index file. The default index file configuration includes item data about attributes, categories, pricing information, and assets (Sterling Order Management System Software provides only the HTML format for asset type by default.)
If any changes are made in the database to the attributes of entities that are defined in the catalog search XML configuration file, the catalog index must be rebuilt, either incrementally or fully. For example, you must rebuild the index after adding or deleting individual items in entitlement rules, or when an item is added or removed from a category. The same is true when the price on an item is modified or added. Additionally, the index must be fully rebuilt when there is a pricelist assignment for anonymous or all customers removed.