Skip to main content
Best answer

Parsing WooCommerce Email with Multiple Items


Using Parser by Zapier i am hoping to strip the items from a woocommerce order so that i can send those items to a row within excel.

 

How/What is the best way to parce out the order items and have it so that they layout in a readable format?

Best answer by christina.dBest answer by christina.d

Hi Friends! I wanted to drop in and summarize some of the suggestions here:
 

Satya09 wrote:

Looking at the Microsoft Excel App Action Step inside Zapier it seems creating a new row doesn’t support Line-Items scenario where you get the entire Order Details from WooCommerce.

Alternatively,you can try using Google Sheets and map the fields into the columns of your spreadsheet there.

Parsing is completely a different kind of scenario and I would suggest try the above method and see if it works for you.
 

 

Troy also brought up a good point in that there are more robust tools which can handle parsing email templates with line items such as Mailparser! 

I hope this helps! Keep us posted how this works for you, Lee!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Satya09
Forum|alt.badge.img+7
  • Beginner
  • 143 replies
  • June 9, 2022

Hello @LeeU-Salesforce 

Looking at the Microsoft Excel App Action Step inside Zapier it seems creating a new row doesn’t support Line-Items scenario where you get the entire Order Details from WooCommerce.

Alternatively,you can try using Google Sheets and map the fields into the columns of your spreadsheet there.

Parsing is completely a different kind of scenario and I would suggest try the above method and see if it works for you.
 

 


Troy Tessalone
Forum|alt.badge.img+14

Hi @LeeU-Salesforce 

Good question.

To handle a variable email template that has line items, you’ll likely need to use a more robust email parsing app such as Mailparser: https://zapier.com/apps/mailparser/integrations


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • June 14, 2022

Hey there, @LeeU-Salesforce!

I wanted to pop in and see if you were able to get this sorted with the tips from Satya and Troy? Keep us posted! 🤗


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • Answer
  • June 17, 2022

Hi Friends! I wanted to drop in and summarize some of the suggestions here:
 

Satya09 wrote:

Looking at the Microsoft Excel App Action Step inside Zapier it seems creating a new row doesn’t support Line-Items scenario where you get the entire Order Details from WooCommerce.

Alternatively,you can try using Google Sheets and map the fields into the columns of your spreadsheet there.

Parsing is completely a different kind of scenario and I would suggest try the above method and see if it works for you.
 

 

Troy also brought up a good point in that there are more robust tools which can handle parsing email templates with line items such as Mailparser! 

I hope this helps! Keep us posted how this works for you, Lee!


christina.d wrote:

Hey there, @LeeU-Salesforce!

I wanted to pop in and see if you were able to get this sorted with the tips from Satya and Troy? Keep us posted! 🤗

I’m still trying to work out a system where it will work for all parties involved.