That solved the issue. Thanks so much for your help LadyHLG!
Printable View
psychicpet + LadyHLG
Have prev done taxes via zip with a hack/mod but since Ca update in 2009 I wanted a easy way to make these changes as our taxes will surely go up again:yuck:
Am trying to do the same thing here "counties as zones" setup for California and realize thats alot of work to do this, well over 1000+ records to do. I was hoping there would be a SQL file to just add this to the database..... :no:
So if anyone has something already setup that can share that would be great, if not if LadyHLG has a starter script for adding these zones to SQL I could start creating the script(s).
Needed for SQL script(s) is;
- Zone for each county in California
- Zone definition for each county
- Adding the details for each definition
- Tax rate for each county
Let me know if I left out anything as I'm sure theres more to this than a few SQL scripts.
Thanks in advance for any help that is offered:flex:
Unfortunately there is no starter script for this, at least not by me. There are a lot of CA business out there using zen and it certainly is possible that someone has already done a counties as zone set up, its all a matter of finding someone who would share it.
Wish I could be of more help!
Something tells me that once its done you will have quite a few others asking for it as well.
LadyHLG
Sounds like this mod is exactly what I need!
I'm a newbie so I'm clueless on how to install this as stated: Copy all files inside the catalog folder to your cart.
Thanks in advance!
If possible I just need specific instructions on where to go and how to install this mod please. Thanks!
I uploaded to files through ftp at my host but I'm not sure if I put them in the write folders.
I did get the sql patch to work by adding ; as stated earlier in this thread.
So the folders must not be in the right spot because nothing is showing in the admin.
Help please.
First make sure you have both version 2.2 and 2.3. Version 2.3 is only an upgrade to version 2.2.
Unzip the version 2.2 files.
Open the folder called "fullversion". Inside you should see a folder called "catalog" and another folder called sqlfiles. You can ignore everything in the folder called "upgrade". Those files are only for people who have already installed previous versions of the mod.
Open the catalog folder and copy everything in that folder (NOT THE CATALOG FOLDER, JUST WHAT IS INSIDE) over to the root directory of your zencart.
Log into your cart admin and go to Tools->Install SQL Patches
Click the Browse button on the the Install SQL Patches Page and go the the sqlfiles folder, inside that is another folder called NewInstall with a file inside called "LocalSalesTaxv2.2.sql." Select it and then click the UPLOAD button.
Once the sql file has been installed you can then open the 2.3 version, open the catalog folder and copy everything in that folder over to the root directory of your zencart (it will overwrite some of the version 2.2 files but that is ok).
From there just follow the rest of the instructions in the README.html file on how to set up and use the module.
Good Luck
LadyHLG
Thank you for the reply, but this is what I'm confused about, sorry,
Open the catalog folder and copy everything in that folder (NOT THE CATALOG FOLDER, JUST WHAT IS INSIDE) over to the root directory of your zencart.
How do i do the above and what is the root folder?
Its the folder where you zencart files are, it all depends on how you installed the cart.
example
If you put your cart files in a folder called store, then the website address for those files would be www.mysite.com/store
This means that "store" is the root folder of cart files.
Does that make sense?
LadyHLG
Yes that is what mine is "store"
And inside that is multiple folders starting with admin and so on, but it also has an includes.
So do I upload your admin to my main admin? Your includes to my includes or the includes in the main admin?
LOL very confusing to me, Believe me I'm trying though.