XSE (Xtreme Shop Ecommerce) ASP.NET Shopping Cart Website: http://www.ecommercesoft.net (c) 2002-2010 IQServices CONTENTS ------------------------------------------ I. Introduction II. How to setup XSE III.Startup Guide IV. SQL Server setup V. Customer Service & Technical Support VI.Purchasing & Licensing XSE .net (for Trial users only) I. Introduction ------------------------------------------ XSE is full featured "out-of-box" asp.net shopping cart and web store builder. No additional software components are required to sell your products online, view sale reports and process orders. Note for Trial users ------------------------------------------ This version is a full copy of the commercial release of XSE shopping cart. There no restrictions on localhost however, it is limited to 10 product items when web store is run from the internet by the current trial license. Trial license (license-trial.rtf) is included in XSE web store folder. When you will decide to lease or buy you may simply purchase and install a new license. Please review section VII for more details. II. How to setup XSE ------------------------------------------ Before installing XSE, please review the software license included in this document. If you do not agree with the terms of the license, do not install XSE. Check if you computer meets hosting / system requirements: ------------------------------------------ -Windows XP Pro, Windows 2000, Windows 2003 family -Internet Information Services (IIS) -Microsoft .NET Framework 1.1 or 2.0 -Microsoft Data Access Components 2.8 -1.2 GHz Intel compatible CPU or higher -256 MB of RAM or more -20 MB of hard disk space Full Trust code access security (CAS) policy is required. For more details check at http://forums.iqservices.com/viewtopic.php?t=256 .NET Framework 2.0 redistributable package can be downloaded at http://www.microsoft.com/downloads/details.aspx?familyid=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en .NET Framework 1.1 at http://www.microsoft.com/downloads/details.aspx?familyid=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en Latest MDAC version can be downloaded at MDAC downloads page http://msdn.microsoft.com/data/ref/mdac/downloads/ Latest Windows service packs and critical updates available at Windows Update http://www.windowsupdate.com/ Supported databases: SQL Server 2005 / 2005 Express, 2000, MS Access How to setup XSE using xsenet.msi: ------------------------------------------ -Download xsenet.msi from http://www.ecommercesoft.net/downloads.php Run xsenet.msi to install XSE on your local computer. The installer will guide you thru the installation process and install XSE web store to c:\intetpub\wwwroot\xse unless you specify other folder name or default web root folder. Setup will create application (subweb) automatically. How to setup XSE using xsenet.zip: ------------------------------------------ - Download xsenet.zip from http://www.ecommercesoft.net/downloads.php Unzip to c:\inetpub\wwwroot. It will unzip files to c:\inetpub\wwwroot\xsenet - Open IIS management (Start -> Run.. -> %SystemRoot%\system32\inetsrv\iis.msc) -> Expand "Default Web Site" -> select xsenet -> right click -> Properties -> click "Create" -> OK IIS screenshots how to create application and set to use ASP.NET version 2.0: http://www.ecommercesoft.net/downloads/IIS-DNN-XSENET-Application1.gif http://www.ecommercesoft.net/downloads/IIS-DNN-XSENET-Application2.gif How to setup required permissions: ------------------------------------------ In order to operate web store you have to set required permissions to ASPNET windows account. This account is created by the .NET Framework setup. Assign required permissions as listed below: -Open windows explorer and navigate to c:\intetpub\wwwroot\xse -> right click -> "Properties" -> select the "Security" tab (if you do not see Security tab then open windows explorer -> click Tools -> Folder Options.. -> select View tab -> uncheck checkbox near "Use simple file sharing (Recommended)" -> click "Apply to All Folders" -> click OK and repeat from first step) -Check if ASPNET account is not in the list then click on "Add.." button else go to the last step. -Click "Advanced..". -> click "Find now..". -> select ASPNET account -> click "OK" -> click "OK" to return to "Security" tab. -Last step: On "Security" tab select ASPNET account and assign "Modify" permission then click -> Advanced -> set checked "Replace permission entries on all child objects.." -> click OK -> click OK Note: On Windows XP Pro, Windows 2000 ASPNET windows account is used. On Windows 2003 NETWORK SERVICE windows account is used by default. If you need to install XSE on web site hosted at your host provider please check this post: http://forums.iqservices.com/viewtopic.php?t=6 If you need to move existing XSE site to remote web site hosted at your host provider upload XSE site files to remote web site root folder -> open http:///cp -> Store Properties page -> set DOMAIN_NAME value to: http:// Note: replace with your current web site domain name. III. Startup Guide ------------------------------------------ Web store: http://localhost/xse Admin Panel: http://localhost/xse/cp If XSE is installed on web site hosted at you hosting provider change "localhost/xse" to your web site domain name. While you are learning XSE, you will see help icon (?) image button on each page top right side. It will provide extensive help about each admin page. * Skins feature Allows create custom layouts "look and feel" for web store pages by changing page elements position, colors, fonts and images. Skin consists of set of images, master pages, styles, scripts and templates (user controls). Note: user controls are dynamic blocks that could be constantly reused on other pages and user controls. Each user control contains layout elements rendered on web server at runtime. * Master Page feature Allows create quick and consistent page layouts. It considered wise to position any repeating elements like page header, left side menu, footer on master page instead of repeating these elements on each individual page. How to configure web store: ------------------------------------------ - open admin -> Store Properties -> enter in filter: MAIL -> click Filter -> set Primary Email, Mail Method and Mail Server properties. If your outgoing mail server requires authentication set User Name and Password. If it requires SSL connection edit /localization/en-US/properties.usr.config and set MAIL_SMTP_USE_SSL=1 - open admin -> Diagnostic & Support -> click "Send" to send a test email to Primary Email. If test fails, re-check your e-mail settings or contact host provider to obtain SMTP mail settings. - open admin -> Store Properties -> edit DOMAIN_NAME and set your web store domain name. For exp. if domain name is www.domain.com set DOMAIN_NAME value to: http://www.domain.com Edit STORE_NAME property and set your web store name. For exp. "Book Web Store" - open admin -> Meta Tags -> set Title, Description and Keywords metatags. - open admin -> Payment Setup and set available payment methods -> configure payment gateway to accept online payment transactions. - open admin -> Shipping Methods and configure shipping rates. You may use real-time FedEx or define custom shipping rates. - open admin -> Tax Rates and configure tax rates if any Once this is completed, your store setup is done. Now you can continue and create categories structure and add new products. You may also import categories and products thru admin -> Import Data Note: on admin -> Store Properties page layout properties to set colors and fonts are deprecated. All layout customization most be done to files located in \skins\\store Master Page - \masters\Master.ascx Cascading style sheet - \styles\Store.css Templates - \templates\*.ascx IV. SQL Server setup ------------------------------------------ Your web store \data folder contains schema.sql and insert.sql scripts. Schema.sql creates database schema, insert.sql inserts default data. Open your web store folder and open web.config. Locate section part and comment out MS Access tags: SQL Server 2005 ------------------------------------------ Standard security: Example: Trusted connection: Example: Connecting to SQL Server instance: For SQL Server instance use Servername\SQLEXPRESS to substitute Servername with the name of the computer where the SQL Server 2005 Express installation resides. The syntax of specifying the server instance in Server key is the same for all connection strings. - Open SQL Server Management Studio Express -> create empty xse database (All collations are supported) - Select xse database -> execute schema.sql and then insert.sql script. - Expand Security -> Logins -> add \ASPNET windows account -> select \ASPNET -> right click -> Properties -> select User Mapping -> under "Users mapped to this login" -> check checkbox near xse database -> select xse database -> under "Database role membership for: xse" -> set checked db_owner and public roles -> click OK. SQL Server 2000 ------------------------------------------ - For Trusted Connection: For Standard Security: If you are using specific SQL Server instance use Server name syntax: Servername\Instancename Replace Servername with the name of the computer where the SQL Server 2000 resides. - Open Enterprise Manager -> create empty xse database (All collations are supported. Default: SQL_Latin1-General_CI_AS) - Open Query Analyzer -> execute schema.sql and then insert.sql script. - Enterprise Manager -> Expand Security -> Logins -> add \ASPNET windows account How to add new account and set database mapping: Enterprise Manager right pane -> right click -> New Login... -> select ASPNET account -> click OK -> select Database Access tab -> check checkbox near xse database -> set checked public and db_owner roles -> click OK. ------------------------------------------ - If your SQL Server is located on remote computer set valid IP in Data Source and username/password. Example: - On Windows 2003 by default NETWORK SERVICE windows account is used instead of ASPNET windows account. ------------------------------------------ V. Customer Service & Technical Support ------------------------------------------ For additional help and questions, please visit support forum at http://forums.iqservices.com or contact us at http://www.ecommercesoft.net/contact-us.php Documentation & Help Resources: http://forums.iqservices.com/viewtopic.php?t=183 Website: http://www.ecommercesoft.net Web Store Demo: http://xsenet.iqservices.com Admin Demo: http://xsenet.iqservices.com/cp VI. Purchasing & Licensing XSE .net (for Trial users only) ------------------------------------------ The XSE can be changed to a full working commercial version simply by purchasing and installing a new license. In addition we offer a lease plan with unlimited updates and no setup fee. For more details visit http://www.ecommercesoft.net/ Thank you for your support! XSE Ecommerce Development Team