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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

...Taxes depending on Zip Codes /Check out setup...

Thread began 5/18/2010 3:48 am by Bruce | Last modified 11/04/2011 11:30 am by goat200487425014 | 3373 views | 40 replies |

Bruce

.........Taxes depending on Cities

I want to set the Tax up in checkout page.

  • Shipping is Free.
  • I only need to set the Tax up for different Zip Code of California state. I want, for example if a user shops from e.g. 90025 zip code and another user shops from e.g. 94102 zip code, eCart to calculate the applicable taxes depending on the zip code entered by users.
  • No tax for other states.


Theses are the requests from my client.
Can this be done in Check out Wizard?
If yes, can you please guide me to accomplish this.
Thank you in advance.

Sign in to reply to this post

Jason ByrnesWebAssist

No, this cannot be done in the checkout wizard.

you will need to create a separate tax rule for each tax rate you need to apply.

the billing zip code will be stored in a session variable named "eCartCheckoutForm_postcode"

you can use the Based On session Variable value trigger in the tax rule:

If the session variable "eCartCheckoutForm_postcode" has a value "=" to "90025"

some of your zip codes may have the same tax rate, so they can be combined into one rule by adding another trigger and setting the OR seperator

Sign in to reply to this post

Bruce

Not understand.

  No, this cannot be done in the checkout wizard.  

Hi Jason,
Thanks for your reply but honestly i have no idea about the session, variable...and these technical vocabulary. Unfortunately I do not know PHP and programming at this level. That's why I bought the eCart 5 because I thought it was ready out of the box. I would not accept this contract from my client if I knew there was a long learning curve behind eCart5.
Just I let you know I started to set eCart5 up since December 2009 and it's not yet finished. So I spent hours ,days and weeks...
Please do not take it personal but you should understand if we (customers) buy your products because we believe in your advertising and we think this is the right product out of the box.
Suggestion:
Please do more friendly and easy to understand tutorials about different steps. That way you do not waste your time neither ours.
I would appreciate it if you can guide me how to do this Tax step by step or if you have any tutorial regarding how to do it.

Help/Question
Please help me how to set up the tax for California.

  you will need to create a separate tax rule for each tax rate you need to apply.  

Can you please guide me how to setup the Tax in eCart5 for California?
There are 4205 zip code and 14 different Tax Rate in California, how can I set up this?
Do I need to to set up tax rate for every county or city?
Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

To be fair, what you are asking is not a standard request, and I don't believe you will find any cart system that will support this sort of tax calculation out of the box.


To accomplish this is going to take 4 main steps:
1) Create a tax rate table
2) Create a recordset to lookup the tax rate
3) Add a Set Session value to store the tax rate
4) Set the tax calculation to use the session value.

1) I think if you can break the tax rates up by city instead of zip code it would definitely simplify things, but either way, I think this solution is going to call for a new database table to hold the tax rate - zip code or city relation:
taxID - Primary Key column - Auto Number
TaxRate - Number - holds the tax rate
zipCode - varchar - holds the zip code - could be state if you decide to go that way instead


You will need to enter all of the zip codes and the corresponding tax rates into this table.

2) Then on the confirm page, create a recordset to lookup the tax rate from the database for the zip code that was entered.

To create the recordset, click the plus button on the server behaviors panel.

Set the name of the recordset to "taxLookup"

select the database connection to use, select the taxRate table.

Leave the recordset window in simple view.

In the Filtering section, Select the zipCode column set the comparison to '='
set the variable type to Form Variable and enter 'postcode' for the variable name.

3) Once the recordset is created, add the set session value server behavior to the confirm page.

Click the plus button on the server behavior panel and select eCart -> General -> Set Session Value

For the trigger select "Recordset taxLookup is not empty"

set the name to "taxRate"

click the lightning bolt next to value and select the taxRate column from the taxLookup recordset.

4) Now to create the tax calculation.

In the eCart object, on the tax tab, click the plus button to create a new tax rule.

For the trigger select Session variable Exists:
if the Session Variable 'taxRate' exists

for the calculation use Based on carts taxable subtotal:
Taxable subtotal 'Times' '$_SESSION['taxRate']'

Sign in to reply to this post

Bruce

Set up only two Tax rate

This post has been deleted.

Bruce

This post has been deleted.

Bruce

Jason,
Thanks for your explanation and I apologize for probably my not friendly post. I am under pressure to finish this job. Thank you for understanding.
Finally after hours of search and effort I could create a table with 1773 cities (CA) with their relative tax rates. I created 3 columns in this table,TaxID,City and Tax columns.
Now I need your help and assistance to go from there please.

Q1)

Should I add more column to this table? If yes, please mention which one and what to assign in Type in phpMyAdmin.
Q2)
Should I remove tax setup in PayPal (I've already set it up to 9.75%) and let eCart do the job?
Thanks.

Sign in to reply to this post

Bruce

Need Help on "Tax Calculation".

  To accomplish this is going to take 4 main steps:
1) Create a tax rate table
2) Create a recordset to lookup the tax rate
3) Add a Set Session value to store the tax rate
4) Set the tax calculation to use the session value.  

I did all the steps you mentioned and I am stuck at step 4 in Tax Calculation page. I cannot get the corresponding Tax/City, no tax is added to confirm page. I am sure something is missing but I do not know what's missing. I include a snap shot.
Thanks.

Sign in to reply to this post

Bruce

Help on Tax Calculation

Any help in Tax Calculation?
Please see above post with screen shot.
Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

Did you create the record set to lookup the tax rate form the database?

Is it setting the tax rate in the $_SESSION['taxRate'] correctly?


Add the following to your confirm page to see if it is being created gorrectly:

php:
<?php

if(!session_id()) session_start();
echo 
"tax rate: ".$_SESSION['taxRate'];
?>




if the recordset is working properly, this should show the tax rate.

In the screen shot, you have not entered a name for the session variable, nor have you entered anything to multiply the taxable total by.

For the trigger use:
session variable exists:
if the session variable 'taxRate' exists.

for the calculation use Based on carts taxable subtotal:
Taxable subtotal 'Times' '$_SESSION['taxRate']'

Sign in to reply to this post
loading

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...