Jump to content

[SEO Updater Module] Automatically generate title, description and keywords meta tags


Recommended Posts

Hi Matis,

 

I get no error messages. Backoffice simply goes blank......

 

Please help me out with this Matis,

 

thanks a lot,

 

Steven

Share this post


Link to post
Share on other sites

Hello matis,

 

Like Steven, in my case, the module crashes.

I will try to attach a picture of the error message.

I use 1.4.8.2, the store is online (FishingNet), and has only 750 products, but in the end, the store will contain over than 6000 products.

When i check the boxes "Bring keywords from category?" and "Update existing?", on the "Products SEO Updater" section, i got the error message (see attachment)

When i check only the box "Update existing?", on the "Products SEO Updater" section, i got the same error message.

Sorry for my english!

 

Please, try to help us !

Bogdan

post-372465-0-91318900-1349275331_thumb.jpg

Share this post


Link to post
Share on other sites

Hello matis,

 

Like Steven, in my case, the module crashes.

I will try to attach a picture of the error message.

I use 1.4.8.2, the store is online (FishingNet), and has only 750 products, but in the end, the store will contain over than 6000 products.

When i check the boxes "Bring keywords from category?" and "Update existing?", on the "Products SEO Updater" section, i got the error message (see attachment)

When i check only the box "Update existing?", on the "Products SEO Updater" section, i got the same error message.

Sorry for my english!

 

Please, try to help us !

Bogdan

 

Hi,

 

In Steven's case was the problem in memory limit (23K products). I'll prepare new version of the module soon, which will be optimized for huge amout of products (I hope).

 

In your case is not clear, where the problem is. Appears this error also for category update or only for products update?

  • Like 2

Share this post


Link to post
Share on other sites

Hello again !

 

It appear only for product update.

For option "bring keywords from category" - i don't really need it, because i think, the keywords for products, must be different to category keywords (in my case), and i put them manually.

For option "Update existing" - i really need this option, but i receive the error message.

The rest works fine.

 

Thanks for your reply!

Bogdan

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Nice module, nice work!

So many time saved!

 

Modifing a line of code I insert automatically manufacturer, product name + a standard sentence + description in every products.

 

thanks

G

Share this post


Link to post
Share on other sites

Hi all,

 

feel free to download new version of this module.

 

Version 0.4:

  • Fixed generating product's Meta description - now it works as expected
  • Fixed issue with "You have an error in your SQL syntax" error message
  • Added warning messages
  • Cleaned and optimized code

Just unzip zip file into the module folder.

Tested on Prestashop 1.4.8.2.

 

Enjoy

 

Version for 1.5.2 ?

  • Like 1

Share this post


Link to post
Share on other sites
  • 2 weeks later...
  • 4 weeks later...

hi, it doesn't generate meta_keywords for products (ps 1.4.3) why ?

I need the meta_keywords from product name or short description, not from categories...and also for categories doesn't generate the keywords, maybe you should update this module, so it generates in every case. You developed as the categories already have keywords, but you should think that they could not have...and categories are much less than products. In short, it's not the right way to do it. thanks anyway

Edited by mmsh (see edit history)

Share this post


Link to post
Share on other sites

the temporary workaround is to generate the meta with this module and then edit the header.tpl:

{if isset($meta_keywords) AND $meta_keywords}
 <meta name="keywords" content="{$meta_keywords|escape:html:'UTF-8'}" />
{/if}
 {if $page_name==product}
<meta name="keywords" content="{$meta_title|escape:'htmlall':'UTF-8'}" />
{/if}
{if $page_name==category}
<meta name="keywords" content="{$meta_title|escape:'htmlall':'UTF-8'}" />
{/if}
// OR
{if isset($meta_keywords) AND $meta_keywords}
 <meta name="keywords" content="{$meta_keywords|escape:html:'UTF-8'}" />
{elseif $page_name==product || $page_name==category}
<meta name="keywords" content="{$meta_title|escape:'htmlall':'UTF-8'}" />
{/if}

after that, remember to clear the tools/smarty/compile folder. :D

Edited by mmsh (see edit history)
  • Like 2

Share this post


Link to post
Share on other sites
  • 1 month later...

I there.

I have version 1.3.1 and have this issue:

