Products not showing Tax

[Munt]

I dont know whats happened ... I can't get the system to display products with tax or to get the tax to calculate on checkout .... I'm sure it was working at some point ... perhaps a database issue.

I would be massively appreciative if someone could help me out ... I'm at my wits end.

Just let me know any details you need to help me diagnose the problem.

Thanks folks

[Munt]

It's working now ... here's what I did. EDIT Not working

• I restored my database from an earlier version (Tax tables might have been fubared)
• added customer groups (i forgot to add them this time round)
• made sure they were not tax exempt
• selected display taxes in customer groups
• and the same in the main site configuration
• Changed all products to Taxable Items

Made this to easily change all products with SQL

update products set products_tax_class_id = replace(products_tax_class_id,'0','1');
update products set products_tax_class_id = replace(products_tax_class_id,'2','1');

Hope this helps someone

[Munt]

OK ... now customers sign they can see the prices with tax.

when they create an account they can still see the products with tax

however when they log out and in again they do not have tax applied.

Maybe assigning users to a customer group automatically when they sign in could fix this ?

Any ideas ?

Live Store

[Munt]

As I think it possibly could be a database problem from the switch over from OsC here's a few snippets of the database.

default user account:

• (128, 0, '', 'Firstname', 'Munt', '0000-00-00 00:00:00', 'r-----@----.com', 144, '23456789', '', '---------', '1', 0, NULL, 'Retail', 0, '0', '', '');
  
  the retail is added automatically but isnt the user group (i think)

customer group

• 1 Retail 1 0

and my tax class

• 2 Taxable Item Any taxable item 2010-07-02 20:45:23 2010-07-02 20:45:23

tax rates

• 2 2 1 1 17.5000 Vat @ 17.5% 2010-07-15 00:04:00 2010-07-03 04:18:58

configuration values

• 17 Tax Decimal Places TAX_DECIMAL_PLACES 2 Pad the tax value this amount of decimal places 1 20 2010-08-18 23:42:32 2010-07-02 20:45:23 NULL NULL
• 18 Display Prices with Tax DISPLAY_PRICE_WITH_TAX true Display prices with tax included (true) or add the tax at the end (false) 1 21 2010-08-18 14:42:09 2010-07-02 20:45:23 NULL tep_cfg_select_option(array('true', 'false'),

[Munt]

Sorry for the excessive posts ... Perhaps the hack I mentioned in Specials & Customer Group Problem fixes my issue for now (Adding a customer group with an ID of 0 not tax exempt and displaying taxes). I haven't been emptying my browser cache after all DB edits. So I can't be sure what worked and what didn't.

4 Days non stop on this ... I think I better give it a rest for tonight before I break it anymore