Skip to main content

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. 

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

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

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.).

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

Reply


Terms & Conditions

Links & Resources

Platforms

Partners

Useful Things

About

  • Terms and Privacy |
    © 2024 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.