Jump to content

Where is the VAT ID stored(sending orders from PS to ERP) [SOLVED]


mk2-pronat

Recommended Posts

Hello,

I'm heaving trouble processing the order sent from PrestaShop to a ERP. Without going into to much detail, is there a place where PrestaShop stores the different VAT settings? Like if i create one VAT for 9% and another for 10% or 20% is there a specific ID created somewhere in PS database for the different VAT numbers?

The reason i'm asking is that they(the dev from ERP) said that the id of a new vat is different from some reason, but i only created a new one like before. 

I added an image of the VAT i'm talking about

VAT.jpg

Edited by mk2-pronat (see edit history)
Link to comment
Share on other sites

Yes it is, and you don't even need to create a new one. Every time you edit an existing tax rule, the ID changes.

In back office you can see all the ID's for different tax rules, and then tax rules are associated to products as id_tax_rules_group column in the ps_product database table.

Link to comment
Share on other sites

Thank you Daresh for your fast reply.

So i changed an old existing vat to the new percent  and created a new order, but it seems that the ERP prompts the same thing...

I've also noticed that whenever i edit an existing VAT and click save, it automatically ads a new ID to it in PrestaShop back-office as shown in the image i added. So how would i keep the same ID if every change creates a new one?

Screenshot 2025-08-04 143336.jpg

Link to comment
Share on other sites

18 hours ago, mk2-pronat said:

The reason i'm asking is that they(the dev from ERP) said that the id of a new vat is different from some reason,

It's the Prestashop functionality to generate the new ID on the update as well. So can't do anything on the same. 

Finalize the taxes on the Prestashop and then update the Tax ID on the ERP system, then use the same.

And whenever you make changes in the taxes, you need to sync the Tax ID on the ERP System

Link to comment
Share on other sites

  • mk2-pronat changed the title to Where is the VAT ID stored(sending orders from PS to ERP) [SOLVED]

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...