Variable on Send Email - Flow Apps

Hi there,

Can someone help me with flow app?

I just need help to know variable to get data with this condition

  1. Total Net Sales - Yesterday

  2. Total Orders - Yesterday

  3. Total Net Sales month to Date.

Can someone with good experience with flow apps, helping me. ^^

To get order data in Flow, you would use “Get order data”. But none of this data is easily accessible via API, and getting it may require you to pull quite a bit of data. If your # of orders is over 100 per day, it just won’t work.

Ideally, Flow wants better integration with Shopify Analytics so you can use data from reports in Flow, rather than trying to pull all the data into Flow.

Thanks for the update. My idea is to send a daily email with the total sales for the day.

On average, my orders range from 60 to 70 per day, never exceeding 100.

My store owner prefers the old-school way—checking reports via email rather than using the Shopify app. I manually send him a report every morning, which is getting quite annoying for me. Haha.

If you suggest using an app, it’s possible, but I don’t see the need to spend money when I can use Flow. It used to be easier to use, but now the variables in Flow feel a bit confusing.

Ok, so you might be able to do (1) and (2) but not (3) because it’s that volume over a whole month.

To do it, you’ll need to get orders from that time period and then total up the values for the email report. I’d recommend exploring Run code as it’s a good way to aggregate data (instead of liquid).