Skip to main content

Exporting Tax Categories from Acumatica to Shopify


KarthikGajendran
Acumatica Moderator
Forum|alt.badge.img+3

By default, in Shopify, there is a boolean flag to mark if the item is taxable or not as shown below screenshot.

This can be updated using the substitution list called SPCTAXCLASSES as shown below. 

All of the above is done by default. Nothing to do from user's perspective. 

For customers who are enrolled in the Shopify Plus plan, they could export the actual Tax Categories from Acumatica to Shopify products as there is a field called Tax Code in Shopify for plus customers. 

Please follow the below entities mapping to do that. 

 

Result: 

Stock Item in Acumatica. 

 

 

Product in Shopify after entities mapping export: 

 

Did this topic help you find an answer to your question?

5 replies

kkeating24
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 89 replies
  • January 10, 2025

@KarthikGajendran - Quick question - how does the boolean flag in Shopify normally get set, it that a setting within shopify or does the ACU Connector influence this somehow out of the box? 

@Yuri Karpenko 


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@kkeating24 , the wiki for 2024R1 says this about export mapping of that field:

In my experience, most merchants will have this line in the export mapping for stock, non-stock, template items:

This allows them to manage taxability in Shopify directly.

If you wanted to manage taxability in Acumatica, I would put a formula in this field mapping. Either relate it to the Tax Category field, or even create an attribute (boolean) to tell Shopify if the item is taxable or not.


kkeating24
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 89 replies
  • January 10, 2025

@Yuri Karpenko - I was reading that and wondering -- so all I have to do is create a Tax Category titled “TAXABLE” and it will check the box?  We typically do this for all our implementations...so i guess I was automagically setting the flag.   And vice-versa if I do “EXEMPT”.


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@kkeating24 , yes, that’s correct. I just tested it for you: Exempt in Acumatica = empty box in Shopify, Taxable in Acumatica = checked box in Shopify.

Happy configuration!


kkeating24
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 89 replies
  • January 10, 2025
Yuri Karpenko wrote:

@kkeating24 , yes, that’s correct. I just tested it for you: Exempt in Acumatica = empty box in Shopify, Taxable in Acumatica = checked box in Shopify.

Happy configuration!

I also tested, with ‘NONTAXABLE’ in the category and that also results in no checked box. 

 

Thanks Yuri 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings