close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Sales tax

Thread began 8/11/2011 9:36 am by elewis93815 | Last modified 12/13/2011 9:29 pm by elewis93815 | 1051 views | 7 replies |

elewis93815

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

elewis93815

Need Help!

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

Attached Files
WA CUPCAKE TAX.zip
Sign in to reply to this post

Jason ByrnesWebAssist

change line 601:

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



to:

php:
$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.

Sign in to reply to this post

elewis93815

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!

Sign in to reply to this post

elewis93815

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.

Attached Files
WA Cupcake Tax Issues.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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'

Sign in to reply to this post

elewis93815

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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...