I need to build some advanced search functionality for a Magento website. User can already receive search auto-suggestions, but when a suggestion is clicked or submitted, the search query needs to be compared to stored URL re-writes and redirected to an alternative URL address within the website if a match is found (please view below example).
A customer uses the search panel and submits a search query for "sodium chloride". The query looks like this....
and should be redirected to....
"products/full-product-list/s-products/[url removed, login to view]"
How it will work:
1. Search panel within Magento frontend uses search suggestions from table in database named "catalogsearch_query".
2. Search queries are submitted and compared to url re-writes table named "core_url_rewrite".
3. Core url re-writes are automatically generated by system by default, I need to be able to import custom URL re-writes via CSV file like I use to be able to do before a previous freelancer caused some issues.
Currently searches give generic results which is not what I am wanting, a previous freelancer corrupted the URL re-write CSV import process. I have now not been able to import my custom URL re-writes via PHPmyAdmin.
Extra Notes: May need to disable system url re-writes so we can import custom rows without having to restart the system re-writes process each time. It takes many hours for system to refresh or re-generate url re-writes.
It would be preferable if I could import my custom URL re-writes into a seperate table which could then be used to compare search queries to my own redirects list. This would help eliminate issues of inserting rows into the system core url re-writes table.
Hope this is enough detail. Let me know if you have any questions....will only award project to someone who writes something directly related to what I have asked.