Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have a zap set up for orders to come over from Shopify to Salesforce. 

The step where an order is created specifies the Standard Price Book, which is what I want. 

I have a step after that that uses “Run Javascript in code by Zapier.” This puts the proper sku, quantity, discount on one line. 

The next step is to find a pricebook entry for the above skus. Instead of picking the price book entry from the Standard Price Book, it is picking the first price book entry that comes up after searching by sku. I don’t understand why it is not pulling by what I specified in the “create an order” step. 

One sku could have multiple price book entries in Salesforce. I need to support that. Has anyone run into this and come up with a solution?

Thanks. 

Rachel

Hey there @rachh! Thanks so much for reaching out.

I took a quick peek and it looks like you were able to open a ticket with my friends in support - which is perfect.

It looks like ya’ll are still working through this together but definitely keep us in the loop on the final solution! We’d love to know. 🤗

I have not heard back so I thought I’d post something out here to see if anyone else could help. 

Hey friends! Just coming in here to close the loop as it looks like our support team was able to help get this issue resolved. I am pasting my colleague Virgil’s advice here for anyone following along with a similar issue:

I'm not sure why the "Find Price Book Entry" Action is returning the ones from the wrong Price Book, but the fact that there is another Price Book with the same SKUs is likely relevant to the issue. 

Does this other Price Book have non-standard prices for some/all of those SKUs? 

In either case, I suspect Salesforce is performing the search for the SKU and sending over whichever one is returned first. I'm not sure what constitutes "first" in this case, but all I can say is that the search would return multiple results, ordered by some category, and SF just picks whichever one is at the top of the list and sends it to Zapier.

I did some testing and it looks like we may be able to do this with a "Find Record by Query" Action by creating a query that searches for both the SKU AND the Price Book ID using the ID value of the "Standard Price Book".

Then, replace the "Price Book Entry" mapped in your "Create Record" Step to use the "ID" value from this new "Find Record by Query" Action rather than the one from your original "Find Record" Action.

Terms & Conditions