AlunM
New Member
- Joined
- Mar 23, 2023
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- Web
Hi
I am managing the inventory backorder process for a small company selling through ecommerce stores. I want to connect the sales order grid of the shopify store to a worksheet in excel. I have tried with the 'Get data from Web' approach, but I am unable to get past the shopify login with my credentials as it is a 2 stage process. I do not know what format or code has to be entered with my credentials into the, 'basic' or 'advanced', dialogues of the data source settings process that is part of 'get data from web' in excel. I have read that I may need to create a private app in Shopify, but the the client definitely do not want to pay for a connector like Zapier or Coupler etc. I appreciate i may be going about this completely the wrong way so any insight would be greatly appreciated.
If the login is possible or a free DSN / ODBC connector, then the user can enter their credentials and refresh the file. I have many dependent sheets that do all of the breakdown of bills of material and create the back orders.
The process is currently achieved with a manually exported csv file from shopify order grid to a manual Power Query import in excel, but this is too laborious for the client. A live read of the orders would be perfect as they would filter out orders by status as required.
Any insight would be much appreciated.
I am managing the inventory backorder process for a small company selling through ecommerce stores. I want to connect the sales order grid of the shopify store to a worksheet in excel. I have tried with the 'Get data from Web' approach, but I am unable to get past the shopify login with my credentials as it is a 2 stage process. I do not know what format or code has to be entered with my credentials into the, 'basic' or 'advanced', dialogues of the data source settings process that is part of 'get data from web' in excel. I have read that I may need to create a private app in Shopify, but the the client definitely do not want to pay for a connector like Zapier or Coupler etc. I appreciate i may be going about this completely the wrong way so any insight would be greatly appreciated.
If the login is possible or a free DSN / ODBC connector, then the user can enter their credentials and refresh the file. I have many dependent sheets that do all of the breakdown of bills of material and create the back orders.
The process is currently achieved with a manually exported csv file from shopify order grid to a manual Power Query import in excel, but this is too laborious for the client. A live read of the orders would be perfect as they would filter out orders by status as required.
Any insight would be much appreciated.
