Standard VAT trouble.

[Stefank]

Hello

 

I would like to find a way to add standard Vat to all products in a shop. Similar to the problem explained in this topic:

http://www.prestashop.com/forums/topic/202105-change-selected-tax-rule-in-backoffice/?&p=999240&do=findComment&comment=999240

 

In the topic betyonfire provides a piece of code that when insert to the file chooses the standard VAT on all products and that sorta Works...

 

The problem is though that even though every item now has the right VAT chosen when clicking on the individual item it isnt calculated. In the attached Picture it can be seen that the VAT is calculated to £75 but on the category page the base porice and total Price is still £60.

 

If I open the item and press save then the total Price changes to £75 in the category page aswell and that will also make the VAT active for that item in the front office.

Is there any way to make that "save" click active to all the products?

 

Thanks in advance.

 

 

[tuk66]

What is your version of PrestaShop? Are you using multi-shop feature?

[Stefank]

It is 1.5.6.

No I dont use that.

[tuk66]

Can you check database tables ps_product and ps_product_shop, especially fields price and id_tax_rules_group for a product before and after saving?

 

Differences in the tables can help to find a SQL query to fix that.

[Stefank]

That was some very usable advice... Thank you.

 

In ps_product the id_tax_rules_group was set to 53 for all products ( the right number).

 

In ps_product_shop the value was 0. When I do a save for an item it changes to 53.

 

I assume that I can get my import program changed to set this value and my problem will then be solved.

 

I do wonder though, why no one else who has used this piece of code havent had this issue?

[tuk66]

Usually when something doesn't work people just let it be.