Hi,
I'm developing an e-commerce site and one of the features I'd like to implement is automated freight charging. The basic idea is to calculate the cost of shipping from the total weight of the goods and where they are going according to data from delivery companies like Fedex, UPS, etc.?
Since the cost schedule is like a spreadsheet that has weight ranges on one axis, and destination on the other, I'm pretty sure I can map this information to a database.
However, I'm not sure how I'm going to manage the data dynamically (e.g. adding another weight range and maintain data integrity, etc.) once it's in the database, and also how I'm going to use it in PHP.
Do I extract the entire table into a two dimensional array and work with that?
Do I create the spreadsheet in Excel and save it as XML?
Is there some better of way of dealing with this problem altogether?
Your assistance would be greatly appreciated.