warning.gif Error while processing products...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's' WHERE `id_product` = 4107 AND `id_lang` = 3' at line 1

Anyone can help telling me what to do to solve this error? Thanks in advance

Share this post


Link to post
Share on other sites
  • 3 weeks later...
  • 1 month later...

First of all thank you for the great work & for this great module.

 

But i have a Problem: it does not get the meta keywords in presta shop 1.5.3.1. Title & description it's ok...how can i fix that?

 

is there a way to copy tags to meta_keywords?

 

Bogdan

Edited by BogdanP2103 (see edit history)

Share this post


Link to post
Share on other sites
  • 1 month later...

First of all thank you for the great work & for this great module.

 

But i have a Problem: it does not get the meta keywords in presta shop 1.5.3.1. Title & description it's ok...how can i fix that?

 

is there a way to copy tags to meta_keywords?

 

Bogdan

 

hi thanks alot for this modül. exelent nice. l have new update 1.5.4.3 and l have saym problem. plz can you update end fix this problem

thanks alot for help and modül.

Edited by Benjamin Utterback (see edit history)

Share this post


Link to post
Share on other sites
  • 1 month later...

Hey guys, if you want to edit some code, this module is not necessary (for products and large shops)

PS 1.4.x

go to classes/Tools.php where is public static function getMetaTags($id_lang, $page_name)

change

/* Products specifics meta tags */
...

if ($row)
{

 if (empty($row['meta_description']))
  $row['meta_description'] = strip_tags($row['description_short']);
 return self::completeMetaTags($row, $row['name']);
}

 

with

 

if ($row)
{
 $sql = 'SELECT id_category_default FROM `'._DB_PREFIX_.'product` WHERE id_product = '.(int)$id_product.'';
 $row_cat = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($sql);
 $cat=new Category($row_cat['id_category_default'],(int)$id_lang);
 $row['meta_title']=$cat->name ." | ". $row['name'];

 if (empty($row['meta_description']))
  $row['meta_description'] = strip_tags($row['description_short']);
 return self::completeMetaTags($row, $row['name']);
}

 

doing this you'll get Category | Product name

instead if you want Product name | Category

change this $row['meta_title']=$row['name'] ." | ". $cat->name;

why this? because the product name is always defined...while you should update meta_title every time you insert/import new products, and sometimes for big shops they are too much every day and go to the module is boring... :D hope this helps

Edited by mmsh (see edit history)
  • Like 2

Share this post


Link to post
Share on other sites

Hello, guys I need SEO updater for prestashop v1.5 it is premium modul $149, I am waiting for free modul is it I hope so, if you have please contact me in firdausadamjualan@gmail.com thank

 

Hi man i bought the module...

Share this post


Link to post
Share on other sites

Hello PS folks,

I trap just now in this tread and read all the things, I'm running v1.5.4.1 and will test these nice sounded module.

Many thx for sharing so SEO imported stuff to the community!

Great job!

 

Best Regards,

Generaal

Share this post


Link to post
Share on other sites

I have installed on v 1.5.4.1, all things like to gone smoothly, but when I look in products, there are nothing in the Tag fields.

When I try to manualy add some words, seperate with the ,

I receive the follow error in BO, prodcuts, global product information:

 

Het veld meta_titel (Dutch) is ongeldig

