Improving data integration between Shopify and Salesforce with empty fields
I am trying to do an Integration between New Orders in Shopify to Salesforce but there are a few annoying issues with the data received from Shopify like the Line items , qty, price etc are in comma separated lists so I have to format them before I map them to Salesforce - this then causes an issue when a field like Tags or discounts is sometimes empty so the step fails or else I have to create two long almost identical paths.
Likewise when a field in Shopify is in Tags and the field in Salesforce is a Yes/No
Any suggestions ? I am trying to use Sub Zaps to improve the flow
Page 1 / 1
Hi @BLife
Shopify order line item data is returned as an array of items, which can look like a comma separated list, but in reality is not.
For us to have more info, explain more about what you are trying to do with the Zap step logic and include screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible in the CONFIGURE tab.
Hi
For example - I am trying to take New Orders from Shopify and sync them across to Salesforce as Opportunities with Line Items and associated to an account so I need to lookup or create accounts in Salesforce first based on the email or phone number from Shopify. If I try to look up by email and there is no email in the Shopify Order Zapier errors and I cannot move on to search by phone number instead the Zap errors
@BLife
Your screenshots shows you have mapped variables from Shopify for “Email” and “Customer Phone”, both of which have values for the example record selected in Zap step 1.
Instead of “Email” you may want to try using this variable instead: Customer Email
Hi @BLife,
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Hi
Even if I use Customer Email - it is sometimes blank coming from Shopify that is the issue
Hi @BLife,
It sounds like you're running into an issue where Shopify's "Customer email" field is sometimes blank in your Zap. Start by checking if the email is in the Shopify order data—if it's missing there, it won't appear in Zapier either. Make sure your trigger is pulling the correct event and that it's adequately mapped. Test with different sample data to see if the issue is consistent or only happens with specific orders. You can also add a filter to skip steps when the email is missing. If the problem continues, contact Shopify or Zapier Support for help.
If you have any further questions or need additional guidance, feel free to ask. We're here to help.
Hi JammesS
Yes it is missing in Shopify but I still need to process the New Order that is the issue I am having, I know it might be Blank but if it is not I need to use it
Hi @BLife,
Thanks for reaching out about the issue with processing Shopify orders through Zapier. Suppose some orders have missing data but still need processing. In that case, you can use conditional logic (like Filters or Paths) to handle them differently, set default values with Formatter, and add error-handling steps to notify your team. It also helps to validate required fields at checkout, set up a manual review process for incomplete orders, and ensure your team is trained to manage these cases. These steps can help you keep things running smoothly despite occasional missing information.
Feel free to reach out if you have any questions or need further assistance.