We need a cost calculator that is based on postcode and surface area of a product for our Oscommerce based website. System needs to be similar to the one used in the following link:
[login to view URL]
The requirements are as follows:
Customer enters the number of rolls of a certain product required and the delivery postcode then click Submit for an instant online quotation on the product including delivery costs.
The number of roll is based on square meter. For eg: 1 roll = 1 square meter.
The shipping cost is calculated based on the postcode and the amount ordered.
We need the calculator to be used on certain products as the site contains other products that do not require this calculation. For this, we have integrated product tabs contribution ([login to view URL]) So the code you will generate can be inserted into one of the tabs making the calculation product independant. (See here: [login to view URL])
You can view the system we are currently using here:
[login to view URL]:2.75,%2061:2.48,%20121:2.23,%20181:2.09,%20241:1.98,%20361:1.84&end=end
The site we need to integrate the system into is below:
[login to view URL]
The Business logic is as follows:
1- Customer enters amount needed (in square meters) and the postcode
2- System converts amount into pallets (1 pallet is 50square meters)
3- System calculates price(Based on pallets and postcode)
4- once the price is calculated, the system needs to update product price on [login to view URL] file for that product.
The postcodes are in the following format. Full list will be provided on request:
B, CV, DY, GL, HR, KA, LL, PA, PE, PH, SN, SY, WR
When customer enters full postcode, for eg, WR1 1HT the system needs to calculate the cost based on WR area from the list above.
I will provide the prices per postcode and pallets later. Maybe you will need an excel file to pull out the price and postcode information from when doing the calculations.
Pre-written free module in Java attached (which does majortiy of what we require)