Meta Tags - Defining Issues

[davewest]

As a suggestion for future development of ZC it would make sense to me to incorporate the adding of meta data on the product page so it is done at the same time as the product is entered with default pre-loading being product name and product description of that product with only keywords to be added - changing product name and description to 'custom' text would be selectable as an override. For the inexperienced at least the prime data will be there for the spiders to see as meta.

Personally, I use CITTINS and do everything in one setting, even autotweet...
https://www.zen-cart.com/downloads.php?do=file&id=2171

I'm not so sure with today's search engines that metadata would be more impotent then content.. Maybe in the past... but it's interesting to see sites still trying the hidden keywords attempt.. Theirs nothing more time consuming then to have sites popup on a search that have nothing to do with the search!

[shags38]

Personally, I use CITTINS and do everything in one setting, even autotweet...
https://www.zen-cart.com/downloads.php?do=file&id=2171

I'm not so sure with today's search engines that metadata would be more impotent then content.. Maybe in the past... but it's interesting to see sites still trying the hidden keywords attempt.. Theirs nothing more time consuming then to have sites popup on a search that have nothing to do with the search!

Thanks Dave for the heads up on CITTINS - looks great, I will install it soon. You are right, content has always been king - meta data is more useful in structured data these days but meta <title> still plays a big part in SERP's .... if everything else on the site is conforming ....

Thanks again for your help - much appreciated.

cheers,
Mike

[echexxxxxxxx10]

hi, can someone help me? I need to set the form of the metatag to all products by activating product name on SI and title on SI to all products and not one by one, they are so many products ...

maybe with a mysql query?

thank you

[shags38]

hi, can someone help me? I need to set the form of the metatag to all products by activating product name on SI and title on SI to all products and not one by one, they are so many products ...

maybe with a mysql query?

thank you

I believe you should be able to do this using Easy Populate (EP4) plugin - do a full product export then in excel you can change the fields to '0' for off or '1' for on for each of the fields shown on the form (starting at column Y - you can even allocate the meta tags for all products, if they are the same or same by category or group of products by copying down the column, in this spreadsheet ........ then import the file and once imported click the copy to data base button.

Setting Product Name to on (1) will automatically allocate your product a meta title as per product name (with title set to '0') ....... *** however as I learned the hard way you MUST enter at least one keyword in meta keywords. My settings are Product Name > on ... everything else is off .... then some keywords in the keyword column.

I hope this helps.

cheers,
Mike

[echexxxxxxxx10]

I believe you should be able to do this using Easy Populate (EP4) plugin - do a full product export then in excel you can change the fields to '0' for off or '1' for on for each of the fields shown on the form (starting at column Y - you can even allocate the meta tags for all products, if they are the same or same by category or group of products by copying down the column, in this spreadsheet ........ then import the file and once imported click the copy to data base button.

Setting Product Name to on (1) will automatically allocate your product a meta title as per product name (with title set to '0') ....... *** however as I learned the hard way you MUST enter at least one keyword in meta keywords. My settings are Product Name > on ... everything else is off .... then some keywords in the keyword column.

I hope this helps.

cheers,
Mike

thanks so much for the answer, the fields are all full, I just want to bring to Setting Product Name on (1), but I could do it without installing anything, directly on the database, only I do not find where this value is stored ...

[mc12345678]

UPDATE products SET metatags_products_name_status = 1 WHERE metatags_products_name_status = 0 AND ...;

Where ... is whatever additional criteria you want to have, such as a products_id, specific master_categories_id, etc... or remove the 'AND ...' at the end to change the setting for all product.

Note though as shags38 pointed out, using a default version of ZC, something that is not empty as associated with php needs to be in either the metatags description or keywords section. If neither has a "truthy" value then the above metatag change will do nothing.

[echexxxxxxxx10]

UPDATE products SET metatags_products_name_status = 1 WHERE metatags_products_name_status = 0 AND ...;

Where ... is whatever additional criteria you want to have, such as a products_id, specific master_categories_id, etc... or remove the 'AND ...' at the end to change the setting for all product.

Note though as shags38 pointed out, using a default version of ZC, something that is not empty as associated with php needs to be in either the metatags description or keywords section. If neither has a "truthy" value then the above metatag change will do nothing.

perfect thanks!
Now I try,