Tax isn't working on my site

[holliej0]

Hi,

I want a 7% tax applied to a checkout order if the item is being delivered to New Jersey. All other states should have no tax. For some reason, it's not getting applied to a NJ order. I am offering free shipping on all orders so I have no carrier set up and was wondering if that's the issue? I don't want to set up a carrier but want to make sure the tax can still work. Here is my site:

 

http://shedtheeclectichome.com/

 

Thanks.

 

 

[bellini13]

you need to confirm that you have a tax rate and a tax rule configured properly.  You also need to confirm that your products are configured to use that tax rule.

 

perhaps take some screen shots of these various configurations and attach to the post

[holliej0]

Ah, figured it out - it was because the products weren't configured to use that tax rule. Thanks!

[Sensorycritters]

Hi,

I want a 7% tax applied to a checkout order if the item is being delivered to Indiana. All other states should have no tax. For some reason, it's not getting applied to a IN order. I transferred 1520 items thats to many to change by hand. I can make a tax rule and change on each product. Please help! I'm using 1.5.6.1

[bellini13]

I assume you have already create a tax rate and a tax rule for IN that implements the rate?  I also assume you have enabled taxes and defined that taxes should be applied based on delivery address?

 

Lastly I will assume that you did not edit each product so that it uses this tax rule?

 

If my assumptions are all true, then please provide me with the ID that is associated to your IN Tax rule.  Navigate to your Localization | Tax Rules section, and provide me the ID number located on the left of the tax rule.

 

I will then provide you a sql query that you can use to update all of your products.

[Sensorycritters]

Hi

Here is the information you ask for.

The ID that is associated with IN Tax : 70
The ID that is associated with IN Tax rule:70
So both have a ID of 70.

 

Thank you for your quick repy.

[bellini13]

Execute the following SQL query using phpmyadmin, and it will update all of your products to use the same Tax Rule.  This should work on both PS 1.5 and 1.4

UPDATE `ps_product` SET `id_tax_rules_group` = '70'
UPDATE `ps_product_shop` SET `id_tax_rules_group` = '70'

Edit 12/16: Updated to include multistore table

Edited December 16, 2013 by bellini13 (see edit history)

[aiynoon]

Hi Bellini13, 

 

I have some issues with the tax not showing as my products are loaded automatically.  Going to each product and saving the option, "Sales Tax" is pretty time consuiming.  I executed your code in SQL query

UPDATE `ps_product` SET `id_tax_rules_group` = '56'

 

But for some reason, its still not updating in the store.  What could the reason be?    Please help!

[blackmiles]

Dear all,

I have a problem with tax rates (prestashop 1.5.6.1) as well. In the tax rules pages, there so no country below (see attach). Is it possible? Can be some problems with files?

 

Thanks

 

Stefano

[bellini13]

@blacksmiles, you need to add the tax rule using the + button on the top of the page

 

@aiynoon, sorry I don't know why.  perhaps you have a cache that needs to be cleared

[aiynoon]

@blacksmiles, you need to add the tax rule using the + button on the top of the page

 

@aiynoon, sorry I don't know why.  perhaps you have a cache that needs to be cleared

 

No Problem Bellini13.  I solved it.  Thanks!

Edited December 14, 2013 by aiynoon (see edit history)

[blackmiles]

Dear Bellini, many thanks, I didn't see it. Sorry.

Now it is working!! Thanks you so much!!

[Sensorycritters]

HI bellini13

 

Was just able to run the sql update UPDATE `ps_product` SET `id_tax_rules_group` = '70' and it did not work. In the database it shows that it added it to the database. All products still have no tax attached to them. Any suggestions?

Thank You again.

 

[aiynoon]

Sensorycritters,

 

You need to also update the ps_product_shop.

UPDATE `ps_product_shop` SET `id_tax_rules_group` = '70'

 

It worked for me. Always make sure you do backup before trying. 

Edited December 16, 2013 by aiynoon (see edit history)

[bellini13]

Ah, multistore always bites me in the butt.  Thanks aiynoon, good catch.  I['ll update my previous post for completeness