Sales Tax from Database

My client needs to calculate different salestaxes for each state, and routinely update the tax rates. Can I have eCart5 calculate the sales tax from tax rates stored in the database? I would add a table.

the billing state abbreviation is stored stored in a session variable named "eCartCheckoutForm_state_province"

you could create a recordset to look up the tax rate on the confirm page using the eCartCheckoutForm_state_province session variable as a filter, then add a set session value behavior (from the server behaviors panel click the plus button and select eCart -> General -> Set Session Value) to store the billing state from the recordset.

you will need to double check the code order to make sure the behavior to set the eCartCheckoutForm_state_province session valriable is before the recordset code, and the behavior to set the new taxRate session is after the recordset.

then you can use the tax rate session variable in the tax calculation.

And, if I already have the check out made, can I add the shipping function to it without re-creating the whole checkout? I customized the pages and need to add the shipping function when my client gets me their account information.

Can you tell me which API eCart uses for UPS?

YEs, you can add the Shipping rate lookup server behavior to the confirm page manually, open the confirm page, then go to the server behaviors tab, click the plus button and select eCart -> Shipping -> UPS

you will also need to create the shipping rule, for the trigger us:
Based on UPS Shipping Quote Value > 0


for the calculation, use based on UPS Shipping Quote "plus" "0"


eCart uses the UPS Shipping quote lookup API.