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.
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.
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']'
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.
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.
here is my ecart files, and thanks for your help.
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:
<pre><?php var_dump($_SESSION); ></pre>
and post back the values stored in the session.
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
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?
[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.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.