Develop HTML shopping cart, admin. interface and order checkout system offering paypal, google and merchant account (credit cards) as payment options

Summary of overall Goals: Develop a solution that can be seamlessly introduced into each of my existing webpages and websites to offer the customer three independent choices of payment options: 1. Paypal 2. Google checkout 3. Credit cards thru a 3d party merchant service provider. Overview: The Client (CL) has existing websites containing pages that are each coded in HTML. Here is one example: [login to view URL] • At the present time, the CL only offers paypal as a payment option to customers. All shipping cart and order data flows from the customer to paypal for payment processing, order data storage and order data retrieval. • In order to offer paypal + google checkout + credit cards (thru an independent merchant account provider) as payment options, the shopping cart data and all of the customer order information must be stored on the CL’s server, instead of being sent to the Paypal server. This must be accomplished by creating new shopping cart software code that will reside on the CL’s hosted servers. The new shopping cart software code will accumulates the shopping cart contents as the customer shops on the CL’s webpages. • In order to offer three different payment options, new shopping cart checkout software code must be developed and installed on the CL’s hosted server. The new shopping cart checkout software code will present a page to the customer that appears as soon as the customer completes their shopping and checks out. The page will offer the customer a choice between 3 different payment options: 1. Paypal 2. Google checkout 3. Credit cards thru a 3d party merchant service provider. • In order to collect customer payment information, new customer payment software must be developed that will reside on the CL’s hosted server. This software will present a screen to the customer after they have selected their payment option and collect all of the data necessary to send to the payment gateways in order to process the payment. • All of the shopping cart data and customer order data collected will be stored on the CL’s hosted server. In order to view, search and process each order, new order processing software must be developed which will reside on the CL’s server. This software will allow the CL features to allow the CL to process and ship orders. The software will also allow the CL to view order history. • The Service Provider (SP) provide the Client (CL) the code necessary to alter the “add to cart buttons“ on these pages without destroying or abandoning these pages. Changes to the pages will be made by the CL. Additional requirements: The Service Provider (SP) shall be responsible to provide the Client (CL) the following: • Software to accomplish the following tasks: 1. Code that will allow the CL to update each exiting HTML using an HTML editor and a find an replace command. The code will alter the :”add to cart buttons” so that they will post the shopping cart data on the CL’s server. No product data base will need to be created or maintained. 2. Software that will accumulate the customer order information and post it onto the CL’s hosted server. 3. Software that will send payment to the payment gateways selected by each customers namely: • Paypal • Google checkout • Credit cards thru a 3d party merchant service provider. 4. Software for an administrative interface set up to manage this information and manage customer orders. This interface will include the following features: • The ability to display customer orders. • The ability to search customer orders by first name, last name, date or email address. • The ability to download a selected date range of orders to an excel comma delimited file. The Excel .CSV download feature shall allow for a selectable date range ie: (From: DD/MM/YY To: Date DD/MM/YY) • The ability to add data into three data fields for each customer • A shipping tracking number • A notes field • Shipping status – Shipped – Not Shipped • The ability to edit any customer order field. • Password protection 5. Software for a customer interface set up to allow customers to lookup and view orders and allow the CL to enter the shipping status and tracking number. This interface will include the following features: • The ability to display customer orders. • The ability to search customer orders by first name, last name, date or email address. The ability to search customer orders shall work using any portion of first or last name within a selectable date range (From: DD/MM/YY To: Date DD/MM/YY). For example: Entering a last name search string "it" for the past week will display orders from: Don Smith Jenifer Italia Mahesh Ghanit Sam Babithica Etc…. • Login password protection • The ability to add a status field – Shipped – Not shipped to each customer order • The ability to add a tracking number to each customer order 1. Software shall include the following checkout features: • The ability to calculate and add shipping charges to each order automatically. This will require a shipping table that allows the customer to choose between multiple shipping options. Shipping charges shall be added to each order automatically using a table That applies the corresponding shipping charge based on the total order value, the shipping method chosen and the country. • The shipping tables shall be set up so the CL can change them from the administrative panel. Different options will be displayed to the customer during checkout based on what country the order is being shipped to. • The checkout feature shall include the ability to calculate and add sales tax charges to each order automatically. The sales tax will be a percentage added to each order based on the total value of the content of the shopping cart. It will be added to each order automatically during checkout based on what State the order is being shipped to. No sale tax will be required from countries outside of the United States. • The sales tax tables shall be set up so the CL can change them from the administrative panel. It will allow a sales tax percentage to be applied for each of 50 states. The range will be from 0% to 100% For example: Alabama – 0% Alaska – 2.4% Arizona – 7.80% California – 0% New York – 0% Etc….. 2. Software shall include a customer order lookup function that any customer can assess from a URL: • The ability for a customer to assess a webpage that can lookup the status of their order. • The customer shall simply enter their email address and a date range: (From: DD/MM/YY To: Date DD/MM/YY). and the basic order data shall appear as follows: i. First Name ii. Last Name iii. Order Date iv. Order Time v. Shipping Status (*Shipped - *Not Shipped). vi. Tracking Number vii. Shipping Method • If there is more than one order from that customer all orders will appear within the date range selected. This software bundle shall be referred to as the Client Custom Ecommerce Software (CCES). The CCES will be provided so that it is easily transferable to any hosting service and can be transferred by the CL anytime with no restrictions. The CCES will be written so that it can be used on all of the CL’s websites The CCES will be provided to the CL and become the sole property of the CL. The CCES will not require any licensing agreements, monthly fees or copy write protections applied. The CCES will not require any additional software to be purchased in order to make it operate. The CCES will not require new web pages to be developed in order to display The CL’s products and allow customers to shop and place orders. This will be done from the customers existing HTML web pages after modification of the shopping cart code on each web page. The SP shall set up the CL’s hosted server for the CL’s main website so that it will accept the data files and all the CCES software is functioning on the CL’s server so that as soon as the shopping cart code is updated on each webpage, the customers and order data will immediately be routed to the CL’s hosted server and payment will be routed to the appropriate payment gateway. The SP shall work with the CL to assure that all three payment gateways are set up and functioning properly with the CCES so that the order and payment flow is functional. Updating each existing HTML webpage shall be the responsibility of the CL, but the code required to update each HTML webpage shall be provided by the SP to the CL. The code shall be structured such that each HTML webpage can be updated using a single find and replace function using standard common HTML editor software. The SP shall provide any consulting service required to assure that the CCES is functioning on each of 3 separate hosting service providers. The SP shall identify all files and directories required to be transferred so that the CL is able to transfer, backup, restore or propagate the required CCES and all customer and order data to allow any hosted server to function using this software. The SP shall provide support and training to the CL on how to propagate, backup and transfer the CCES and all customer and order data to each of the CL’s hosted servers for use on each of the CL’s websites. The SP agrees to provide free technical support for one year after completion of the project. Payment terms and milestones: 50% escrow to GAF to start project. 50% payment released upon demonstration of all software and functionality on the SP’s server. 50% payment released upon demonstration of all software and functionality on the CL’s server.