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.

Best answer

How do I automate Shopify 'Create Order' from ClickFunnels and manage cancellations or refunds using Zapier?

Z

Hello!

 

I hope you can help me... Thank you very much!

 

I am creating a funnel in ClickFunnels and have already connected it to my Shopify store using ZAPIER.
In the funnel, I will be selling 2 products with variants (5 different sizes).

 

QUESTIONS:

1. "CREATE ORDER" (shopify): Is all the information automatically pulled from ClickFunnels, or do I need to enter certain information manually?

2. If I want to add other options such as a cancellation or a refund, do I need to create another ZAP (trigger + action)?

 

Thank you very much!

Best answer by SamBBest answer by SamB

Sorry for the delay in my reply here @zaragoza.susana! I’m happy to help offer some further assistance here. 

 

1. The product I am selling has variations in terms of sizes, and I want to know if I need to list each size in a separate column in a Google Sheet.

Looking at that loom video it seems like it was giving an example of how to use it to search for a product not a product variant. To use a Google Sheets Lookup Spreadsheet Row action to search for a product you want to have a each different product variation (product size) in a different row rather than have multiple columns for each size variation.

That said, the Shopify app on Zapier has Find Product Variant by Title and Find Product Variant by SKU search actions available so it might be better to use one of those to look up the relevant product details that you want to have added to the order.
 

3. Should I include the SKU provided by the supplier both within the funnel and also in the Shopify section in Zapier?

That depends, does the SKU provided by the supplier match up with what’s used in Shopify? If not you might need to create a lookup table to convert the supplier’s SKU into the corresponding Shopify SKUs. You could use a Google Sheet like the one shown in that loom video to create a lookup table by having a column in the spreadsheet for the supplier’s SKU and the corresponding Shopify SKU.

Otherwise if you’re able to get the name of the product variant from ClickFunnels then you could just use a Find Product Variant by Title (Shopify) action to find the product variant’s details along with it’s SKU to add to the order details if desired.

Hope that helps. If you get stuck on that at all or need me to clarify anything further do let us know! 🙂

View original
Did this topic help you find an answer to your question?

8 replies

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6608 replies
  • August 2, 2024

Hi @zaragoza.susana,

I just came across your post here and wanted to check in here to see how you’re getting on. Are you still running into the same issue here?

Please do let us know if you’re still in need of some help on this at all - happy to assist further! 🤗

 

Z

Hello Ken,

Thank you very much for your message.

 

A person from the ClickFunnels Facebook community wrote to me and explained through a video how I can integrate Shopify with ClickFunnels using Google Sheets →  LOOM VIDEO (4 min).

 

However, I still have the following questions and didn't receive a response.

I hope you can help me.

 

QUESTIONS:

1. The product I am selling has variations in terms of sizes, and I want to know if I need to list each size in a separate column in a Google Sheet.


2. I am going to sell 2 products in a single funnel, so do I need to create two Zaps?


3. Should I include the SKU provided by the supplier both within the funnel and also in the Shopify section in Zapier?

 

Thank you very much Ken, and I hope that with your help, I can finally integrate my Shopify store with ClickFunnels.

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6608 replies
  • August 6, 2024

Hi @zaragoza.susana,

Thanks for the update here.

I’m sorry if I can’t give any opinion regarding your workflow since I haven’t had much experience with Shopify orders. However, I can answer your 2nd question. If you are going to sell 2 products you will need to create 2 Zaps for each products.

Hopefully, this helps.

Z

Thank you very much Ken for the information you provide me.


Of course it works for me!


Have a great day...

SamB
1 person likes this
  • SamB
    SamB
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7967 replies
  • August 7, 2024

So glad to see Ken was able to help out here, @zaragoza.susana! 🙂

Sounds like you might be all set for the moment but if you run into any issues or have any further questions at all please do let us know. 

In the meantime, happy Zapping! ⚡

Z

Hi Sam!
 

Ken responded to one of my questions, but there are still two that went unanswered. 

If someone could help me with those, that would be great.

 

Thank you so much!

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7967 replies
  • Answer
  • August 21, 2024

Sorry for the delay in my reply here @zaragoza.susana! I’m happy to help offer some further assistance here. 

 

1. The product I am selling has variations in terms of sizes, and I want to know if I need to list each size in a separate column in a Google Sheet.

Looking at that loom video it seems like it was giving an example of how to use it to search for a product not a product variant. To use a Google Sheets Lookup Spreadsheet Row action to search for a product you want to have a each different product variation (product size) in a different row rather than have multiple columns for each size variation.

That said, the Shopify app on Zapier has Find Product Variant by Title and Find Product Variant by SKU search actions available so it might be better to use one of those to look up the relevant product details that you want to have added to the order.
 

3. Should I include the SKU provided by the supplier both within the funnel and also in the Shopify section in Zapier?

That depends, does the SKU provided by the supplier match up with what’s used in Shopify? If not you might need to create a lookup table to convert the supplier’s SKU into the corresponding Shopify SKUs. You could use a Google Sheet like the one shown in that loom video to create a lookup table by having a column in the spreadsheet for the supplier’s SKU and the corresponding Shopify SKU.

Otherwise if you’re able to get the name of the product variant from ClickFunnels then you could just use a Find Product Variant by Title (Shopify) action to find the product variant’s details along with it’s SKU to add to the order details if desired.

Hope that helps. If you get stuck on that at all or need me to clarify anything further do let us know! 🙂

Z

Hi Sam!

What a great surprise to hear from you, and your guidance was so clear and professional!

Now I fully understand how to do it. THANK YOU SO MUCH!

I’m new to this community and I’m not sure if you work for Zapier or if you’re a consultant offering Zap creation services.

Thanks for clarifying this last question for me.

Many thanks!!

Reply


Terms & Conditions