Author Topic: Washington State sales tax - destination-based implementation  (Read 31221 times)

FinallyInSeattle

  • Beginner
  • *
  • Posts: 25
Re: Washington State sales tax - destination-based implementation
« Reply #15 on: April 29, 2009, 17:33:16 pm »
Tested it just this morning by dropping my default rate to .01 and doing a test purchase - it correctly picked up my tax rate as .095.  Do you have cURL enabled?

Bruce Morgan

  • Full Member
  • ***
  • Posts: 672
Re: Washington State sales tax - destination-based implementation
« Reply #16 on: April 29, 2009, 18:48:54 pm »
Tested what???  Please explain

Bruce

Zombie

  • Beginner
  • *
  • Posts: 36
    • Thunder Kiss NW
Re: Washington State sales tax - destination-based implementation
« Reply #17 on: April 30, 2009, 04:16:07 am »
I have gotten the first 2 parts of your instructions installed, but I am having troubles with the last part.  Where exactly does that bit of code go?  Everytime I install it, it errors out.

Is there anyway for you to post a modded copy of the ps_checkout?

I have tried to implement, but it just doesn't work for me.

Thanks

kIsa_camel

  • Beginner
  • *
  • Posts: 30
    • sanalpos-tr
Re: Washington State sales tax - destination-based implementation
« Reply #18 on: May 03, 2009, 12:44:49 pm »
I found out a workaround on this..I got the job in the section "Commercail Jobs" and implemented this WA based tax thing onto VM, but for version 1.0.15. It's working, and this is not a hack just on the ps_checkout.php. Anyone who needs it for VM 1.1.3, contact me by pm.
http://www.sanalpos-tr.com
custom payment mods, modification projects, installation-configuration-migration support for vm

Zombie

  • Beginner
  • *
  • Posts: 36
    • Thunder Kiss NW
Re: Washington State sales tax - destination-based implementation
« Reply #19 on: May 03, 2009, 22:52:21 pm »
Kisa_camel's hack is just what us Washingtonians need.
Well worth the few bucks for the amount of piece of mind you'll get!

Bruce Morgan

  • Full Member
  • ***
  • Posts: 672
Re: Washington State sales tax - destination-based implementation
« Reply #20 on: May 05, 2009, 00:17:30 am »
This thread seems to have forked in a couple of different directions.  So does anyone have a version working for VM 1.1.3?  Want to share?  I have not made any prgress implementing multiple tax rates so i migh at least ry and get destinationb based tax rates working.

bruce
www.pepper-passion.com

kIsa_camel

  • Beginner
  • *
  • Posts: 30
    • sanalpos-tr
Re: Washington State sales tax - destination-based implementation
« Reply #21 on: May 05, 2009, 08:25:19 am »
I have the working version for both VM 1.1.3 and 1.0.15, and this was what i was telling in my last post.
http://www.sanalpos-tr.com
custom payment mods, modification projects, installation-configuration-migration support for vm

Bruce Morgan

  • Full Member
  • ***
  • Posts: 672
Re: Washington State sales tax - destination-based implementation
« Reply #22 on: May 06, 2009, 22:07:27 pm »
I seem to be getting nowhere trying to solve my WA state tax issues.  Could you help by sharing the code you implemented?  The ideal solution fr mne would be a hack that also will allow multiple tx rates so I can charge zero tax for food items.

Bruce
www.pepper-passion.com

kIsa_camel

  • Beginner
  • *
  • Posts: 30
    • sanalpos-tr
Re: Washington State sales tax - destination-based implementation
« Reply #23 on: May 07, 2009, 10:17:31 am »
There are still some issues on it and I'm looking into those. For example, today I got a message that the discounts were not working on VM 1.1.3 while taxes are applied fine. I'll leave a message here when all are done.
http://www.sanalpos-tr.com
custom payment mods, modification projects, installation-configuration-migration support for vm

Zombie

  • Beginner
  • *
  • Posts: 36
    • Thunder Kiss NW
Re: Washington State sales tax - destination-based implementation
« Reply #24 on: July 24, 2009, 05:03:23 am »
Kisa_camel

Once I bought this script from you, you said you would support it. 
I have a script that only half works and you keep ignoring my emails and PM's.

You need to fix this situation.

Mike Wyatt

  • Jr. Member
  • **
  • Posts: 71
Re: Washington State sales tax - destination-based implementation
« Reply #25 on: September 24, 2009, 20:11:31 pm »
Anyone with anything new for this thread? FinallyInSeattle's code worked well in our test site. Having trouble with production site. Looks like the potential solution, though...

kIsa_camel

  • Beginner
  • *
  • Posts: 30
    • sanalpos-tr
Re: Washington State sales tax - destination-based implementation
« Reply #26 on: September 24, 2009, 20:47:15 pm »
I've done something working a long time ago but couldn't bring the rest. It's not just about ps_checkout. the checkout process sometimes get's the tax included price from ps_product and even ps_cart too. this comment is for developers : beware while examining the issue, follow the codes in ps_checkout and see it calling functions in other class files. hope this helps, when i find time to complete it, I'll share the complete solution (both for VM 1.0.15 and 1.1.3) here. No blaming please, I tried hard to do it but there's a little trick somewhere that'll resolve the issue, the point was to find it. As I couldn't find it, i had nothing to say. Soon I'll be back here in forums.
http://www.sanalpos-tr.com
custom payment mods, modification projects, installation-configuration-migration support for vm

Bruce Morgan

  • Full Member
  • ***
  • Posts: 672
Re: Washington State sales tax - destination-based implementation
« Reply #27 on: September 24, 2009, 21:20:51 pm »
I sympathize.  I have learned the hard way that the whole tax calculation issue is built on a shaky foundation and may need to be rebuilt from scratch. Not a terribly sexy thing for programmers to do (bells ans whistles are more fun) but vitally necessary if you are going to have a workable ecommerce site.  I would help if I had the knowledge to do so.

I would contribute some $$ if someone can come up with a comprehensive fix.

Bruce

kIsa_camel

  • Beginner
  • *
  • Posts: 30
    • sanalpos-tr
Re: Washington State sales tax - destination-based implementation
« Reply #28 on: September 24, 2009, 22:11:41 pm »
no $$ needed. I've already sold this (uncompleted) hack, we were thinking that it was working. see Zombie's post. I've never left anybody down, so as i said, I'll make this thing running without issues and share it here.

just stay tuned please. subscribe to this topic to get the updates.

thanks.
http://www.sanalpos-tr.com
custom payment mods, modification projects, installation-configuration-migration support for vm

chrislim

  • Beginner
  • *
  • Posts: 1
Re: Washington State sales tax - destination-based implementation
« Reply #29 on: September 30, 2009, 07:12:28 am »
I found out why the initial solution was not working.
Although we changed the SQL query, we weren't loading up the $address, $city, $zipcode fields into variables so the WA_state_tax() function was getting all null arguments.

Simply add the following lines:
Code: [Select]
$address = $db->f("address_1");
$city = $db->f("city");
$state = $db->f("state");
$zipcode = $db->f("zip");
$country = $db->f("country");
Two lines after the first change specified by FinallyInSeattle. Or in my code, after this:
Code: [Select]
$q = "SELECT address_1, city, state, zip, country FROM #__{vm}_user_info ";
$q .= "WHERE user_info_id='".$ship_to_info_id. "'";
$db->query($q);
$db->next_record();
And the taxes should be working for WA!