Skip to main content
Solved

Trigger Flow based on Purchase Date day

  • November 8, 2024
  • 4 replies
  • 39 views

Forum|alt.badge.img+3

I may be overlooking something, but I can’t seem to figure out the following seemingly simple scenario: 

I want to enroll profiles in a flow to receive an email if their order purchase date is on a Friday. 

 

The context is: 

  • Friday starts our Order Week. (Example: November 1, 2024)
  • Order Week ends on the following Thursday. (Example: November 7, 2024)
  • Any orders within this window will be delivered on Sunday. (Example: November 10, 2024)
  • Cycle restarts Friday 12:00 a.m. 

Many people ignore the giant text at the top of the ordering page, place an order at 1 a.m. on a Friday (Example: November 1, 2024) and think they will receive their order on that nearest Sunday (Example: November 3, 2024). Given this, I’d like to send an email that reminds them that their order isn’t coming for another week. 

Best answer by bluesnapper

No problem @VinnieT 

You can use purchase date as a trigger around dates but not for specific days of the week. It would be great to have that day data but if the ecomm platform doesn’t capture it. Klaviyo doesn’t have it.

I did take a look at Shopify flow to see if this could be achieved to create a custom property for day-of-week in Klaviyo, but no luck. Hopefully it can be achieved using AutomateWoo. I did look at purchase event data for a WooC client and that too only captures date not day.

It would be helpful for others on the forum if you post back your solution when you’ve nailed it!

Regards

Andy

View original
Did this topic or the replies in the thread help you find an answer to your question?

4 replies

Christiannoerbjerg
Expert Problem Solver II
Forum|alt.badge.img+12

Hi @VinnieT 

Thank you for posting in the Community!

I think the best way, would be thought a Webhook function or storing the customer purchase date in a data warehouse like Napkin.io, where it’s checks for the day of the week via. a JSON script. 

Hope that helps! :-) 

Christian Nørbjerg Enger
Partner & CPO
Web: Segmento.dk
LinkedIn: @christianfromsegmento
Voldbjergvej 22b, 8240 Risskov


bluesnapper
Partner
Forum|alt.badge.img+45
  • Champion & Partner
  • 731 replies
  • November 9, 2024

Hi @VinnieT 

An interesting one!

Ecomm platforms usually capture the date and time of the order but not the day. So as @Christiannoerbjerg suggests you will need to add something in the process that can handle the date to day-of-week conversion. You may be able to do that with make.com or Zapier without coding. For example, a chatGPT module will be be able to convert that for you.

Then update a profile’s custom property in Klaviyo for the day of the week. That can be used in your flow to identify orders placed Friday to Sunday. 

As a workaround, you could call-out in the placed order flow that orders placed Friday to Sunday will be delivered the following Sunday. That way you hit them twice with that messaging: on the order confirmation page and in a post-order email.

Hope that helps.

Regards

Andy


Forum|alt.badge.img+3
  • Author
  • Contributor III
  • 5 replies
  • November 9, 2024

Thanks for the input! 

 

I’ll just use AutomateWoo. I was hoping to keep all emails in one spot, but not a big deal. Guess I am just shocked there is no way to use Purchase Date as a trigger (at the very least, within a range, before/after a date, etc.).


bluesnapper
Partner
Forum|alt.badge.img+45
  • Champion & Partner
  • 731 replies
  • Answer
  • November 10, 2024

No problem @VinnieT 

You can use purchase date as a trigger around dates but not for specific days of the week. It would be great to have that day data but if the ecomm platform doesn’t capture it. Klaviyo doesn’t have it.

I did take a look at Shopify flow to see if this could be achieved to create a custom property for day-of-week in Klaviyo, but no luck. Hopefully it can be achieved using AutomateWoo. I did look at purchase event data for a WooC client and that too only captures date not day.

It would be helpful for others on the forum if you post back your solution when you’ve nailed it!

Regards

Andy