TAX Question... Please help !

[signprint]

Hi to all !

I have a zencart installation Zen Cart 1.3.8a, and have recently gone VAT registered.

I have all the TAX/VAT setup and working fine on new products that i add. But for my 5000 old products, is there a way of updating the "Tax Class" for each product, without manually editing each one ?? As all the old products are set as "Tax Class" 'none'.


Steve

[Absolute]

Run a quick SQL patch in Tools >> Install SQL Patches.

YOU MUST BACKUP YOUR DATABASE BEFORE RUNNING THIS PATCH

update products set products_tax_class_id = '1';

You MUST ensure you replace the 1 with the actual tax class ID. This can be found in Locations/Taxes >> Tax Classes. Use the ID on the left of the relevant tax class.

Absolute

[Absolute]

PS - Obviously this updates ALL products within your database! If you want to only do selected items, then these need to be done either one at a time, or using the EasyPopulate routine, and then use excel or similar to update the exported file, before re-importing all the products.

Absolute

[signprint]

Yup, thats exactly what i want to do !!!

Thanx a million !

Best Regards,

Steve

[signprint]

Thanks for your help, VAT is now being calculated in the total shown to the customer on checkout, but it doesn't display "VAT" and the amount, just adds it up invisibly.

Any ideas ?

Kind Regards,
Steve

[signprint]

Please ignore me, i didn't have "Order Tax" installed in the Order Total modules !

doh.

fixed now.

Thanks once again.

[MagicMan]

Hi Folks,

I do not know what VAT is but I am now running into the mess of dealing with taxes. Particularly in MA, FL, NY and CA. I have been absorbing the taxes till now but need to start charging customers tax for these states.

I tried setting up taxes but it listed all the states on the checkout page not just for the ship to address state.

Also, how can we break down the tax rates to each county level?

Lastly, is there a way for a Tax Exempt customer to enter a code to bypass sales tax upon checkout?

Thank you so much.

Dr. Byte or another Admin, would you be kind enough to list some thread links to newbie's just beginning with the whole tax thing?

[Absolute]

You will need to look up details of how to use Tax Zones. there is a whole host of information on how to use EVERY section of Zen hidden behind the Wiki Link at the top of support site. Take a look at http://www.zen-cart.com/wiki/index.p...es_Definitions and the relecant links from this page. That should point you in the right direction.

As for VAT, it is the name given to the tax on goods in the UK. (Value Added Tax)

Good luck,

Absolute

[MagicMan]

Thanks for the info. This is the first time that I saw the Wiki. Pretty cool. I will have to play around with the tax thing in my demo site to get it working before going live with it. What a pain. Oh well.