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.

Hello,

 

I am trying to copy sales invoices across from Shopify to Xero. I have nearly got it to work, the only part I am struggling to transfer to Xero is the shipping cost. There is ‘shipping line’ fields on Zapier, but I cannot get this to display as a separate line on the Xero invoice. 

 

I’ve attached screenshots of the zapier screen and how the invoice is displaying on Xero. Can anyone help with this?

 

Thanks, Ben

Hi @ben.ewart 

In the Xero step if this is a line items section, then the data passed to these fields would be to be formatted as an array of items when there are multiple items.

Help article to reference about using line items in Zaps: https://zapier.com/help/create/basics/use-line-items-in-zaps

 

Hi Troy, thank you for your fast reply. So for line items to work it has to be a ‘line item’ attribute? 

 

From the image above ‘Shipping Lines Title’ is not a line item attribute, but ‘Line Items Name’ is?

 

Thanks, Ben

@ben.ewart

The Item Code expects a value in the dropdown list.

Help article to reference: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 

For Unit Price, you have 2 values mapped.

e.g. that would create a value of 3.991.91 which is not a valid value.

You would need to use a different variable that is the desired SUM or use another Zap step to SUM those numbers.

 

Same for Description.

The 2 mapped variables will create a concatenated value.

 

Thanks for your help with this, I have added another step to add shipping to the existing sales invoice. I’m puzzled on ‘invoice type must be specified’ error, I cannot see a box to input the invoice type 

 

These are the action boxes 

 

Thank you for your help. 

@ben.ewart 

Check the Invoice field.

The Invoice field may expect the internal Invoice ID, which may be different than the Invoice Number.

 

Thank you very much, just got it to work! It required the internal invoice number like you sad, appreciate your help and patience. 

That’s an amazing news @ben.ewart! A huge thanks to Troy for pointing you in the right direction!

Happy Zapping! ⚡️

Terms & Conditions