Ceon URI Mapping (SEO)

Hi,

fawad123:

I'm already using CEON URI Mapping module for my zencart. But now i want to modify it like:

http://solutioninn.com/Physics/product_id

instead of

http://solutioninn.com/Physics/Product_Title

Please help me with this modification part.

You'll have to go in and manually update/enter your URIs with their product IDs.. the autogeneration doesn't support IDs.

All the best...

Conor
ceon

Hi,

new2u:

When spider testing my site some of the links ex: and ezpages show zenid: followed by a bunch of characters. I cant seem to get those to change to just say /contact-us what might I be doing wrong.
thx in advance

That's the Zen Cart session ID. Zen Cart handles that, it's nothing to do with the URI Mapping module. I think search engines ignore session IDs so I think you can just ignore this.

All the best...

Conor
ceon

Hi,

new2u:

automagically lol....
Yes I have gone into each product checked the box for the rewrite however it doesnt seem to do it on any of the "ezpages"
It seems to work fine on the product pages.

It sounds like you have missed uploading the files from the admin folder in the modified_core_files folder. Please reupload all the files and you should see the boxes for adding URIs to EZ-Pages.

All the best...

Conor
ceon

Hi,

captainmorgan:

I just added the following to my .htaccess file and it still doesn't work. Is ther eanything else I need to change?

"It doesn't work" isn't very helpful!

Please try installing the module from scratch again (repeat the entire process). If you are getting a blank page, then search this forum for "blank page" and follow the instructions for enabling error reporting.. that'll give you a better idea of what you've done wrong. 9 times out of 10 it's simply that a file or two hasn't been uploaded or the FTP software has messed up uploading a file.

Hope that helps!

All the best...

Conor
ceon

conor:

Hi,

You should check the code of your site. It sounds like you have something wrong with your search pages.

The module normally makes two SQL calls when mapping a page.

It makes a single SQL call per generation of a link on the site to a product/category/manufacturer EZ page.

It makes 2 SQL calls for a link to any other Zen Cart page.

I fail to see how that could add a significant load to your site. Unless you are generating hundreds of links on a page (a massive search index or something?!).

Unfortunately there's no worthwhile way to make the module faster.. so if you are still having those problems you should try and reduce the number of links generated on your site or upgrade to a better server which doesn't take so long! (1 minute is ridiculous, pages here are generated in milliseconds!)

All the best...

Conor
ceon

It seems that the problem relates to the css horizontal flyout menu, it must be generating the links for these everytime the page loads but if i remove the ceon mod it generates the link using the seo mod no problem. Any ideas how i can get both the ceon mod in and working with the horizontal drop down i have reduced the amount of levels the menu goes to but this is still a little slow.

Thanks
Brad

conor:

Hi,

"It doesn't work" isn't very helpful!

Please try installing the module from scratch again (repeat the entire process). If you are getting a blank page, then search this forum for "blank page" and follow the instructions for enabling error reporting.. that'll give you a better idea of what you've done wrong. 9 times out of 10 it's simply that a file or two hasn't been uploaded or the FTP software has messed up uploading a file.

Hope that helps!

All the best...

Conor
ceon

Hmm. Interesting. My website didn't work last night when I went to bed. Now I've checked it this morning and it's working!

Hi,

captainmorgan:

Hmm. Interesting. My website didn't work last night when I went to bed. Now I've checked it this morning and it's working!

That sounds like a fantastic way to get things to work! Do you mind sharing the secret? I'd love to have a bit of a sleep and have things just start working! ;)

Glad to hear everything's alright now!

All the best...

Conor
ceon

Hi Brad,

websightdesign:

Any ideas how i can get both the ceon mod in and working with the horizontal drop down i have reduced the amount of levels the menu goes to but this is still a little slow.

