I am new to this and i need to know where to start on something like this.

1) I have a full list of country's. 2) I have 5 different options to post to these countries (each with a different price) - Sender 1 = Price list 1 - Sender 2 = Price list 2 Weight is calculated, i.e: 0.5 kg = £10 , then each additional 0.5KG is £0.50.

I want to be able to select a country and a weight and it pull the info from each sender and calculated price.

I.E Spain - 50 KG. and each sender will have all their related info pulled onto 1 page. Also want these values to be editable easily and not have to go deep into a database.

Please give me a head in the direction as i am not sure how to approach this

if i understand you correctly, it's just one table?

columns: country, item, initial_price, additional_price

then you can have a lot of countries, and each country can have multiple items. each item associated with a specific country has an initial price for .5kg and additional price per .5kg

or was .5kg just an example and it can be different weights? in which case you add two more columns: initial_weight and additional_weight

if you have more stuff related to a country (eg: zip code, shipping cost, etc) then you can create a second table for country and use a foreign key.

or can pricing be completely customized? item1 has initial price for .5kg and additional price for each additional .5kg, but item2 has tiered pricing, and item3 has bundle pricing, etc? really need more requirements and sample data.

This post was edited by carteblanche on May 12 2014 07:46pm