How can I automate exporting orders as a CSV file using Flow?

[Ram_A]

Hi,

I'm trying to automate the process of exporting orders and saving them as a CSV file on my desktop using Shopify Flow. The Flow ran without encountering any errors, but I am unable to locate the downloaded CSV file! Also not sure if the flow worked.  I thought to use the data returned from step #2 as a variable in step #3, but I am uncertain about how to achieve this.

Not sure if this is the easy way to auto-export orders without using 3rd party app.

Any assistance would be greatly appreciated. Thanks

This image shows step #3:

here is what I did in step#2:

[joshbeckman]

Hi @Ram_A,

Currently, the Send HTTP Request action does not return data into the workflow to be used elsewhere. So the request was sent, but the resulting CSV file is inaccessible. We're working to improve that (and capture returned data) in the future.

[Ram_A]

Thanks Josh for your response,

Is there a way to auto-export all today's orders in CSV format using Shopify Flow or any built-in Shopify feature without relying on a third-party app?

I'm aware of the option to add a a new row to a Google Sheet, but what I'm looking for is a method to export all of today's orders at once. Thanks,,

[joshbeckman]

Right now you can:

- export orders (or a selection of them) through the Shopify orders admin page

- create a custom report under and export through the Shopify data analytics admin page

[Ram_A]

sure, but what I want is an auto solution.

Anyway thanks for your response.

[CarmineT]

how one  "create a custom report"?

Because the section "create custom report" they talk about here, https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/custom-reports...

is completely missing

[paul_n]

Reports here:

OR analytics here..

[scamby]

Has there been any improvement on this issue?  Any documentation about how to do the export to CSV?

[paul_n]

The same tools exists. Google Sheets is the best/easiest option for outputting tables and those can be downloaded as a CSV. You can get orders from today and loop over them using "For Each" action, sending 1 row at a time. 

[scamby]

What "tool" are you referring to?  Google Sheets for Shopify Flow?

[paul_n]

What the answers above are referring to.