MySQL Key for price excluding TAX

[Baudrazor]

Hello,

I am using and testing PS for a while now and i have a script which i use with a cron job to update prices and stock. Now i have the following problem.

The import is working like a charm, except the salesprice including tax for me, is in PS the salesprice excluding tax. Because i have a 19% tax rate all my prices are 19% higer afterwards. I know you can use the backoffice the import a price excluding tax, but i cannot find the mysql key related tot that.

Below is part of the script i am using.(****** is my database name)

// update mysql accordingly
mysql_query("UPDATE `********`.`ps_product` SET `quantity` = '$prod_stock', `price` = '$prod_price', `wholesale_price` = '$prod_inkoop' WHERE `ps_product`.`id_product` = $prod_id LIMIT 1;");

In stead of using $prod_price i need something like for example $prod_price_ex_tax.

It's easy if you now it, and i am looking over it. But looking at your own mistakes is a kind of a nono.

So if anybody can assist, please.

Kind regards.

Jeroen