Woocommerce Keyword to CSV

Job ID: 35926266

Budget: $10 – $20 USD

Hi,
I have a wordpress with 400000 posts.
Inside there is a Woocommerce with 80000 products.
Inside each product there is a shortcode [XXXX]UNIQUE_WORD[/XXXX]

What is needed:
I need a script to go through all posts.
If post_type = product ---> find UNIQUE_WORD ---> Move word to CSV
Open new line in CSV, move to next post
* Avoid timeouts
** Possibly with root access

I cannot provide site access or FTP access, you must do this on your local server.

Any reply without:
" I have fully read and understood what needs to be done and I can do it on my local server " will be ignored
Related categories: PHP Data Entry WordPress MySQL WooCommerce