Okay, I have a requirement for a fairly simple web-based catalogue, stock control and quotation system. There will be a public catalogue (which will lead to a quote request) along with a back-end system, which will maintain a stock list of a set of products and be able to display various things, such as outstanding quotes, orders, etc. It's not quite an ecommerce system as there is no cart as such or checkout, however i'm sure a cart type script could easily be modified for this part of the project. Requirements of the backend system :- Web based utility that:- 1) Has a simple stock items table. It will store a unique product ID, the product title, a description, a url and a category. Probably not necessary to have seperate relational tables for these as the product count probably won't ever get over 200 and/or more than 20 categories. 2) A quotation management console. The ability to view outstanding quote requests (from the public catalogue site). The system will use historic data (and a baseline) price for each item to automatically suggest a quote price for each item and then package it all up as a complete quote. Once the quote has been finalised, a button will be hit which will generate the text of the quote into a textbox for copying and pasting into an external application. 3) A sales management console. When a payment is made based on a previous quote, this console will allow a payment status to be set. This flag will be relevant in the purchasing console below. 4) Purchasing console. This console will allow the backend user to view what outstanding items there are to be purchased (ie, everything other than what is in-stock and for orders that have been paid for). It will use historic data to display the cheapest region of where to purchase each item from. For each item that gets purchased, the purchase price and purchase region will be entered in teh system referencing the appropriate order. Ctd.. in deliverables:
## Deliverables
Requirements of the public catalogue :- 1) Simple multiple category single tier catalogue system. 2) Ability for a public user to add various items into a quotation 'cart'. 3) Ability to submit cart to the quotation console above. Notes: Basically what i'm after is a system that allows me to list a bunch of products on a public website for people to browse and multi-select for quotation. Once I receive the request for quote, the system will then generate a quote based on previous purchase and sales data. Once payment has been received, I will be able to look at the console to see what I need to buy and the best place to buy it from, again based on previous sales/purchase data. This is for an online game, so typical e-commerce thoughts may not apply. Deliverables: 1) Complete PHP source code and all SQL scripts. 2) Ownership of all code and redistribution of any part (for example if you use an existing library or include) will be at our prior agreement). 3) Your willingness to perform future changes to the code after the release, for a limited time only or until you are no longer willing to work on the project (at agreed figures).
## Platform
Windows/Unix, PHP 4/5, MySQL. ASP + MSSQL if you're cheap enough :-)