Skip to main content
Question

How to configure Zapier to sync Shopify sales to Xero with separate line items

  • May 12, 2025
  • 5 replies
  • 42 views

We currently have Zapier moving sales from shopify to to xero but it merges all the different items and freight into 1 line in xero.

How do I set up the zap so each line is entered on it’s own different line on xero?

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

Sync9-Solutions
Forum|alt.badge.img+1

Hello ​@NutriSoil ,

You may want to use the Looping by Zapier action. Set it up so that it will loop through each line item and send them as separate lines in Xero. You also need to use Formatter by Zapier → Utilities → Line Itemizer. Hope this helps!


  • Author
  • Beginner
  • 2 replies
  • May 13, 2025

I have set up the formatter and looper but I am having trouble with the formatter duplicating all the discdounts to each line

 


Sync9-Solutions
Forum|alt.badge.img+1

Hello ​@NutriSoil ,

How do you want to exactly output the discount values? I noticed that you are using the Split Text in the Transform field. You may try using again the Zapier → Utilities → Line Itemizer.

(Optional) Also if you are working with currencies, you may try using the Formatter by Zapier → Numbers → Format Currency.


  • Author
  • Beginner
  • 2 replies
  • May 13, 2025

I ended up using the line itemizer and got it working, thanks for all your help.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6780 replies
  • May 14, 2025

That’s great news ​@NutriSoil! We’re glad to hear that using the line itemizer action resolved the issue here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