cfisupply Posted April 20, 2008 Share Posted April 20, 2008 Hi, I have a 'relatively simple' question. New York STATE requires that retailers charge sales tax based on where the sale takes place. So if it shipped via UPS to another tax jurisdiction I have to charge their sales tax. the NYS Tax Department offers a search function located at http://www8.nystax.gov/STLR/stlrHome. I didn't know if there was any way to be able to have the NY customers type their address and 5 digit zip code into a search box and run it through the tax departments site and fetch the tax rate / code. Possibly this would be able to change the tax rate that they are being charged to the correct one based on their location. Of course all out of state sales are exempt from NYS Sales Tax. Anyone have any ideas on how to make this work? Quote Link to comment Share on other sites More sharing options...
mickeymouse Posted May 5, 2008 Share Posted May 5, 2008 Try This: New York State Tax By Zip Code Quote I only do what my Rice Krispies tell me to do! Link to comment Share on other sites More sharing options...
cleveland-jay Posted May 28, 2008 Share Posted May 28, 2008 I have the same sales tax problem too, being in Ohio. I've tried to install this contribution, but it appears to be written for something older than the current 2.2RC2a distribution that I'm trying. The admin stuff it puts in is working, but it has one required modification to the file order.php that has me stumped. The install guide says to look for a sniglet of code in the function cart() containing a tep_db_query to set the $tax_address. The current distribution has no such code in cart(). The only thing I see in order.php is a simple if..then..else statement that builds $tax_address as an address array. I thought I might be able to add either $billing_address['entry_postcode'] or $shipping_address['entry_postcode'] as an element to this array, but that completely breaks the checkout process. Obviously, I'm missing something else here, and I'll confess that I'm not familiar enough yet with the architecture to know how all this is called. (hey, I've only been working on this since last Friday.) It might help if I could see the version of order.php that this contribution was intended to modify. Maybe then I could see what changed between it and the current version to know what and where to fix. -- Jay Quote Link to comment Share on other sites More sharing options...
gotham Posted June 6, 2008 Share Posted June 6, 2008 I have the same sales tax problem too, being in Ohio. I've tried to install this contribution, but it appears to be written for something older than the current 2.2RC2a distribution that I'm trying. The admin stuff it puts in is working, but it has one required modification to the file order.php that has me stumped. The install guide says to look for a sniglet of code in the function cart() containing a tep_db_query to set the $tax_address. The current distribution has no such code in cart(). The only thing I see in order.php is a simple if..then..else statement that builds $tax_address as an address array. I thought I might be able to add either $billing_address['entry_postcode'] or $shipping_address['entry_postcode'] as an element to this array, but that completely breaks the checkout process. Obviously, I'm missing something else here, and I'll confess that I'm not familiar enough yet with the architecture to know how all this is called. (hey, I've only been working on this since last Friday.) It might help if I could see the version of order.php that this contribution was intended to modify. Maybe then I could see what changed between it and the current version to know what and where to fix. -- Jay I use the contribution and it works well for me. I did have to do a lot of modification to get it to work. I could give out copies of any files you want but they are heavily modified including MVS and 30+ more. email me if you want copies. Quote Kendall Brooklyn, New York USA Link to comment Share on other sites More sharing options...
gotham Posted June 6, 2008 Share Posted June 6, 2008 I use the contribution and it works well for me. I did have to do a lot of modification to get it to work. I could give out copies of any files you want but they are heavily modified including MVS and 30+ more. email me if you want copies. I would also suggest a much simpler solution. Setup your credit card processor to do just auths rather than sales. This is so you can adjust the final charge slightly. Then setup instate sales to be charged one estimated prevailing rate. Then as each instate sale comes in use the State provided Jurisdictional Online Tool (NYS has one) to retrieve both the Jurisdictional rate and Jurisdictional Reporting Code (you need the reporting code to file the sales tax payment). Compare the rate charged and the correct rate. Using Order Editor add a line to the Totals column of the order saying "Adjustment for Sate Tax " and correct the invoice. Then convert the auth to a sale and correct the final amount to be charged to the customer. This seems like a lot but it really isn't. Here is why: you have to check the State provided Jurisdictional Online Tool anyway (even with this contribution installed) as zip codes do go across tax boundaries. And the contribution does not give you the Jurisdictional Reporting Code which you need on the tax forms (this would be a nice enhancement of the contribution) so you have to look it up. Even with the contribution installed I still end up looking it up! Be aware that the NYS provided Jurisdictional Online Tool does go down from time to time so be prepared (using the tax form) to estimate yourself. Hope this helps! Wouldn't it be great if we only had 1 tax rate per state (or none)! Quote Kendall Brooklyn, New York USA Link to comment Share on other sites More sharing options...
petercascio Posted July 21, 2008 Share Posted July 21, 2008 I have a solution that gives you NY taxes by jurisdiction rather than by ZIP code as that's the way the tax people want it. Send me a private message -- not on the forum -- if you want it. Peter Quote Link to comment Share on other sites More sharing options...
akiva7777 Posted August 29, 2008 Share Posted August 29, 2008 how do I install the ziptax nys 1.1a ? After unzipping it, there is only a SQL file with no instructions. Thank you Quote Link to comment Share on other sites More sharing options...
akiva7777 Posted September 19, 2008 Share Posted September 19, 2008 I get this error after doing the installation. Anyone help? 1146 - Table 'database name.TABLE_ZIPTAX' doesn't exist select zip_tax_rate from TABLE_ZIPTAX where zip_code = '””' [TEP STOP] Quote Link to comment Share on other sites More sharing options...
edukes Posted August 9, 2009 Share Posted August 9, 2009 The code in /includes/classes/order.php has changed in RC2A. Anyone have a fix for this file? TIA Quote Link to comment Share on other sites More sharing options...
gwynwyffar Posted December 21, 2009 Share Posted December 21, 2009 I have the same sales tax problem too, being in Ohio. I've tried to install this contribution, but it appears to be written for something older than the current 2.2RC2a distribution that I'm trying. The admin stuff it puts in is working, but it has one required modification to the file order.php that has me stumped. The install guide says to look for a sniglet of code in the function cart() containing a tep_db_query to set the $tax_address. The current distribution has no such code in cart(). The only thing I see in order.php is a simple if..then..else statement that builds $tax_address as an address array. I thought I might be able to add either $billing_address['entry_postcode'] or $shipping_address['entry_postcode'] as an element to this array, but that completely breaks the checkout process. Obviously, I'm missing something else here, and I'll confess that I'm not familiar enough yet with the architecture to know how all this is called. (hey, I've only been working on this since last Friday.) It might help if I could see the version of order.php that this contribution was intended to modify. Maybe then I could see what changed between it and the current version to know what and where to fix. -- Jay I'm having the same issue. There is no such $tax_address query on the classes/order.php file. Any insight into a solution would be helpful. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.