The web application is called PCS (Price Consult System).
The specification is on Bitbucket. [url removed, login to view]
Our database is Firebird and is on a remote server on AWS (Amazon).
The main application's goal is to allow all the users seek for the product's price quickly and allow the administrator manage the product's price and updates with our ERP called Ilux (Firebird database) in a fast and easy way.
*** This feature is very important ***
The whole program interface will be translated into the Portuguese language and therefore the messages of the interface should be registered as constants in the code and in a single file for easy maintenance and to allow us to make the translation to Portuguese.
The application will be used for 4 types of users with different privileges. So, there are four kinds of visions or privileges that will be detailed further up.
All the functions of the application would be
F1. Manage the user table INN_Price_Users with CRUD (Create, Read, Update, Delete).
F2. Manage the markup table INN_Price_Markup with CRUD. This table has the product's factors that when multiplied by the product cost calculate the price of a product.
F3. Import an Excel .xls file with the product list and their costs updating the table INN_Price_Products_cost.
F4. Manage the product table INN_Price_Products_cost with the products and their costs and prices.
F5. Calculate all the prices and update the product table INN_Price_Products_cost with the prices calculated.
F6. Update the prices on the system Ilux, updating the table ITABPRECOIT.
F7. List and export historical data of the products searched by users and registered in INN_Price_Searched.
F8. Seek and show the products and their prices.
F9. Seek and show the product balance in the stock.
The specification F3 is ready to develop. The project is small and we are developing the other functions very quickly and will be ready soon while the first functionality F3 is being developed.
The first budget is to develop the F3 function.
6 freelancers are bidding on average $42 for this job
i am experienced and no one can do it better than me. Relevant Skills and Experience Amazon Web Services, MySQL, PHP, Software Architecture Proposed Milestones $30 USD - def