Essentially i have a zapier to find an order in Shopify and then send that order and other information to salesforce, and it works perfectly when they only order one product. However, if they order two or more products the zapier breaks at a step of me sending the SKU of the item in Shopify to match the product in Salesforce as it sends every value instead of each value of the SKU seperated.
Answer
Zapier SKU Mapping Fails for Multi-Item Orders in Shopify to Salesforce Integration
- Beginner
Best answer by Troy Tessalone
The Quantity fields expects a number.
You need to add the variable to the Loop, then map the variable from the Loop.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- Beginner
Hi
But when on the next step when I am looking for the product in Salesforce im searching by those looped values but it still groups them all as one value. Maybe im not doing looping correctly?
+14- Zapier Orchestrator & Solution Partner
The mapped value is not a single SKU as you can still see the commas separating multiple SKUs.
This shows a “Test” variable name for the Looping step, but the above variable name is “SKU” from the Looping step, so something is not right.
Can you post updated screenshots for the Looping step? (how it’s configured and after testing the step)
- Beginner
But now im running into the issue of the quantity values not coming over correctly. And its doing the same things as the non looped SKU was by passing all the values as once, so the order had two products of quantities of 1 each but it passed that value as two 1’s connected for 11 and the quantity on Salesforce is 11 instead of once each, but i can only use looping once in the flow so how would i fix that?
+14- Zapier Orchestrator & Solution Partner
We would need to see updated screenshots with how each of your Zap steps are configured.
- Beginner
- New order in shopify created.
- Search for existing contact in salesforce, if none is found created one.
- Find the price book in salesforce by searching for Currency ISO code.
- Create order in Salesforce, connect it to the contact found in step 2.
- Updating the order created in step 4 with the price book id in step 3.
- I loop the product SKU numbers from the order place in step 1.
- I find the products in Salesforce searching by the looped SKU numbers from step 6.
- I find the price book entry associated with the product found in step 7.
- I create the order products in the order on Salesforce using the ID's found in steps 7,4,8. I also grab the quantity here from the order in step 1 and here is where its not working as the quantity comes over as all the numbers grouped.
- I create the order products in the order on Salesforce using the ID's found in steps 7,4,8. I also grab the quantity here from the order in step 1 and here is where its not working as the quantity comes over as all the numbers grouped.
- I find the price book entry associated with the product found in step 7.
- I find the products in Salesforce searching by the looped SKU numbers from step 6.
- I loop the product SKU numbers from the order place in step 1.
+14- Zapier Orchestrator & Solution Partner
- Answer
The Quantity fields expects a number.
You need to add the variable to the Loop, then map the variable from the Loop.
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
- Beginner
+6- Zapier Staff
That’s an amazing news
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
How do you do the same thing for Shopify SKU into Xero - it needs to be place against the item code.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.