since the post is live again, I have a problem that I have been struggling for days and can’t figure it out.
I created a script to import/update products, but since I receive lots of records per minute, I had to give up using the webservices or Magento APIs. I am writing directly into MySQL product, stock and catalog search tables.
Product is being added fine, I can see it using the direct url (http://<host>/index.php/<url_path>) and also under the category that is being passed. Problem is, I cannot find it under Search or Advanced Search by any means.
I am creating a record in `catalogsearch_fulltext` table with Product Title and SKU, exactly in the same way that older products are recorded and ‘foundable’ through both Search modes. But still can’t find it, even after rebuilding search indexes.
These are all the tables that I am inserting information about the product:
I can’t see anywhere else that a product info is stored and could bring me the new product result after I search for it.
Does anyone know what I am doing wrong?
Or, at least, show me the path to debug the search module so I can understand why it is looking for something that is in `catalogsearch_fulltext` table and not bringing any result?
Thanks in advance!!!