Project Description:
I need a simple website where I can store data of all customers I visited and products I sold them. I would also like to give my customers access to a page with all the products they ordered before and where they can place a new order. No invoices or payment processing needed.
I would like to store:
> My customer data
-- Company name, contact name, address, phone numbers, e-mail, login name, password, status (active/inactive customer)
> My visits/sales
-- customer
-- visit date
-- products sold (with adaptable price field)
-- remarks
-- sale status (ordered, processed)
> My products
-- categories
-- product name
-- small product description
-- price
-- 3 VAT categories
Customer page:
-- log in (show 'forgot my username/password' button after which the username and password is mailed to the mail address in the customer database)
-- view all products/prices sold to this customer
-- extra column where where customers can fill in amounts they want to order of their products.
-- show new order, process these amounts and send acknowledgement per e-mail to me.
I would like overviews of:
-- my customers with their total turnover, postal code, latest visiting date, status (sorted by any column). print button
-- all my products and prices, grouped by product category. print button
-- my turnover (based on all processed orders) per period between x and y (selectable). print button
-- sales report per period (selectable) with 2 different views: per customer and per product. print button
-- new orders through website (click to open and be able to change order to status 'processed'). print button
I would also want a simple dashboard with 3 sections:
- list of all non processed web-orders.
- list of all active clients sorted by visiting date (oldest first).
- turnover (based on all processed orders) with total turnover in this week and this month.
Technical requirements:
MySQL and PHP4/5 based. CSS based page template with formatted logo's etc. will be provided.
Thanks in advance!
Jean
