Modification of 3 php files, based on specifications given

General information for the website: Selling Toner Cartridges an
Kind of development: Customization of existing website
Num. of web pages/modules: 3
Description of every page/module: abcsupplier_import.php
supplier_prices.php
orders.php
Description of requirements/features: The one php file
We Import lists of our suppliers in our database, in the table of prices we have a abcsupplier_import.php file where we have the possibility for ABC supplier when entering the price to ad a fixed amount (of transport cost) in addition to the purchase price. At the database there is the table of suppliers where this constant amount (transport cost) for each individual supplier which can be added to the product price given.
Thus e.g. when a product with id = 34961 from supplier ABC cost EUR 1.00 and in the Table suppliers for supplier ABC the transport cost is 0.30 The result is that the imported price in the database for product with id = 34961 from supplier ABC is 1.30 euros. There is one line of code that adds the value of transport cost to the product.
The work:
We want to change this so the imported price in the database are the pure product price without transport.

settype($price,'float');
while($row = mysql_fetch_array($categories,MYSQL_ASSOC)) {
if($row['shipping']!=0.0)
$price+= $row['shipping'] ;


The second php file
we have a php file called supplier_prices.php where the products are in rows and suppliers in columns, the price of each product is displayed in the suppliers column in a text input field.
The work:
We want to the Product Price to add a fixed amount of transport which will take a certain field from the base (see above code of abcsupplier_import.php). We also want to be able to enter values to the database because now our text input field only display the values of the base we are not able to change those prices.

The third php file
we have a php file called orders.php where the products that are in order are displayed in lines and there is a column at he end where the supplier and the purchase price for each product appears.
The work:
We want in the value of the product purchase price shown to add a fixed amount of transport which will take a certain field from the base (see above code of abcsupplier_import.php).
Specific technologies required: php, MySQL, HTML
Extra notes: