Link from Excels Power Query to Squares Items (Inventory)

[Candlestore]

Is it possible to use Squares Inventory Item list as a web based source for Power Query in excel to use as a data file?  I just want to have an Excel Spreadsheet use the Inventory or Items data set to basically do vlookups without having to download a csv file of the data all the time.  I know in Excels Power Query I can have different sources of data for reading without changing the original data.  Basically using Power Query to look at my inventory and making a list of only items with under X Quantity or a variable Quantity.  Would also be great for when we count inventory with a barcode scanner Power Query could look at the inventory to get the Items name and quantity from the barcode we scan and have another column that is counting items we scan.  I already have spreadsheets that do this all except for connecting to the inventory file.  Currently I need to login to Square , then download a csv of my Items library, just would be nice to open excel and click refresh and pulls the data from my items file in Square.

Does anyone know if this is possible?

thanks in advance

[Ria]

Hi @Candlestore - Thanks for bringing this question to The Seller Community, it's always nice to see you 😊

Great Question.

I'm happy to do some research to see if this is something that can be done or if its actually a feature request that can be escalated to our engineers. I'll be sure to pop back in with you as soon as I know more. 

As always, feel free to stop by The Community with question, concerns and even feature requests. We are more than happy to assist. ✨

[Candlestore]

@Ria ,

Thank you for looking into this, as I know you can access the Items via export, but would be great to link Excel to it as just even a viewed file so it can not be accidently changed without doing the upload through the Square Dashboard.

[Ria]

Hi again @Candlestore 

Thank you for your patience while I looked a little further into this.

Looks like this is more of a feature request at this moment. 

 I recommend you submit a Feature Request here. This will help our product team get visibility and track other Sellers' interest in your request.

Let me know if there's anything else that I may be able to do to assist. 

As always, feel free to stop by The Community with question, concerns and even feature requests. We are more than happy to assist. ✨