Best answer

Parsing WooCommerce Email with Multiple Items

  • 9 June 2022
  • 5 replies
  • 45 views

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?

icon

Best answer by christina.d 17 June 2022, 23:35

View original

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

Userlevel 4
Badge +6

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.
 

 

Userlevel 7
Badge +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

Userlevel 7
Badge +9

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! 🤗

Userlevel 7
Badge +9

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

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!

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.