Dynamic Tax

Is therea way i can make the tax calculate by a dynamic field extracting the tax value depending on what i have on a database table named taxes for example, i ask this cause the country where i am they change the taxes every year and some of my clients have ask me if they can set the taxt value manually from the admin section, any lead on how i can acomplish this?

you could do this by creating a database table to hold the tax rate, and storing the tax rate in a session variable.

on the cart page, create a recordset to lookup the tax rate in the database, then add a set session value behavior.

on the server behaviors panel, click the plus button and select eCart -> General -> Set Session Value.

set the trigger to:
If Session Variable is not defined

set the name to TaxRate

for the value, click the lightning bolt, and select the tax rate column from the recordset.


you may need to rearrange the code so that the set session variable behavior is after the recordset.


then in the tax rule, you can refer to the tax rate using $_SESSION['TaxRate']

Sorry to bring this up after so much time last time i just totally edited and practally manually made the tax calculation modified so much ecart that was a pain later on for any update to the page. So now i will try to do this the correct way.

Ok storing the taxRate in a session is easy but how can i tell the grand total to use that tax rate saved in a session, i see that in the eCart Merchandising Rules theres an option for if session exist ok so far until here or also using total number of items > 0 so far the last step is what im not sure what to do.

On other places i had the tax setted to : Cart Taxeble total --> Times --> 0.12 (since the tax is at 12% for that other job) but the one im making right now the country changes the tax rate every year so i have to make it dynamic, so on that last part of the rule what should i pick im guessing based on a column subtotal and picking TaxRate but after that time? minus? i dunno from here any help please?

instead of:
Cart Taxeble total --> Times --> 0.12

use:
Cart Taxeble total --> Times --> $_SESSION['nameOfTaxSession']

Thank you Jason worked like a charm