seo url issue [solved]

(SOLUTION in post#3)

I am trying to create seo friendly url's in v1.5.6. I am using a VQmod that I've picked up in the forum (here). I have attached the both mod and the cached file from VQmod that would be altered.

I would really appreciate it anyone could take a look at the code and advise why this is not working.

I have turned on seo url in admin and in fact the seo friendly urls for my products is working 100%; but not for the other main pages (main, register, wishlist, login, etc..)

Cheers.

The upper pair of links in http://forum.opencart.com/viewtopic.php ... 80#p439397 may help.

The cache file is simply memory of what went by and goes by again, so that recalling files is avoided. The extension does not alter the cache file. The extension substitutes segments of code for those in one or more core files when it runs.

Thank you for your reply.

The reason I included the cached file is to make it easier to see how the mod is integrated into the original file (instead of doing the work yourself).

I checked the link you mentioned, and there was a couple of things that in the end helped me figure out a solution.

After trying different things, it turned out that it is extremely simple.

I hope this will help someone; here's what to do:

All you need to do to get the friendly seo url for pages like "main" or "login" etc.. is to insert to the table url_alias in php a record of the page you which to route to a seo friendly url.

For example if you want to route your login page from http://www.yourdomain.com/index.php?=account/login to http://www.yourdomain.com/login, using phpMyAdmin, simply insert the following in a new record in url_alias:

Insert 'account/login' into the "query" field and 'login' into the "keyword" field.

Here's the SQL:
Of course you need to have "Use SEO URL's" enabled in ADMIN>SYSTEM>SETTINGS>SERVER

That's all you need to do.

Congratulations, you got there. When you're satisfied, go ahead and edit your opening title Solved, for others' benefit.

el3ati2 wrote:For example if you want to route your login page from http://www.yourdomain.com/index.php?=account/login to http://www.yourdomain.com/login, using phpMyAdmin, simply insert the following in a new record in url_alias:

Insert 'account/login' into the "query" field and 'login' into the "keyword" field.

Here's the SQL:

Code: Select all

INSERT INTO url_alias (query, keyword) VALUES ('account/login', 'login');

Do you need to add a record for each and every url_alias to get the mod to fully work?

EDIT: on further searching, yes it does, here is a tutorial written on it: http://forum.opencart.com/viewtopic.php ... 72#p164179

Why has this sort of thing not been added to the core of the opencart SEO? - it seems like a common thing people are having to manually add for the last few years (from searching for a solution myself).

my website ralali[dot]com have a canonical url problem

Thank you el3ati2 for the excellent tip. I have created video format showing you how to create the seo friendly urls for opencart pages after reading this post. Let me know. Thanks.

http://buildmyecommerce.com/blog/how-to ... art-pages/

hi guys, i am using oc Version 2.0.1.1. i followed the steps but nothing has changed. is there an updated version on how to change the url to seo friendly? thanks!

SEO for opencart is fucking shameful.

In comparison to other carts and CMS's, this is the worst I have ever experienced and why something like a simple SQL command hasn't been added to core files is quite frankly.... lazy.

Its a great look cart, fantastic functionality but without CORE SEO work, it means nothing at all for search functions. No-one is ever going to find your shop. So.... whats the point?