Skip to main content
Best answer

How to Find new Salesforce opportunity using the same reference ID from FastSpring


Hi
We use FastSpring for our subscription business. Each time there’s a new subscription a FastSpring account ID is created.

I’m using the FastSpring ID to reference/find/trigger the workflows. Each time there’s a new subscription the FastSpring ID creates an opportunity in Salesforce and populates a custom field in Salesforce with the FastSpring ID.

 

When there’s a renewal, I use that same FastSpring ID to find the original Salesforce Opportunity to create the renewal opportunity.

 

The issue I’m having is when a customer upgrades their subscription a new Salesforce Opportunity is created with a new dollar amount. For instance, the original Opportunity was for $5 but then they upgraded and now the new opportunity is for $10. Creating a new Opportunity for a total of two Opportunities. The original for $5 and the upgraded for $10

 

The workflow is set up to find the original Opportunity ($5) and create a renewal from it. This would be fine if the person didn’t upgrade. Since they upgraded from $5 to $10, the renewal Opportunity should be finding the new upgraded Opportunity ($10) and creating the renewal from there.

 

This isn’t happening. How can I add to my current renewal workflow (or create a new one) that finds the upgraded opportunity ($10) and creates the renewal from that?

Thank you 😁

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @OM22 

Good question.

Sounds like the original Salesforce Opportunity should be marked as “Closed” when a new Opportunity is created.

Then you should be able to use a Salesforce Find Record by Query Zap action step to search for the new “Open” Opportunity.

 

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.

3 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31398 replies
  • Answer
  • August 31, 2022

Hi @OM22 

Good question.

Sounds like the original Salesforce Opportunity should be marked as “Closed” when a new Opportunity is created.

Then you should be able to use a Salesforce Find Record by Query Zap action step to search for the new “Open” Opportunity.

 


  • Author
  • New
  • 1 reply
  • September 1, 2022

@Troy Tessalone Thanks a bunch, I’m going to give it a try. Fingers crossed… of course if this is the answer, I’ll be sure to “mark as best answer.”

 

Thank you 😁


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • September 2, 2022

Hey there, @OM22! I wanted to pop in and see if you were able to get this squared away using @Troy Tessalone’s recommendations? 🤗

Keep us posted - we’d love to know!