Community Forums

by **deadcow** » Tue Mar 29, 2011 6:39 pm

Tired of manually entering your SEO keywords? Here comes the successor of the AutoSEO module from voodoo!

This module will automatically generate:
- your products SEO keywords
- your categories SEO keywords
- your manufacturers SEO keywords
- your meta keywords
- your products tags (new in v1.1)

The meta keywords generation can use both the templating system (for example product_name], [model_name]) and the Yahoo! Term extraction service (BTW you might not need an App ID, try with some random stuff before).

If you don't know, the Yahoo! Term extraction service will extract keywords from your product description.

Grab it here!

v1.x is for OpenCart before 1.5, v2.x is for Opencart >= 1.5

CHANGELOG :

v2.1
- Quick fix for the buttons to display properly after some OpenCart style changes

v2.0
- OpenCart 1.5 compatibility

v1.2
- NEW : Better language handling by letting the admin choose the source language
- NEW : Better support for typos in product names, eg spaces before / after (suggestion by alexmbra)

v1.1
- NEW : Tags generation
- NEW : Spanish translation thanks to Norbert I.!
- NEW : Added [manufacturer_name] tag to products
- FIXED : No hyphens "-" removal in Meta Keywords generation (suggestion by gsdev)

v1.0
- Initial release

Enjoy and leave your comments!

by **nathalie** » Tue Apr 05, 2011 2:03 pm

Does it also gives you a warning when you have 2 of the same Title's and Model names?

by **deadcow** » Tue Apr 05, 2011 2:20 pm

No warning but it will append a number so you'll end up with ipod, ipod-1, ipod-2, etc.

by **nathalie** » Tue Apr 05, 2011 3:07 pm

Awesome! thank u! Im gonna try it out right now!

by **alekln** » Wed Apr 06, 2011 9:25 am

it doesnt work with sub categories, their names left the same

by **minhhieu493** » Fri Apr 08, 2011 2:42 am

It work with other languages?

by **SupraTwinTurbo** » Fri Apr 08, 2011 5:03 am

Awesome work.

by **madimar** » Fri Apr 08, 2011 10:28 am

Excellent Excellent Excellent

by **deadcow** » Fri Apr 08, 2011 10:58 am

SuprawinTurbo, madimar : thanks!

minhhieu493 : yeah of course. BTW the interface is available in English and French. If you're like Spanish it will stay in English but you can use the module nevertheless.

by **alexmbra** » Sun May 08, 2011 8:55 pm

deadcow wrote:No warning but it will append a number so you'll end up with ipod, ipod-1, ipod-2, etc.

Well, that is not working right. I have 2 products with this name: "blusa oncinha", and after generating the product SEO, one of them became like this: "blusa-oncinha-" and the other like this: "blusa-oncinha".

I found out that I had an empty space at the end of one of the products. But this can be fixed if you add this into the makeSlugs function:
Change this:

Code: Select all: $string = strtolower($this->noDiacritics($string));

Into this:

Code: Select all: $string = rtrim(strtolower($this->noDiacritics($string)));

by **deadcow** » Sun May 08, 2011 9:48 pm

Is it the module not working right or your typing that's wrong? If you have the same problem with another module will you ask for a fix too? Wouldn't it be faster to fix the space yourself so that you have a clean database?

Just asking.

by **alexmbra** » Mon May 09, 2011 12:57 am

deadcow wrote:Is it the module not working right or your typing that's wrong? If you have the same problem with another module will you ask for a fix too? Wouldn't it be faster to fix the space yourself so that you have a clean database?

Just asking.

Well, if I was the only person editing and entering new products, it would be faster, but I am not the only person doing that. And I can not be looking over the other persons all the time to be sure they will always making sure that they don't enter empty spaces at the end of the product names.
Also, as a programmer we need to make sure that our code will always try to treat the right way all data entered by any person that could be using our code or software, so that our code could always respond the way it should respond.

by **deadcow** » Mon May 09, 2011 1:12 am

OK from what you said then it's a bug report for OpenCart in general, isn't it? Let's ask Daniel why he doesn't trim the name before saving to the database.

by **alexmbra** » Mon May 09, 2011 2:49 am

deadcow wrote:OK from what you said then it's a bug report for OpenCart in general, isn't it? Let's ask Daniel why he doesn't trim the name before saving to the database.

