How to automatically update woocommerce products with a csv

Question

I'm currently stuck on my websites with a csv product import. I want the csv to sit on the server where i can simply update the csv and all the data will be transferred over to my products instantly without having to consistently upload the csv.

Does anyone know any way how to make this happen automatically ?

Thanks for your help!

I am not sure if I understood you correctly. You want to import from a csv file which placed on the server i.e. by automatic ftp upload, and the import should start automaticly if a file is there? — Andy Tschiersch, Sep 04 '20 at 13:41

score 1 · Answer 1 · answered Sep 04 '20 at 14:13

A simple way to this can be a function which will be executed on every page load. This function checks if there is a csv-file, and if so, starts the import. But there a weaknesses by doing it this way. The import process will stuck the page load. And if the functions checks whether there is a cs-file, it can be that this csv-file is not completely uploaded, because the ftp-transfer is still running in this moment. (see here)

A better way is to use a Webhook to invoke the import function. The Webhook ideally should triggered by the process which transfer the csv-file (after completion) to the server.

Hi Andy, thank you very much for helping on this. I will try both options to see which one will work better. — Oskar Gruszewski, Sep 04 '20 at 14:43

How to automatically update woocommerce products with a csv

1 Answers1