How can I automate daily order and inventory updates via CSV?

[arnab1]

How to create  a process when  order created end of the day only today's order are send to our 3rd party inventory management through excel or csv format and also send them notification, After that when 3rd party inventory update quantity and make them order fullfillment and order process through excel or csv data,

How to create this process, can anyone suggested that? we dont want to update through api

[PaulNewton]

---

@arnab1 wrote:

How to create this process, can anyone suggested that? we dont want to update through api

---

Not wanting to use the api is an inflexibility that will strangle a business.

Shopify cannot be everything to everyone, the api is there for you to build the exact processes you need. 

For egress try setting it up in shopify-flow to send to googlesheets

https://help.shopify.com/en/manual/shopify-flow/reference/triggers/scheduled-time 

https://help.shopify.com/en/manual/shopify-flow/reference/actions/get-draft-order-data 

https://help.shopify.com/en/manual/shopify-flow/reference/connectors 

To bring data back in is either excel/google-sheets and formulas then using the orders import.

Otherwise use an app or build one.

[arnab1]

Hi @PaulNewton ,

Using Api can you suggest me how to create same process also use excel data?