Meta Tags - Defining Issues

[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,