Local Sales Tax Mod (with admin!) for testing

As long as you downloaded the most current version from the downloads then you should have the right file. I forgot to change the version number in the file names.
The problem you ran into is a result of the use of a table prefix. Some people choose to use them some do not. If you use the zencart admin to upload the sql patch then it will automatically create the prefix when it creates the table. If, however, you run the sql patch directly outside of the cart then you have to change the table name in the sql file or once the table has been created.

From experience sql patches dont always work the way you expect. Sometimes they run without trouble sometimes you can't run them through the cart.

Just be sure to test things out as much as possible and be sure to back things up whenever you run patches.

LadyHLG

jaylyns:

Please help!!!! I uploaded all the files and tried to run the sql file patch and it said failed. What do I do now? Don't even know where to begin. Tried to upload the files again same error. Could it be because of the override system or customer template? Please help me get this working.

My site is https://www.jaylyns.com. Warning: this site sells products of adult nature.

Thanks for anyone's help.

LadyHLG,

I am having the same problem on a new install. The "Local" feature is not appearing. I am using the Zen Install SQL, however, I am not sure how to make the changes you referred to in your reply to the above inquiry regarding the SQL failure.

Thank You

David

I'm sorry I'm not sure what you mean. Are you saying the sql file failed or are you seeing a specific error?

LadyHLG

LadyHLG,

Sorry for the obscure message. I have uploaded all of the files. However the SQL script failed. There is nothing about local taxes under Admin > Modules > Order Total. There is a link under Admin > Locations/Taxes >"Local Taxes", but it is not populated. It has the following message:

1146 Table 'theladybu_data.tax_rates_local' doesn't exist
in:
[select count(*) as total FROM (tax_rates_local st LEFT JOIN tax_class tc ON st.local_tax_class_id = tc.tax_class_id) LEFT JOIN zones z ON st.zone_id = z.zone_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Is this a result of the SQL failure?

David

Ok, I see.
Instead of trying to upload the sql file, open it and copy everything inside.
Then go to the install sql patches in the admin and paste the sql code in the large text box and try to run it that way.
Sometimes that works when the upload doesnt.

LadyHLG

LadyHLG:

Ok, I see.
Instead of trying to upload the sql file, open it and copy everything inside.
Then go to the install sql patches in the admin and paste the sql code in the large text box and try to run it that way.
Sometimes that works when the upload doesnt.

LadyHLG

This is exactly what I am trying to do. When I hit "send" it gives me a "Failed!" message in the very top of the window highlighted in fusia. I'm running 1.3.8a. This is what I a pasting:

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)
)

Have I missed something?:wacko:

David

If neither uploading the file or pasting it directly into the admin will work then you have to create the table manually via whatever mysql client you have. If you create the table this way then dont forget to change the table name in the sql statement to include your table prefix if you have one for your cart set up.

LadyHLG

EUREKA!!!

:frusty: After two days, I have found out what the problem was:

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)
)

Notice how it doesn't end with a ";" as mentioned on the Install SQL page.

Something so simple has driven me nuts. LOL!!!

Glad to hear you found the solution!

LadyHLG

IS there a way to pass the local and state taxes as a single item to paypal or google checkout? Everything calculates fine until I get to the google checkout page and the only tax it recognizes is the state tax. PayPal has the same issue. Did I miss something?

Thanx

tallen,
The short answer to your question is no, or at least I don't think so.
I wish I could offer more in the way of help, but the truth is I can't.

For google, if I understand it correctly, all your tax rules have to passed to google, when you consider all the local taxes, zone taxes, and tax classes, this is not as simple as it seems, especially if google does not compound taxes, but selects only one tax to charge(I'm really not even sure of this).

As for paypal, there are actually 3 different paypal payment options, so I would guess the possibilities for passing sales tax to paypal would depend on which paypal payment option you are using.

As I said I wish I could offer more help, but I just dont have a strong enough understanding of any of these payment options to even attempt this.

LadyHLG

hello guys
if this has not been done...
I added ability to enter a zip list.
The only file I modified is \includes\modules\order_total\ot_local_sales_taxes.php
All my changes are noted by //=====
I tested on my site and it worked.
I added some comment in the readme file.

LadyHLG, please take a look at the code. if you like, please put it in the download area.

guqian,
Thanks for the contribution!
I have submitted the update to the downloads section and it should be available shortly.

LadyHLG

I am new to Zen Cart and am thrilled to find this mod, as it is exactly what I need for Ohio.

I noticed it says it is for use with version 1.3.7; will it be okay to use it with version 1.3.8?

Denyse

I apologize in advance for such a basic question --

The instructions say to copy all thefiles inside the catalog folder to my cart. Is that via my FTP to the main store folder, or to one of the folders under that like, admin or includes, etc.

I haven't uploaded anything yet, so this answer may be self explanatory once I do..... it says to run the LocalSalesTaxv2.0.sql file....will that appear in the zen cart admin area or where do I run it from?

Denyse
an obvious newby

itsdenyse,

Yes, the mod is ok for use with version 1.3.8.

As for the upload of the files, if you look in the catalog folder of the download you will see two folders "admin" and "includes" these correspond to the "admin" and "include" folders in main the zen cart folder. Does that make sense?

You should be able to just upload both folders via ftp the mod does not overwrite any of the existing files.

To update the sql in the cart admin go to Tools -> Install SQL Patches
From there you can either upload the sql file or copy and paste the contents of the file.

Good Luck,
LadyHLG

Yes, that makes sense. Thanks for such a quick reply, it is greatly appreciated! I will go try it now :smile:

I just tried to run the sql, and I got this message:

NOTE: Zen Cart database-upgrade scripts should NOT be run from this page.
Please upload the new zc_install folder and run the upgrade from there instead for better reliability.

I'll see if I can find the new zc_install folder.

It looks like the copy paste thing worked.

What exactly does it mean to have debugging active or inactive? Which should I select?

Thanks for your help! Everything worked perfectly.

Well, except for the state of Ohio where I am based. I didn't realize how many zip codes overlapped counties.

Is there a module in the works that allows for people to enter the county the item is being shipped to?