Tax calculation below a threshold, ot_tax.php

[donplay]

Hi,

I'm trying to apply a tax rate to an order only when the subtotal for the items in that tax class is above a certain amount.

Is www/shop/includes/modules/order_total/ot_tax.php the right place to try to modify the tax calculation logic or am I barking up the wrong tree? It seems to me that function process() in that file communcates that?

Any guidance appreciated.

thanks,
Don

[yellow1912]

Just being curious, is there some kind of tax that applies "only when the subtotal for the items in that tax class is above a certain amount."?

[donplay]

Yes, in the lovely State of New York if you buy clothing or shoes for under $110 there is no state tax charged.

http://www.tax.state.ny.us/pdf/memos/sales/m06_6s.pdf

I'm not just doing this for fun :)

[donplay]

Sorry, thread title should read "Tax calculation above a threshold".

I'm a bit of a newbie to the bowels of zencart and I don't have much PHP or OO programming experience, just some perl and DB programming. Thought I could figure this out on my own but definitely feel a bit over my head and a bit pressed to sort this out.

If anyone can give me some guidance on how to implement a tax threshold above only a certain dollar amount I would greatly appreciate it. I thought perhaps I could modify the ot_tax.php file, but I believe that is incorrect.

Thanks in advance for any help you can give me.

-Don

[Kim]

Is that per item or the total?

[donplay]

Initially I thought the exemption applied to the total of that tax class of items. In actuality there is no tax applied if the cost per item or pair does not exceed $110. Ooops...

Ultimately I was able to sort it out by modifying shop/includes/classes/order.php. Took a while (and some help from a buddy) to figure out that's where the guts are but I think I'm ok.

-Don

[rorschach]

donplay,
I posted a similar post in another, related thread. It sounds like i'm in exactly the same position you're in - i need to correct the tax rates for a store w/ an online component in NYC. so, please correct me if i'm wrong, the new tax rate is applied only to specific items over 110 in the order, not the whole order itself. so, a pair of shoes in a 2 item order that cost 75 dollars will not be taxed but a shirt that's 120 dollars will be taxed at a rate 4.375%.. this is what i gathered reading the nystax.gov info.. i guess i'm going to look into the php code now and see how to make the change .. any additional info you have on how to facilitate this change will be appreciated !

[donplay]

rorschach,

Actually on September 1st NYC rules have changed. For clothing and shoes, there is no tax period, whether the per item/pair cost is 110 or not.

But to complicate matters, that threshold still applies to NY State. That's further outlined in the link I posted previously. To accomodate this I modified order.php. Within the for loop that goes through each line item, I created a running sum of tax for items in that "clothing and shoes" category (for which I created a tax class). After the for loop ended I subtracted that total from the total tax.

I have to run out and don't have time to post the code right now; but I can try to give you a snippet later if you're interested.

By the way; I further had to modify the code to accomodate the NYC no threshold for that tax class...I can give you more detail on that as well if you want.

-Don

[rorschach]

Don,

Hmm.. there's a lot of confusion about the NYS/NYC tax topic - at least in my mind. I think you may be wrong about there being no tax period regardless of cost.. Since i'm a pretty good programmer (but a rather poor accountant) I did some research and found this:

http://www.tax.state.ny.us/pdf/publi...ub718c_807.pdf

Take a look at part 2, in particular this footnote to the NYC jurisdiction:

Effective September 1, 2007, sales in New York City of clothing and footwear, and items used to make or repair clothing, costing $110 or more per item or pair, are also exempt from the 4% New York City local tax. These sales remain subject to the New York State 4% sales and use tax and the ⅜% sales and use tax imposed by the state in the Metropolitan Commuter Transportation District.

The way I am reading this is that clothing and footwear that costs more than 110 dollars still has the 4.375% (combined) NYS and MCTD sales and use taxes. Conversely items under 110 are no subject to the state taxes. I might just call the 800 number they list and talk to someone there and get final confirmation that I am interpreting this correctly..

Anyway, thanks so much for your reply - i started poking around order.php and am getting familiarized with the system. I appreciate the offer of code snippets - i may take you up on your offer if I feel like i'm not getting anywhere but right now i'm kinda eager for the challenge. i'll happily share my code, too, once i write it after I get the final confirmation on what the business logic should be!

[donplay]

Hi rorschach,

Definitely confusing.

I think we're pretty close to being on the same page here with the tax rules. These are the rules as I understand it.

In NYC, I agree you are still charged NYS tax if it is in the clothing/apparel/shoes tax class, and the per-item (or pair) cost is $110. That's pretty clearly outlined in the links both of us posted from the NYS tax folks.

However as of 9/1/07 in NYC taxes are never charged on this class (clothing/apparel/shoes) anymore, regardless of the total. Check out the city website in the Tax Rates section:

http://home2.nyc.gov/html/dof/html/b...ys_sales.shtml

There is no City sales tax imposed on the purchase of clothing and footwear regardless of the amount. The New York State tax rate of 4.375% (including the Metropolitan Commuter Transportation District rate) was repealed effective April 1, 2006, and the New York City tax rate of 4% was eliminated effective September 1, 2005 for items under $110. For items over $110 the tax was eliminated effective September 1, 2007. More information on the clothing and footwear sales tax exemption is available from the State Web site.

We handled this by installing the Local Sales Tax mod authored by LadyHLG that goes by zip, along with custom coding in that mod and the order.php class.

Good luck.

-Don