We've got a Google sheet that amalgamates stock from a variety of sources and have a summary sheet which displays a column of SKU's and the next column displays the available stock.
Our e-commerce platform (JShop v2.4.0) utilises a MySQL database and we would like a script writing that takes the stock levels, matches the SKU's in the Google sheet to the ones in JShop and updates the stock on a periodic basis - say every hour.
The Google sheet can be accessed as a tab separated file from a link like this:
[login to view URL]
13 freelancers are bidding on average £163 for this job
Hello, I will write a php script and setup as corn job which will read data from google sheet and update MySQL Table. Corn job will run once in every hour. I am ready to start immediately. Regards Rais U
I can provide you simple PHP script that will read tab separated file (from your last link), match SKUs from it with information in your MySQL database and next update stock level.
I could code this for you and you could either call the script with a cron job or the script could run in the background. Let me know if you are interested and I'll get right on it!