Auto export store items into a CSV file and transfer via FTP

One of my customers requested an addition to their site. They want a feature that can collect and save all the store products as a CSV file and then automatically transfer the file via FTP whenever a product is added or updated. I’ve never set anything like this up and I have a limited knowledge of Javascript so I’m wondering if anyone has suggestions for me.

There are a few requirements with the CSV file that add another layer of complexity to the problem.

  1. Image URLs would have to be a full URL, not just the slug that you get when you export your store to CSV. This means that something would have to be set up to add the first part of the URL to every image for a product.

  2. The Description field would need all HTML tags removed, I noticed in the exported CSV there were < p > tags for new lines all over.

I’ve read in some of the other forum threads that Wix does not have a built-in FTP feature and that I would have to use a third-party system that would link to Wix.

Any code suggestions or tips would be appreciated!