I created a module for prestashop call "mysftpfile" I need to include a PHP script on this module to create a "[login to view URL]" file from the database using only active products, then upload this file using SFTP to a remote server, the configuration page of the module is ready and will provide the variable to login to the SFTP.
Configuration::get('MY_SFTP_LOGIN')
Configuration::get('MY_SFTP_PASSWORD')
Configuration::get('MY_SFTP_SERVER')
I included a sample of the "[login to view URL]" file on a sample folder on the module, so you can see what needs to be collected from the database.
I should be able to create a "cronjobs" to run this one a day to create and upload the file.