Display Inventory On A Webpage / Google Sheet / Php Page

[e-piazza.biz]

Hi,

i've been using google sheets so far to keep track of my inventory so far.

in order to do that i've had to do everything on google sheet: create a sheet with the DB and the another sheet with formulas calculating and showing the available quantities.

(i've attached some screenshots to show these sheets)

 

is there a way to retrieve those data from prestashop so that i can easily and quickly have a look at what products are available opening a singe webpage from my mobile phone, for instance?

 

 

Edited March 18, 2016 by e-piazza.biz (see edit history)

[kokosmin]

I'm also searching for some solution to this. 2000 pcs inventory in many color and size variations drive one mad some times.

[Thorfy]

Hi,

i've been using google sheets so far to keep track of my inventory so far.

in order to do that i've had to do everything on google sheet: create a sheet with the DB and the another sheet with formulas calculating and showing the available quantities.

(i've attached some screenshots to show these sheets)

 

is there a way to retrieve those data from prestashop so that i can easily and quickly have a look at what products are available opening a singe webpage from my mobile phone, for instance?

 

 

Hello,

I am currently trying to create a module allowing to make exports to a google doc (googlesheet).

But I do not have much documentation.

Small track if you are developer:

 - https://developers.google.com/sheets/api/quickstart/js JavaScript

- https://developers.google.com/sheets/api/quickstart/php PHP

 

I come back to you if I can develop a viable trick