Hi! I operate an online store with over 150 products. I used to edit every price change manually, two places for every item. A while ago I came across the Live Data stack from OneLittleDesigner, and that made my life a lot easier. I just gathered data from a Google Sheet document with everything I needed. The problem is/was that on my main product page I display every single item. The page used over 20 seconds to load all the prices from the document, so the sale dropped 99% during that short period.
Now I’m wondering; is there any way to display data from a spreadsheet locally on my server? I just want to display the value in for example E4 in tab X.
The perfect solution would be to automatically export the data from the Google Sheet we use to edit and add items, and store that data locally on my server as a CSV, XML or whatever, and then we able to get that info and display those numbers in milliseconds in the store.
Is this possible yet? I could use a local exel document, but then I’d find a way to get those numbers to display them. Please help.