dandelion Posted August 29, 2005 Share Posted August 29, 2005 Sorry my post didn't show up so I might be double posting? <_< The taxes aren't being charged to either the products or the shipping. I think I've set everything correctly I used the Ontario Canada Tax Zones Setup instructions found here Please help this is the last thing to work out and then I can go live with the store at long last! Ruth My Webpage Link to comment Share on other sites More sharing options...
dandelion Posted August 29, 2005 Author Share Posted August 29, 2005 Sorry my post didn't show up so I might be double posting? <_< The taxes aren't being charged to either the products or the shipping. I think I've set everything correctly I used the Ontario Canada Tax Zones Setup instructions found here Please help this is the last thing to work out and then I can go live with the store at long last! Ruth My Webpage <{POST_SNAPBACK}> Maybe I should redo all the product prices to include taxes. Ooops no that won't work as out of Ontario there is no PST... Anyone willing to look at my files and help me out? Ruth Link to comment Share on other sites More sharing options...
dandelion Posted August 30, 2005 Author Share Posted August 30, 2005 Sorry my post didn't show up so I might be double posting? <_< The taxes aren't being charged to either the products or the shipping. I think I've set everything correctly I used the Ontario Canada Tax Zones Setup instructions found here Please help this is the last thing to work out and then I can go live with the store at long last! Ruth My Webpage <{POST_SNAPBACK}> I've been working through all my files and comparing changed code with the clean version of oscommerce files and I can't find what's wrong. Can anyone tell me which file to look at? Where are the taxes added checkout_confirmation.php? PLEASE I need to get this site launched this week!! Ruth Link to comment Share on other sites More sharing options...
Guest Posted August 30, 2005 Share Posted August 30, 2005 Two things to help you (I hope). One, the taxes are not added in checkout_confirmation.php. They are compiled in catalog/includes/classes/order.php. And when they are compiled, it's simply a DB query. Two, I would check on your admin side to see if tax is even being called for. Log in to your back-end, under "Modules" there should be one called "Order Total." Under that heading you will find the sort order of all fields in the order total module. Check to see if the tax field is installed, and if so, does it have the correct placement in the sort order. I hope this helps. Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 30, 2005 Share Posted August 30, 2005 I've been working through all my files and comparing changed code with the clean version of oscommerce files and I can't find what's wrong. Can anyone tell me which file to look at? Where are the taxes added checkout_confirmation.php? PLEASE I need to get this site launched this week!! Ruth <{POST_SNAPBACK}> Hi Ruth, I do not think the files are messed up, maybe something in your admin. You did create a new zone, and you did fill if with each zone you need to collect taxes for in the details section? that is often overlooked. Let me know. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
dandelion Posted August 30, 2005 Author Share Posted August 30, 2005 Two things to help you (I hope). One, the taxes are not added in checkout_confirmation.php. They are compiled in catalog/includes/classes/order.php. And when they are compiled, it's simply a DB query.Two, I would check on your admin side to see if tax is even being called for. Log in to your back-end, under "Modules" there should be one called "Order Total." Under that heading you will find the sort order of all fields in the order total module. Check to see if the tax field is installed, and if so, does it have the correct placement in the sort order. I hope this helps. <{POST_SNAPBACK}> Thanks for your comments: I double checked and yes I have the order total module set to 1 subtotal 2 shipping 3 tax 4 total This is correct isn't it? Link to comment Share on other sites More sharing options...
dandelion Posted August 30, 2005 Author Share Posted August 30, 2005 Hi Ruth, I do not think the files are messed up, maybe something in your admin. You did create a new zone, and you did fill if with each zone you need to collect taxes for in the details section? that is often overlooked. Let me know. <{POST_SNAPBACK}> I have my store set to Country: Canada Zone: Ontario I have created tax Zones: 1) Canada GST Zone one sub zone for each Province (except NS, NB, NFL) like this: Country Canada Zone Alberta (etc for 10 provinces) 2) Ontario PST Zone sub zone Country Canada zone Ontario 3) HST Zone one for each or the 3 Atlantic Provinces Country Canada Zone Nova Scotia (etc) Created Tax Classes 1) GST & PST & HST description all taxable goods 2) GST shippping class description gst on shipping within Canada Created Tax Rates Created 6 tax rates 1) GST & PST & HST Class Zone Canada GST Zone tax Rate % 7.0000 description with gst number priority 1 2) GST & PST & HST Class Zone Ontario PST Zone tax Rate % 8.0000 description 8% pst Ontario priority 1 3)GST & PST & HST Class Zone HST Zone tax Rate % 0000 description we don't collect HST priority 1 4)GST Shipping Class Zone Canada GST Zone tax Rate % 7.0000 description with gst number priority 1 5)GST Shipping Class Zone Ontario PST Zone tax Rate % 8.0000 description Ontario PST 8% (shipping) priority 1 6)GST Shipping Class Zone HST Zone tax Rate 0000 description we don't collect hst priority 1 All products are listed with tax class as "GST & PST & HST" This may not be word for word what I have in the descriptions but otherwise this is what I did. Ruth Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 30, 2005 Share Posted August 30, 2005 I have my store set to Country: Canada Zone: Ontario I have created tax Zones: 1) Canada GST Zone one sub zone for each Province (except NS, NB, NFL) like this: Country Canada Zone Alberta (etc for 10 provinces) 2) Ontario PST Zone sub zone Country Canada zone Ontario 3) HST Zone one for each or the 3 Atlantic Provinces Country Canada Zone Nova Scotia (etc) Created Tax Classes 1) GST & PST & HST description all taxable goods 2) GST shippping class description gst on shipping within Canada Created Tax Rates Created 6 tax rates 1) GST & PST & HST Class Zone Canada GST Zone tax Rate % 7.0000 description with gst number priority 1 2) GST & PST & HST Class Zone Ontario PST Zone tax Rate % 8.0000 description 8% pst Ontario priority 1 3)GST & PST & HST Class Zone HST Zone tax Rate % 0000 description we don't collect HST priority 1 4)GST Shipping Class Zone Canada GST Zone tax Rate % 7.0000 description with gst number priority 1 5)GST Shipping Class Zone Ontario PST Zone tax Rate % 8.0000 description Ontario PST 8% (shipping) priority 1 6)GST Shipping Class Zone HST Zone tax Rate 0000 description we don't collect hst priority 1 All products are listed with tax class as "GST & PST & HST" This may not be word for word what I have in the descriptions but otherwise this is what I did. Ruth <{POST_SNAPBACK}> lol, my head is spinning from all those taxes ... I think I would need to see it. If you would like to, PM me the admin info :-) :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
dandelion Posted August 30, 2005 Author Share Posted August 30, 2005 Is there anyone from Canada who can help me get the taxes/shipping to work? Link to comment Share on other sites More sharing options...
dandelion Posted August 31, 2005 Author Share Posted August 31, 2005 I think it's something to do with my shipping module regions not being connected to my tax zones. Anyone? Link to comment Share on other sites More sharing options...
Guest Posted August 31, 2005 Share Posted August 31, 2005 try the contribution i posted to you in my taxes topic :) and if you can get ontario pst to work, please tell me how you did it. Link to comment Share on other sites More sharing options...
dandelion Posted August 31, 2005 Author Share Posted August 31, 2005 try the contribution i posted to you in my taxes topic :) and if you can get ontario pst to work, please tell me how you did it. <{POST_SNAPBACK}> Okay I've tried that contribution too and have the gst but no pst. Have you figured it out yet? Ruth Link to comment Share on other sites More sharing options...
dandelion Posted August 31, 2005 Author Share Posted August 31, 2005 Okay I've tried that contribution too and have the gst but no pst. Have you figured it out yet? Ruth <{POST_SNAPBACK}> I also realize that gst is being charged to all of Canada - Atlantic Provinces should replace GST with HST. So the zones aren't working. I've disabled the tax module and reinstalled it to activate it a couple of times. Have you found any solution? I'm searching the boards. Link to comment Share on other sites More sharing options...
dandelion Posted August 31, 2005 Author Share Posted August 31, 2005 I've spent hours searching the forums, bug reports, and contributions. I've tried every contribution that deals with Canadian Taxes. I've played with the module settings till I want to cry. Can anyone help me??? PLEASE. I have gst now but no pst and gst shouldn't charge for atlantic provinces. I really wanted this store live before Sept. 1!!! Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 that really sucks. i've found no fix either :( i wonder how active canadian stores figured this out.. Link to comment Share on other sites More sharing options...
dandelion Posted September 1, 2005 Author Share Posted September 1, 2005 that really sucks. i've found no fix either :(i wonder how active canadian stores figured this out.. <{POST_SNAPBACK}> What are you doing for shipping - I'm trying two flat rates one for Ontario and one for the rest of Canada. It's definitely my shipping module that needs fixing. Ruth Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 ok so I am using the default setup for canada taxes as it's very simple (in contrast with us) now I have 3 zones. 7%,8% and 14.5%. Basically the 7 is for most states, 8 ontarion and the 14.5 for qc for the products I sell. Then on Tax Classes I setup (btw is the default) one class for "Taxable Goods" and in tax rates assign all percentage zones to that class. For shipping is where I use the "Rates based on Regions" contribution; this allows to have different shipping tables for different states. All is well and tax+S&H is added to the total. Have you tried without the contrib first and setup the same class and assign to the products that tax class? Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 ok so I am using the default setup for canada taxes as it's very simple (in contrast with us) now I have 3 zones. 7%,8% and 14.5%. Basically the 7 is for most states, 8 ontarion and the 14.5 for qc for the products I sell. Then on Tax Classes I setup (btw is the default) one class for "Taxable Goods" and in tax rates assign all percentage zones to that class. For shipping is where I use the "Rates based on Regions" contribution; this allows to have different shipping tables for different states. All is well and tax+S&H is added to the total. Have you tried without the contrib first and setup the same class and assign to the products that tax class? <{POST_SNAPBACK}> can you give us steps how to set up the gst & pst? i've tried nearly everything. all i have operable at the moment is gst. how does the rates by region work? is it by weight? currently i use the zonesworld_v2 shipping module, and just assign individual prices as "zone 1, zone 2" instead of by weight (which is what it was designed to do) Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 Ok first lets make sure the tax code works for each product. (lets put aside the canada specific notations HST, GST etc for the time being) I also assume you make these mods on an install without tax modules contributions. 1. goto to Tax Classes create a class (if one not present) call it "Taxable Goods" 2. goto Tax Zones create 3 zones folders call them 7P, 8P, 14P5, for 7%, 8%, 14.5% respectively. 3. goto to Tax Rates, create 3 rates for 7%, 8%, 14.5% and for each assign the equivalent zone. Put a description on all like "State Sales Tax" that description will come up on the confirmation page and its good to be consistent for each state. 4. ok now start entering the countries/states to the equivalent zones. So goto Tax Zones, double click the tax zones folder for each zone to get to the sub-entries level. Clicke insert, select country & zone accordingly. So Canada Ontario for example will go under the 8P zone folder. Then once you have a product set with Taxable goods the tax will be added. Shipping is different and you should done with the tax first. Once this is working you could start differentiating with the HST,GST etc. although in my case I keep it as total tax. Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2005 Share Posted September 3, 2005 after following your instructions, i have noticed there is no place for "province" or "state" in my address book. is this a mistake?? i can't even edit to add one in! my addresses (while using a test account, show up like this): first last 123 address 12345 city, country Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2005 Share Posted September 3, 2005 okay it is definately a mistake. whereabouts do i go to add the state/province: back in so it will show on my account -> view or change entries in addressbook (address_book_process.php) Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2005 Share Posted September 3, 2005 okay it is definately a mistake. whereabouts do i go to add the state/province: back in so it will show on my account -> view or change entries in addressbook I dont understand. Did you manage to setup your taxes as I mentioned? Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2005 Share Posted September 3, 2005 ok nevermind !!! i had under "customer details" state checked to FALSE. now my taxes work properly: gst AND pst! thanks for any help! ! :) Link to comment Share on other sites More sharing options...
Coastie Posted September 13, 2005 Share Posted September 13, 2005 Hello all, i have done what you said mark and when i go into tax zones to the sub cats i get this Tax Zones Country Zone Action 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-50, 50' at line 1 select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 12 order by association_id limit -50, 50 [TEP STOP] Doe any know how to fix this. Link to comment Share on other sites More sharing options...
Guest Posted September 13, 2005 Share Posted September 13, 2005 hello scott this is a reported bug just change your search results php files. Details here: http://www.oscommerce.com/community/bugs,1605 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.