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.

In Xero I need my Sales and Cost of Goods sold captured in different GL accounts based on product line items and customer location from my Shopify sales. 

How do I used Shopify customer location (country)/ shipping address with product line item to allocate to relevant GL account? Below target Xero GL accounts are what I am trying to achieve:

GL Sales acc1: Product A (US Sales)

GL Sales acc2: Product B (US Sales)

GL Sales acc3: Product A (EU Sales)

GL COGS acc1: Product A (US Sales)

GL COGS acc2: Product B (US Sales)

GL COGS acc3: Product A (US Sales)

Appreciate your help!

Thanks!

Hi there @GlamGoat,

Welcome to the Community! 🎉

Here is how I see the Zap for the workflow that you have in mind:

  1. Trigger: Shopify (New Order)
  2. Action: Shopify (Find Customer)
  3. Action: Filter by Zapier - This will check the customer's location (country) and continue the Zap only if the location matches the desired regions (US or EU).
  4. Action: Xero (Create Sales Invoice)

Also, I wanted to share some helpful resources with you in case you're new to using Zapier. These links will give you a good starting point:

  • Zapier Quick Start Guide: This guide covers the basics and will help you get up and running quickly. You can find it here.

  • Zapier University 101: If you're looking for more in-depth tutorials and information, Zapier University is a great resource. Check it out here.

  • Creating Zaps: This page will guide you through the basics of creating Zaps, which are the automated workflows in Zapier. You can find it here.

Also, my colleague Danvers wrote an amazing article on working through whether and how Zapier can help. You can read it here.

Hopefully, this points you to the right direction! 😊

Terms & Conditions