How to export custom post type with ACF to individual file with automation?

Question

I have a custom post type product using ACF (Advanced Custom Fields)

I would like to schedule a daily cron task automation to export all published posts into post_id.txt, one for each post.

I know there are plugins that can export custom post type and ACF to CSV or XML.

But my requirement is a more customized task.

A simplified example, the format of the output file post_id.txt should be and each field separated by \n:

eg. 1234.txt

POST_TITLE
PRODUCT_IMAGE(ACF URL FIELD)
CATEGORY
TAGS
CONTENT

I can access all these information in the template loop, but how do I write a function to export them as the above job requirement?

Any pointer and direction of where to begin is appreciated.

Answer 1

Schedule your backup with WP Cron - https://codex.wordpress.org/Function_Reference/wp_schedule_event

In the cron event, run your query for posts or CPTs and be sure to add 'numberposts' => -1, to return all.

When you loop through your posts from the resulting query, push the values to an array $data[]=$some_string_data_for_prop;

• https://www.advancedcustomfields.com/resources/get_field/
• https://developer.wordpress.org/reference/functions/get_post_meta/
• https://codex.wordpress.org/Class_Reference/WP_Post

And when you're ready to write the data, convert the array values to a single string; $output = implode("\n", $data);

Then write the data to a file file_put_contents($filepath, $output);