VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: markawol on January 18, 2012, 05:06:32 AM

Title: Tax Rate by Zip Code
Post by: markawol on January 18, 2012, 05:06:32 AM
I'm using VirtueMart 2.0 with Joomla 1.5.23

Is it possible to have a tax rate according to a zip code? My goal is to have a 5% tax to only VA state buyers and none for all others.

Thanks!
Title: Re: Tax Rate by Zip Code
Post by: tech on February 04, 2012, 04:07:38 AM
I too would like to know if this is configurable in the VM 2 settings.
Title: Re: Tax Rate by Zip Code
Post by: PRO on February 04, 2012, 04:14:24 AM
THEN, you set it to the state, NOT the zip code and yes. thats available.
Title: Re: Tax Rate by Zip Code
Post by: tech on February 04, 2012, 22:55:55 PM
Hi Banquet... are there some instructions for setting that up correctly in the backend that you can point me to? I want to setup Tax Rates dependent on the users zip code. I guess it wouldn't be by state...but a larger list by zip code.

I'd also like to know if I can even do tax by City.

Quote from: BanquetTables.pro on February 04, 2012, 04:14:24 AM
THEN, you set it to the state, NOT the zip code and yes. thats available.
Title: Re: Tax Rate by Zip Code
Post by: PRO on February 05, 2012, 14:20:12 PM
have you looked in the calculation settngs? click new and look at the settings
Title: Re: Tax Rate by Zip Code
Post by: tech on February 05, 2012, 20:54:53 PM
Banquet. Yes I did and I will paste my settings here so you can see what I see... I am using VM 2.0. Here is my screen image: http://s17.postimage.org/jwq119vn3/tax.jpg

Quote from: BanquetTables.pro on February 05, 2012, 14:20:12 PM
have you looked in the calculation settngs? click new and look at the settings
Title: Re: Tax Rate by Zip Code
Post by: PRO on February 06, 2012, 17:08:46 PM
oh, ok I forgot California has a crazy sales tax system.

This is not in the core, and more than likely will require a 3rd party plugin.

I know in florida, we have a 6% tax. BUT some counties have an extra 1/2%, 1%, or 1.5%.
Th state lets me just charge a flat 7% for everyone.

Title: Re: Tax Rate by Zip Code
Post by: tech on February 06, 2012, 17:12:43 PM
Banquet. Ok thank you. Just wanted to be sure before I created a plugin for that. Thanks.

Quote from: BanquetTables.pro on February 06, 2012, 17:08:46 PM
oh, ok I forgot California has a crazy sales tax system.

This is not in the core, and more than likely will require a 3rd party plugin.

I know in florida, we have a 6% tax. BUT some counties have an extra 1/2%, 1%, or 1.5%.
Th state lets me just charge a flat 7% for everyone.


Title: Re: Tax Rate by Zip Code
Post by: matthewod01 on February 14, 2012, 06:19:11 AM
I am looking to just manually add this function into the code.  I have the current tax table by county for Florida.  Let me know if anyone has made progress on this yet as a module.  I am willing to put in my $.02 to get this working, since I am in FL and have several clients that could use this too. 

Thanks

MD
Title: Re: Tax Rate by Zip Code
Post by: Bruce Morgan on February 23, 2012, 00:56:40 AM
I guess i am a little disappointed the standard install does not include an example tax calculation.  I created a new tax calulation and called it "Sales Tax" and assigned it to Washington State and then I got stuck there.  I did not specify the max tax rate of 9.5% in the calculation rule because food products are not taxed.  Each of my products has a tax rate assigned to it that was carried over from VM1.1.x and I have two tax rates of 0% and 9.5 % assigned for WA state.  The question is how can I direct this to calculate the correct tax amount base on the rate assigned to the pridcts in the cart at checkout?

Bruce
Title: Re: Tax Rate by Zip Code
Post by: PRO on February 23, 2012, 21:58:18 PM
Quote from: Bruce Morgan on February 23, 2012, 00:56:40 AM
I guess i am a little disappointed the standard install does not include an example tax calculation.  I created a new tax calulation and called it "Sales Tax" and assigned it to Washington State and then I got stuck there.  I did not specify the max tax rate of 9.5% in the calculation rule because food products are not taxed.  Each of my products has a tax rate assigned to it that was carried over from VM1.1.x and I have two tax rates of 0% and 9.5 % assigned for WA state.  The question is how can I direct this to calculate the correct tax amount base on the rate assigned to the pridcts in the cart at checkout?

Bruce

the "sample" is in the sample data, which you didnt install:D

If you set washington to 9.5%
The set a 0% rate. called "food"

YOU can go into EACH food product and set a different rule for it.
OR, do it with csv improved.

Title: Re: Tax Rate by Zip Code
Post by: matthewod01 on March 07, 2012, 17:38:18 PM
I have not found a precise solution yet to the surtax for the state of Florida.  Each county has the ability to charge above the flat rate state sales tax.  I have tried to manually enter the zip into the virtuemart_states table and created the rule for the taxes & calculations.  The tax function, I am guessing, is looking for the state in the shipping/billing address and not the zip code.

I think the problem is I can't seem to find the function that calculates the state sales tax.  I think it would be easier to add an additional function to do a zip code lookup on the states table, then get the rule and function for that zip code from the address. 

If anyone has any suggestions on where the code for the tax lookup then I could maybe play with that. 

My client is meticulous and doesn't like to settle for just charging 7%!

Thanks in advance for any advice or help!
Title: Re: Tax Rate by Zip Code
Post by: eldravo on April 18, 2012, 18:06:58 PM
I need something similar not for tax, but for shipping rate:

Shipping Rate by neighborhood.
Minimum order by neighborhood as well.

On the user registration (Shopper Field) I added an extra field called neighborhood (Colonia in spanish). Here we use this name to refer to a set of 15 to 30 blocks approx. I would like to establish a shipping rate for each neighborhood, as well as a minimum order by neighborhood. If someone can point me in the right direction I would appreciate it.
Title: Re: Tax Rate by Zip Code
Post by: jhoompk on November 27, 2013, 11:49:27 AM
Quote from: matthewod01 on March 07, 2012, 17:38:18 PM
I have not found a precise solution yet to the surtax for the state of Florida.  Each county has the ability to charge above the flat rate state sales tax.  I have tried to manually enter the zip into the virtuemart_states table and created the rule for the taxes & calculations.  The tax function, I am guessing, is looking for the state in the shipping/billing address and not the zip code.

I think the problem is I can't seem to find the function that calculates the state sales tax.  I think it would be easier to add an additional function to do a zip code lookup on the states table, then get the rule and function for that zip code from the address. 

If anyone has any suggestions on where the code for the tax lookup then I could maybe play with that. 

My client is meticulous and doesn't like to settle for just charging 7%!

Thanks in advance for any advice or help!

Any luck ever?
Title: Re: Tax Rate by Zip Code
Post by: PRO on November 29, 2013, 16:09:28 PM
I use avatax for virtuemart
Title: Re: Tax Rate by Zip Code
Post by: GJC Web Design on November 30, 2013, 12:31:56 PM
You can also look here - http://forum.virtuemart.net/index.php?topic=113564.0