Order & Customer Management System

General information for the business: We sell bespoke wooden buildings
Kind of development: Customization of existing program
Description of requirements/functionality: To expand on current order system with an Order Diary, Route Planner & Email/Ticket tracking

We want 1 place to manage orders, customers, enquiries, emails to and from customers & staff.

We currently have a self built OMS (order management system) written in C#.net using MySQL databases using MVC and Entity Framework with Unity Dependency Injection (http://stackoverflow.com/questions/608585/can-someone-explain-microsoft-unity)

We will want this project created in C#.net and HTML 5, responsive layout (so can be used on mobiles, tablets & PCs) & can be used across Windows & Mac browsers.

System needs to be secure and allow various types of User Permissions.
[Diary, Orders, Emails, Photos, Reviews] (edit, delete, create, view)

#Diary & Orders
(see process.jpg)

When a job is complete. The fitters have photos of the completed shed and a couple of forms with info about the job and feedback from the customer. The fitter will email the photos to a specific email address with Subject Line of associated OrderId. The system will need to then link those emailed images to the order.
The admin needs to set the status of the order to complete (satisfactory, unsatisfactory) and add notes if necessary.
If the Job date has past and the status of the order is unknown then alert us.
We should be able to set certain alerts to email, SMS or just highlight.
Notes:
(Some of the functionality part coded already in C#.Net)
Link to Google Maps API for “Job Runs”
Link to an SMS system to send text messages at various intervals
Base email/ticket system on osTicket (http://osticket.com/) (open source PHP)

#Email System (Newsletters, Review/Checkup requests)
Link to Interspire Email Marketer 6.1.2 API (PHP)
Campaign email templates (newsletter, review request etc) are already created. This system will be a way of selecting the data we want to send and fill the Campaign email template with it to be then be sent as an HTML email through Interspire.
Show:
- List of Campaigns.
- Create or Edit.
- Last sent DateTime
- Number of recipients
- Next send due DateTime
- Start, Stop
Set up & Save Filters (allow From and To ranges on those appropriate):
- Order Type (shed size, price, etc)
- Order address, installation date
- User interaction (if they've left us a review, if any of their correspondence contained a specific word, if we are yet to know what they think about their shed)
Save Campaign with:
- The chosen Filters
- Schedule/Repeat DateTime events
- which Subscriber list (if any) we use to send the Campaign to
(e.g. 1 day after an Order's 'UserStatus' field is modified send a request for a review to those Orders where the 'UserStatus' is “Satisfied”)
Return the stats using Interspire API (opens, bounces, etc) for Emails sent
(See http://www.interspire.com/emailmarketer/)

#Reviews / Checkups
(Some of the functionality part coded already in C#.Net, see shed-reviews-admin.jpg below)

Show:
- Emails sent out with requests for a Checkup Reply
- Show emails sent out with requests for a Review
(DateTime, Subject, To, Replies, Email Stats)
- List of Reviews left
Allow Verification & Edit of Reviews
Link reviews to Orders/Order Items
Allow entry of Review User to a Rewards scheme

#Photos
(Some of the functionality part coded already in C#.Net, see shed-pics-admin.jpg below)

Show:
- List of photos uploaded by customers & fitters
- Edit, Delete, Verify
- Filter list
- Upload new photo
Allow basic manipulation: cropping, colour/gamma correction
Save image in various set sizes for thumbs, front page, gallery etc
Save to multiple locations (e.g. easyshed.co.uk/images, beastsheds.co.uk/images)
Flag image (assignable to someone) for touch up or other
Email image to someone / attach to a current ticket/email
Link image to orderItem
Link image to review
Create review from image
Set Image type & where to be shown (Showcase, Front page, site (easyshed/beastsheds etc), hide)

#Rewards
Set up and run rewards
Choice of: Draw. First to Reply. Recommend a Friend. Like us on Facebook etc..
Set Reward date range and repeat DateTime


PLEASE SEE THE ATTACHED BRIEF.DOC
Extra notes:

http://www.easyshed.co.uk/shop/custom-sheds