Why is a Opencart bug? Having a empty space at the end of product's name doesn't affect any opencart functionality.
But is your module, that gets the product name and make some treatment to it. Since is your module that needs to have no empty space at the end, so, it should be your module to take care of that.
Daniel should not be changing the way opencart works because of every module that people develop, don't you think?!

Anyway, this module is a great module.

by **deadcow** » Mon May 09, 2011 3:06 am

Hmm yeah but you know why I told you that? I have this module (not written by me) that does a report and allows to group the results by name. If I had your database I wouldn't be able to group because of the spaces. And instead of asking the author to handle my errors, I'd fix the spaces myself, because something is wrong with my database in the first place. *OR* if I wanted to patch something badly I'd patch OpenCart so that the database would be clean - and that would solve every problem we could think of. But I wouldn't patch each module one by one. Well maybe it's just me.

Anywaaaaaaaaaaaaaaay since you told me you loved the module I'll stop being an asshole and will consider inserting your patch! xD

Better, I'll even insert a trim instead of rtrim so that people that insert a space before won't complain afterwards. How nice is that?

Catch you later dude!

by **nando** » Tue May 31, 2011 12:10 pm

Does this module work automatically? I mean that AUTO SEO needed the administrator to go to extensions->modules and run the products update everytime a product would go live (if I am not mistaking). This is not working properly on a live website (duplicate products appear in url_alias) and the integration with RSS feeds is not there.

Also, if I install this module and deactivate AUTO SEO first, Would it respect the schem we have now? product_name-product_id? like site/skaters-54 being skaters the title and 54 the product id.

by **deadcow** » Tue May 31, 2011 12:24 pm

No, it does not work automatically. For that I would need to change OpenCart core files and I don't want to do that ATM, too much trouble in term of support

I'm not quite sure to understand when you talk about duplicate products... If you could send me a dump or something that would be great cause it might be a bug but this is something that was never reported.

You can uninstall AutoSEO, it's the same here, only better, so the scheme is going to be respected, in fact you can edit the scheme the way you want too.

by **nando** » Tue May 31, 2011 3:47 pm

Ok, great to know that! I am still using 1.4.9.1 so I guess it is better to update Opencart and then switch to deadcow SEO.

The database had different url_alias_id for the same product, although the query column showed somehow different urls like product_id=56&category_id=37 and product_id=56& and the keyword column showed different content too. I am not sure if I did well by removing manually the duplicate entries but the site is working normally now.

by **nando** » Fri Jun 03, 2011 8:40 pm

Hi deadcow,

I did install your mod to version 1.4.9.1 and then upgraded up to 1.4.9.4 seeing that the urls do not work properly, as AutoSeo used to work.

What I had was site.com/productname-product_id which worked perfectly, while keeping the category in the breadcrumb. Now I have doubled the products in the url_alias table with the same product available many times. I can access the same product using any combination of site/product_name or site/product_name-product_id although the site still shows the latter (as it should be). AutoSEO kept in the DB url_alias table column query product_id=49&category_id=35 or manufacturer_id=13 or product_id=50 for the rewritten keyword without the -product_id at the end for products, but working on the site urls with the product_id.

I understand that changing

Code: Select all: $uniqueSlug = $slug . '-' . $index++;

to

Code: Select all: $uniqueSlug = $slug . '-' . $product['product_id'];

and line 19 from catalog/model/tool/seo_url.php to like instead of = would return the site to how it was before this upgrade on admin/model/module/deadcow_seo.php, like this:

Code: Select all: $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` like '" . $this->db->escape($key . '=' . (int)$value) . "&%'");

But I have another problem since I installed deadcow SEO: new products are not shown without url rewrite as site/index.php?route=product/product&product_id=109 from highlighted products and site/category_keyword?product_id=109 if accessing from the category. This product particularly is present in 2 categories.

The Manufacturers "widget" is not showing rewritten urls either since the installation of this module. I made sure the brand name in the keyword cannot conflict with any other product, category or manufacturer.

Any help directing us to the right solution is welcome!

by **deadcow** » Fri Jun 03, 2011 8:58 pm

Hi nando,

when you say you have doubled the products in the url_alias, does that mean that you doubled them yourself or that the module makes duplicate lines? Could it be possible for you to copy and paste some of your table content? I don't really get it.