Cart not adding tax

[LinuxChick]

I know the whole "tax" topic has probably been beat to death, I've searched the forums, to no avail, trying to find an answer.

If I set it to "not show tax in price" it does not add tax on the invoice during checkout. I know it is capable of calculation tax, because it will if I tell it to show products with tax included....

My store is Canadian and I have all the tax zones set up.

I've tried a couple addons dealing with Canadian taxes, but those didn't seem to help my problem either.

 

Any help is greatly appreciated, I need to get this store working asap .... I know, I know, who doesn't! Right? :blush:

Thank you in advance.

[LinuxChick]

Alright, I worked on this more last night. Now I have the Tax percentage showing on the invoice PST & GST together as 10% but there is no tax added to the order...

 

 

I followed the Contribution Document for setting up Canadian taxes before, the only thing I changed last night was switching the priority from 1 to 0 in Locations/Taxes/Rates..

Show Tax is set to "True" in Modules/Order Totals...

 

I'm sure it's nothing big, but I can't seem to find the problem...

[LinuxChick]

I thought it might help to show how my tax zones, classes and rates are set up:

 

 

 

 

 

 

 

 

 

[LinuxChick]

Someone? Anyone? Please..

[Guest]

Someone? Anyone? Please..

 

Hi LinuxChick, readers everywhere ... :blink:

My client's site had this problem as well. For a number of reasons, the testing of the site did not go as far as actually

purchasing items to check the invoicing. :blush: When we got a payments module working =(8^D), we found that the

invoices were completely without VAT tax. :angry: [VAT is a UK purchase tax, it's a tax only applicable to UK buys].

 

I looked at the tables mentioned in this thread, rates and zones and so on, and all looked pukka at GBR GB VAT 15%.

Settings all looked ok but my request to the hosting co for code support was rebuffed with 'check your config and SQL'

so I moved on from inspecting (the few) configuration settings to examine the content of table 'products'. <_<

 

Here is the table definition and the INSERT of data as an example, with bold emphasis on the relevant field/datum.

CREATE TABLE `products` (

`products_id` int(11) NOT NULL auto_increment,

`products_quantity` int(4) NOT NULL,

`products_model` varchar(12) default NULL,

`products_image` varchar(64) default NULL,

`products_price` decimal(15,4) NOT NULL,

`products_date_added` datetime NOT NULL,

`products_last_modified` datetime default NULL,

`products_date_available` datetime default NULL,

`products_weight` decimal(5,2) NOT NULL,

`products_status` tinyint(1) NOT NULL,

`products_tax_class_id` int(11) NOT NULL,

`manufacturers_id` int(11) default NULL,

`products_ordered` int(11) NOT NULL default '0',

PRIMARY KEY (`products_id`),

KEY `idx_products_date_added` (`products_date_added`)

) ENGINE=MyISAM AUTO_INCREMENT=318 DEFAULT CHARSET=latin1;

 

INSERT INTO `products` (`products_id`,`products_quantity`,`products_model`,`products_image`,`products_price`,`products_date_added`,

`products_last_modified`,`products_date_available`,`products_weight`,`products_status`,`products_tax_class_id`,

`manufacturers_id`,`products_ordered`)

VALUES (143,100,'Micro 1','prod_91.jpg',1.86,'2006-10-16 22:21:00','2008-06-24 13:58:31','2008-06-24 13:58:31',0,1,0,NULL,0);

 

This field has to reflect the id of the tax class records you set up in the admin section. This connects it to those values and when the product is processed through an order it pulls in the correct rate. Leave this field set to zero and you don't connect to any tax rate so no tax is computed at all. Which is fair enough, up to a point ... :unsure:

 

I had no understanding as to the use and necessity of this field when working on the site, because I was working on large chunks of raw tables data that had been exported and reformatted from the old site, rather than being entered gradually through the OSCommerce customer interface. Using that to change things would have been waaay to slow!.

 

But, for you, it will work the magic you need ... :wub:

 

If you use the OSCommerce interface you can drill down into Products and when you reach the item(s) use Edit and there will be a drop down list for tax class. Drop down the one you have configured and select it to associate the product with the tax class.

 

Ta-Da? I hope it works for you. B)

 

It's obvious that if you are selling to different locales and so have to apply different tax classes then this setting within product data might not be the best way to work out the tax class, because it's product specific and not customer location specific. But I don't understand the data model of this thing well enough to advise on side effects. I think I would make adjustments prior to shipping and email the client accordingly instead of making this edifice more complicated.

 

Good luck!

Steve Morris.