That's good to hear! How did you manage to get the taxes charging as desired?
Victor | Shopify Social Care
I'm a state and local tax professional specializing in multi-state sales and use tax and found your comment - "Only 12 of which require us to collect State, County and Local. The other 34 States we only need collect the State tax" - to be very interesting. Reason is because I'm only aware of a few states that offer a single rate for remote sellers to charge and exclude them from collecting their local sales tax rates. As an example I do not know of any provision in New York's sales tax rules that allow a remote seller to only collect the state tax and exclude them from collecting their local taxes.
With that said I'd be happy to review your information source to verify its accuracy if you'd like to email it to me at firstname.lastname@example.org.