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’ve been reading about line items and looking for solutions, but I’ve come up empty.

 

I’m trying to create a Zap that sends a notification to Google Chat whenever we receive a new order in BigCommerce.  The New Order trigger supports line items for all the items on the order, and I want to print them in the chat message so I can see quantity, name and price for each item they ordered.  I just can’t seem to find how I can parse those lines and format them into a block of text.  It seems like it should be do-able.

 

Unfortunately Google Chat doesn’t have any cool formatting options for tables that I’m aware of, so I think it just needs to be appended in a string.  But instead of it being appended by data type. (quantities, names, prices), I want to append them by line item

 

Not this:

1,2,1

Product X, Product Y, Product Z

$1.00, $4.00, $3.00

 

I want this,

 

1, Product X, $1.00

2, Product Y, $4.00

3, Product Z, $3.00

Hi @gspence 

Try using Digest by Zapier: https://zapier.com/apps/digest/help

Ok, I got it all figured out.  This always happens after I finally post for help. :grin:

 

Formatter → Utilities → Line-Item to Text

 

Use the Input field to format the text the way you want it.  Here’s what mine looks like.  I surrounded the Quantity in parenthesis, put two spaces before the SKU, and then a space, dash, space after the SKU and before the product name.

({{117691319__products1]quantity}})  {{117691319__products9]sku}} - {{117691319__products9]name}}

For the delimiter, I used i:newline:] so each product gets its own line.

The final output in “text” looks like this.

 

(1) ABC123 - Product X

(1) ABC124 - Product Y

(2) ABC125 - Product Z

 

Hi @gspence 

Try using Digest by Zapier: https://zapier.com/apps/digest/help

Thanks for the reply!

Since digest works with multiple events, and i’m just dealing with one event, would the Line-Item to text solution I posted above not be a bit simpler?  

 

@gspence 

Good job!

Often there are multiple ways to achieve the same results.

If you’re interested play around with Digest to see if it’s an app you can add to your skill set which may come in handy in the future.

The Looping app is also helpful when dealing with Line Items (aka Arrays): https://zapier.com/apps/looping/integrations

Terms & Conditions