[Solved] Taxes are gone after update

[patrickvbw]

I've updated my shop from 1.2.5 to the latest version.

 

After update, all of my products have no taxes anymore, so all the prices are lowered.

 

The tax rules are enabled and applied, but in the product pages, it states no tax.

 

Is there a way to give every product 19%BTW (tax) without manually having to edit every single product?

 

Perhaps through a database query?

 

Thanks for any answers!

[bellini13]

taxes are managed very differently in v1.4. i would start with looking at your customer groups, and confirming how taxes are applied.

[patrickvbw]

The tax lines and rates are all set correctly. But at the products, taxes are not applied anymore. It now has 0 tax enabled.

 

So my main question: How do i change the taxes for every product in 1 blow.

[bellini13]

the ps_product table has a column named "id_tax_rules_group". i suppose if you know the id for the tax rule, you could set this value for all your products in a single update statement

[patrickvbw]

Thanks,

 

And what would the update sentence be?

 

tax id is 2, currently all of them are on 0.

[patrickvbw]

nevermind, it worked!

 

Thanks for the help.

[jennybeaumont]

heya - would you mind sharing that line of code please? thnx!

[jennybeaumont]

nevermind, figured it out too!