Make the product indexable

When you make a product indexable, all the components of the product are placed into a database table and tracked as updates are made. This improves performance by only searching the required data and not the complete database.

Procedure

1. Run the qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -clear_all_indexes and qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -clear_queue commands to clear any existing index or queues.

2. Run the qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -make_indexable -product={PRODUCT_ITEM_ID} 2> make_indexable.out command to make the product indexable.

   If there are any missing product components, the check_indexable option lists it. You must index it again for it to be picked up.

3. Run the qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -check_indexable -product={PRODUCT_ITEM_ID} 2> check_indexable.out command to validate that the product is indexed.

4. Run the qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -list_indexable -product={PRODUCT_ITEM_ID} 2> list_indexable.out command to list all the contents of the indexed product.

Note: Run the qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -make_non_indexable -product={PRODUCT_ITEM_ID} command if you want to make the product non indexable.

After you index a product, it is recommended that you regenerate the database statistics to improve the search performance, as described in the database documentation.