SEO URL Rewrite 1.2.9

Quote

Post by iuliantoma » Mon Jun 22, 2009 2:12 pm

Let's talk about the new SEO Url rewrite in v.1.2.9

Issues:
1. Not all links are passed through the Seo Url funtion
2. the url_alias table could use indexes at query and alias columns
3. site pages like 'route=account/create' , 'route=checkout/cart' etc should be added by default or addable in admin.
4. it is not a good practice regenerating the whole 'url_alias' table after product/category/information update or add. the process takes 12 sec and more! (for 4000 products)
there should be a special page with the option to purge all Seo Urls
5. if an update of 'url_alias' table is made after product/category/information update or add should be a smart update with only the info it requires


I have hard coded some of the default links in admin/model/tool/seo_url.php

Code: Select all

$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=common/home', 		`alias` = ''");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=product/special', 	`alias` = 'oferte-speciale'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/account', 	`alias` = 'cont'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/create', 		`alias` = 'inregistrare'");		
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=product/latest', 		`alias` = 'noutati'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/login', 		`alias` = 'logare'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=account/logout', 		`alias` = 'delogare'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=checkout/cart', 		`alias` = 'cos-cumparaturi'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=checkout/shipping', 	`alias` = 'date-livrare'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=information/contact', `alias` = 'contact.html'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=information/sitemap', `alias` = 'harta-site.html'");
		$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET `query` = 'route=product/search', 		`alias` = 'harta-site.html'");
iuliantoma
New member
Posts
30
Joined
Fri Jun 19, 2009 12:38 am
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by idopoo » Mon Jun 22, 2009 2:43 pm

i can't see seo url module in my site www.idopoo.com
i have full new install the 1.29 opencart system.
but not see seo module.we can tell me how to find the seo url module?
idopoo
Newbie
Posts
2
Joined
Mon Jun 22, 2009 12:07 pm
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by dbassa » Mon Jun 22, 2009 3:20 pm

Hi Daniel, I think that I am doing something wrong with seo urls, I didn't put anything for each product or category, I will have a look. I leave my web site link here If anyone wants to have a look, it's running with v1.2.9. If someone have got IE6 please tell me if he is able to see my page correctly. Thanks Daniel.
User avatar
dbassa
Active Member
Posts
230
Joined
Tue May 19, 2009 12:11 am
Location - Spain
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by dbassa » Mon Jun 22, 2009 3:21 pm

Ooooops, I forgot to write the site....XD

www.todoparacalzado.com
User avatar
dbassa
Active Member
Posts
230
Joined
Tue May 19, 2009 12:11 am
Location - Spain
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by Daniel » Mon Jun 22, 2009 7:19 pm

iuliantoma wrote:Let's talk about the new SEO Url rewrite in v.1.2.9

Issues:
1. Not all links are passed through the Seo Url funtion
2. the url_alias table could use indexes at query and alias columns
3. site pages like 'route=account/create' , 'route=checkout/cart' etc should be added by default or addable in admin.
4. it is not a good practice regenerating the whole 'url_alias' table after product/category/information update or add. the process takes 12 sec and more! (for 4000 products)
there should be a special page with the option to purge all Seo Urls
5. if an update of 'url_alias' table is made after product/category/information update or add should be a smart update with only the info it requires


I have hard coded some of the default links in admin/model/tool/seo_url.php

Create account page and many of the others should not be added as there is no reason for google to index them.

You are really the big SEO guru!! who can give me some one who has been doing seo for 10 years.

The seo urls mean NOTHING! Its really all about content and keyword density.

4. it is not a good practice regenerating the whole 'url_alias' table after product/category/information update or add. the process takes 12 sec and more! (for 4000 products)
No its about optimization! If you have to split the keywords up and you need to do a search for each keyword its going to take a lot more cpu power and time to build each url. If its already generated each seo url requires one search.

It does not take 12 seconds!!

what do you thnk is better? the admin generating the url for once in a while or multiple clients generating them on the fly on ever page request?
User avatar
Daniel
Administrator
Posts
5627
Joined
Fri Nov 03, 2006 6:57 pm
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by iuliantoma » Mon Jun 22, 2009 11:31 pm

Daniel wrote: If you have to split the keywords up and you need to do a search for each keyword

I did not understand what you mean here.
Daniel wrote: It does not take 12 seconds!!

It does. this code is talking 12+ seconds when generating the 10000 links of my store at every product save (admin/controller/catalog/product.php)

Code: Select all

if ($this->config->get('config_seo_url')) {
				$this->load->model('tool/seo_url');
				
				$this->model_tool_seo_url->generate();
			}
Daniel wrote: what do you thnk is better? the admin generating the url for once in a while or multiple clients generating them on the fly on ever page request?

the admin way is better i think
Daniel wrote: Create account page and many of the others should not be added as there is no reason for google to index them.
True, what about sitemap page and contact?
iuliantoma
New member
Posts
30
Joined
Fri Jun 19, 2009 12:38 am
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by Daniel » Wed Jun 24, 2009 5:10 am

sitemap is done i think.
User avatar
Daniel
Administrator
Posts
5627
Joined
Fri Nov 03, 2006 6:57 pm
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by make-oc » Wed Jun 24, 2009 7:44 am

@dbassa
Your page throws JS errors:

Code: Select all

Access is denied to:
http://todoparacalzado.com/catalog/view/javascript/png/iepngfix.htc
search the forum I think there was something in that regard

Also for IE just remove

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
from your layout template—it's totally useless anyway as it puts IE in quirks mode
http://en.wikipedia.org/wiki/Quirks_mod ... ring_modes

this will bring your center column up.

Attachments

www.todoparacalzado.com.png

www.todoparacalzado.com.png (107.54 KiB) Viewed 4932 times

make-oc
New member
Posts
54
Joined
Tue Apr 07, 2009 2:17 pm
Top

Re: SEO URL Rewrite 1.2.9

Quote

Post by nterry » Sat Jul 04, 2009 9:38 am

Does it matter where you put the hardcoded code in seo_url.php for it to generate the other pages as pretty URLs? Or how do you get it to update the cart so that pages like the index, sitemap, and contact are displayed how you want? Thanks.
nterry
Newbie
Posts
2
Joined
Sat Jul 04, 2009 9:33 am
Top
Post Reply
Return to “Concepts”
Who is online

Users browsing this forum: No registered users and 8 guests