Ohio Sales Tax

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Ohio Sales Tax

Post by jmestep » Mon Jun 02, 2008 9:56 am

I'm working on putting the Ohio sales tax rates into a store- Ohio goes by county or zip+4. The Ohio table for zip+4 has 12,000 entries in it and customer would have to put in the full zip code.
Ohio also has a web service for tax rates and some sample code. Can anyone give me any clues about how this would integrate with Able? Here is their sample code:

Code: Select all

Sample code for .Net  
To help developers get a head start in consuming the web services, we have provided some sample .Net C# code. Our web service implements the open standard of WS-Security for authentication. This code sample and instructions are provided for users of Visual Studio.Net. If you are using some other development tool, you will have to alter the instructions accordingly. 
Install the latest version of Microsoft's Web Services Extensions (WSE) 
Create a new project in Visual Studio.Net 
From within Visual Studio, add a web reference to https://thefinder.tax.ohio.gov/OHFinderService/OHFinderService.asmx.
With WSE installed, it will also generate WSE versions of web service stubs. 
Try out the sample code, substituting valid login/address data for the values in [brackets]. 
// Create new instance of web service reference using WSE
OHFinderServiceWse finderService = new OHFinderServiceWse();

// Create authentication token
UsernameToken tkn = new UsernameToken("[username]", "[password]", 
    PasswordOption.SendPlainText);

// Add authentication token to web service request
finderService.RequestSoapContext.Security.Tokens.Add(tkn);

// Create new date for method calls
DateTime todayDate = new DateTime();

// Tax rate lookup by address...
Finder.AddressReturn addressReturn = finderService.GetOHSalesTaxByAddress(
    "[address]", "[city]", "[state abbr]", "[postal code]", "US",
    [tax amount], todayDate, [true/false]);
// addressReturn.addressResponse contains the standardized address
// addressReturn.taxResponse contains an array of tax return values

// Tax rate lookup by zip code...
Finder.ZipCodeReturn zipReturn = finderService.GetOHSalesTaxByZipCode(
    "[postal code]", [tax amount], todayDate, [true/false]);
// zipReturn.zipResponse contains the original zip code queried
// zipReturn.taxResponse contains an array of tax return values
 
 

Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Ohio Sales Tax

Post by Logan Rhodehamel » Mon Jun 02, 2008 10:24 am

You might find this thread interesting.

viewtopic.php?t=5935&highlight=avalara

I would like to see us complete the tax integrations for AC7 soon. We had CertiTAX and CyberSource. If Ohio has a free web service, that would be a candidate for a third integration if it were that simple!
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Ohio Sales Tax

Post by jmestep » Mon Jun 02, 2008 12:58 pm

Thanks, I will look at it. I just got another Ohio client, so I know it would be good if I could figure it out.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

keats76
Commander (CMDR)
Commander (CMDR)
Posts: 117
Joined: Sat Dec 15, 2007 4:45 pm

Re: Ohio Sales Tax

Post by keats76 » Mon Jun 02, 2008 2:11 pm

I beleive the State of Ohio service is just for Ohio though, correct?

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Ohio Sales Tax

Post by jmestep » Mon Jun 02, 2008 3:29 pm

Yes, it is.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply