G
Guest
I have a product table with productID and UnitCost. I want to calculate sales tax if sales based on instate or state were requires sales tax. In shopping cart I have a Product Quantity and Unitcost per product. I do subtotal on each product and at the end I add up all and do the total.
Should I calculate sales tax per subtotal or should I calculate on total.
Although, I will caluculate tax after I collect Billing and Shipping Info which has state infornation. So When user fills shopping cart I will have just total but on few page later after collecting Billing and Shipping Info I will calculate tax.
Also I like to store total tax or per item base tax in oder table so when User want to see old order I can reassemble again.
Should I calculate sales tax per subtotal or should I calculate on total.
Although, I will caluculate tax after I collect Billing and Shipping Info which has state infornation. So When user fills shopping cart I will have just total but on few page later after collecting Billing and Shipping Info I will calculate tax.
Also I like to store total tax or per item base tax in oder table so when User want to see old order I can reassemble again.