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.

Hello, I am currently using a Zap that outputs data when a Shopify order is placed to a Google Sheet by line item based on the number of products ordered. I had 2 main questions regarding the automation for things I was looking to do.

1. The zap outputs the order number, customer name, date, email address, and state for each order. If the order contains multiple products, the zap will repeat the above mentioned fields for each line item in the order. I was wondering if it would be possible to only have those fields output on the first row and stay blank for the subsequent rows for the rest of the order’s line items. 

 

2. I am using Bold Product Options as some of the products I have offer too many variants beyond the number that Shopify as able to support. As a result, if an order is placed that has the Product Options, it will give each option its own line item as if it were a separate product. Is there a way for the Zap to detect if the order contains such options and then combine both the line item names and the prices into the corresponding product they are associated with? The screenshot below shows how the product and options are formatted in Shopify.

 

Any help with this would be greatly appreciated in advance.

Hi @BPZ

1. Can you share a screenshot of your actual Zap setup?

 

2. Did you try using conditions in the zap to detect if the order has product options? 

@samiabid 
Here is how the zap is currently set up. We have looked into using conditions to detect the bold options but we don’t know enough about orders that contain both products that have product options and regular products.
 

 

Hi @BPZ 

Have you looked at using Formatter by Zapier? Check this article - https://zapier.com/blog/formatter-line-item-automation/?utm_source=Iterable&utm_medium=email&utm_campaign=itbl-gbl-pgv-evr-blog_formatter_line_item_automation_20210804

 

It’s specifically written to deal with eCommerce orders having line items. Let me know if this helps.

Terms & Conditions