Edit Category - Update the meta information in database

Hi There

We have large number of Categories and Sub Categories. Updating the fields for each Categories and Sub Categories one by one through Admin Console consumes lot of time.

Is there a possibility to BULK UPDATE the following fields (from Edit Category page) directly in database.

Fields to be updated: Heading (H1), Title, Description, Meta description, Meta keywords, Listing meta description, Listing meta keywords, Listing meta title, Automatic post pattern

PS: Refer to the attached screenshot for the page and the fields I'm referring to.

Thankshttps://forum.flynax.com/attachment....tid=3375&stc=1

Hello,

How do you need to update these fields ? to empty them for all categories ?

Quote:

---

Originally Posted by Rudi

Hello,

How do you need to update these fields ? to empty them for all categories ?

---

Hi Rudi

I need to update these fields.

There is no a quick solution as you need to put DIFFERENT values into each category

the only thing you can do is to display all entries from database and update them all at once

using this mysql query:

Code:

---

Only registered members can view the code.

---

check a few entries and click 'Edit'