Skip to main content
Question

Email WooCommerce order based on zip code

  • March 4, 2022
  • 5 replies
  • 137 views

We have a WooCommerce store with 3 physical locations. We don’t manage stock so don’t need a fancy plugin for that, but wondered if Zapier would be able to help send the order notification to the correct store manager based on where the customer lives.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 4, 2022

Hi @jstammer 

Try adding a Filter step to the Zap: https://zapier.com/apps/filter/help

Or you can maintain a Lookup Table in a GSheet or Airtable Base.


  • Author
  • Beginner
  • March 4, 2022

Thanks, I’ll give that a try!


Satya09
Forum|alt.badge.img+7
  • Beginner
  • March 4, 2022

Hi @jstammer  Just an addition as the locations are just 3 create a path for each location and add a filter to continue that action step when zip code is xyz and send an email to the particular store manager


  • Author
  • Beginner
  • March 5, 2022

I haven’t had a chance to try it yet, but will it be possible to use wildcards in the ZIP codes so I don’t have to list every single possibility?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 5, 2022

@jstammer 

We’d need examples in order to better evaluate and advise.

 

What is your current logic for determine which Store Manager to route the notifications to?

 

You can maintain a Lookup Table in a GSheet or Airtable Base.

Lookup Zip

If found = TRUE, then that would return related info (Store Manager)

If found = FALSE, then you’ll have to decide how to handle