Last post Jan 21, 2010 07:18 PM by asp__developer
Jan 12, 2010 07:20 PM|ASP__DEVELOPER|LINK
I am developing a e-commerce website and stuck with a confusion. I have to calculate shipping charges according to the weight of the product.
Lets say there are 3 standard rates for shipping: Ground, 2 day, Overnight
then wll each shipping option will be having a possibility , like what if in the Ground shipping the product is very light or TOO heavy then according to the weight the shipping charges should be calculated.
I am confused how i will be dealing with this in the databse and on the front end to calculate the shipping charges ?
Have to implement UPS and FedEX.
Please guide me...
Jan 12, 2010 11:36 PM|deepu.mi|LINK
Did you try FedEX or UPS API
Don't forget to “Mark as Answer” on the post, if it helps you.
Jan 12, 2010 11:55 PM|ASP__DEVELOPER|LINK
what is FedEX/UPS API
and how it can be implemented please guide me step by step...
Jan 13, 2010 12:08 AM|deepu.mi|LINK
Demo link shows step by step to consume the web service
Hope this helps
Jan 13, 2010 12:36 AM|ASP__DEVELOPER|LINK
its really helpful but is it free of cost or require any annual fee ? or is is available for UPS too ?
what is the alternative to this ? i mean lets say if i just have to save the shipping rates according to the weight of the product then how the logic will work and how it will be in databse ? please explain me
Jan 13, 2010 12:43 AM|deepu.mi|LINK
Yes its free but go through the api and make sure the same..
UPS,FedEx,USPS are available..
So if you want to do it manaually you can store the weight and shipping rate in a table based on the states..
and you can calculate.. it..
Don't forget to “Mark as Answer” on the post, if it helps you.
Jan 13, 2010 12:48 AM|ASP__DEVELOPER|LINK
Could you please how it will be stored in the database how i will be calculating the shipping rate on the webpage
my product table is like
ProductID ProductName Description Price ImageID Weight
please show me with example, please
Jan 13, 2010 01:01 AM|deepu.mi|LINK
Create a table to maintain some thing like this
If the state and country varies use some thing like this
country | state | weigth | rate
USA CA 10 $25.00
USA VA 10 $35.00
weight | rate
From the web page you can query the rate by weigth
and calculate... rember this is just a prototype..
I am not followed any Relational database stuff for ex : keeping country and state in different table and store id in the rate table.
I am just leaving it to you
Jan 13, 2010 01:23 AM|ASP__DEVELOPER|LINK
Just one more question my friend, lets say somebody is placing an order for more than 1 item
like: laptop, router, desktop
each having different weight
so in this situation the shipping weight should be calculated 3 times for each item ? or total weight will be taken?
Jan 13, 2010 05:01 AM|deepu.mi|LINK
You can take total weight instead of sending 3 request to Database.
Jan 13, 2010 11:50 AM|ASP__DEVELOPER|LINK
This is my requirement to ask for this kind of shipping method:
Please guide me how it could be done in database and front end webpage logic, Please explain me...
Jan 13, 2010 05:29 PM|FedEx Dolores|LINK
Hello this is FedexDolores we would like to assist you with your shipping needs. Please give our customer service a call at 1-800-463-3339. If you set up an account we can arrange for one of our account executives to speak with you about our products and
rates. We look forward to assisting in the future.
Jan 13, 2010 07:54 PM|ASP__DEVELOPER|LINK
thanks for the information but still i dont understand, i had a word with FedEX executive and they told me do go in developer section and from there i can integrate the rates, but i dont know how to integrate all these things with my code, is there any other
easy way just to store the prices by weight and calculate the shipping cost ?
On 99% websiste we see shipping options and it is so easy by selecting from few options , but never though that it is so difficult to integrate it on the back end ..anyone please help...
I guess implementing API is too difficult, anyone please explain me the simplest way to deal with shipping, on webpage as well as database
Jan 18, 2010 07:25 AM|Qin Dian Tang - MSFT|LINK
It seems to be a very easy problem like do sum in GridView for one column. Then use this sum to calculate a final result by different options. For example, you can show all shipping products in a GridView with a column of weight for each product, which means
each row in GridView has a weight field. Then you can place a button to calculate the result by adding all weight from GridView and getting the rates from a RadioButton List or CheckBoxList (to select options: Ground, 2 day, Overnight). That's all. You don't
need to do anything in db. Just do some calculation in the event of button. Here are some links about calculating sum from GridView, you can refer:
Jan 18, 2010 08:30 PM|ASP__DEVELOPER|LINK
thank for the detailed explaination my friend but i think you misunderstood my question, i am not asking how to do sum/total,
I AM asking about how to implement the shipping cost, from where it will come and how it will be processed in the code, you can read my question again in this thread then you will understand what i am trying to do
Jan 19, 2010 02:20 AM|Qin Dian Tang - MSFT|LINK
I cannot find any detail information from your question. What you need to show us is something like "I put shipping products into GridView, and how to calculate the cost for all products from GridView". Then we know how to help you. We don't focus on what
the logic you use, we focus on how we can help to implement the logic, so you need to tell us something in detail, not all general words like "shipping cost", "shipping charges". There are thousands solutions for them.
What I mean is you can put the whole shipping list into GridView. Then each product will have its weight. You can loop through the GridView to get each weight, then use the rate to calculate the cost. What I suggest is just an idea option. The more detail
things are required to be done by yourself. Here is the code to loop GridView:
foreach (GridViewRow gvr in GridView1.Rows)
double weight = Convert.ToDouble(gvr.Cells.Text);
//calculate by rate or something
Jan 19, 2010 02:48 AM|DTMarkDotInfo|LINK
I wrote code to do what you're asking in a previous project. That was in VBScript, though I'm converting it into .NET C# now which should be pretty straightforward as at the time I structured it with that in mind (to fit into a n-tier achitecture).
However the entire project took about a week to provide the level of functionality you're looking for (multi carriers, multi carrier options, base on highest weight, combined weight, total order price, show a list of options applicable to region/country/area).
Getting the radio button list of delivery options the user can select from is the easy bit. Building the administration screens was the major task.
Beyond copying and pasting all the code which I haven't finished converting yet, I am not sure how best to help. I can provide the SQL Script for the database objects which you could build on from there, I guess?
Jan 21, 2010 05:14 PM|FedEx Dolores|LINK
Hello ASP_DEVELOPER please call our tech support at 1-877-339-2774 and ask for our web services. Also let me provide you the link to view the demo
http://www.fedex.com/us/pckgenvlp/fcl/bussol/drc/index.html . I hope this answers your questions and that you can give us an opportunity to assist you with your shipping needs. Have a
Jan 21, 2010 07:18 PM|ASP__DEVELOPER|LINK
Thanks a lo for replying back,
i have already figured it out, in order to do so
1) Register with FedEX.
2) Get the Developer Test Key by filling out the form in your account.
3) Use the key and other credentials provided by the FedEX in your website.
Thanks a lot to all of you for posting your replies....