Build an Online Store with php/database

Hello, We are creating an ecommerce system to upgrade from a free to premium version of software. We are able to build the rest of the website for the client but we need someone that specializes mainly in PHP and the connections to a Mysql database to create the check out and registration process. So you would basically be subcontracted by our design firm. We already have an existing mysql database but as far as the platform for the website and the ecommerce, that is flexible at this point because nothing has begun but we would prefer wordpress or joomla. A good exmaple site that has similar business model would be [login to view URL] here is list of functionalities that we will need… [login to view URL] initial purchase - most all customer will have the free version to start out with and it will come with a license number so when they upgrade to the paid version they will need to enter their original license number and then after check out they need to receive a ‘thank you’ email with their new premium license number in it. We have a simple algorithm that will produce their premium license number based off of their original license number, this algorithm should be able to be done in the php script.. Their original license number will already be in the Mysql database but the new premium license number will need to be added to the database upon check out. Initial, one-time purchase: 1 user license $395 Each additional user license: $99 2. Upgrades - In the future customers may want to add more users licenses to their package, which they can do for a reduced cost. So we will need an ecommerce system that can verify their original purchase by checking for their valid premium license number in the database then once it is verified it will allow them to purchase more user licenses at a reduced cost. 3. Annual Maintenance - customers will need to pay an annual maintenance fee. price - Annual Maintenance (subscription) is 20% of the purchase price of all seats on record for the company. So if they have 3 seats (software = $593) maintenance is $118.60 The software can produce a unique url for the customer to click on in order to pay their maintenance cost. Which their url will probably have the premium license number embed in [login to view URL] based of the url, the system will need the query the database to see how many user licenses they have and then produce the correct Annual Maintenance cost for them to pay. Or we can ask them to manually enter their license number for the query but either way the ecommerce system will need to be flexible based on what is returned by the query. Notes - This project will be white labeled through our design firm [login to view URL] so we will be doing most of the communication with the client. So it it is important that periodically you can explain exactly what you are doing and how your system will be coded so if we need to perform maintenance in the future we will know how to do it. So you may want to factor that additional time into your quote. Price - We are not looking for the cheapest possible option but more for quality and experience and someone the can work with us throughout the entire process to insure that any bugs are worked out so that the final product runs very smoothly. We do not want to pay an hourly rate of an ambiguous amount of time. We would prefer a flat rate quote for the entire project. The above functionality requirements may be adjusted slightly before the project scope is finalized. But before we begin work we will provide you with a complete project scope, so that you can give us a final quote. But right now these are the core functionalities that will be necessary and any charges will be minor. So any quote you give us now may be adjusted once the scope is finalized. Future work … We are quickly growing design and marketing firm and will hope to work with you more in the future. Thank you! Alex Roseland | [login to view URL]