Snicklefritz,
I believe what jprough did was use the zone taxes for zen cart to set up a state wide sales tax and then used the mod to apply additional sales tax to specific zip codes.
LadyHLG
Printable View
Snicklefritz,
I believe what jprough did was use the zone taxes for zen cart to set up a state wide sales tax and then used the mod to apply additional sales tax to specific zip codes.
LadyHLG
Yes!! It works now! thanks.Quote:
Originally Posted by LadyHLG
If you are a knitter, I should send you free yarn for writing a great mod :smile:
Glad everything is working now.
I did try knitting a while back but all I could ever seem to make was pot holders and scarfs. Anything more complicated than that and I was lost! :P
Have a good weekend!
LadyHLG
LadyHLG,
Thank you for this add-on. It is, by far, the best solution for those who do business in states that apply sales tax based on the destination address. I am currently using it on http://www.randylion.com.
As I read through the thread, I understand that the mod does not perform the tax calculations if a discount coupon is applied to the subtotal. I've verified that it doesn't. I'd like to try to tackle this problem.
Do you have any pointers on where I could change the calculations? In ot_local_sales_taxes.php, it loops through the items in the cart and calculates the subtotal based on a matching tax class id. I have only one tax class set for my products and local tax table. It seems that I could just subtract the discount coupon from this calculation - or am I oversimplifying the problem?
Thanks,
kjconnects
I am having a problem with how local tax module interacts with one of the shipping modules:
My store is in (the city of) Denver and I have a local tax set up for Denver. Tax basis is set to 'shipping'.
I need to add the local Denver tax to every order that uses 'Store Pickup', regardless of what the shipping address is set to. But I need to offer store pickup to all zones, not just Denver.
Is there a way I can modify ot_local_sales_taxes.php to do this? The local sales tax module is working great on all my other shipping modules, but for store pickup it only shows local tax if the shipping address is set to Denver.
(I honestly don't know why ZenCart restricts using the Store as the tax basis the way it does! Flaw of ZC in my opinion.)
Thank you thank you thank you for any help you can offer! :cool:
Hello Zenners,
Sorry I've been a bit absent lately, but I've started a new job and my time is limited.
BassFace,
I actually have an update to resolve this issue. I'm not currently at home and so can not upload it. As soon as I can I will add this update to the uploads section for you.
kjconnects,
Yes coupons are a bit of a problem. Its been a while since I dealt with them so I will have to go back and take a look, hopefully we can come up with a solution.
LadyHLG
OMG, you are a gem, indeed! Thank you! I can't wait to see what you've done, as I was giving myself a migraine trying to figure out how to make it work on my own! :smile:Quote:
Originally Posted by LadyHLG
Thank you for this excellent MOD and for continuing to support it and support it's users. As a writer of phpbb mods I truly understand how much time and effort goes into a mod and it's support, so thank you again!
LadyHLG, do you have an idea of when the update you mentioned will be available to download? Thanks again.
BassFace and anyone else interested,
I have uploaded version 2.4 of the mod with support for taxing in store pickup. The download has both a full install version and an upgrade version for 2.3 users.
The readme file has instructions on how to use this new feature, I tried to make it as clear as possible, but it may still seem confusing so please read it carefully!
As always back up the database and store files before installing!!:smile:
Good Luck!
LadyHLG
Thank you LadyHLG. But we need to wait til it shows up in the Contributions section for download, correct?
Yes, hopefully it will be up soon.
LadyHLG
LadyHLG,
I can't seem to get this 2.4 update working. Local tax is still not being applied to Store Pickup items.
I've attached a screenshot of the Modules>OrderTotal>Local Sales Tax edit screen; there is an unlabeled text field and it does not accept input. I tried entering some text, click 'Update' but what I entered isn't saved. In the 2.4 package there was no /admin folder and no sql fileinside the 'Upgrade Only' folder. Is this correct or is something missing?
Thanks for your continued help. I'm lost and need your assistance to get this working for my store! :cool:
http://www.bassface3d.com/uploads/loctax.jpg
Hello Zenners!
It appears there may be an issue with the 2.4 upgrade only files. (I think I may have missed a file in the upgrade folder).
So while I am trying to determine what the issue is please do the following to upgrade your Local Sales Tax Mod to version 2.4.
Step 1 - Completely disregard the upgrade only folder!!!
Step 2 - Make note of your Local Sales Tax Admin settings and then uninstall the Local Sales Tax Mod via the zen cart Admin (ie - click the "REMOVE" button in the admin interface. Don't worry this will not delete your database sales tax info, it just deactivates the mod).
Step 3 - Copy over all the files from the Full Version Folder - overwrite all the mod files.
Step 4 - Reinstall the mod via the admin and set things up based on the previous setting from Step 2.
Step 5 - Follow the instruction in the README file included with the mod to use the new Store Pickup taxation option.
Step 6 -Sleep well at night knowing you are providing your local government with proper financial support! :D
I will try to get a look at the mod install as soon as possible to correct the issue.
Cheers!
LadyHLG
Hello Heather (your a saint to help all of us) and anyone else that might be able to shed some light.
I am a New York stater suffering through the county tax headache and I appreciate all the info on the forum already. I started to add in the county information and then saw the posting from 'therealex' that included an SQL file of zen_tax_rates_local.sql with the tread quoted below. I pasted the sql file into my site (http://atriatechnologies.com/store/) but can not make things work.
1 Does the local sales tax mod connect to this database insertion that 'therealex' included? (zen_tax_rates_local.sql)
2. Can the insertion be removed if necessary?
3. Is there a procedure to connect the two?
4. Is there an easier way to add in all the counties one by one per the instruction on the local sales tax mod as currently written?
I'm dying here, any help is appreciated. Thanks so much.
Jamie
PS: ZenCart version 1.3.8, Local sales tax mod 2.3, I do have customer tax exempt mod installed and it is working, Cherry zen template, edit orders mod installed.
= - = - = - = - = - = - = - = - = - =
Quote:
Originally Posted by sugarhill
Tesla,
From what I can see, the sql file creates a table called zen_tax_rates_local. The problem here is that unless your store uses "zen_" as a table prefix, it wont work with the mod.
So you need to go into the database and rename that table with whatever you used for a table prefix (or delete the "zen_" in the table name if you didn't assign a table prefix for your store).
Hope that makes sense.
LadyHLG
Lady Heather, you certainly are a genius and an angel. :clap:
Congratulations on the job, I hope you're happy and comfortable there.
If you ever do get an opportunity to make more enhancements on this... when you have time, and after ZenCart 2.0...
I'm one of the people afflicted by the Washington state destination tax joy. (I'm amazed that got passed... the municipalities that seem to be the most affected are the ones with the least bargaining power... but I digress. :smile:)
After reading the hundreds of posts about this, I created a compromise solution -- I'm a programmer by day, compromise solutions are my life -- and it's only going to "work" for me because my sales volume is going to be low enough that I can manually verify each transaction and refund any overage (which will be a max of about forty five cents).
Where I'm going with this... There are probably complicated answers that will give us 100% compliance, but I think that even a compromise solution would be a whole lot closer if we could match on 5-digit zip code *and* a city name that's populated using a drop-down. I don't know if that's possible, php is not one of the seventeen or so languages I write in, but if it is, it would probably get us to 95% or so.
[FONT=Arial]What This Is:[/FONT]
[FONT=Arial]Within about half hour, not including reading all this documentation, you can get a [/FONT][FONT=Arial]New York[/FONT][FONT=Arial]State[/FONT][FONT=Arial] tax solution in place that works really well. I have documented what I have learned from others on the forum by their posts and some help. I have made modifications to sql files that 'therealex' posted and described the changes in detail. The implementation is the zip code implementation that does have limitations around some parts of NY where the zip crosses counties or something like that. [/FONT][FONT=Arial]
[/FONT]
[FONT=Arial]My intent is to share what I have learned in the documentation attached. The upload could not handle the screen shots due to file size so I uploaded it to here and attached my doc file without the images:[/FONT]
[FONT=Arial]http://www.frontiernet.net/~tesla/zencart/A[/FONT][FONT=Arial]NewYork[/FONT][FONT=Arial]StateLocalSalesTaxSolutionDocumentation.doc[/FONT]
[FONT=Arial] I got this solution working two ways and describe what the differences are. I hope this helps others. Disclaimer: I know enough to be dangerous and am not a programmer and think I have this working properly.[/FONT]
[FONT=Arial]Please see the attached two zip files. (doc and 3 sql files) [/FONT]
[FONT=Arial]Special Thanks and Recognition to:[/FONT]
- [FONT=Arial]Zen Cart user LadyHLG for writing the Local Sales Tax Mod and answering good and stupid questions from lots of people including me! I REALLY appreciate all you have done![/FONT]
- [FONT=Arial]The folks at BushkillFarms.com for making the New York State Zen Cart SQL file with all the zip codes in it and posted on the Forum by user therealex. I REALLY appreciate that too. See his posting of [/FONT][FONT=Arial]14th September 2009[/FONT][FONT=Arial], [/FONT][FONT=Arial]09:59 PM[/FONT][FONT=Arial] (thread #223) with subject Re: Local Sales Tax Mod - Support Thread[/FONT]
[FONT=Arial]jamie[/FONT]
Tesla,
Thank-you for sharing what you have learned. Its whats makes the zen community so great!
Best of luck to you!
LadyHLG
I am having the same issue as some of your other users where if I use a discount coupon with taxes, the coupon is not subtracted. If no taxes, the coupon is works fine. After changing the order to apply the coupon after the tax, it works in a confusing way.
Get total showing
and tax is based on that total correctly
then is shows the coupon subtracted at face value,
but with my settings it does correctly subtract the coupon and any tax on that amount. That is correct because you cannot tax on what they did not spend.
So overall the calculations are correct, but it will confuse the customer. Also, I am creating a summary tax report, and that becomes an issue because the tax showing is for the city and state, but the values are on the sub totals before any discounts. So the amounts showing on the report are incorrect since we did not collect say 4% on $45, but rather 4% on $20 because of a $25 coupon.
Has there been any progress on a possible fix? If I could apply the coupon before the tax, the tax would be calculated correctly and stored in the DB correctly and my customers would see the actual tax they were charged correctly.
Please Please Help, our site is live and I want them to be able to use discount coupons.
Zen 1.3.8a
Tax module 2.4
Thanks, and I do love the mod. Good work. :clap:
Hello,
I have the local sales tax modification (ver 2.4) working very well with ZC ver 1.3.8 in New York with 2260-ish zip codes in NY.
I have a problem where if a customer is in NY (my state) I need to charge tax but if the customer has their home address zip with zip+4, 9 digit zip with the form 12345-6789 format of zip code, they do not get charged tax.
Is there any way to modify the read of the customer's zip code and truncate all but the first 5 digits before it does the compare and search the database table. I could not find any other information/postings in the forum on this subject. Does everyone have this problem? Any suggestions appreciated. Thank you.
Tesla,
I haven't had time to test this, but you can give it a try.
Open the following file:
includes\modules\order_total\ot_local_sales_taxes.php
at about line 170 look for the following:
$debug2 .= $myfield."<br>";
right above that line place the following code:
See if it does the trick.PHP Code:if($taxmatch == "postcode"){
$myfield = substr($myfield, 0, 5);
}
LadyHLG
I recently installed Zen Cart and dealing with Washington State city sales taxes is the last step. It seems the Local Sales Tax mod will do the trick. My Zen Cart folder within my website is titled "store" so I uploaded the "FullVersion" folder within this folder.
I then went to "Install SQL Patches" and pasted the following in the box:
CREATE TABLE `tax_rates_local` (
`local_tax_id` int(11) NOT NULL auto_increment COMMENT 'tax id',
`zone_id` int(11) default NULL COMMENT 'zen cart zone to apply tax',
`local_fieldmatch` varchar(100) default NULL COMMENT 'name of field from delivery table to match',
`local_datamatch` text COMMENT 'Data to match delievery field',
`local_tax_rate` decimal(7,4) default '0.0000' COMMENT 'local tax rate',
`local_tax_label` varchar(100) default NULL COMMENT 'Label for checkout',
`local_tax_shipping` varchar(5) default 'false' COMMENT 'Apply this tax to shipping',
`local_tax_class_id` int(1) default NULL COMMENT 'Apply to products in what tax class',
PRIMARY KEY (`local_tax_id`)
);
The system returns the following message:
CREATE TABLE zen_tax_rates_local ( local_tax_id int(11) NOT NULL auto_increment COMMENT 'tax id', zone_id int(11) default NULL COMMENT 'zen cart zone to apply tax', local_fieldmatch varchar(100) default NULL COMMENT 'name of field from delivery table to match', local_datamatch text COMMENT 'Data to match delievery field', local_tax_rate decimal(7,4) default '0.0000' COMMENT 'local tax rate', local_tax_label varchar(100) default NULL COMMENT 'Label for checkout', local_tax_shipping varchar(5) default 'false' COMMENT 'Apply this tax to shipping', local_tax_class_id int(1) default NULL COMMENT 'Apply to products in what tax class', PRIMARY KEY (local_tax_id) );
Am I putting the folder in the right place? I can't seem to get this installed. Thanks for your help in advance.
Inside the FullVersion folder are 2 folders catalog and sqlfiles.
You need to copy all the files and folders inside the catalog folder, but not the folder itself, into your shop folder.
LadyHLG
That sounds simple...but I encountered an issue. You were right about the catalog and sqlfiles folders. If I understand correctly, I am to take the contents of the catalog folder and move them to the top level (in may case a folder titled, "store"). The problem is that the two files in the catalog folder are titled, admin and includes. The "store" directory already contains folders with these names.
Its ok if you already have folders with the same name (in fact thats exactly what you need). There is nothing in the mod folders that will overwrite anything it will just copy the new content into the folders where they need to go.
Good Luck!
LadyHLG
This WORKS! I need to test it more but wanted to thank you again for saving our collective behinds! If you ever need any electrical engineering, please let me pay you back. For others, make sure you edit this in version 2.4 of ...\ot_local_sales_taxes.php ....Tesla
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Quote:
Originally Posted by LadyHLG
Thanks LadyHLG.
When I try moving the files from the "catalog" folder (admin and includes) to the shop folder I get the message: "The directory "admin" already exists. Would you like to replace it? Overwriting a directory will replace all files contained in it with the new directory contents."
The folders already located in the shop folder have a lot of files and folders in them (admin has 80 and includes has 28). The ones I am moving have (admin 2 and includes 3).
I'm kind of an ameteur here, so please reconfirm that I should replace the current directories.
distinctivedog,
I would say you have two options.
1. Backup all the files and folders somewhere and then go ahead and upload the mod, if for some reason it removes all the existing files (normally FTP does not do this) then you can restore from the backup.
or
2. Upload the files and folders (new ones) individually.
Good Luck
LadyHLG
Thanks. Glad I backed up. It did indeed overwrite. I replaced the original files and added the files from the mod. Seems to be installed. Thanks for the help.
The attached zip contains a plain text file with a current list of 2010 Florida county surtax rates broken down by zipcode. It's already formatted for use with the Local Sales Tax Mod.
-The list is current until the end of 2010.
-Changes from 2009? Only one: Marion county changed from 6.5% to 6.0%, so the Marion county zipcodes have been removed from the list.
Please Note:
-Florida counties and zipcodes aren't contiguous; i.e., hundreds of zipcodes span 2 or even 3 counties. In these instances, the list assigns the zipcode to the county containing the greater population (for that zipcode). If a buyer says they've been charged an incorrect surtax, don't assume they're wrong; do a little investigating with google maps.
slomojojo,
Thank-you for the contribution!!
LadyHLG
Thank you LadyHLG, for creating and supporting such a useful add-on! It's remarkably flexible and easy to configure.
I have the Local Sales Tax mod installed and works great! But, I also have the Tax Exempt mod installed for my Distributor customers. The Tax Exempt mod will remove the state tax, but it won't remove the local tax.
I had seen a post on this forum from LadyHLG back in 2008 with a download file, looking like exactly what I need. However, it was from 2008 and MANY changes have been made to both mods since then.
Does there happen to be a new and improved download to make Local and Tax Exempt work together???
Thanks for everyone's help in this forum.
Rick
RFree190,
Exactly which tax exempt mod are you using?
LadyHLG
I am using Customer Tax Exempt 1.12a. And Local Sales Tax Mod 2.4. My Zencart is 1.3.8a.Quote:
Originally Posted by LadyHLG
Thanks for your help! I really appreciate it.
Rick
My shop is just about ready. BUT for WA state tax codes.
I have the local sales tax all set up, but can't figure out how to have it implement by the last four digits of the zip code.
Do you make your customers input it them selves or is there a way to auto populate it?
Or do you ask them their county?
Can I see an example?
How did you get all that bleeping data imported???Quote:
Originally Posted by Andi98640
Hi Jason,Quote:
Originally Posted by patternman
Besides this amazing mod (thanks LadyHLG :hug: ) your solution is the best I have found for acceptable slave compliance to the WA state tax master :bigups:. Yes, dramatic I know, but if you are in WA state you are feeling the pain! Streamlined sales tax my :censored: :censored: :censored:
I have downloaded and installed the local tax mod and the dor zip + 4 (your download isn't working) I will install the address verification mod in a few moments. I am hoping to copy your solution, but need to better understand what you did with the dor information and your instructions above. If your download is still available, I would greatly appreciate using it.
Your checkout is slick and accurate, and the delay is minimal! I think I may have an easy way to perform the updates every 3 months and would be willing to post them for sharing to anyone who uses your fix.
Thanks in advance for your time,
Lisa
Hi Lisa,
:smile:
Thanks for posting in more than one thread, I had unsubscribed from this thread a while ago. I didn't really know if my little contribution was useful to anyone or not. I'm glad someone has benefitted. And sorry about the link. I don't know when I deleted it from the server. I figured it was so old that it probably wasn't useful to anyone at this point.
Before I begin the meat of this post, please let me just give thanks to LadyHLG and the many others who know a lot more about mods, php, and programming than I. None of this would be possible without the heavy lifting from the real programmers.
But I'd also like to be blunt: please understand that I am not an expert with this stuff.
I am trying to help out and am posting what I can. But I offer no guarantees.
Always make sure to do proper backups before playing around with your database.
And as I stated earlier, I am not really interested in posting updates every three months. If someone else would like to adopt my methods (and hopefully clean them up a bit) and offer regular updates, please feel free to do so. The updates aren't especially difficult; I am just not in a position to take on that responsibility.
For the sake of clarity, I would also like to say that I don't consider this to be an ideal solution to the WA state sales tax. It would be much better to have a real-time lookup tool much like a shipping rate lookup. So for anyone who might know of a working mod for this, please post your information on this thread: Washington State Destination Sales Tax API
http://www.zen-cart.com/forum/showthread.php?t=102788
Ok, sorry for the verbosity.
It was good timing to post right now. The end of the quarter is upon us, and that means some new tax rates. I don't have the new ones done yet. (I'm always a few days behind on it.)
First, I have restored the link to my previous tax rate upload.
http://www.fashionpatterns.com/downl...tes_090410.zip
But like I said, probably not that useful because it's out of date. It's just an sql file that can (hopefully) be easily imported into the your database.
Second, here's a link to my most current tax_rates_local sql file:
http://www.fashionpatterns.com/downl...tes_100403.zip
Same sort of thing as before. It's just an export of my current table. I have not attempted to re-import it from this sql file. So please be careful and do your backups if you're going to play around with this.
Third, I have attached my personal instructions for doctoring the csv data from the WA DOR.
These instructions are attached directly to this post. (It's small enough to be attached, so I don't have to provide my own link to it.)
Attachment 7723
Please keep in mind that these are just my own personal notes to help me update the data each quarter. There may certainly be easier ways to do things. I can also not guarantee these instructions to be error free. But they work pretty well for me.
Fourth, here are the links to my previous post and attachment for uploading the data using MS Access:
http://www.zen-cart.com/forum/showth...078#post727078
http://www.zen-cart.com/forum/attach...2&d=1242085524
Just so everyone knows, importing the data using this method requires a very long time (at least it does for me). Importing an sql file is much quicker and easier. I just don't have a good procedure / tools for converting the data to sql before importing. So there is plenty of room for improvement.
Fifth, I have uploaded my excel sheet from this last quarter prior to import:
http://www.fashionpatterns.com/downl...ort_100403.zip
As you will notice, it is much larger than the sql file. I have provided it so that you can have a good example of what the data from the WA DOR looks like after I've finished doctoring it.
Since the timing is so close, I will go ahead and post my quarter 3 files after I've finished them.
Hope this helps!
Please let me know how it works out for you. :D
-Jason
Thanks again LadyHLG for a Mod that WA state residents can't live without! :hug:
Jason- Thanks for sharing! What you have started may be a great jumping off point for all of us caught in this issue. Let me know if you already made the July 1, 2010 changes.
DISCLAIMER: I am NOT a programmer. Not even close. Without Zen Cart and the great contributions, help, and easy to follow instructions, I would not be building a website.
I took patternmans tax_rates_local sql file (export of his current table) and had a php savvy friend break it into parts and turn it into something that can be uploaded to the tax_rates_local sql file through my php admin by starfield technologies. This is something that godaddy uses, so if you have godaddy and zen, this will work for you. (should work for everyone with starfield tech and possibly other sql control panels)
Download the sql file here: http://www.gemni-gems.com/sql.zip
Go to my php admin, click on your database name on the left hand side, scroll down and look for the table called tax_rates_local (click to highlight). Click the import tab, use the browse button to select file 1 (upload these in order and don't lose track) select SQL under the 'format of imported file' and click GO.
Continue until all are loaded. When complete, you should have 60,980 records entered.
I see it also allows selection of csv, so someone smarter than I should be able to download the WA state CSV file each quarter and load that in without the extra steps. Please share if you figure it out.
Still working on an easy way to update patternmans file each quarter.
*note: (62) is the number that is given in these files for WA state in your database. If you upload the files and don't show any local records when checking via your zen cart admin, you will need to go back to your php admin and correct that in the table.
Good Luck!
Hey Zenners,
Attached below is a Local Sales Tax Mod v2.4A replacement file for use with Customer Tax Exempt Mod by Numinix
Included is one replacement file for the Local Sales Tax Modv2.4
This new file will ONLY work with Local Sales Tax Mod v2.4 and the Customer Tax Exempt Mod by Numinix
To exempt customers from Local Sales Taxes:
The "Customer Tax Exempt" field in the customer admin must be either "ALL", which will exempt the customer from ALL sales taxes both zone and local,
or to exempt a specific local tax you need to enter the local tax description. This description MUST match the TAX DESCRIPTION used when setting up you local tax!
Cheers!
LadyHLG
Hi Lisa (Bonkycat),
Well since someone else is interested in this, I decided to roll up my sleeves a little and do a bit of experimenting.
I came up with a much better method of importing the tax rate data.
The import step was definitely the most bothersome part of the whole process.
So, just for the sake of clarity, I'm still keeping the instructions for re-working the WA DOR data and turning it into a usable excel sheet. Here is the link:
http://www.zen-cart.com/forum/attach...3&d=1277407594
After that, I had some instructions for uploading with MS Access. I was never happy with it.
Please trash those instructions (as long as this new method works for you).
Please note: I use phpMyAdmin for managing the database. Your software may be different depending on your hosting.
After the excel sheet is done, we need to alter it slightly for importing.
For these purposes, delete the first row.
(This method imports data but does NOT create the table so the first row is redundant here.)
Then for the last column H (local_tax_class_id):
Instead of the number 1 in all rows, you'll want to have 1\r\n
(phpMyAdmin says "A Carriage Return and Linefeed (\r\n) is strongly recommended to minimize errors.")
Then save the file as CSV.
Here is a link to my new csv import sheet:
http://www.fashionpatterns.com/downl...csv_100712.zip
You will probably need to extract the file from the zip file before importing.
(Just to repeat what Bonkycat noted: my database uses 62 for the zone for WA State. If yours is different, please adjust as necessary.)
Log on to your database using phpMyAdmin.
I'll try to make this simple and hopefully not confuse too many people.
Again, this method imports data, but does not create the table.
For simplicity, just go ahead and delete the table tax_rates_local.
Here is a small sql file to re-create a blank table.
Attachment 7808
Probably best to unzip the file prior to working with it.
From phpMyAdmin, click on the SQL tab to do an SQL query.
You can either copy and paste it into the query window or upload the file. (I tried both ways, and both worked just fine for me.)
This will create a fresh blank table with no rows.
Then click on tax_rates_local on the left hand side.
Once we're working on the correct table, click on the SQL tab.
At the bottom, there is an option to "Insert data from a textfile into table" click on that.
I have these options available:
Location of the textfile browse to locate the CSV file that we created earlier.
Replace table data with file left as default blank
Fields separated by left as default there should be a comma here
Fields enclosed by left as default blank
Characters escaped by left as default blank
Lines separated by left as default \r\n
Column names left as default blank
Then click on the "Upload File" button.
It may take a few minutes to upload depending on the speed of your internet connection, server speed, etc.
Then check to make sure that all of the rows were imported.
For this latest one, Q3 2010, my csv had 48275 rows.
That's it! Should be ready to go.
Hope this helps. :smile:
During checkout, I have discovered a circumstance when Gift Certificate does not require payment information when shipping to an in-state address (charging local sales tax).
If I apply a lesser Gift Certificate amount than the total purchase, checkout allows me to Confirm My Order when full payment has not been met. In other words, I am NOT prompted for a payment method when the Gift Certificate apply amount is close to the order total. This means an order can be completed without full payment.
Gift Certificate balance: $100
Order Total: 64.58
Apply Amount: $64.50
Confirm Order Total: $0.08
On the other hand, if the Gift Certificate Apply Amount is only $50, checkout DOES prompt for an alternate payment method.
The breakpoint seems to be $0.50 - if the GC apply amount is $0.50 less than the order total, I get prompted for payment information. If the GC apply amount is $0.01 - $0.49 less than the order total, I do NOT get prompted for payment information.
I'm using Zen Cart 1.39d and Local Sales Tax mod 2.4
Local Sales Taxes are set up by zip code.
I posted this under Gift Certificates, but Ajeh could not duplicate and suggested posting here. Please HELP!
I did some quick testing with version 1.38 (sorry dont have 1.39 installed yet), and I was able to duplicate the issue, BUT I turned off the local tax mod and was still able to duplicate the issue.
CustomBooks is it possible for you to turn off the local tax mod and do another test to see if you can duplicate the issue, that would lead me to believe there is something else going on.
LadyHLG
Hmm, the plot thickens...
Using Zen Cart 1.3.9d, with Local Sales Tax mod turned off, I DO get prompted for additional payment if I apply Gift Certificate amount of $0.01-$0.49 less than the total purchase when shipping in-state (state tax applied) and when shipping out-of-state (no state tax applied).
With Local Sales Tax mod turned on, I do NOT get prompted for additional payment if I apply Gift Certificate amount of $0.01-$0.49 less than the total purchase when shipping in-state (state and local sales tax applied). Out-of-state shipping works fine.
I need to charge 8.25% sales tax within California, and an extra 1% district tax to people living in Santa Clara County. I have installed this mod and tried to set this up, but it's just not working. Before I add the Santa Clara tax, it shows this at checkout, which is correct:
CA TAX 8.25%: $1.65
After I add the district tax, it shows this:
CA TAX 8.25% + 95101 Santa Clara District Tax 1.00%: $0.20
I have tried changing the module sort order and a few other things, but I just can't get it to add correctly.
Will this module work for what I want to do, and if so, how do I set it up?
Thanks!
As usual as soon as I posted I got it figured out :) I was setting up a whole new zone for the district tax but I should have just been using the same zone and specifying which zip codes were subject to district tax.
Thanks!
Quote:
Originally Posted by Danielle
Hey Zenners!
Apparently there are some issues with the local tax mod and zen cart version 1.3.9. I have not yet figured out what is going on (it really is only evident when gift certs are involved as far as I know, but I have not done extensive testing as yet.)
Until I figure out what is happening, I can not recommend the use of the Local Tax Mod with Zen Cart version 1.3.9.
When i have more to report I will let everyone know.
LadyHLG
I like your software. It is very helpful. I also believe in paying for things that I get. Where can I send a donation?
Hello all,
My question is once I install the local sales tax (update all the correct zones)... what do I do with my normal sales tax zone for Washington.
I was, until today charging the sales tax from my shipping location. Hadn't found a better way to do it until I stumbled upon this thread.
So, I have implemented the local sales tax mod, and would like to ensure that other Washington Tax Rate from Admin > Locations/Taxes > Tax Rates interferes with my new local ones.
Do I just Delete the Washington Zone from the Tax Rates section (would I lose any current info?)
Thanks for any assistance.
Hi jasmel,
Please check out my previous posts to get a firm grasp of what I have implemented with my site:
http://www.zen-cart.com/forum/showth...030#post727030
http://www.zen-cart.com/forum/showth...607#post901607
http://www.zen-cart.com/forum/showth...543#post908543
For Washington State, I just kept the zone id the same = 62.
The rate should be 6.5%.
The local sales tax rate is added on top of the state tax rate.
Hope this helps.
-Jason
Using with 1.3.8
Installed fine, sql mods also ok, when I go to put in my first tax rate, the country dropdown is empty and thus the zone dropdown is empty.. Any thoughts???
I got around my dropdown problem by directly importing my zip data to the backend. On my checkout screens it shows the zip before the description of each tax. How can I get rid of the zip being displayed?
Thanks
The drop-down list is supposed to be pulling directly from your countries list. If its not working then it could be a sign of some sort of problem, its almost impossible to say why without more info.
To remove the zip code from the output you will need to edit some lines in the following file:
includes\modules\order_total\ot_local_sales_taxes.php
At about line 204 look for the following:
You need to comment out the 3rd or 5th lines as you like it.Code:
//next we define the text used to describe the tax on the invoice
//to use only the rule label uncomment the following
$ot_local_sales_taxes_rate_description = $ot_local_sales_taxes_rate_description . " " .$myfield;
//to see the specific tax area with label uncomment the follwing
$ot_local_sales_taxes_rate_description = $ot_local_sales_taxes_rate_description . " " . $taxlabel;
(if you arent familiar with php to comment out the lines you simple put the // at the start of the line).
LadyHLG
Thanks, That worked..
I have all my countries deleted from the countries table except the US and Canada.. Can't figure out why that would be a problem.
Having only those two countries shouldnt matter. But again its hard to guess at what could be happening.
Are you getting any kind of errors?
LadyHLG
No errors, Working fine since I did an import of the data directly to the table without using the admin.
Can you edit the data from the admin?
LadyHLG
It still shows the country dropdown as blank but the zone is there if I edit one.
Very strange. I'm stumped as to what it might be.
I think I would have to see how its working to figure it out.
LadyHLG
Very strange indeed. I even pulled the query out and ran it in Navicat and it brought up the countries just fine. Seems to not work in Zen Cart with the query factory.
Great help! **Just got an email from WA about the new rates for Oct-DecQuote:
Originally Posted by patternman
Has anyone installed this on version 1.3.9d and got it to work?
I have installed the Local Sales Tax Mod. The setup for New York State tax rates is monstrous.
In the several threads regarding this mod, there is a suggestion to use The "New York State Tax Table" from b-u-s-h-k-i-l-l-f-a-r-m-e-s dot com
The table seems like just the thing to cut a weeks work to a minutes work. The problem is, I don't understand it's use. It is probably a simple cut and paste using phpMyAdmin, but I am clueless as to how to do it. Can anyone advise me.
Can someone tell me EXACTLY what to do here?
The file begins with:
zen cart local sales tax - NY county tax by zip code
-- compiled by edited.com-- Please report errors to [email protected]
--
-- Table structure for table `tax_rates_local`
-- Remove Old Table First
DROP TABLE IF EXISTS `tax_rates_local`;
CREATE TABLE `tax_rates_local` (
`local_tax_id` int(11) NOT NULL auto_increment COMMENT 'tax id',
`zone_id` int(11) default NULL COMMENT 'zen cart zone to apply tax',
`local_fieldmatch` varchar(100) default NULL COMMENT 'name of field from delivery table to match',
`local_datamatch` varchar(100) default NULL COMMENT 'Data to match delievery field',
`local_tax_rate` decimal(7,4) default '0.0000' COMMENT 'local tax rate',
`local_tax_label` varchar(100) default NULL COMMENT 'Label for checkout',
`local_tax_shipping` varchar(5) default 'false' COMMENT 'Apply this tax to shipping',
`local_tax_class_id` int(1) default NULL COMMENT 'Apply to products in what tax class',
PRIMARY KEY (`local_tax_id`),
UNIQUE KEY `local_datamatch` (`local_datamatch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2263 ;
--
-- Dumping data for table `tax_rates_local`
--
INSERT INTO `tax_rates_local` VALUES (1, 43, 'postcode', '00501', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (2, 43, 'postcode', '00544', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (3, 43, 'postcode', '06390', 4.6300, 'Suffolk County Sales Tax', 'true', 1);
INSERT INTO `tax_rates_local` VALUES (4, 43, 'postcode', '10001', 4.3750, 'New York County Sales Tax', 'true', 1);
And then goes on with hundreds of similar lines.
Please help
Essentially it is, although, i wouldn't go about using it in THAT manner. However, I would recommend using the Install SQL Patch, after you fully backup your SQL table. I have Local Sales Tax Mod with the New York State tables already defined if you want to use it. It groups the tax rates by rate, then by local zip code. You might find it handle, and a lot less cumbersome then each zip getting its own row in that table.Quote:
Originally Posted by larryweiss
Has anyone had a problem with it doubling the tax?
Sub Total $2800.00
6% Tax $168.00
1.00% Local Tax should be $28.00 but comes up as $56.00
Any thoughts?
fotofx,
Doubling can occur if you have two local taxes that are identical.
Have you turned on the debugging option to see if this is happening?
LadyHLG
That is what it was .. Had a few zip codes that were in two zones.
I would *love* to get access to that. Is there some way you can make it available? Thanks in advance.Quote:
Originally Posted by retched
-- Carlos
Any update on this issue?
Quote:
Originally Posted by LadyHLG
Here is the MySQL code for my table. You should be able to use the Install SQL Patches for it. If not, let me know and I'll help you with this. AGAIN, this is for New York State Only.Quote:
Originally Posted by ctotogo
Code:--
-- Table structure for table `tax_rates_local`
--
DROP TABLE IF EXISTS `tax_rates_local`;
CREATE TABLE IF NOT EXISTS `tax_rates_local` (
`local_tax_id` int(11) NOT NULL auto_increment COMMENT 'tax id',
`zone_id` int(11) default NULL COMMENT 'zen cart zone to apply tax',
`local_fieldmatch` varchar(100) default NULL COMMENT 'name of field from delivery table to match',
`local_datamatch` text COMMENT 'Data to match delievery field',
`local_tax_rate` decimal(7,4) default '0.0000' COMMENT 'local tax rate',
`local_tax_label` varchar(100) default NULL COMMENT 'Label for checkout',
`local_tax_shipping` varchar(5) default 'false' COMMENT 'Apply this tax to shipping',
`local_tax_class_id` int(1) default NULL COMMENT 'Apply to products in what tax class',
PRIMARY KEY (`local_tax_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `tax_rates_local`
--
INSERT INTO `tax_rates_local` (`local_tax_id`, `zone_id`, `local_fieldmatch`, `local_datamatch`, `local_tax_rate`, `local_tax_label`, `local_tax_shipping`, `local_tax_class_id`) VALUES
(1, 43, 'postcode', '10001;10002;10003;10004;10005;10006;10007;10008;10009;10010;10011;10012;10013;10014;10015;10016;10017;10018;10019;10020;10021;10022;10023;10024;10025;10026;10027;10028;10029;10030;10031;10032;10033;10034;10035;10036;10037;10038;10039;10040;10041;10043;10044;10045;10046;10047;10048;10055;10060;10069;10072;10079;10080;10081;10082;10087;10090;10094;10095;10096;10098;10099;10101;10102;10103;10104;10105;10106;10107;10108;10109;10110;10111;10112;10113;10114;10115;10116;10117;10118;10119;10120;10121;10122;10123;10124;10125;10126;10128;10129;10130;10131;10132;10133;10138;10149;10150;10151;10152;10153;10154;10155;10156;10157;10158;10159;10160;10161;10162;10163;10164;10165;10166;10167;10168;10169;10170;10171;10172;10173;10174;10175;10176;10177;10178;10179;10184;10185;10196;10197;10199;10203;10211;10212;10213;10242;10249;10256;10257;10258;10259;10260;10261;10265;10268;10269;10270;10271;10272;10273;10274;10275;10276;10277;10278;10279;10280;10281;10282;10285;10286;10292;10301;10302;10303;10304;10305;10306;10307;10308;10309;10310;10311;10312;10313;10314;10451;10452;10453;10454;10455;10456;10457;10458;10459;10460;10461;10462;10463;10464;10465;10466;10467;10468;10469;10470;10471;10472;10473;10474;10475;10499;11004;11005;11101;11102;11103;11104;11105;11106;11109;11120;11201;11202;11203;11204;11205;11206;11207;11208;11209;11210;11211;11212;11213;11214;11215;11216;11217;11218;11219;11220;11221;11222;11223;11224;11225;11226;11228;11229;11230;11231;11232;11233;11234;11235;11236;11237;11238;11239;11240;11241;11242;11243;11244;11245;11247;11248;11249;11251;11252;11254;11255;11256;11351;11352;11354;11355;11356;11357;11358;11359;11360;11361;11362;11363;11364;11365;11366;11367;11368;11369;11370;11371;11372;11373;11374;11375;11377;11378;11379;11380;11381;11385;11386;11390;11405;11411;11412;11413;11414;11415;11416;11417;11418;11419;11420;11421;11422;11423;11424;11425;11426;11427;11428;11429;11430;11431;11432;11433;11434;11435;11436;11439;11451;11484;11499;11690;11691;11692;11693;11694;11695;11697', 8.8750, 'New York City Sales Tax (8.875%)', 'false', 1),
(2, 43, 'postcode', '13054;13123;13157;13162;13301;13303;13304;13308;13309;13313;13316;13318;13319;13321;13322;13323;13328;13338;13341;13352;13354;13362;13363;13401;13403;13413;13417;13424;13425;13435;13438;13440;13441;13442;13449;13455;13456;13461;13469;13471;13476;13477;13478;13479;13480;13483;13486;13490;13492;13494;13495;13501;13502;13503;13504;13505;13599;14001;14004;14006;14010;14025;14026;14027;14030;14031;14032;14033;14034;14035;14038;14043;14047;14051;14052;14055;14057;14059;14061;14068;14069;14072;14075;14080;14085;14086;14091;14102;14110;14111;14112;14127;14134;14139;14140;14141;14150;14151;14169;14170;14201;14202;14203;14204;14205;14206;14207;14208;14209;14210;14211;14212;14213;14214;14215;14216;14217;14218;14219;14220;14221;14222;14223;14224;14225;14226;14227;14228;14231;14233;14240;14241;14260;14261;14263;14264;14265;14267;14269;14270;14272;14273;14276;14280', 8.7500, 'New York Sales Tax (Erie and Oneida Counties)', 'false', 1),
(3, 43, 'postcode', '00501;00544;06390;11001;11002;11003;11010;11020;11021;11022;11023;11024;11025;11026;11027;11030;11040;11041;11042;11043;11044;11050;11051;11052;11053;11054;11055;11096;11099;11501;11507;11509;11510;11514;11516;11518;11520;11530;11531;11535;11536;11542;11545;11547;11548;11549;11550;11551;11552;11553;11554;11555;11556;11557;11558;11559;11560;11561;11563;11564;11565;11566;11568;11569;11570;11571;11572;11575;11576;11577;11579;11580;11581;11582;11583;11588;11590;11592;11593;11594;11595;11596;11597;11598;11599;11701;11702;11703;11704;11705;11706;11707;11708;11709;11710;11713;11714;11715;11716;11717;11718;11719;11720;11721;11722;11724;11725;11726;11727;11729;11730;11731;11732;11733;11735;11736;11737;11738;11739;11740;11741;11742;11743;11745;11746;11747;11749;11750;11751;11752;11753;11754;11755;11756;11757;11758;11760;11762;11763;11764;11765;11766;11767;11768;11769;11770;11771;11772;11773;11774;11775;11776;11777;11778;11779;11780;11782;11783;11784;11786;11787;11788;11789;11790;11791;11792;11793;11794;11795;11796;11797;11798;11801;11802;11803;11804;11805;11815;11819;11853;11854;11855;11901;11930;11931;11932;11933;11934;11935;11937;11939;11940;11941;11942;11944;11946;11947;11948;11949;11950;11951;11952;11953;11954;11955;11956;11957;11958;11959;11960;11961;11962;11963;11964;11965;11967;11968;11969;11970;11971;11972;11973;11975;11976;11977;11978;11980', 8.6250, 'New York Sales Tax (Nassau and Suffolk Counties)', 'false', 1),
(4, 43, 'postcode', '14029;14707;14708;14709;14711;14714;14715;14717;14721;14727;14735;14739;14744;14745;14754;14774;14777;14786;14802;14803;14804;14806;14813;14822;14880;14884;14895;14897', 8.5000, 'New York Sales Tax (Allegany County)', 'false', 1),
(5, 43, 'postcode', '10509;10512;10516;10524;10537;10541;10542;10550;10551;10552;10553;10557;10558;10579;10701;10702;10703;10704;10705;10710;10801;10802;10804;10805;10901;10911;10913;10920;10923;10927;10931;10952;10954;10956;10960;10962;10964;10965;10968;10970;10974;10976;10977;10980;10982;10983;10984;10986;10989;10993;10994;12563', 8.3750, 'New York Sales Tax (Putnam and Rockland Counties, Mount Vernon, New Rochelle, Yonkers)', 'false', 1),
(6, 43, 'postcode', '13324;13329;13331;13340;13350;13357;13361;13365;13406;13407;13416;13420;13431;13454;13472;13475;13491', 8.2500, 'New York Sales Tax (Herkeimer County)', 'false', 1),
(7, 43, 'postcode', '10601;10602;10603;10605;10606;10607;10610;10650;10910;10912;10914;10915;10916;10917;10918;10919;10921;10922;10924;10925;10926;10928;10930;10932;10933;10940;10941;10943;10949;10950;10953;10958;10959;10963;10969;10973;10975;10979;10981;10985;10987;10988;10990;10992;10996;10997;10998;12501;12504;12506;12507;12508;12510;12511;12512;12514;12518;12520;12522;12524;12527;12531;12533;12537;12538;12540;12543;12545;12546;12549;12550;12551;12552;12553;12555;12564;12566;12567;12569;12570;12571;12572;12574;12575;12577;12578;12580;12581;12582;12583;12584;12585;12586;12590;12592;12594;12601;12602;12603;12604;12729;12746;12771;12780', 8.1250, 'New York Sales Tax (Dutchess Co., Orange Co., White Plains)', 'false', 1),
(8, 43, 'postcode', '12007;12008;12009;12010;12015;12016;12017;12018;12022;12023;12024;12025;12028;12029;12031;12032;12033;12035;12036;12037;12040;12041;12042;12043;12045;12046;12047;12050;12051;12052;12053;12054;12055;12056;12057;12058;12059;12060;12061;12062;12063;12064;12066;12067;12068;12069;12070;12071;12072;12073;12075;12076;12077;12078;12082;12083;12084;12085;12086;12087;12089;12090;12092;12093;12094;12095;12106;12107;12110;12111;12115;12116;12117;12120;12121;12122;12123;12124;12125;12128;12130;12131;12132;12133;12134;12136;12137;12138;12140;12141;12143;12144;12147;12149;12150;12153;12154;12155;12156;12157;12158;12159;12160;12161;12165;12166;12167;12168;12169;12172;12173;12174;12175;12176;12177;12179;12180;12181;12182;12183;12184;12185;12186;12187;12189;12192;12193;12194;12195;12196;12197;12198;12201;12202;12203;12204;12205;12206;12207;12208;12209;12210;12211;12212;12214;12220;12222;12223;12224;12225;12226;12227;12228;12229;12230;12231;12232;12233;12234;12235;12236;12237;12238;12239;12240;12241;12242;12243;12244;12245;12246;12247;12248;12249;12250;12252;12255;12256;12257;12260;12261;12262;12288;12301;12302;12303;12304;12305;12306;12307;12308;12309;12325;12345;12401;12402;12404;12405;12406;12407;12409;12410;12411;12412;12413;12414;12416;12417;12418;12419;12420;12421;12422;12423;12424;12427;12428;12429;12430;12431;12432;12433;12434;12435;12436;12438;12439;12440;12441;12442;12443;12444;12446;12448;12449;12450;12451;12452;12453;12454;12455;12456;12457;12458;12459;12460;12461;12463;12464;12465;12466;12468;12469;12470;12471;12472;12473;12474;12475;12477;12480;12481;12482;12483;12484;12485;12486;12487;12489;12490;12491;12492;12493;12494;12495;12496;12498;12502;12503;12513;12515;12516;12517;12521;12523;12525;12526;12528;12529;12530;12534;12541;12542;12544;12547;12548;12561;12565;12568;12588;12589;12593;12701;12719;12720;12721;12722;12723;12724;12725;12726;12727;12732;12733;12734;12736;12737;12738;12740;12741;12742;12743;12745;12747;12748;12749;12750;12751;12752;12754;12758;12759;12760;12762;12763;12764;12765;12766;12767;12768;12769;12770;12775;12776;12777;12778;12779;12781;12782;12783;12784;12785;12786;12787;12788;12789;12790;12791;12792;12901;12903;12910;12911;12912;12914;12915;12916;12917;12918;12919;12920;12921;12923;12924;12926;12929;12930;12933;12934;12935;12937;12939;12944;12945;12952;12953;12955;12957;12958;12959;12962;12966;12969;12970;12972;12976;12978;12979;12980;12981;12983;12985;12986;12989;12992;12995;13020;13021;13022;13024;13026;13027;13028;13029;13030;13031;13032;13033;13034;13035;13036;13037;13039;13040;13041;13042;13043;13044;13045;13051;13052;13053;13056;13057;13060;13061;13062;13063;13064;13065;13066;13068;13069;13071;13072;13073;13074;13076;13077;13078;13080;13081;13082;13083;13084;13087;13088;13089;13090;13092;13093;13101;13102;13103;13104;13107;13108;13110;13111;13112;13113;13114;13115;13116;13117;13118;13119;13120;13121;13122;13124;13126;13129;13131;13132;13134;13135;13136;13137;13138;13139;13140;13141;13142;13143;13144;13145;13146;13147;13148;13152;13153;13154;13155;13156;13158;13159;13160;13163;13164;13165;13166;13167;13201;13202;13203;13204;13205;13206;13207;13208;13209;13210;13211;13212;13214;13215;13217;13218;13219;13220;13221;13224;13225;13235;13244;13250;13251;13252;13260;13261;13290;13302;13310;13314;13315;13317;13320;13326;13332;13333;13334;13335;13337;13339;13342;13346;13348;13355;13364;13402;13408;13409;13410;13411;13415;13418;13421;13426;13428;13437;13439;13450;13452;13457;13459;13460;13464;13465;13468;13470;13482;13484;13485;13488;13493;13655;13730;13731;13732;13733;13734;13736;13737;13738;13739;13740;13743;13744;13745;13746;13747;13748;13749;13750;13751;13752;13753;13754;13755;13756;13757;13758;13760;13761;13762;13763;13774;13775;13776;13777;13778;13780;13782;13783;13784;13786;13787;13788;13790;13794;13795;13796;13797;13801;13802;13803;13804;13806;13807;13808;13809;13810;13811;13812;13813;13814;13815;13820;13825;13826;13827;13830;13832;13833;13834;13835;13837;13838;13839;13840;13841;13842;13843;13844;13845;13846;13847;13848;13849;13850;13851;13856;13859;13860;13861;13862;13863;13864;13865;13901;13902;13903;13904;13905;14003;14005;14008;14009;14011;14012;14013;14020;14021;14024;14028;14036;14037;14039;14040;14041;14042;14054;14056;14058;14060;14065;14066;14067;14070;14082;14083;14092;14094;14095;14098;14101;14103;14105;14107;14108;14109;14113;14120;14125;14126;14129;14130;14131;14132;14133;14138;14143;14144;14145;14167;14168;14171;14172;14173;14174;14301;14302;14303;14304;14305;14410;14411;14413;14414;14415;14416;14418;14420;14422;14423;14427;14428;14429;14430;14433;14435;14437;14441;14445;14449;14450;14452;14454;14462;14464;14466;14467;14468;14470;14472;14476;14477;14478;14479;14480;14481;14482;14485;14486;14487;14488;14489;14502;14505;14506;14507;14508;14510;14511;14513;14514;14515;14516;14517;14519;14520;14521;14522;14525;14526;14527;14529;14530;14533;14534;14536;14538;14539;14541;14542;14543;14544;14545;14546;14549;14550;14551;14555;14556;14557;14558;14559;14560;14563;14568;14569;14571;14572;14580;14586;14588;14589;14590;14591;14592;14601;14602;14603;14604;14605;14606;14607;14608;14609;14610;14611;14612;14613;14614;14615;14616;14617;14618;14619;14620;14621;14622;14623;14624;14625;14626;14627;14638;14639;14642;14643;14644;14645;14646;14647;14649;14650;14651;14652;14653;14660;14664;14673;14683;14692;14694;14706;14719;14726;14729;14730;14731;14737;14741;14743;14748;14751;14753;14755;14760;14766;14770;14772;14778;14779;14783;14788;14801;14805;14807;14808;14809;14810;14812;14814;14815;14816;14817;14818;14819;14820;14821;14823;14824;14825;14826;14827;14830;14831;14836;14837;14838;14839;14840;14841;14842;14843;14844;14845;14846;14847;14850;14851;14852;14853;14854;14855;14856;14857;14858;14859;14860;14861;14863;14864;14865;14867;14869;14870;14871;14872;14873;14874;14876;14877;14878;14879;14881;14882;14883;14885;14886;14887;14889;14891;14892;14893;14894;14898;14901;14902;14903;14904;14905;14925', 8.0000, 'New York Sales Tax (8% Counties)', 'false', 1),
(9, 43, 'postcode', '12851;12852;12855;12857;12858;12870;12872;12879;12883;12913;12928;12932;12936;12941;12942;12943;12946;12950;12956;12960;12961;12964;12974;12975;12977;12987;12993;12996;12997;12998;13305;13312;13325;13327;13343;13345;13367;13368;13404;13433;13473;13489;13601;13602;13603;13605;13606;13607;13608;13611;13612;13615;13616;13618;13619;13620;13622;13624;13626;13627;13628;13631;13632;13634;13636;13637;13638;13640;13641;13643;13648;13650;13651;13656;13657;13659;13661;13665;13671;13673;13674;13675;13679;13682;13685;13691;13692;13693;14048;14062;14063;14081;14135;14136;14166;14701;14702;14703;14704;14710;14712;14716;14718;14720;14722;14723;14724;14728;14732;14733;14736;14738;14740;14742;14747;14750;14752;14756;14757;14758;14767;14769;14775;14781;14782;14784;14785;14787', 7.7500, 'New York Sales Tax (Chautauqua Co., Essex Co., Jefferson Co., Lewis Co.)', 'false', 1),
(10, 43, 'postcode', '10501;10502;10503;10504;10505;10506;10507;10510;10511;10514;10517;10518;10519;10520;10521;10522;10523;10526;10527;10528;10530;10532;10533;10535;10536;10538;10540;10543;10545;10546;10547;10548;10549;10560;10562;10566;10567;10570;10571;10572;10573;10576;10577;10578;10580;10583;10587;10588;10589;10590;10591;10594;10595;10596;10597;10598;10604;10706;10707;10708;10709;10803', 7.3750, 'New York Sales Tax (Westchester County)', 'false', 1),
(11, 43, 'postcode', '14424;14425;14432;14443;14453;14456;14461;14463;14469;14471;14475;14504;14512;14518;14532;14537;14547;14548;14561;14564;14585', 7.5000, 'New York Sales Tax (Ontario County)', 'false', 1),
(12, 43, 'postcode', '12019;12020;12027;12065;12074;12108;12118;12139;12148;12151;12164;12170;12188;12190;12801;12803;12804;12808;12809;12810;12811;12812;12814;12815;12816;12817;12819;12820;12821;12822;12823;12824;12827;12828;12831;12832;12833;12834;12835;12836;12837;12838;12839;12841;12842;12843;12844;12845;12846;12847;12848;12849;12850;12853;12854;12856;12859;12860;12861;12862;12863;12864;12865;12866;12871;12873;12874;12878;12884;12885;12886;12887;12922;12927;12949;12965;12967;12973;13353;13360;13436;13613;13614;13617;13621;13623;13625;13630;13633;13635;13639;13642;13645;13646;13647;13649;13652;13654;13658;13660;13662;13664;13666;13667;13668;13669;13670;13672;13676;13677;13678;13680;13681;13683;13684;13687;13690;13694;13695;13696;13697;13699', 7.0000, 'New York Sales Tax (Hamilton Co., St. Lawrence Co., Saratoga Co., Warren Co., Washington Co.)', 'false', 1);
LadyHLG have you had any progress with 1.3.9 and this mod? As I am rebuilding our site and have been using the the local taxes very successfully on my 1.3.7 site but I need to upgrade to 1.3.9 ASAP.
Thank you in advance.
supersnow & others,
I apologize for my lack of attention to this thread of late. But the new job leaves me very little time for work on personal development projects like this one.
I have begun work on 1.3.9 version of this, but the changes from 1.3.8 to 1.3.9 are significant enough that I really need to get more familiar with 1.3.9 before I can proceed.
I haven't given up on it and plan to devote some time to this today, after which I will give you all an update on the progress tonight or tomorrow.
LadyHLG
Hey Zenners,
I am getting close to have the Local Sales Tax Mod for 1.3.9 ready.
Would there be any takers out there that would like to do some beta testing on the mod for me? I just dont have enough free time to do all the testing myself.
Please send me a PM if you are interested.
Thanks
LadyHLG
I am using ZenCart v1.3.9f and I believe I have Local Sales Tax Mod v2.0a (How do I tell?), I would like to upgrade to the 2.4 version so I can install the Tax Exempt patch. Should I do new install? If the add-on makes changes to my database, I want to ensure that that will not causes a problem to do it a second time.
Thanks for the update LadyHLG. Your the best!
Let me know when you are ready. I am working on a new install as I will be merging my active store into this new install once I have everything working. We did want to go live next week.
I have a customer Tax exempt module installed, COWOA and dual pricing. So I am not sure if I am a good candidate.
What files are affected? and I will see how much merging I will need to do.
Thanks again for the update!
I will try to get the files to you after the holiday weekend.
I have not set this up to work with the tax exempt mod yet. I wanted to be sure it works with the new version of zen before I made any modifications beyond that.
Have a good Thanksgiving Everyone!
LadyHLG
I have searched far a wide for this. Has this been addressed? Discount coupons work great for customers outside of WA state but local customers don't get to view the discount coupon.Quote:
Originally Posted by kramergutt
It looks like this question didn't get answered. Or my searches aren't returning the answer.
I have a CyberMonday $20.00 off coupon code... and a few local customers calling our office.
jasmel (kramergutt if you are still out there),
I'm sorry I never saw this post!
So I have to start by asking the obvious question, have you tried adjusting the sort order of the coupons and the local tax?
LadyHLG
Sub-Total: $37.85Quote:
Originally Posted by LadyHLG
Discount Coupon: JMMCYBER20 : -$20.00
Free Shipping Options (Free USPS First-Class Mail (Domestic or International)): $0.00
Local sales tax: $1.16
98208-4368 Local Tax 1.80%: $0.68
Total: $39.69
(I guess they get to "view" it but not see the discount being applied to their cart)
It looks like I have the coupon code before the shipping and the tax info.
I haven't tried moving it around. Would you suggest having the coupon be placed after taxes?
*coupon code only good today.. so if anybody happens to come across it (no big deal)
Jasmel,
Unfortunately, I cant tell you for sure what may or may not work. Sometimes its trial and error.
Different options will have different results.
LadyHLG
I experimented and moved the coupon code to after the taxes and all worked as expected.
See text checkout summary:
Sub-Total : $32.85
Free Shipping Options (Free USPS First-Class Mail (Domestic or International)): $0.00
Local sales tax:$2.13
98271-8848 Local Tax 2.10%: $0.69
Discount Coupon: JMMCYBER20 : -$20.00
Total : $13.95
Is it better to give discount pre-tax or after tax? Example... lets say it was a % discount.
Hmmm... I will go this way for now. Less phone calls! :clap:
First off thanks for this mod. My taxes are totaling correctly but it is blank before the colon. I've read a few posts that said I had to fill out the description under locations/taxes-->local sales taxes and change the description there. I have done that and it still does not show up. Any help would be appreciated. Thanks.
engagemedia,
I will need more information before I can help.
What version of the mod do you have? What version of zen are you using?
LadyHLG
I have the Sales tax Mod installed. Tax calculates correctly by zipcode but displays all 2262 matching records. I have the NYS only table set up from the Three New York State table choices. NY ID is 194 in my setup. Not sure how to correct the display. Below is a partial copy and paste from the Step 2 page.
Step 2 of 3 - Payment Information
Billing Address:
Change Address
RC Tonewoods
Robert Cefalu
1109 Military Rd
Kenmore, NY 14217
United States
Your billing address is shown to the left. The billing address should match the address on your credit card statement. You can change the billing address by clicking the Change Address button.
Your Total Local Tax Rec ID: 1
Tax Name: - .00
Local Tax Rec ID: 2
Tax Name: - .00
Local Tax Rec ID: 2260
Tax Name: 14217 Sales Tax 8.75% - 8.939
Local Tax Rec ID: 2261
Tax Name: 14217 Sales Tax 8.75% - 8.939
Local Tax Rec ID: 2262
Tax Name: 14217 Sales Tax 8.75% - 8.939
Tax based on customer shipping zone 194
2262 matching tax zones found
$92.00
Sub-Total:
$111.10
Total:
$10.16
United Parcel Service (1 x 6.00lbs) (Ground):
$8.94
14217 Sales Tax 8.75%:
I'm sorry are you talking about the all of that extra output? You can turn that off, its the debugging, its under the Admin Order
Totals Local Tax Mod.
LadyHLG
Ok...here's my problem! The module is calculating and working just fine. The problem is in the checkout process. I'm getting what looks like debugging info in the upper right of the page at the checkout page. It's also throwing off the CSS for the page.
And then when i complete the order, there is NO confirmation page, yet that similar debugging code is listed on that page. But the order is complete since I get an email notification and the card is hit.
Can anyone help?
I can supply screenshots if you need. Thanks!
Nevermind! I figured it out. In Modules > Order Total > Local Sales Tax there's a debug option. Turned it off and we're good!
Hi, LadyHLG,Quote:
Originally Posted by LadyHLG
I totally understand "haven't had time" and "paying job comes first." Thank you for the time you have been able to put toward this. I notice you sometimes have to answer the same question multiple times.
I am NOT the IT person here. I am gathering the data he needs to get sales tax up and running. We are using ZC 1.3.9d. He has downloaded the 'h' update but not gotten it up yet.
I am wondering if I have missed something. do you have the Local Sales Tax Module out for this version and I missed it? And have you yet had time to work on getting it to work with the Customer Tax Exempt module that you referenced a few posts before the one I just quoted.
I need to give the IT specific directions. Where do I find these modules if you have finished them?
Thank you,
DebraM
Hey Zenners,
I have uploaded version 2.5 of the local tax mod. When/if it is approved it can be downloaded from the addons section here.
This download will include both a full version and an upgrade, as well as compatibility files for the customer exempt mod.
PLEASE READ THE README FILE INCLUDED WITH THE MOD. I cant stress this enough!!
If you have an urgent need for the mod and can not wait for it to be added to the downloads section, please send me a PM and include an email address where you would like the mod sent to.
Finally, this version had been through limited testing, it does not overwrite any core files but as always back-up things before installing.
Happy New Year!
LadyHLG
Hello and thank you for providing us with this.
I thought I had to start writing if else statements.
For test purposes I have read the file and followed to steps to create the following for 2 different counties:
Zone
Zone definition
Tax class
Tax rate
The one issue I have is that when I try to add a test product the "Tax Class" list show multiple choices to choose from... or
if I set one tax class all the tax rates are added up making the sales tax double the cost of the goods.
Where can I find complete info on how to set this up so when a customer logs in and wants to buy the goods from their county the correct tax rate is selected automatically?
What steps am I missing? :frusty:
Thank you for your time.
Ohh and happy New Year!
:oops: Ohh wait I think I figured it out.
It seems to be working now.
I was using a customer account who's address was wrong... I had to edit the address after installing the Mod in order for it to read to correct address and apply the proper sales tax.
Thank you again for everything you have done.
BRAVO!:bigups:
Happy New Year!:laugh:
Glad to hear you figured things out.
LadyHLG
Hi, Lady HLG,
Thank you for all your work.
I was lookin through the addons for your up date and also for the "Customer Exempt' module by Numinix that you mentioned. I stumbled on "State Sales Tax Lookup" by TaxCloud. Went to their Site & to Streamlined because eventually we will want a Service. I think that the states will soon get their acts together & we will have to collect and remit sales tax to them all. We had been looking at Avalara.
Do you know anythin about this TaxCloud Service? Right now we only have NEXUS for Nebraska. We will probablly go with your mod now. But we need to look at the future. Too many jurisdictions not to use a service once we have to collect out of state.
Thank you again.
Debra
Hi Debra,
I only recently found out about the Tax Cloud myself. I haven't had the time to investigate it much, but it looks very promising. I too had looked at Avalara quite some time ago, but the cost was ridiculous for a small business. I can only hope that Tax Cloud remains free or low cost otherwise it will be just like Avalara.
Ultimately, it would be nice if my mod became obsolete and everyone could move over to the Tax Cloud method.
My suggestion is to really take a look through their site and maybe set up a test site and try out the mod and see how it works.
If you do, drop us a note and let us know how it goes.
Good Luck,
LadyHLG
Hello everyone.
I thought I would post a reply here since I have just recently completed an integration of TaxCloud into Zen Cart. The integration is installed as a "module" and configured through the admin console.
We are working on integrations with popular shopping carts to make it easier for people to get started using our free services. I still need to create an official post making this available to everyone but I thought I would give you a "heads up" here since there was some interest.
More info can be found here: http://dev.taxcloud.net/
Let me know if you have any questions.
Thanks LadyHLG for all your work. It works great on 1.3.9h and the version you sent me works great with dual pricing too! You are the best!!
Just downloaded the latest version of Zencart and need some tax help...
in KS we have to collect sales tax based on the city. I downloaded this Local Sales Tax mod, installed it, and started to enter a couple of cities and their tax rate.
The problem is, for every entry I have in the Local Sales Tax I get an output entry when checking out AND it will duplicate the tax value of the correct tax.
Example:
I currently have 3 local tax rates setup (one for three different cities) Leawood, Abbyville, and Abilene.
Item costs $10
I have my shipping address set to Leawood (city).
At checkout I get:
Sub-Total: $10
Per Item (Best Way): $2.50
Leawood Sales Tax: $0.90
Abilene Sales Tax: $0.90
Abbyville Sales Tax: $0.90
Total: $15.21
If I change the shipping address to Abilene then Leawood Sales Tax shows $0 but both Abilene and Abbyville are filled in with the abilene tax rate.
What am I missing?
With billing and shipping set to Abilene here is the debug output...
Taxing based on: Shipping
Taxing For Zone: 26
Local Tax For: Leawood
Total Tax =
test product - 10
Abilene Sales Tax - 0.815 @ 8.15
10.815
Abilene Sales TaxTotal Tax = 0.815
Abilene Sales TaxTotal Tax = 0.815
And the checkout looks like this:
Sub-Total: $10.00
Per Item (Best Way): $2.50
Leawood Sales Tax: $0.00
Abilene Sales Tax: $0.82
Abbyville Sales Tax: $0.82
Total: $14.13
If I'm entering 798 city tax rates I can't possibly have all 798 of them listed during checkout, let alone applying the incorrect tax. Hope I just missed something simple.
I read the readme file and everything else I could find. I'm lost.
thanks
I set mine up on a county level then if you have to collect an additional for a particular city then you would set the city tax on its own. So for me I have Los Angeles county so I chose zipcode as the basis for the sales tax then in the delimited list I put something like this (this is only a fraction of the zipcode but you get the idea):
Then I put the county tax rate of 1.50Quote:
90001;90002;90003;90004;90005;90006;90007;90008;90009;90010;90011;90012;90013;90 014;90015;90016;90017;90018;90019;90020;90021;90022;90023;90024;90025;90026;9002 7;90028;90029;90030;90031;90032;90033;90034;90035;
If you have to collect an addition amount for a particular city then you would set this particular city as its own - but make sure the zipcodes for this city is in the county level too! That way they add together to get the correct amount.
So then it would display the county tax then under it would be the city tax.
This worked for me!
Hope this helps.
Lady HLG - my local sales tax is not showing up at all - it doesn't matter if the person is tax exempt or not.
I am not sure why this is happening - it is so bizarre that it is just stopped even working.
HELP!:cry:
supersnow,
If the tax has suddenly stopped showing up I guess the obvious first question is have you made any recent changes that might be causing problems?
CMJohn,
My first suggestion would be to check your tax settings, look under Configuration -> My Store -> Basis of Product Tax is this set to shipping, billing or store? If you are taxing based on the ship to city then it should be shipping.
LadyHLG