(the field meta_title (Dutch) are invalid

 

Only the Dutch language are installed.

 

I have inspected the follow under Products, SEO:

the Meta Title field shows: Classic Dong > erotiekfabriek

And when I remove the ">" than the prob are solved!

Now, what can we do about this issue?

 

Sorry Folks, It's my stupid fault, not reading the previous treads!! :wub: :wub:

 

It's work like a cram! Many THANKS for sharing these module!

 

 

Best Regards,

Generaal

Edited by Generaal (see edit history)

Share this post


Link to post
Share on other sites
  • 3 weeks later...

Sorry , who can help you with my problem ? for example, i set up prestashop at localhost and i chose Vietnam language , my site shows :" localhost/prestashop/vn " at home page

 

How i can remove vn , do localhost/prestashop/vn ---> localhost/prestashop

 

Thanks so much

Share this post


Link to post
Share on other sites
  • 3 weeks later...
  • 2 weeks later...

I installed the 0.4 version in 1.5.4.1 multistore and not working...

 

This is the error:

[PrestaShop] Fatal error in module DbPDO:

Allowed memory size of 536870912 bytes exhausted (tried to allocate 7871 bytes)

 

any ideas?

 

Thank you

Edited by francesc (see edit history)

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Module works perfectly! I love it, but I miss (for me) one big thing.

I want to put in the title the reference number of the item.

Strangely enough, there is a product_ID, but I guess the reference number is more wanted...

 

Can anyone help me with this?

 

PS 1.5.4.1 (NL-UK & Multistore)

www.miniwheels-online.com

Edited by Miniwheels-online_com (see edit history)

Share this post


Link to post
Share on other sites

Hi guys!

 

I would like to say that such modules don't work well for SEO promotion. The thing is that if to do keyword research manually you can find many winning variants which will considerably change your website performance in the search engines. SEO specialists know that if to try different variants of the keyword spelling, include typos or synonyms, it is possible to find keywords with mothly searches two times greater than the initial keyword  suggested by the module.

 

Let's take the example of the website Sabi.com. Their current title is "Pillboxes, pill dispensers, and pill organizers simply made better", the monthly search volume for the "pillboxes" is 210, however, "pill box" keyword has 3600 searches per month, and "pillbox" 1300. It seems then that the website misses out on a great share of potential buyers who could come to the website if it had been ranked for keywords "pillbox" and "pill box" thanks to writing them in page title.

Edited by Elena Ruchko (see edit history)

Share this post


Link to post
Share on other sites

Hi, 

 

I have installed SEOupdater module and it is working efficiently though yet to test it completely. 

 

I would like to know how I can make meta keywords to be copied from product tags as this would be most helpful. 

 

Thank you. 

Share this post


Link to post
Share on other sites
  • 4 weeks later...

Module is great for 1.5x but use the version 0.4.

 

The only problem i cant find out how to solve, is the empty keyword.

 

Keywords is something google uses lesser attention on (some say) but im not 100% sure.

Share this post


Link to post
Share on other sites
  • 1 month later...
  • 1 month later...

On my multistore didn't work good, there's no support for multistore in this module. If you use this module in store number 1 all product in other store had the same seo include shop name.

Share this post


Link to post
Share on other sites
  • 1 month later...

Endrui,

 

Prestashop is already well written in terms of SEO best practices. I have only ever done on page optimisation and configured product pages with meta information. This has given me a good PR3 after 9 months and my products land Google page one.

 

Focus on the content that you control. SEO modules may help some kinds of installations but not all.

Share this post


Link to post
Share on other sites
  • 3 weeks later...
  • 2 weeks later...

Hi, I try this module on ps 1.4.7, works fine with title but I need something different. The problem is I have no description in products, my long description is generate in clasess/Product.php, just one text which is paste to 50k products and inserted in this text words from sql: model, type, etc..

 

My question is: how copy multiple rows "name" to the rows "meta keywords" could you give me the sql command for this please ?

Share this post


Link to post
Share on other sites

On my multistore didn't work good, there's no support for multistore in this module. If you use this module in store number 1 all product in other store had the same seo include shop name.

 

did you notice in multistore environment there are multiple entries (x no.of store) in product_lang table, even though if you enter the product for a specific store, i think this is a major bug in PS, same is creating issue in gsitemap module also

 

as far as getting the proper store name in meta title, you have to do tweaking in query.

Share this post


Link to post
Share on other sites

Module is great for 1.5x but use the version 0.4.

 

The only problem i cant find out how to solve, is the empty keyword.

 

Keywords is something google uses lesser attention on (some say) but im not 100% sure.

Where can I find version 0.4? :)

Share this post


Link to post
Share on other sites
  • 1 month later...

Yes it is working also for PS 1.6. BUT

 

Meta-keywords and other meta-tags are ignored by Google since years and nowadays strictly. It is better you invest your time in good description, content and precisely titles added as URL, so manually.

 

If you are still using microdata, you are on the best side of SEO for Google. Take a look into Google Webmaster Tools tips and forums.

 

https://support.google.com/webmasters/answer/79812?hl=en

 

and

https://support.google.com/webmasters/answer/35769?hl=en

