Skip to main content
Contributor I
December 27, 2022
Solved

How do I create a segment only for unfulfilled orders?

  • December 27, 2022
  • 2 replies
  • 1211 views

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?

    This topic has been closed for replies.
    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
    Partner - Silver
    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
    Ashley I.Answer
    2025 Champion
    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

    Ashley Ismailovski, Klaviyo Champion & Director of Email Marketing at SmartSites https://www.smartsites.com/