Local Sales Tax Mod (with admin!) for testing

[LadyHLG]

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

[hardtokill]

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

[LadyHLG]

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

[hardtokill]

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

[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

[hardtokill]

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?

David

[LadyHLG]

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

[hardtokill]

EUREKA!!!

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

[LadyHLG]

Glad to hear you found the solution!

LadyHLG

[tallen]

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