Automatically update a spreadsheet of active products

One of our e-commerce clients has several thousand active products. As a distributor, their clients are retailers, some of which like having an up-to-date product spreadsheet.

Using the Events, Conditions, and Actions (ECA) module along with a Views Data Export view of all products, we created a view of all the relevant fields that exports a spreadsheet of all their products, and saves it in their private media system once per day.

First, create a view showing all the fields you want shown, using Views Data Export.

Then, run the view to generate the initial spreadsheet.

In the media library, upload the first spreadsheet.

And finally, in the ECA model, use the Views Export Query into File action, and give it the file name of the file you uploaded.