close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Ecart 5.2 Database driven shipping

Thread began 11/11/2010 12:32 am by kris517211073 | Last modified 1/26/2011 3:11 pm by toms016390756 | 18588 views | 24 replies |

kris517211073

Ecart 5.2 Database driven shipping

Where can i get help for database driven shipping or tax for Wa Ecart 5.2

i want to get shipping rate from database for ecart 5.2, please help, thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

in your database you would need to create a tax and shipping table.

I'll give an example for tax, but the same concept works for shipping:

taxes:
taxID - Primary Key
taxState - Text - 2 character state abbreviation, CA = California, TX= Texas, AZ= Arizona etc.
taxRate - number - this is the tax percentage, fore example 0.825


the checkout page will post the billing state to the confirm page.

On the confirm pate, create a recordset that will filter the taxState column on the state_province form element.

Then add a set session value server behavior. On the server behaviors panel, click the plus button and select eCart -> General -> Set Session Value.

Use Any Form Post for the trigger.

Use taxRate for the name

for the value, click the lightning bolt and select the taxRate column form the recordset. this will store the tax percentage in a session.

Now you need to create the tax rule.

On the tax tab of the eCart object add a new rule, set the trigger to If session Variable 'taxRate' exists.

set the calculation to Based on the Cart Subtotal:
Cart Subtotal 'times' '$_SESSION['taxRate']'

Sign in to reply to this post

kris517211073

datebase driven shipping

i have defined two charge rule under the ecart 5.2 'baseshipping' and increment shipping' and then use ecart display manager to create a shopping cart display page, but the weird thing is these two charge rule are not in the shopping cart display page, it's suppose to inserts a table row for each charge rule defined in the shopping cart display page.
what happen these two charges not in my shopping cart dispaly page?

please help

i have attach files below, thanks for your help.

Attached Files
checkout.zip
confirm.zip
Sign in to reply to this post

Jason ByrnesWebAssist

can you send a copy of the eCart object file from the WA_eCart folder so i can see how you have defined the shipping rules.

Sign in to reply to this post

kris517211073

database driven shipping

This post has been deleted.

kris517211073

database driven shipping

here is my ecart files, and thanks for your help.

Attached Files
leegiftshop_PHP.zip
Sign in to reply to this post

Jason ByrnesWebAssist

the rules seam to be created correctly, so we need to know what is stored in the session variables.

Add the following code to the body of the confirm page:

php:
<pre><?php var_dump($_SESSION); ></pre>




and post back the values stored in the session.

Sign in to reply to this post

kris517211073

sorry for my silly, if the rules created is correct, why in my shopping cart display page has no base shipping and increment shipping insert into shopping cart display page, this is my problem, i have created two charge rules and they dont show in cart display page
what about my two shipping rule ?
When i add the code <pre><?php var_dump($_SESSION); ></pre> to the body
they dont display detail info about the variable, but error, confirm page is dreamweaver template page, what is the trick for this code, it's just for showing detail info for variable right? please tell little detail about this

Sign in to reply to this post

kris517211073

i have problem to run session variable test using var_dump()
i have try today still dont know how to use var_dump(), to run value test
my problem is the shopping cart display page do not insert table row for each charge rules i have defined when using display wizard, what is the problem for this? can you answer me that, anything wrong with ecart?

Sign in to reply to this post

Jason ByrnesWebAssist

[quote]dont display detail info about the variable, but error[quote]

Please post the text of the error, when reporting an error, you need =to include the error message for us to be able to trouble shoot it.

perhaps if you could provide a link where i could see the error and a copy of the page, that would be helpful.

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