Ceon URI Mapping (SEO)

[conor]

Hi Loyd,

I was able to figure out that if I were to query the db the code to use is:

Why are you using a SQL statement when I said that using the Insert function is easier?

It won't have taken you more than a few minutes to learn how to use the Insert function, but instead I have to answer more questions, taking up more of my time.

I appreciate your nice comments about the module but you are making things harder for me by not trying things out yourself but relying on me to answer questions first. That's a little unfair on me.

Using the Insert or the query command, do I still need to associate the uri I'm entering with 'associated_db_id' for contact_us, about_us, shippinginfo and so forth? If not, I leave the value as empty?

As the documentation clearly says, you make the associated_db_id field NULL.

When using the Insert function this means leaving the box "Null" ticked.

A quick test or research into the PHPMyAdmin tool would have helped you work that out or showed you that's how it works.

For the about_us, contact_us, shippinginfo, and so on pages, for 'main_page' value, do we need to enter: index for value or for example: CONTACT-US main_page value would be:contact_us and so forth as anyone could see just pointing the cursor to the link and seeing the browser footer link it gives where index.php?main_page=value?

Yes, for the main_page field you use the Zen Cart main page name, e.g.:

about_us

or

contact_us

Sorry for keep asking questions about it. I just want to use your addon and I need to have these solved so it could work for me. I'm pretty sure that this thread will help others having similar problem until a new version help handdling the current and historic URI from admin.

You're the first person I know of to attempt to enter the data using SQL instead of learning the PHPMyAdmin Insert function so I doubt many will ever need to know this information (and for those who know SQL it's easy enough to see from the database structure). I appreciate you are trying but it would be better if for future work on Zen Cart you tried to listen to what the developer was saying to you a bit more, both in the documentation and on the forum.

Hopefully you've enough information now to get what you need done.

All the best..

Conor
ceon

[countrycharm]

Thanks once again Conor!

I was able to figure out that if I were to query the db the code to use is:
INSERT INTO `zen_ceon_uri_mappings` (`uri`, `language_id`, `current_uri`, `main_page`, `query_string_parameters`, `associated_db_id`, `alternate_uri`,`redirection_type_code`, `date_added`) VALUES

follow by the values to insert...

QUESTION1 (most important):
Using the Insert or the query command, do I still need to associate the uri I'm entering with 'associated_db_id' for contact_us, about_us, shippinginfo and so forth? If not, I leave the value as empty? If I do need to enter an associated_db_id for them, how do I find the right one because if I do a search for value on contact_us, I get a few values...

QUESTION2 (very imporant):
For the about_us, contact_us, shippinginfo, and so on pages, for 'main_page' value, do we need to enter: index for value or for example: CONTACT-US main_page value would be:contact_us and so forth as anyone could see just pointing the cursor to the link and seeing the browser footer link it gives where index.php?main_page=value?

QUESTION2:
What is 'alternate_uri' for?

QUESTION3:
When using the Insert tool, do I need to enter the Null Values or just leave it blank and it automatically fill it with NULL value? I'm not familiar with the insert tool. I always used a query command...

Sorry for keep asking questions about it. I just want to use your addon and I need to have these solved so it could work for me. I'm pretty sure that this thread will help others having similar problem until a new version help handdling the current and historic URI from admin.

Thank you once again Conor!


Loyd

As Conor said you don't use SQL statement but you use the Insert function. Conor's instruction are very easy to follow if you follow them to the tee. I'm going to show you an image of what to inset into the fields. You have to do each link you want to change just like this. If you can not figure it out after this, you will need to pay someone to do it for you.
Here's the image link

Thanks Conor for your time and your hard work on explaining things with this module.

[DivaVocals]

YOU REPLIED:

Sorry, the custom modifications distributed with that addon are not supported by Ceon.

Eventually I intend to look at that contribution with a view to fixing it but unfortunately I don't have the time at the minute. I'd suggest not using it but using another Wordpress module instead. DivaVocals on the forum has another one I think, which works.

MY REPLY:
This addon actual does support Ceon, but the issue is that when you follow the instructions in adding the code given by WOZ for /includes/init_includes/init_ceon_uri_mapping.php you get a blank page. Since it is your page the one being customized and not one from the addon, I thought you were the right person to ask the question to. Anywhere I add it, it appears to get a blank page after it. So, I guess I'm adding it on the wrong spot.

As for the 404 rule, it's working for me ;) I ask you the question because I thought you might be good on htaccess rules.

