shopping cart shipping

[pixelsoul]

okay I have a problem me (the designer) and another person (the programmer) are building this site with a shopping cart and it is turning out okay but he is in Finland and the site is for a customer here in US and we don't know how you would go about figuring shipping costs. I am not a php fluent person so I have no clue what it would take. I have seen scripts for UPS and FedEx Calulators but it says that you need the weight of the package. Has anyone set up a shopping cart that understands how that all works? They used Yahoo cart prebuilt cart before this but I would imagine that even the Yahoo script would have to have something that did all that. Can anyone help inform me on this process? What does it take?

Thanks people.

[kamy99]

Hi:

I've been working on an ecommerce site for a while now and we had the same issues.Merconnet

Basically what I did was to get the shipping charges chart from FexEx, yes they're weight based, then inserted that in a DB table. I also had the issue of countries, because the same package to different countries costs different.
SO I got the countries in another table.
I created a third table which links the countries and weights.
Your programmer should know this concept, it's called many-to-many relationship (in DB talk!)
😉 😃

So it takes my cart, 3 queries to extract the correct shipping price for any country , based on the package weight.

I don't claim for this to be the best way of achieving this, however that's the solution I came up with .
If you find a better solution please post it!

Hope this helps.
kamy