I'm afraid not. Either you'll have to adjust how the menu works so it isn't effectively creating a sitemap of your site for every single page load, replace the menu with some less resource intensive code (adding caching for example), or you'll have to upgrade to a better server (hardware's cheap these days! :) ).

Sorry I can't be of more help than that!

All the best...

Conor
ceon

Just to add to this, in my experience, some of these fly-out menus use javascript to drive the menu behavior.. If this is the case for you perhaps a CSS only menu might help.. Not sure what horizontal menu you are using now, but here's some links you might be interested in.

I LOVE this site:
http://www.cssplay.co.uk/
This guy has all kinds of CSS only solutions.. VERY cool stuff..

I am using this horizontal menu contrib with Ceon URI with no lag issues whatsoever.
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=479

conor:

Hi Brad,

I'm afraid not. Either you'll have to adjust how the menu works so it isn't effectively creating a sitemap of your site for every single page load, replace the menu with some less resource intensive code (adding caching for example), or you'll have to upgrade to a better server (hardware's cheap these days! :) ).

Sorry I can't be of more help than that!

All the best...

Conor
ceon

conor:

Hi,

That's the Zen Cart session ID. Zen Cart handles that, it's nothing to do with the URI Mapping module. I think search engines ignore session IDs so I think you can just ignore this.

All the best...

Conor
ceon

Looking at this article

URL based session id's not only index poorly but they are a security risk. Is there any mod anyone knows of to force these to use cookies? He goes into detail on how to use the .htaaccess file to do this... anyone try it yet?

DivaVocals:

I LOVE this site:
http://www.cssplay.co.uk/
This guy has all kinds of CSS only solutions.. VERY cool stuff..

Thx for the link diva... how well do those drop downs index?

new2u:

Thx for the link diva... how well do those drop downs index?You're welcome.. The menu itself doesn't index (nor does it need to.. it's just a menu) The menu itself doesn't need to index at all since the menus simply repeat links that are indexed already via my XML sitemap (I hope I understood your question correctly..:smile:) The Zen Cart menu add-on will correctly "fix" the automated links once you apply the Ceon URI mod.

new2u:

Looking at this article

URL based session id's not only index poorly but they are a security risk. Is there any mod anyone knows of to force these to use cookies? He goes into detail on how to use the .htaaccess file to do this... anyone try it yet?Not to be the detail police or anything..:smile: But we probably don't want take Conor's support thread too far off topic.. That said, I've seen quite a few posts on this subject sprinkled liberally through out the forum.. Try doing a search for "zenid" and see if you come across anything helpful..

I don't mean to hijack it at all. Just might be a nice touch to the .htaccess file if it works.. I support I could try it and see if zen tanks..

Hello Conor,
I installed the Ceon URI Mapping3.2.4, and it run well on my web, but today, I found a problem. before not installing Ceon URI Mapping, when I click "see all", then it dispaly all my products Directory, but after installing the Ceon URI Mapping, I found that, when I click the "see all", the page is blank, and display nothing, and other EZ pages like wholesale, dropship and gifts are same problems, what the problem is, hope you can help me.
Thank you.
Alan

alan145:

Hello Conor,
I installed the Ceon URI Mapping3.2.4, and it run well on my web, but today, I found a problem. before not installing Ceon URI Mapping, when I click "see all", then it dispaly all my products Directory, but after installing the Ceon URI Mapping, I found that, when I click the "see all", the page is blank, and display nothing, and other EZ pages like wholesale, dropship and gifts are same problems, what the problem is, hope you can help me.
Thank you.
Alan

this is the pictures

after further checking, I found that, before installing Ceon URI Mapping 3.2.4, my zen cart web already has all the files in the modified_core_files of 1.3.8a.
When I install it, I cover these files which already in my web. is there cause the problem?

So, I've been trying to figure out the mechanics of how your module works a little bit.

My hope is that I could directly work with the SQL tables to do mass changes to my whole things. For instance, I wanted to add a new top level directory to every page on my site.

So, I downloaded the ceon_uri_mappings table, did all the changes I needed in a spreadsheet, converted to back to SQL, and inserted it again (AFTER BACKING EVERYTHING UP FIVE TIMES!). But it didn't work :( I kept getting a lot of 404 pages, and , for the URL would show http://site.com/dir/subdir/NULL

So, just a couple quick questions.

1. In theory, should it be possible to directly alter the SQL data to add or delete URI mappings? Am I doing something wrong?

2. Are the links created on the page - for categories and products, stored in SQL anymore? I realized that, even when I changed all of the URI mappings, on my web page the category/product links were still all the same, and did not take into account the new URIs. Is there a table where the links are stored?

Is it unwise what I am doing, or should it work if I am careful and do it properly?

Thank you,
Sasha
HyosungSource.com

There is no problem at all writing to the MySQL table for this mod. I'd say to install it (on a test site perhaps) and look at the data doing it the normal way generates. Once you see how easy it is to enter mappings via sql stmnts, you can write a script to do it however you want.

This may give a clue from one of my own auto mappers:

		$ceon_sql = "insert into ceon_uri_mappings(
			uri,
			language_id,
			current_uri,
			main_page,
			associated_db_id
			) values (
			$uri,
			1,
			1,
			'$page',
			$new_zen_id)";

Right, it should be quite simple, and thank you for your reply.

What I did was (using PHPMyAdmin), I exported the whole table, changed EVERYTHING using Gnumeric spreadsheet, saved to CSV, converted to SQL using a web utility, and inserted everything back into the spreadsheet.

In theory, it should all work. In reality...everything is all messed up! On the home page, the category links all now go to dead product links product links. Nothing works, the whole thing is bonkers.

When I drop the table and reinsert the original exported SQL backup, it still doesn't work. I have to copy over a backup table back, and then it all works.

Weird, weird, weird...maybe it is a problem with PHPMyadmin, or maybe I just screwed something up doing all of those data operations. I'll let you know if I sort it out, or if I still have any questions...

Ah! I figured it out. The whole problem was I was using an online CSV to SQL tool, which was putting quote characters around the "associated_db_id" field, turning them from an int to a string. This was causing the whole thing to choke up. I fixed it by just doing a CSV import into phpMyAdmin.

I am SOOOO happy to see how easy it is to mass edit the mappings by using phpMyAdmin and a basic spreadsheet to manipulate the ceon_uri_mappings SQL table. This makes the extension so much more useful for me. That earns a donation for you. THANK YOU!!!