Skip to main content
Best answer

Connect specific Stripe product sales via Zapier


Scottbro
Forum|alt.badge.img

Hi there,

I’m researching a lot on a very simple thing, yet I can’t find any thread about it:

How can I filter purchases through product names?

Let’s assume I have 4 different “Trials” and they all cost the same, yet it’s a different workflow.
All of the Trials are separate products in Stripe.

I would need specific Zaps for each Trial, yet I cannot separate them when starting the workflow with “New Payment in Stripe”.

Any working solutions?

Best regards,

Alex

Best answer by Troy Tessalone

@Scottbro

The Stripe API may have to be used to lookup the Stripe Product (e.g. prod_XXX) from the Stripe Price (e.g. price_XXX) or other internal Stripe object ID: https://stripe.com/docs/api/prices/retrieve

 

If you need help consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Scottbro 

Good question.

Some options to configure Zaps.

  1. Filters
    1. https://zapier.com/apps/filter/help
  2. Paths
    1. https://help.zapier.com/hc/en-us/articles/8496288555917
    2. requires Zapier Pro+ plan
  3. Lookup Table
    1.  


Scottbro
Forum|alt.badge.img
  • Author
  • Beginner
  • 12 replies
  • June 6, 2023

With Paths I think it’s not possible, because there is no way to distinguish the products. 
Somehow the purchases have to be categorized before. As far as I can see it, it’s only possible to distinguish unique purchases (but I might be wrong.) I might try the lookup table.


Troy Tessalone
Forum|alt.badge.img+14

@Scottbro 

Try adding one of these Zap actions as Step 2 to see if those return more details about the payment that include the product name.


Scottbro
Forum|alt.badge.img
  • Author
  • Beginner
  • 12 replies
  • June 7, 2023

Unfortunately there is no information on neither product name, nor product ID or similar. Only the transaction amount. There might be more I need to mention for clarification:

  • Clients pay per Payment Link
  • Some of them purchase through ApplePay

I’m not sure if that is a reason for a lack for details on product purchases.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6360 replies
  • June 7, 2023

Hi @Scottbro,

I’m jumping in to see if I can help!

Maybe you could try using a Webhook workaround to fetch information you’re trying to look for. Here’s how:

  1. Use Stripe webhooks to trigger a (silent) Catch Hook in Webhooks by Zapier
  2. Link: https://dashboard.stripe.com/webhooks/create
  3. More info here: https://stripe.com/docs/webhooks#webhooks-summary
  4. Events can be found here: https://stripe.com/docs/api/events/types

Hopefully, this helps! 😊


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30902 replies
  • Answer
  • June 7, 2023

@Scottbro

The Stripe API may have to be used to lookup the Stripe Product (e.g. prod_XXX) from the Stripe Price (e.g. price_XXX) or other internal Stripe object ID: https://stripe.com/docs/api/prices/retrieve

 

If you need help consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace


Scottbro
Forum|alt.badge.img
  • Author
  • Beginner
  • 12 replies
  • June 21, 2023

@Troy Tessalone 

Your idea with the custom API worked. I actually needed two to fetch the Info I needed. Not through products, but through payment links with custom metadata.

Lucky this even worked. It seems like Stripe is trying their best to make it as hard as possible...


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • June 23, 2023

Amazing, thanks for letting us know what solution you went with! Glad to hear you were able to get this working. 🤗


dawnmeditation

Does the solution require a premium account? Could you share a detailed implementation of the solution please? Thanks in advance. 


Troy Tessalone
Forum|alt.badge.img+14

@dawnmeditation 

Zaps with 3+ steps require a Zapier paid plan.