Title correct: How do I add multi-item WooCommerce orders to PDFfiller form?

Try using  Looping by Zapier after the WooCommerce Order Trigger and then add all the formatter and other steps that you successfully tested

Hi @TryAbp 
We can help you fixing this zap out!
We are Zapier Premier Partners https://zapier.com/experts/connex-digital/

@Satya09 

Thanks for reply, as i checked, I didnt find a way to work this with looping, I think, issue is that template i designed doesnt support line items, to rule out any issue in data and formatting i tested same woocommerce order with ZOHO Books invoice.

The data works fine, i want same structure of ‘Items & Description’ to present in PDFfiller file. Do you know is there any way that i can add item line support to pdf document? OR any other workaround to do this job?

Well in that scenario you have to look at other options like airtable to collect data into separate fields.And then from Airtable you can send data to Google Docs.This can be a workaround

Hi @TryAbp!

I think I can help A couple of things:

1. What’s coming from WooCommerce is in line item format (which looks like comma-separate items). Your Formatter step isn’t actually changing anything. 
2. We can use a different Formatter function to get us what we need (a separate field for each line item).

I don’t have access to WooCommerce or PDF Filler so I’m using something different, but the general idea should be the same.

Choose Formatter — Utilities — Line-Item to Text

This will result in something like this as your output, where each of your line items becomes its own field: 

Now you can map those into the individual spots in your action step (I’m using Google Docs — Create Document from Template for this example):

NOTE:

1. This gets trickier if you also need quantity, rate, amount, etc. 
2. You would also have to test with a sample that has more items than you’ll ever have, in order to have the mappable fields (item 1, item 2, item 3, etc shown above).

Hope that helps!

Hi @TryAbp!

I think I can help A couple of things:

1. What’s coming from WooCommerce is in line item format (which looks like comma-separate items). Your Formatter step isn’t actually changing anything. 
2. We can use a different Formatter function to get us what we need (a separate field for each line item).

I don’t have access to WooCommerce or PDF Filler so I’m using something different, but the general idea should be the same.

Choose Formatter — Utilities — Line-Item to Text

This will result in something like this as your output, where each of your line items becomes its own field: 

Now you can map those into the individual spots in your action step (I’m using Google Docs — Create Document from Template for this example):

 

NOTE:

1. This gets trickier if you also need quantity, rate, amount, etc. 
2. You would also have to test with a sample that has more items than you’ll ever have, in order to have the mappable fields (item 1, item 2, item 3, etc shown above).

Hope that helps!

Hi @nicksimard thanks for reply. I will test this an let you know!

@nicksimard thank you very much for your help! This worked fine!

@nicksimard One more question, i got data separated like item price, SKU, quantity, subtotal. But i am again stuck on Item Tags Data. I tried few different things but i failed to separate the item tags data form woocommerce. Below is screenshot.

Then selected data vales from woocommerce.

But the output should have been separate values for each product just like name and other fields. But i am getting below output.

SO, i am again requesting your help in this case.