Skip to main content
Best answer

Shopify line item field includes tax and integration with QBO (quickbooks online)

  • April 7, 2020
  • 2 replies
  • 390 views

Hi Folks, 

 

I have my zap set up and it works. 

 

My problem is the ‘line amount’ field in Zapier requires (suggests) a non-taxable line item amount. Shopify’s integrating exports the following field ‘line items Price’ which includes Tax. and does a tax calculation separately. 

 

Obviously this throws out the Sales Receipt in QBO as it calculates the tax on the ‘line items Price’ and inflates the incorrect price. 

I have tried to do a ‘numbers’ zap to make the line items field ex.vat, but I can’t seem to get that to work either! 

 

Any ideas!? 

J.

Best answer by johngreeneroom

https://zapier.com/shared/ec88151c45c79e2b2daf390bfbae999a9258f6a3

 

Resolved I think for now! 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

  • Author
  • Beginner
  • Answer
  • April 7, 2020

AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • April 8, 2020

That’s great @johngreeneroom  - let us know if you still have issues.