Skip to main content
Solved

How do I create a segment only for unfulfilled orders?

  • December 27, 2022
  • 2 replies
  • 1048 views

Forum|alt.badge.img+2

Hi, I am needing to create a segment for those whos orders are currently unfulfilled so that I can send a mass email to let them know the status of their order.

 

Can this be done?

Best answer by Ashley I.

Hello!

Depending on what ecommerce platform you have integrated with Klaviyo, you can create a segment using the Placed Order and Fulfilled Order variables. In this case, you would want to include any customers who made a purchase during the affected time frame, AND exclude users who have already had an order fulfilled during the same time period (note the AND connector instead of OR).

The segment would look something like this:

 

You may choose to add additional conditions to this segment, such as “Person is not suppressed for email” and more as you see fit for your use case. 

 

Hope this helps!

 

- Ashley Ismailovski

2 replies

Akers Digital
Partner - Silver
Forum|alt.badge.img+21
  • Partner - Silver
  • 139 replies
  • December 27, 2022

Which eComm platform are you using? And what type of email message are you trying to send?

 

If its Shopify, it might be easier to just pull this data right from that platform. Sort all unfulfilled orders, you could export the data and import it into Klaviyo. 


Ashley I.
Partner - Platinum
Forum|alt.badge.img+42
  • 2025 Champion
  • 246 replies
  • Answer
  • December 27, 2022

Hello!

Depending on what ecommerce platform you have integrated with Klaviyo, you can create a segment using the Placed Order and Fulfilled Order variables. In this case, you would want to include any customers who made a purchase during the affected time frame, AND exclude users who have already had an order fulfilled during the same time period (note the AND connector instead of OR).

The segment would look something like this:

 

You may choose to add additional conditions to this segment, such as “Person is not suppressed for email” and more as you see fit for your use case. 

 

Hope this helps!

 

- Ashley Ismailovski