About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

"Only continue if" troubleshooting

E
Userlevel 1
Badge

Hey all, having some trouble with the “Only continue if” function in one of my Zaps. Here’s the breakdown.

 

I own a running store with hundreds of different products, but am looking to upload only shoe orders from Shopify to Google sheets. I currently have a “only continue if” filter that imports when orders contain shoe sizes. 

The issue is that if an order contains a shoe, it successfully imports, but also adds all additional items (for example a T-shirt) because it’s within the same order as the shoes. Im hoping someone can explain a way to only import the shoes lineitems, rather than all the lineitems within an order than contains shoes.

 

Might need to provide more information than this to get a solution, but hoping this can get the thread started.

 

Appreciate the support as always,

 

Eric.

icon

Best answer by Danvers 11 January 2023, 13:29

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

18 replies

Danvers
Userlevel 7
Badge +12

Hi @Eric Caldwell!

It sounds like you’re off to a good start with the filter step, let’s see if we can help you with the rest of your Zap. There are a few more things that we need to know to start working on this with you:

  • What’s the trigger for the Zap (app and event)?
  • Please could you share an example of the sample data for the trigger, specifically what the products look like. 
  • You mentioned that you want to add it to a Google Sheet, can you confirm exactly how you want that to look? eg each shoe order is added as a new row in the sheet

 

Thanks!

 

E
Userlevel 1
Badge

Hi @Danvers, thanks for the reply.

  1. The trigger for the Zap is a new Shopify order.
  2. Each shoe ordered is meant to be added as a new row, which I currently have set up correctly.
  3. Here is the filtered data from a test trigger:

id

17114

row

17114

COL$A

#100132976

COL$B

Leah Steinberg

COL$C

COL$D

COL$E

December 10, 2022

COL$F

$209.99

COL$G

Saucony Triumph 20 women's - 9 / Night Lite

COL$H

1

rows

1

id

17114

row

17114

COL$A

#100132976

COL$B

Leah Steinberg

COL$C

COL$D

COL$E

December 10, 2022

COL$F

$209.99

COL$G

Saucony Triumph 20 women's - 9 / Night Lite

COL$H

1

2

id

17115

row

17115

COL$A

#100132976

COL$B

Leah Steinberg

COL$C

COL$D

COL$E

December 10, 2022

COL$F

$209.99

 

Hope this is sufficient. Let me know if you need anything else - thanks so much for the help.

COL$G

Saucony Triumph 20 women's - 9 / Black | White

COL$H

1

rowCount

2

Troy Tessalone
Userlevel 7
Badge +14

Hi @Eric Caldwell 

Good question.

Try using the Looping app followed by a Filter step to handle each Shopify Order Line Item separately.

https://zapier.com/apps/looping/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
Userlevel 7
Badge +12

Hi @Eric Caldwell, thanks for sharing that extra context :) 

To expand on Troy’s suggestion, you can use Looping to run through each line item in the order and add an extra filter as part of that so only the shoes get added to the sheet. 

So the Zap would look a bit like this:

  1. Shopify trigger
  2. Filter - only continue if the order contains the shoe
  3. Looping
    1. Filter - only continue if the line item item is the shoe
    2. Google Sheets - add row to spreadsheet

Looping can be a bit tricky to get your head round at first, so I’d recommend checking out the help guide that Troy suggested and of course if you have any questions you can ask them here!

 

E
Userlevel 1
Badge

Thanks @Danvers. Unfortunately im stuck on the filter section after Looping.

 

Here is a screenshot of my looping step (2 loops for the line item and they seem to be successfully separated. 1 shoe, 1 non shoe)

 

Then I get stuck. For some reason the only 2 line item options contain just the non shoe item, or both items together. Feel like I must have missed a step somewhere. Hoping you can help.

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Eric Caldwell

Looping help article: https://zapier.com/apps/looping/help

  • When you test this action, the Zap will only create the first loop. It will not create any other loops during the test.
  • Don’t use the preview_loop_values field from the loop test in your Zap. It is for preview purposes only and doesn’t appear in actual Zap runs.

 

Try turning the Zap ON and testing.

Then check your Zap Runs history details to see the DATA IN/OUT for each Zap step: https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E
Userlevel 1
Badge

Thank you for the response. However, when I send a test to my spread sheet both line items seem to appear. Still unsure as to how I can only import shoe orders into the sheet.

 

Hoping I can provide some additional info for you to help find an answer.

 

Thanks as always,

 

Eric.

Troy Tessalone
Userlevel 7
Badge +14

@Eric Caldwell

Please provide a screenshot that shows the order/outline of your Zap steps.

Make sure the Filter step comes after the Looping step so it applies to each line item output from the Looping step.

Do this to help you troubleshoot and provide us with screenshots.

Then check your Zap Runs history details to see the DATA IN/OUT for each Zap step: https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E
Userlevel 1
Badge

So essentially it goes:

Only continue if it has email/name

Loop line items

Only continue if line item “meets specific shoe criteria”

And here’s a good example of the zap history that I need to work…

So we have the two line items, Asics GT-2000 and Superfeet run comfort. Both items were put into the sheet, but with my filters i thought only the shoes ( Asics GT-2000), my criteria for filtering shoes is if text contains numbers 5-15, so the Superfeeet run comfort should have been filtered out. I’ve clearly set it up wrong. Hope this is enough info!

Troy Tessalone
Userlevel 7
Badge +14

@Eric Caldwell

We’d need to see screenshots with how the Zap Step 4 Filter processed in the Zap Runs (DATA IN/OUT).

 

Also, please provide screenshots with how your Zap Step 5 (GSheet) is configured.

Make sure the values are mapped from the Looping step.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E
Userlevel 1
Badge

I haven’t received an order since the last edit so I cannot send an updated Zap history screenshot right now. 

 

But here are the steps configured in google sheets - this step definitely seems incorrect.

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Eric Caldwell 

FYI: You should also pass these values thru the Looping step, then map from the Looping step, since those are arrays as well.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E
Userlevel 1
Badge

Great. So I have done that, now when I test the action it comes out as one line item, but it’s the wrong one. Could that just because its sample data?

Troy Tessalone
Userlevel 7
Badge +14

@Eric Caldwell 

Yes, configuring and testing the Zap will use the first line item data output from the Looping step.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
E
Userlevel 1
Badge

Perfect. Ill wait for an order to come in and see if it works. Appreciate you being so patient with me!

Danvers
Userlevel 7
Badge +12

It sounds like you have everything set up now, @Eric Caldwell, 🤞🏻 it all works smoothly when you get an order. Let us know how you get on!

E
Userlevel 1
Badge

Looks like it’s working! Thanks for the help and patience @Danvers @Troy Tessalone.

Eric.

SamB
Rank
Userlevel 7
Badge +11

Thanks for letting us know @Eric Caldwell! I’m so glad Danvers and Troy were able to help get your Zap up and running here! 😁🎉

Terms & Conditions