I don't want to get off topic for this thread.. So I'll say this and move on.. PLEASE post any responses to this post in the WOZ support thread. Since that is the correct place to ask questions about WOZ.

The code hacked into WOZ to "support" Conor's module is just that.. HACKS.. Instead of properly re-writing his module to work with URL re-writing and URI mods (like Ceon URI Mapping and SSU) the author of WOZ chose to write in a number of hacks to MAKE these mods "compatible", and as you found out they don't always work.. Conor cannot help you with this..

WOZ is now and has always been a poorly written, poorly supported module, and it needs a SERIOUS re-write. (and personally I hope Conor doesn't waste his time with WOZ..) Suggest using Numinix's Blog Embedding solution instead.. WORKS out the box, works with latest version of Zen Cart and requires no hacks to work with Conor's module..

Wish you luck... Again if you wish to respond to THIS post, please do so in the WOZ support thread as this whole line of discussion is NOT on topic for this support thread..

[choccybox]

Conor,

Love the script. I now have it up and running on 1.3.9F.

I'm just wondering on how to do the mapping of each product page.

Do you have an opinion on which way to map each product page? I was thinking of going with cutting out the category in the url all together to shorten it up somewhat. Is there any disadvantages of doing such a thing?

Thanks!

[Scott_C]

Conor,

Love the script. I now have it up and running on 1.3.9F.

I'm just wondering on how to do the mapping of each product page.

Do you have an opinion on which way to map each product page? I was thinking of going with cutting out the category in the url all together to shorten it up somewhat. Is there any disadvantages of doing such a thing?

Thanks!

Hi, Conor will be able to fill you in on whether there is any issue in cutting out the category in the url, (Im thinking it might not work) but I thought id mention that having the category name in your url helps your search engine ranking. Google looks at the text on your page, the meta data, and the words comprising the url itself. For example:

Search: jam donuts

Google would show something like;

www.sweets.com/donuts/jam-donuts
Description: 6 flavors of jam donuts now available...

Finding the keywords in your url helps your overall 'score'

Since we installed Ceon, our results have improved greatly.

Hope this helps,

Scott.

[conor]

Hi Scott,

Hope you're well!

Hi, Conor will be able to fill you in on whether there is any issue in cutting out the category in the url, (Im thinking it might not work)

It'll work just fine, as long as each product's URI is unique. The software will not currently warn you if you try to set a product's URI to one which is already being used, it is up to the store owner to ensure uniqueness of URIs.

but I thought id mention that having the category name in your url helps your search engine ranking. Google looks at the text on your page, the meta data, and the words comprising the url itself.

I agree with Scott. Although not the primary purpose behind the module, the autogenerated URIs do seem to have a positive effect on rankings by being structured as they are.

The primary purpose behind the module is that it's your choice though, it lets you set up your URIs whatever way you want! :)

All the best..

Conor
ceon

[Scott_C]

Hi Conor, im good thanks, but more importantly - how are you?

I hope you're getting plenty of rest and are not working too hard.

[choccybox]

Thanks for letting me know Connor. I had kind of figured that everything would be ok if all urls were unique. The only thing I don't like about missing out the category is that it kind of makes the url structure unpleasant, but I was under the impression Google prefers 5 words or less in the url and some of mine go up to about 8-10 when I include cat and sub cat etc.

The final question I have is how do you delete old urls that the ceon mapping has made for a product, but which I have now changed? I notice that the old mappings are still viewable and they don't redirect.

Is there any way to delete them?

Thanks!

[monet60707]

Hi,

I just got zen cart v1.3.9f and installed ceon Module Version: 3.6.3. But unfortunatelly it only convert url's to static links but pages don't display: i get "Oops! This link appears to be broken." page. Please see http://www.teaandmore.ca , e.g. http://www.teaandmore.ca/white-tea/pai-mu-tan
and click on any product image. Does ceon support zen cart v1.3.9f?
I have also instlled the following modules:
1. Categories Dressing
2. Column Divider Pro
3. Better Together
4. Column_Layout_Grid_For_Product_Listing
5. Define Pages Generator
6. Group Pricing (per Item)
7. Image Handler
8. FCK Editor
9. Admin Category / Product Images
10. Maximum Amount Allowed In Shopping Cart
11. Ultimate SEO URLs
12. ZEN Lightbox
13. Quick Updates
14. Search Log
15. Ad Manager

Any idea what might be the problem?

[Scott_C]

Hi, Ceon definetly works with 1.3.9f Im using it on two sites.

double-check the settings of your .htaccess file, and make sure each product is re-saved with the uri option checked.