I run a magento storefront and my client asked if I could connect the website to the in store sql db to pull inventory and send orders to.
I am not familiar with how to do this and I am thinking that I could run a cron to send a csv file to a location on the website then tell the customers computer to pull that file and import it into the SQL server they have locally?
I would have to map the fields while doing this.
On a difficulty scale how hard would this be? I can easily have the file dumped to a folder no problem and can use php to map the fields but how to I get that file to their local sql server?