Tax and Non-Tax
I have some items that are taxed and some are not. How can can I setup a tax rule based on a bit colum in the sql database? Where the product is marked as nontaxable = True or nontaxable = False.
I have some items that are taxed and some are not. How can can I setup a tax rule based on a bit colum in the sql database? Where the product is marked as nontaxable = True or nontaxable = False.
you will need to add a new column to the eCart object named taxable
in the add to cart button, set the value for the taxable column to 1 for items that should be taxed and 0 for items that should not be taxed
Then in the eCart object, set the tax rule up on the tax tab.
Set the trigger to "Number of items With A Specific Column value":
If the total Number of items where 'taxable' has a value of '1' is '>' than a value of '0'
Set the calculation to "based on items with a specific value":
Total of 'TotalPrice' where 'taxable' has a value of '1' 'times' '.10'
replace '.10' with the correct tax rate you wish to use.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.