How to set this up, tax collection for State, County, & City? (Prepared Food Taxes)

[SecretChocolate]

Had a Shopify shop for more than a decade but we're looking at the POS element to replace our Square setup. Taxes are giving me a bit of a headache.

• Our State has a base rate (4.75%).
• Our County has base rate (2.5%).
• Our City (County) has a Food rate for goods that are made by us (eg: Prepared foods. 1%)
• We sell both in house made goods and resold goods.

Shopify captures the state & general county rate just fine but it has no knowledge of the prepared food rate (+1%) that needs to be added. And it only needs to be added to purchases in the county, not outside of it.

Overrides seem to be on a state level, so its too high up. I need to get the 1% on orders within the county on specific products and it needs to be reflected when I sync this up to Xero so that I can properly pay for these things.

Any bakeries, candy shops, or other food retailers bumping against this and find a solution?

[SecretChocolate]

"Putting county taxes, instead of state tax, is really a good function. However, as per checking in our resources and with our Taxes team, it appears that overriding taxes is statewide and the county overriding is yet to be added on our system. What I can do is take this opportunity to submit your inquiry as a feature request to our developers/engineers and have it incorporated in the future update. Actually, upon submitting this request to our developers/engineers for future request, it shows that a lot of our valued merchants are also wanting to have this incorporated to our future Shopify functions." -- Shopify Support

To help those out looking for a similar answer, there is no viable path forward at this time. We really need granular control of taxes otherwise I can't switch. If I can't switch one way then I will probably start to look for a way to switch the other way.

[SecretChocolate]

Been 6 months, wonder if I can bump this for viability and to see if anyone has contrived a solution yet. Still split between two platforms that can't seem to do what businesses need.