Edited by selectshop.at (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites
  • 2 weeks later...
  • 3 weeks later...
  • 1 month later...
  • 1 month later...
  • 2 months later...

it works fine, but i need help.

ps 1.6.0.9 - seo updater 0.4 - multilanguage

 

In 5 of 6 languages, meta-data are well recorded. In the 6th speech does not. I have changed the name in the language and since it does not work more with the entries of the meta-data.
I have already uninstalled and reinstalled the module, unfortunately without success.

I do not want to remove and reinstall the language - but the effort is now too high.

Can someone help me with this problem.
Thanks in advance.

Share this post


Link to post
Share on other sites
  • 2 weeks later...

i need a little modification for this module, please for your help

 

Product Tittle : [product name]

Product Description : [long description]

 

i want change into :

 

Product Tittle : FOR SALE [product name]

Product Description : FOR SALE [long description]

Share this post


Link to post
Share on other sites
  • 4 months later...

I need your help. 
I've installed the SEO updater and at first it didn't seem to work. then i played with it and it seemed to work fine.
however i've tried now to change some categories of few products but everytime I try to save, the product, it comes with following error:

Property Product->meta_title is not valid

i've tried to disable the seo updater, even uninstalled it and deleted the meta title of the product, but even with blank meta title it still show above error. so i'm unable to do any changes to existing products whatsoever.

any idea what could have caused it?

Share this post


Link to post
Share on other sites
  • 3 months later...
  • 3 months later...

Hey guys, if you want to edit some code, this module is not necessary (for products and large shops)

PS 1.4.x

go to classes/Tools.php where is public static function getMetaTags($id_lang, $page_name)

change

/* Products specifics meta tags */
...

if ($row)
	{
	
	 if (empty($row['meta_description']))
	  $row['meta_description'] = strip_tags($row['description_short']);
	 return self::completeMetaTags($row, $row['name']);
	}
with

 

if ($row)
	{
	 $sql = 'SELECT id_category_default FROM `'._DB_PREFIX_.'product` WHERE id_product = '.(int)$id_product.'';
	 $row_cat = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($sql);
	 $cat=new Category($row_cat['id_category_default'],(int)$id_lang);
	 $row['meta_title']=$cat->name ." | ". $row['name'];
	
	 if (empty($row['meta_description']))
	  $row['meta_description'] = strip_tags($row['description_short']);
	 return self::completeMetaTags($row, $row['name']);
	}
doing this you'll get Category | Product name

instead if you want Product name | Category

change this $row['meta_title']=$row['name'] ." | ". $cat->name;

why this? because the product name is always defined...while you should update meta_title every time you insert/import new products, and sometimes for big shops they are too much every day and go to the module is boring... biggrin.png hope this helps

 

Nice, I'm run V1.6.13 and can you fix even the picture caption with the product name filling?

Thnx a lot!

Share this post


Link to post
Share on other sites
  • 1 year later...

hello i need help with this module i have an error like that when i update the configuration, i think the error is the function mysql_error(), but i don't know to fix it

 

 

[PrestaShop] Fatal error in module file :/home/*******/public_html/modules/seoupdater/seoupdater.php:
Uncaught Error: Call to undefined function mysql_error() in /home/*******/public_html/modules/seoupdater/seoupdater.php:241 Stack trace: #0 /home/*******/public_html/modules/seoupdater/seoupdater.php(76): SEOUpdater->_postProcess(1) #1 /home/*******/public_html/controllers/admin/AdminModulesController.php(867): SEOUpdater->getContent() #2 /home/*******/public_html/controllers/admin/AdminModulesController.php(1116): AdminModulesControllerCore->postProcessCallback() #3 /home/*******/public_html/classes/controller/Controller.php(178): AdminModulesControllerCore->postProcess() #4 /home/*******/public_html/classes/Dispatcher.php(367): ControllerCore->run() #5 /home/*******/public_html/admin137/index.php(58): DispatcherCore->dispatch() #6 {main} throw

 

 

 

 

 

 

I have prestashop 1.6.1.11

Edited by nagaor (see edit history)

Share this post


Link to post
Share on other sites
  • 3 months later...
  • 1 year later...

This module not working as it should. Removes description from product SEO and does not mether what you chose: as default, short or long it makes every time: "Meta description  
371 characters — try to shorten description to 300 characters."

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More