Best answer

Connect specific Stripe product sales via Zapier


Userlevel 2
Badge

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

icon

Best answer by Troy Tessalone 7 June 2023, 17: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.

10 replies

Userlevel 7
Badge +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.  

Userlevel 2
Badge

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.

Userlevel 7
Badge +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.

Userlevel 2
Badge

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.

Userlevel 7
Badge +6

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! 😊

Userlevel 7
Badge +14

@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

Userlevel 2
Badge

@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...

Userlevel 7
Badge +9

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

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

Userlevel 7
Badge +14

@dawnmeditation 

Zaps with 3+ steps require a Zapier paid plan.