Jump to content
Pablus

Meta description

Recommended Posts

Hi, I need to compleate the meta description of each products,  but my catalog is too long. What I have already filled is the description of each products, can anyone tell me a function or solution on my DB to copy automatically this information from one field to the other?

Share this post


Link to post
Share on other sites
2 hours ago, Pablus said:

Hi, I need to compleate the meta description of each products,  but my catalog is too long. What I have already filled is the description of each products, can anyone tell me a function or solution on my DB to copy automatically this information from one field to the other?

Hi,

You can  use   a module  to  fill  the  meta  description  automatically   from  the  product  description.

  • Like 1

Share this post


Link to post
Share on other sites

You can run the following query in the DB. Kindly take the backup of the DB before executing the same.

UPDATE ps_product_lang SET meta_description = description (Ensure your db prefix is ps_ OR change the query accordingly)

 

 

 

Share this post


Link to post
Share on other sites
5 hours ago, Knowband Plugins said:

You can run the following query in the DB. Kindly take the backup of the DB before executing the same.

UPDATE ps_product_lang SET meta_description = description (Ensure your db prefix is ps_ OR change the query accordingly)

 

 

 

Great, thanks for the query!

Share this post


Link to post
Share on other sites

you can also use third-party tool to add meta details in bulk, like Store Manager trial with its import functionality (simply export columns with identificator, description and meta data you want to add).

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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