Canadian Taxes

Average Rating: 5
Description
This is the proper way to setup Canadian Taxes. V.1.0

Please choose the province in which you do business and run ONLY that SQL file. They have been separated and altered to be accurate as of July 1st 2012.

Either open and run in your Zen Cart Administration "Install SQL Patch" utility located under 'tools' or run in phpmyadmin.

PLEASE NOTE:

BACKUP YOUR DATABASE FIRST!

These SQL files will remove all existing taxes and zone definitions. It is assumed that you are downloading this module because your store taxes and zone definitions do not work anyway. It is purposely done this way to clean up the incorrect settings that would remain otherwise.

If you require additional zone definitions for shipping, you will need to add them in again after running this SQL file.

There is a chance that you may have set your products to a tax that may have had a different ID associated with it. In this case we have provided the below SQL statement to globally change all of your products to use the taxes that you are going to install.

So to be clear run this statement in admin->tools->install SQL patches after you run your Tax setup SQL:

UPDATE products SET products_tax_class_id=1;


Qdixon - Quentin Dixon
GeekHost.ca
+ Download Latest

Forum Support Thread

Submit An Updated Version
Zen Cart® Versions v1.3.9, v1.5.0
Original Author Qdixon
Last Updated by Qdixon - 14 Sep 2012
Downloads 651

Version History

Canadian Taxes   -   Version: 1.1
I uploaded the wrong Zip file previously and this is the correct one. Be sure the Zip you are using has a CRA pdf in it. If it does not you have the wrong zip.   + Download
Zen Cart® Versions v1.3.9, v1.5.0
Date Added 14 Sep 2012
Author Qdixon
File Size 769.1 KB
PHP 5.3 Safe? Yes
Downloads 530
 
Canadian Taxes   -   Version: 1.0
This is the proper way to setup Canadian Taxes. V.1.0

Please choose the province in which you do business and run ONLY that SQL file. They have been separated and altered to be accurate as of July 1st 2012.

Either open and run in your Zen Cart Administration "Install SQL Patch" utility located under 'tools' or run in phpmyadmin.

PLEASE NOTE:

BACKUP YOUR DATABASE FIRST!

These SQL files will remove all existing taxes and zone definitions. It is assumed that you are downloading this module because your store taxes and zone definitions do not work anyway. It is purposely done this way to clean up the incorrect settings that would remain otherwise.

If you require additional zone definitions for shipping, you will need to add them in again after running this SQL file.

There is a chance that you may have set your products to a tax that may have had a different ID associated with it. In this case we have provided the below SQL statement to globally change all of your products to use the taxes that you are going to install.

So to be clear run this statement after you run your Tax setup SQL.

UPDATE##products##SET##products_tax_class_id=1;


Qdixon - Quentin Dixon
GeekHost.ca
  + Download
Zen Cart® Versions
Date Added 6 Jul 2012
Author Qdixon
File Size 86.0 KB
PHP 5.3 Safe? No
Downloads 121
 


disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR