The script should be plain... just header en footer files.. no fancy design., graphis or HTML.... just bassic PHP.
This Script is to be an interface from which customers should be able to request an quote, based on items in an Mysql Table.
There is no need to transfer a qoute to orders .. or any payment gateway.. just quotes on which my client is going to do telephone or email followup.
The following tables should be used
Table 1. : Items (to contain items, each item could be from an category)
Items should get 3 price levels. There should be an option to masked out price field when building quote request, first time customer should not have access to item
3 Pictures should be uploaded for Items
Table 2 Category table for main catogorie an sub categories
ex. Main category Clothing Sub -category Pantes
Category pictures should be uploaded also.
Each category should have the ability to define category specifiec fields for each item belonging to that (sub) Category
Category Clothing should have Size and color as category specifiek fields for each item belonging to this group
Colors should be picked from a predefined color pallete.
An second category like Automobile should have other item specifiek fields like (no of doors, color, transmission ect. ect..
Tabel 3 Quotes
Customer should be able to build a quote by picking items from the items database, and add items specifiek features to te order.
Customer should provide Name (Mandatory) telephone (Mandatory) Fax , email (Mandatory) information, and quite should be saved in table.
Email should be generated notifying administrator for pending order.
Quotes should get an notes field, and should be able to be modified by admin or customer as long its in the process (or Pending)
Admin can tranfer quotes to te Quoted status.. afther that only admin could modify quote.. customer should be able to view quotes.
When quotes set to closed or Ordered status.. no one kan edit the quote.
table 4 :Customer database table.
- When requesting quotes for the first time customer information is saved in customer database, en password is mailed to custumer
- Standaard password retreive fetaure.
- customer kan login en view or edit quotes based on quotes status..
View and edit all information
define items categories en categorie specifiek fields for Items.