Sales tax

We have created site that sells cupcakes, t shirts and catering. The only element that should have sales tax is catering. Is there a way to have only catering items charged sales tax, if if so, how would I accomplish this?

Thanks,
Jackie

you would need to create a new column in the eCart object called taxable.

for items that have tax applied, set the value of the taxable column to 1 in the add to cart object.


for items that should not have tax applied set that column to 0 in the add to cart button.


you can then create your tax rule using the trigger "Number of items with a specific column value":
if the total number of items where 'taxable' has a value of '1' is '>' a value of '0'


and the calculation:
based on items with a specific value:
total of 'TotalPrice' where 'taxable' has a value of '1' 'times' '0.82'

you can substitute your tax rate for 0.82.

We had a premium ticket today with Dani which was very helpful, however, we are getting an error and need help!

Here is the following error that is visible in the browser when going to merchandise.php

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/97/6933397/html/merchandise.php on line 601

The second error we're getting is when we attempt to open two of the recordsets associated with this page:

It appears that one of your server-side values is improperly coded. Please check this interface for inconsistencies.

Any help would be greatly appreciated. As it stands, our clients merchandise page does not work.

Thanks

Jackie

change line 601:

$ATC_itemDescription = "\".$_POST['parent'].\", \". $_POST['child'].\"";// column binding

to:

$ATC_itemDescription = "".$_POST['parent'].", ". $_POST['child']."";// column binding

the issue with your recordsets looks to be caused by using bad naming conventions for your database tables.

database table names should contain only letters and numbers, no special characters, or spaces should be used.

the only allowed exception to that rule is the underscore [_] character, but I don't recommend using that either.


in your recordsets, i see names such as:
m-long sleeve unisex t-shirts
be my cupcake t shirt
i cupcake mpls purple vneck
m-toddler t-shirts


there are all bad table names as they use hyphens and spaces.

Thank you for your reply! Dani ended up helping with this, but thank you for the post. I didn't realize that our database naming was so off, we will definitely look at that!

We have been informed by our client that the tax is not calculating correctly. I did recreate the order and saw that the cart is only calculating $.07 per item in the cart, however not 7% sales tax per item. e.g. if the customer orders seven items, it will only calculate $.49 total for tax. I have attached the files, this was done via a premier ticket with Dani and I have posted via the support ticket history, however, we are having a difficult time reaching Dani or Ray (who was the one that recently responded). Any assistance is greatly appreciated.

in your tax rule, you have set the calculation to:


total of 'taxable' where 'taxable' has a value of '1' 'times' '0.07'


it should be:
total of 'TotalPrice' where 'taxable' has a value of '1' 'times' '0.07'

Jason,

Thank you very much for your help. I actually looked back at an old post and saw the discrepancy of what I had in the calculation and what you submitted.

Thanks again!
Jackie