Question

Email WooCommerce order based on zip code

  • 4 March 2022
  • 5 replies
  • 104 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

Userlevel 7
Badge +14

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.

Thanks, I’ll give that a try!

Userlevel 4
Badge +6

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

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?

Userlevel 7
Badge +14

@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