Would like to change page content (e.g., text fields) via a weekly batch job.

Ask the community
, ,
1

I would like to periodically (via a schedule) change the content on the home page for a client. They have many Case Studies and Testimonials. I realize I can randomly query from tables to do this, but it slows the home page loading. Ideally I would like do this on a daily or weekly basis to (hopefully) get SEO benefits, but more importantly speed the actual page load as it would not have to perform two separate queries to load the page. This also means my client wouldn’t have to periodically do this themselves or pay me to do it.

I know how to write server side, batch scripts, query the DB etc., but I have not found a way to reference fields on a specific page and their content via a batch script. Maybe I am missing something obvious and simple?

I am hoping (speculating) that such changes if done from the back-end will still appear on the published site, but that maybe another question.

Any thoughts, pointer, or suggested areas to investigate are appreciated.

2

You should connect your text elements to a database and use the new jobs feature ( https://support.wix.com/en/article/corvid-scheduling-recurring-jobs ) to update the values in the database.

3

Hi Ohad;

Thank you for the response, perhaps my description was not clear, or I did not follow your suggestion. I am aware of the jobs feature as a way to schedule things to run periodically and I plan to use that.

Currently I have 3 testimonials, and 3 Case Studies; on the home page that are queried from the DB. I would like to change this design to automatically (e.g., weekly) have a job run that changes these testimonials and case studies directly; meaning change the content in the fields on the home page. (this is the part i am trying to figure out how to do).

The goal is to eliminate the queries from the home page completely; thus speeding the home page load time.

Thank you,
Ron