Post by el3ati2 » Fri Nov 29, 2013 8:40 am

(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.

Attachments

Cached file

mod file (xml)

Last edited by el3ati2 on Thu Dec 19, 2013 6:04 pm, edited 1 time in total.

Newbie

Posts

Joined
Thu Nov 28, 2013 9:25 am

Post by butte » Sat Nov 30, 2013 1:23 am

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by el3ati2 » Sat Nov 30, 2013 5:18 am

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:

Code: Select all

INSERT INTO url_alias (query, keyword) VALUES ('account/login', 'login');
Of course you need to have "Use SEO URL's" enabled in ADMIN>SYSTEM>SETTINGS>SERVER

That's all you need to do.

Newbie

Posts

Joined
Thu Nov 28, 2013 9:25 am

Post by butte » Sat Nov 30, 2013 5:40 am

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

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Andaho » Sun Mar 16, 2014 11:09 pm

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).

New member

Posts

Joined
Wed Jul 10, 2013 4:15 am

Post by blogralali » Wed Apr 02, 2014 10:48 am

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

Newbie

Posts

Joined
Mon Dec 10, 2012 10:54 am

Post by buildmyecommerce » Sun Jul 20, 2014 11:51 pm

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/

User avatar

Posts

Joined
Fri May 30, 2014 12:23 pm
Location - New York City

Post by mishiertoo » Fri Apr 10, 2015 7:05 pm

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!

Newbie

Posts

Joined
Fri Apr 10, 2015 7:03 pm

Post by 4thdesign » Thu Jan 14, 2016 5:25 am

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?

Newbie

Posts

Joined
Sun Oct 28, 2012 10:39 pm
Who is online

Users browsing this forum: No registered users and 3 guests