Magento - Fix URL Rewrite code + Import URL rewrite CSV file

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.

Habilidades: AJAX, Excel, Magento, MySQL, PHP

Ver mais: work notes freelancer, url of freelancer, the freelancer core, phpmyadmin freelancer work, named query, how to fix a redirected website, how know freelancer address, frontend freelancer, frontend auto, freelancer q&a, freelancer q, freelancer of frontend, freelancer magento 2, freelancer html code, freelancer code html, freelancer build website magento, csv freelancer, compare website freelancer in, code of freelancer, build mysql query, auto website fix, 2014 freelancer panel, system.core, freelancer q and a, freelancer frontend

Acerca do Empregador:
( 15 comentários ) Napier, New Zealand

ID do Projeto: #6802939

8 freelancers are bidding on average $161 for this job


Hi, My name is Marat, I am CEO of WEB4PRO development company from Ukraine. I have a team of skilled front-end and back-end Magento developers (4+ years of experience) which are ready to cooperate, communicate, sh Mais

$250 NZD in 3 dias
(302 Comentários)

We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below E-commerce [url removed, login to view] http://w Mais

$368 NZD in 4 dias
(221 Comentários)

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - We (technical team) will review the job and Mais

$170 NZD in 4 dias
(71 Comentários)

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Mais

$126 NZD in 3 dias
(104 Comentários)

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can Fix your URL Rewrite code + Import URL rewrite CSV file issue according to your exact requirements. Please Mais

$194 NZD in 3 dias
(86 Comentários)

Hello. I am able to start working on the project right away and ready to complete it in a several hours, would like to get paid for it today after the work is done. In the description you said to be NOT being abl Mais

$61 NZD in 0 dias
(138 Comentários)

Hello.. !!! We have read and understood the Project Requirements of your posted Project giving attention to each and every aspect of it. I would highly Appreciate if we could discuss this in detail. I can Assure Mais

$65 NZD em 1 dia
(82 Comentários)

i have 4+ years exp. in Magento, php i can do this in sort time ...................................... Thanks.........................

$56 NZD em 1 dia
(3 Comentários)