Hello Guys,
So I was wondering how do I go about this task:
I want Zapier to look into new Shopify orders, lookup an SKU, and match it with a google sheet file, I then want to format certain line Items as well as a Product Description from the Google sheet file from that order and place them in a Google Docs file like this:
ORDER no: lineitem m] Order
Customer Information:
First Name: lineitem m] First Name
Last Name: lineitem m] Last Name
Order Details:
QTY: lineitems m]qty
SKU: Line Items m] sku
Desc: Line Items m] vendor line Items m] Product Title ldescription from Google Sheets]
This is all good if I only have one item being ordered but if I have multiple items then it does not look great, what I wanted is to have something like this:
ORDER no: lineitem i] Order
Customer Information:
First Name: lineitem i] First Name
Last Name: lineitem i] Last Name
Order Details:
QTY: lineitems i]qty
SKU: Line Items I] sku
Desc: Line Items I] vendor line Items I] Product Title Tdescription from Google Sheets]
QTY: lineitems e]qty
SKU: Line Items ] sku
Desc: Line Items ] vendor line Items ] Product Title description from Google Sheets]
QTY: lineitems n]qty
SKU: Line Items e] sku
Desc: Line Items e] vendor line Items e] Product Title tdescription from Google Sheets]
QTY: lineitems i]qty
SKU: Line Items n] sku
Desc: Line Items n] vendor line Items n] Product Title cdescription from Google Sheets]
So based on the number of items in the order it will create grouped QTY SKU AND DESC lines. Is this even possible? I tried using line Itemizer as well as text to line items and it seems to just show them separated with commas and shows it as a single line. Can anyone please help?
