Post by alberto.gdedios » Tue Nov 06, 2012 7:52 pm

I think it´d be very useful to have a language_id column in url_alias table.
For those who want multilingual routes, that is, url_alias in each language, we need only to insert an url_alias entry for each language.
If opencart project manager/s want to have routes in only one language as now, there isn´t any problem. Leave blank the column language_id, or better, insert the default language_id for all the entries.

What do you think?


Posts

Joined
Mon Aug 06, 2012 7:56 pm

Post by straightlight » Thu Nov 08, 2012 11:02 pm

While this request may be a good idea, the entire OpenCart admin interface has the same scalability when handling multilingual settings. It is either all at the same time or nothing at all for each installed languages and within each features upon each configurations at this time.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by alberto.gdedios » Thu Nov 08, 2012 11:56 pm

What do you mean with "the entire OpenCart admin interface has the same scalability when handling multilingual settings"?
I have one store for each language, and I can customize each one. I have forced the language to the specific store (if you are in domain.us, the language is engligh; if you are in domain.fr, language is french; and so on...). And it works pretty good. The only problem is that routes are all in the default language. I´m working in an extension to fix this, but it´s a pitty to create another table like url_alias with a column language_id (I´m not going to ALTER one table of the core...).


Posts

Joined
Mon Aug 06, 2012 7:56 pm

Post by straightlight » Fri Nov 09, 2012 6:15 am

It would seem you have answered your own question. You did forced your store to load by domains which is of course implemented. As for the url_alias table, you can use the same concept as the product and product_description or category and category_description table without hope to hit a cache object on the store-front end.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by rph » Fri Nov 09, 2012 6:27 am

alberto.gdedios wrote:I have one store for each language, and I can customize each one. I have forced the language to the specific store (if you are in domain.us, the language is engligh; if you are in domain.fr, language is french; and so on...). And it works pretty good. The only problem is that routes are all in the default language. I´m working in an extension to fix this, but it´s a pitty to create another table like url_alias with a column language_id (I´m not going to ALTER one table of the core...).
What you're saying makes sense with your multi-store setup but a lot of people will be approaching the issue having one store with multiple languages. In those cases having multiple aliases for the same page could water down their search ranking.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by alberto.gdedios » Fri Nov 09, 2012 9:45 am

rph wrote:What you're saying makes sense with your multi-store setup but a lot of people will be approaching the issue having one store with multiple languages. In those cases having multiple aliases for the same page could water down their search ranking.
Uhm, now in Opencart there are a real problem of url alias. There are as many alias for product as the level of subcategory of the product. I.e, a product that is under Electronic/Computer/, will have 3 alias: domain.com/product, domain.com/Electronic/product, domain.com/Electronic/Computer/product. There are some non-free extensions that fix this, although I´m not sure if they also fix the sitemap...

If you have a page in other language, is not an url alias, is another page. If I have a product called "Ordenador" in spanish, with a spanish description, and the same product called "Computer" in english, with en english description, the pages domain.com/Ordenador and domain.com/Computer are different. I´m not an expert in SEO, and my be I´m wrong and pages in different languages but with the same content are considered alias...

I think it´s most interesting to fix the actual url alias problem (have a single route to a product), and have a multilingual url routing. But Opencart is free source, and I´ve learned sometime ago that what I want, I can do it myself. Then I can submit it as a extension if someone also want to do the same.

By the way, the actual url alias in opencart, is it a problem? I mean, Google penalizes this routing?


Posts

Joined
Mon Aug 06, 2012 7:56 pm

Post by rph » Fri Nov 09, 2012 12:57 pm

alberto.gdedios wrote:Uhm, now in Opencart there are a real problem of url alias. There are as many alias for product as the level of subcategory of the product. I.e, a product that is under Electronic/Computer/, will have 3 alias: domain.com/product, domain.com/Electronic/product, domain.com/Electronic/Computer/product.
No, this is one of the biggest myths that keeps getting repeated. There is no issue at all with this in OpenCart because it uses canonical URLs.

http://googlewebmastercentral.blogspot. ... nical.html

Multi-language URL aliases are bad because they would screw up the canonical URLs; instead of having one canonical product page you'd have one for every language.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by alberto.gdedios » Fri Nov 09, 2012 7:03 pm

rph wrote:No, this is one of the biggest myths that keeps getting repeated. There is no issue at all with this in OpenCart because it uses canonical URLs.

http://googlewebmastercentral.blogspot. ... nical.html

Multi-language URL aliases are bad because they would screw up the canonical URLs; instead of having one canonical product page you'd have one for every language.
Thank you for the link. I didn´t know about canonical urls. But I have also found in that article that multilingual routes are recommended, and advised against canonical url, like Opencart is doing. The part with url alias for many categories is OK, but not the part with url alias for different languages.
Each language should have a separate URL because the content is unique. We’d advise against equating different languages using either 301s or link rel="canonical".


Posts

Joined
Mon Aug 06, 2012 7:56 pm

Post by rph » Sat Nov 10, 2012 3:03 am

Fair enough. I hadn't read that comment before.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska
Who is online

Users browsing this forum: No registered users and 2 guests