This issue started happening after I converted to the lastest Zen Cart 1.3.7
I have tried to reproduce the errors but haven't been able to.... maybe this is happening when some table isn't able to be updated (because the server is bogged down).... all rows have the shortened state "TX" instead of "Texas" I see this happen with other states but I don't collect sales taxes for other states.... I didn't see this on the previous version I was on.
Go to phpadmin in your cpanel ... go to your zen cart database .... click on the "orders" table (left hand side) .... Find the SQL tab (top tabs) and click on it.... enter this query with your state (Substitute your state that you collect taxes from where 'TX' and 'Texas' are) in the query box.... click go.
SELECT * FROM `orders` WHERE customers_state='TX' or customers_state='Texas' and order_tax is null
All rows found YOU are paying the sales tax on or you are not reporting all your owed sales tax.
Related thread:
http://www.zen-cart.com/forum/showth...ight=sales+tax
MODS I have: SEO URL, GOOGLE CHECKOUT, CART UPSELL, CROSS SELL, PPEC-137, Return Auth, Shipping Ins, Quickbooks
Bookmarks