Here’s how I got my tt_products product database indexed and searchable so that visitors to the site can find product by sku, product title, description, etc.  Because the product pages are non-cached, one has to set it up with the crawler extension – not having used it before it was a bit of a challenge.
Got there with the help of the wiki page (https://wiki.typo3.org/Crawler), a couple of newsgroup posts (http://www.typo3-jack.net/typo3-project-tt-products-lists-netfielders-de/14187-typo3-shop-problem-tt_products-crawler-indexed_search.html) some email exchanges and just reading the dmn manuals.
Site typoscript template needs to include:
config.index_enable = 1 config.index_externals = 1
Page TSConfig on the root page needed to include:
tx_crawler.crawlerCfg.paramSets tx_crawler.crawlerCfg.paramSets { all = all { cHash = 1 procInstrFilter = tx_indexedsearch_reindex, tx_indexedsearch_crawler baseUrl = www.websitedomain.com }
products = &tt_products[product]=[_TABLE:tt_products;_PID:113] products { cHash = 1 procInstrFilter = tx_indexedsearch_reindex, tx_indexedsearch_crawler baseUrl = www.websitedomain.com pidsOnly = 118 } } #113 is the pid of my products folder, 118 is the pid of the page with the products single-view template on it.
In the extension manager, on the indexed_search page:check the box for “Disable Indexin In Frontend” check the box for “use crawler extension to index ex…”Then go to Info mode, click top page in tree, switch to “site crawler”, select “start crawling”, under “processing Instructions” select “Re-indexing …” and click the “crawl urls” button.
Switch from “start crawling” to “cli status” and click run now to do the initial indexing.
Set up a cron job as per the crawler manual (or the wiki https://wiki.typo3.org/Crawler#Running_the_crawler_via_a_cronjob) to get it running every night.