Hospitality E-Commerce Site

1. Vision 1.1 [login to view URL] Community • Football community (Spurs fans) o Mail addresses at [login to view URL] o Download Steve Perryman videos/information - Content from Steve Perryman, Pat Jennings, etc o Chat o Travel Guide to Football destinations o Photo competitions o Action Site • Collection of leads • Banner database • Cross-linking from [login to view URL] o Regional sites in the UK, Germany, Scandinavia, south America, the US 1.2 [login to view URL] Management System • Package Database accessible online (very easy web based input model) from many different regions o SQL database (retrievable by XML) can be retrieved from both sites on the server and from outside servers - Regional sites - White-label to resellers and corporate intra-sites o Inventory solution linked with payment provider o Tracking and weekly reporting to media partners (sales) o Promotional CRM - Database with contacts on-line - Mail outs - Reporting on ordering and packages that might suit their interest. See Amazon - Linking to Quickbooks (Monthly reporting) which is located on a dedicated computer in the office with broadband connection. Outputs from Quickbooks can be done in Excel. Quickbooks uses several files for reporting: .QBW, .QBB, .QBX, QBA, .AIF 1.3 On-line System • E-commerce site o Display of offerings including active inventory system o Payment on-line o Customer service on-line 2. Infrastructure Steve Perryman UK Ltd has rented one RedHat Fedora Core 3 Linux dedicated server through Active24 in the UK. Server IP: [login to view URL] Firewall IP: [login to view URL] Services: • SSL Ecommerce website hosting • Database hosting • Mail software (IMAP on UNIX) • Web based email and calendar service • Web based admin control panel Support: • Patching with the latest application and OS security updates • Regular changes to critical passwords • Intrusion monitoring • Filesystem and disk space monitoring • Service monitoring • Backups • Remote Power cycling 2.2 Technical • Patched with the latest application and OS security updates • Intrusion monitoring • Service and hardware failure monitoring • Domain [login to view URL] • System Restore • System Hardening • Perl Modules (including RPM builds if necessary) o [login to view URL] 3.04 o Crypt-TripleDES-0.24 o Date-Simple 2.04 o Digest-1.08 o Digest-HMAC 1.01 o Digest-MD5 2.33 o Digest-SHA1 2.06 o Email-Valid 0.15 o Expat 1.95.7 o Htmldoc 1.8.23 o IO-SocketSSL-0.96 o Imagemagic o Libnet-1.18 o Libwww-perl 5.79 o LWP5emu-0.01_01 o MailTools 1.60 o Memoize 1.01 o Mime-Base64-3.01 o Mime-Lite 2.117 o Net-DNS 0.41 o Net-Domain-TLD o URI-1.30, Wwwcount 2.5 o XML-Parser 2.31 2.3 Websites on Server • [login to view URL] (this is the site that the e-commerce system will be implemented on) • [login to view URL] 3. E-commerce System In this proposal we give you a brief outline of the possibilities of Travel Management, a web software application for e-commerce implementation and administration. 3.1 Software The Software is a highly sophisticated web tool to promote travel packages online. Within several minutes packages can be added, changed or deleted by login to the back office system. Besides common fields (like name, place and date of the event) The system makes use of an availability field. In this field the number of packages available can be placed. Every done booking results in a automatic countdown of the number of packages available. The system is modular based build. Future connections and integrations to other systems online and offline can be easily made. 3.2 System technical (details can be discussed) Travelmanagement consists out of: Number of software modules approximately 150 Number of lines program code approximately 25.000 Program language PERL Database MYSQL Facilities Automatic Backup Daily (adaptable) Tailor-made adjustments 100% possible (on request) Tailor-made extensions 100% possible (on request) Online payment possibilities 100% possible (on request) XML connections 100% possible (on request) Proprietary connections 100% possible (on request) System requirements: • Operating system (OS) Unix (Linux, BSD, SCO, AIX, Solaris) • PERL version 5 or higher • MYSQL version 3.23.56 or higher • Dedicated server Yes, required • Backup facilities Desired, not required Software components: • Content management system Easily placement of travel packages by making use of an ingenious content management system. The content management works easy. No technical background is needed. If you can type a letter, you are able to work with the content management system • Visualization of travel packages In accordance with client demands the visualisation of the packages are build database driven. Place of text, images and navigation buttons (Book online, tell-a-friend, etc) is identical for every package 3.3 Back office control Working and possibilities are explained later in this proposal. Shared libraries All scripts and files make use of shared libraries. Changes in database structures, names and table definitions can be easily made. Software security 1. Secure Socket Layer connections tot encrypt sensitive data (i.e. credit card details) compatible with WorldPay 2. Control on valid email addresses (on functions: tell-a-friend, mailing list, and bookings data) 3. Encrypted login and passwords tot access back office modules 4. Control on appealing of scripts on IP-address? Deep linking from other websites will be made possible? We have to solve this 5. Use of session variables. By doing so no double bookings can be made this will be done with WorldPay Backup facilities Periodic backup (adaptable) of all MYSQL databases. On demand backup files can be uploaded to separate server facilities or being sent by e-mail (with backup files in attachment) Back office system The back office of Travelmanagement consists out of two type of back office system: Main Supervisor, Individual User Back Office and Participant Back Office. Main Supervisor Back Office 1. Manage back office users Create new users with login and password. Identify the individual rights to the modules 2. Manage software modules Add, change or remove software modules Individual User Back Office Depending on the given rights users will see one or more of the following modules in their individual back office. The major items are: 1. Manage categories. Create new categories in which packages can be placed. For example: tennis, soccer, golf, formula 1, etc. 2. Emailing. Send emailing by cut/paste html source codes into the page. Automatically all saved addresses will receive the mailing 3. Payment profiles (if applicable). Making use of online payment facilities, this function makes it possible to create several payment profiles which can be connected to placed packages. We can imagine some packages can only be paid by credit card or bank transfer. Especially packages with short time to departure. 4. Statistics & summaries. In the back office several statistics and summaries can be looked into: Statistics • Number of visitors per package • Number of visitors per category • Microsoft Excel counter file download • Etc. Summaries • All bookings per category • All bookings per month • All bookings per package number • Search on bookings number • Search on package number • Etc 4. On-line Payment System 4.1 Payment Service Provider WorldPay is an important part of The Royal Bank of Scotland Group, the 5th biggest banking group in the world, WorldPay payment solutions are trusted by over 20,000 customers trading over the Internet and more than 1,200 strategic banking and e-commerce partners worldwide. WorldPay is the only way to accept such a universal range of payments through one merchant account, one payment processing system, 24/7: • All major Credit Cards: Visa, MasterCard, Diners, American Express, JCB • Debit Cards • Local Payment Schemes: Switch, Laser, Electron, etc • Bank transfers (such as the German ELV system) • Installments • Standing-order • Direct-debit style payments Andorra Australia Austria Belgium Canada Cayman Islands Channel Islands China Croatia Cyprus Czech Republic Denmark Estonia Finland France Germany Gibraltar Greece Hong Kong Hungary Iceland India Ireland Isle of Man Israel Italy Japan Latvia Liechtenstein Lithuania Luxembourg Malaysia Malta Monaco Netherlands New Zealand Norway Poland Portugal San Marino Singapore Slovakia Slovenia Spain Sweden Switzerland Taiwan Thailand United Kingdom United States Minor Outlying Islands United States of America Virgin Islands (U.S.) Holy See (Vatican City State) WorldPay will provide an Internet Merchant Account (IMA), this is separate to the Merchant account held by Avant Garde Travel (AGT), but can be added to their existing service provider Streamline. Streamline which are affiliated with NatWest will ensure minimum processing time. Changes within the RBSG internal structure mean that WorldPay, Bibit and Streamline International are unified in a single business unit, referred to internally as International Merchant Services. Add on services • Repeat Billing • Internet Terminal: take payments over the phone, by fax or e-mail • Fraud Prevention: online transaction authorization, cardholder verification (i.e. via Verified by Visa and MasterCard Secure Code), Address Verification Service (AVS), and WorldPay several in-house fraud detection/protection tools that are designed to avoid hassle and minimize financial loss (including the WorldPay Guarantee which can protect you against financial loss due to fraud) • Multiple Currencies and Languages: WorldPay can help you accept payments in most currencies and provide international shoppers with dialogue in their own language • Customer Service Support: 24/7 including WorldPay IMA online and manage account remotely 4.2 Security • Transaction Encryption: Encrypted and digitally-signed protocol with a combination of standard methods such as PGP, RSA and MD5 to ensure that the information passed is secure and tamper-proof via SSL • Purchase Token (cookie) Security: o Select Pro and Select COM use 1024 bit encryption to protect certain elements of the purchase token o Prevent Duplicate Transactions: CartID and limited life of the token o Data Integrity & Country Restrictions o Validating e-mail addresses o Pre-Authorisation: The Ultimate Sanction • 128 Bit SSL • Data storage and the communication between WorldPay and the worldwide banking networks, is regularly audited by the banking authorities to ensure a secure transaction environment. We also ensure that we stay up-to-date with the latest versions of any third-party code we use, and continually review our own proprietary code 4.3 Fraud Prevention Supports the industry leading anti-fraud systems provided by both MasterCard and Visa. WorldPay offer a guarantee system which pays out where you have been the victim of fraud. 5. Customer Service Line The agreement is a Lo-Call Advanced Service. BT will invoice you for part of the cost of calls to that number. Offering a Lo-Call (0845) number sends a clear message to new and existing customers: 'We value your custom so much that it will only cost you the price of a local call to contact us, wherever you are in the country.' 5.1 Technical • This is low-cost way to encourage customers to call • It can reduce your marketing costs • It enhances customer service, delivers competitive advantage and helps you build loyalty • A large proportion of consumers know about 0845 numbers (Source: Henley Centre research) • Potential uses include advice lines, response lines for marketing campaigns, or an order line for a new product or service brochure • Lo-Call 0845 supports BT Serviceview, an online tool that enables you to monitor how well you handle your calls and adjust your call management accordingly • Added Service for Advanced Package: Incoming calls can be routed differently at different times, using features such as 'time of day routing' and 'day of week routing'. These routings are set up in an Advanced Plan, arranged with a sales agent or your Account Manager 6. Customer Relation Management SugarCRM Open Source will be used as the CRM software on the server. This will use the Outlook plug-in. Alternations will be made to implement mySQL database. (Alternative Programs can be discussed; the advantage of SugarCRM is the open source) 7. Back Office Quickbooks is used as the backend system for estimates, billing, sales reconciliation, and accounting output. Quickbooks is compliant to accountant software and will therefore lower cost in the longer term. Financial year will end in April/May. Customer database will be uploaded from Outlook to both the accounting system as with the CRM solution. 7.1 Revision Software The most adaptable accounting system has been implemented. Using Quickbooks offers a solution that includes sales ledger, P&L reconciliation, and management system. The software is adaptable for corporations up to 30-35 million GBP yearly turnover firms. The process follows that we need to input all the sales and expenses into the system. Then the management has to verify those figures with the statement from the bank accounts (if this does not reconcile checks have to be made with every single account), then a monthly/quarterly reporting will be sent to our Accountant. This system will insure a lower Accountant cost as SPL will be able to lower their accounting costs as the software ensures that SPL can easily transfer the reports directly to their accountant using a report function.