CyberStrong eShop Installation and Setup Guide

Installation | License Agreement | Upgrading | SQL | Revision History

Installation Instructions

Welcome to CyberStrong eShop the easy to use, easy to install shopping cart system for Windows NT/2000 servers.

To install CyberStrong eShop proceed as follows:

  • Create a sub folder off the root folder for your Web site. We recommend naming your folder eShop, but you may choose any name you wish. Microsoft FrontPage users may find it beneficial to create a separate "web" to store their eShop files.
  • Give your eShop folder permissions. To operate properly, your eShop folder will require modify permissions for the "IUSR_<Machine Name>". If you need assistance in setting your folder permissions, please see these screen shots.
  • Unpack the contents of this zip file into your eShop folder. The zip file contains a number of sub folders so be sure to check the box "Use sub folder names" (or the like) when you unpack. If you have already entered data into the free trial version of CyberStrong eShop and wish to retain it, please read our instructions on upgrading your eShop later in this document.

    Optional: If your host provider requires that you move your eShop database to another folder, locate and change the line:

                           ReturnValue = RootPath & "<database name>.mdb"

    in the file userexit.asp to reflect this by following the instructions contained therein.
  • Test your server. Your CyberStrong eShop comes with a utility to test your database connectivity and server compatibility.  To run the utility, launch the URL http://<your domain name>/<your eShop folder>/admin/mTest.asp and follow the instructions contained therein. We strongly recommend running these tests prior to attempting to operate your eShop.
  • Test your installation. Our database comes pre-configured with a small collection of products for a fictitious caf. To launch your CyberStrong eShop, load the following address into your browser: http://<your domain name>/<your eShop folder>/10Browse.asp. You should see a display of the items in the caf. Move through the screens and place a test order. There are five screens in total. Note that your CyberStrong eShop software is shipped in "Demonstration Mode" to make initial testing and learning easier.
  • Configure your eShop software by launching the following URL: http://<your domain name>/<your eShop folder>/admin/mLogin.asp where you will find further instructions on configuring your shopping cart software. Your temporary Login ID and password is cyberstrong which will be automatically entered for you until you change them in eShop Setup/Security.
  • Link to your new shopping cart. When you are ready to go live with your shopping cart, click the Demo Mode button at the bottom of eShop Setup and set the parameter "Demonstration Mode" to "No". Create a link from your Web site to 10Browse.asp. Be sure to fill in your Secure and Non-Secure prefixes in eShop Setup/Payment. If you are unsure as to how to secure your shopping cart, please contact your host provider.

Many of the common problems encountered when setting up your CyberStrong eShop are covered on the FAQ page on our Web site at www.CyberStrong.com/eshop.

  [top]

License Agreement - Please Read Carefully

Each source code page of this product has been seeded at point of sale with one or more lines of unique information. Every copy of CyberStrong eShop is traceable to its purchaser. No portion of this code may be copied, redistributed or resold without the written permission of CyberStrong Internet Services, Inc. All violators will be prosecuted.

CyberStrong Internet Services, Inc has confirmed the operation of this software through careful testing. By using this software you agree that CyberStrong Internet Services, Inc. will not be held responsible for chargebacks, errors, loss of revenue, loss of data, web server failure, downtime, hardware failure or any disputes that may arise from the use of this software in modified or unmodified form.

CyberStrong eShop software is supplied 'as is'. No warranty is given either implied or expressed. Purchasers use this software entirely at their own risk.

Each purchase of CyberStrong eShop, including any gateways and/or add-ons, entitles the purchaser to install the software on one web site and one development machine only. The purchaser is permitted to make alterations to the software, but the copyright of the original code remains with CyberStrong Internet Services, Inc. Any software which uses any portion of CyberStrong eShop as a base may not be resold without the expressed written permission from CyberStrong Internet Services, Inc. Further installs of CyberStrong eShop will require further licenses to be purchased from CyberStrong Internet Services, Inc.

VARs may freely distribute the free trial version of CyberStrong eShop for the purpose of promoting their eCommerce offerings.

CyberStrong Internet Services, Inc reserves the right to refuse to sell CyberStrong eShop to any individual or organization for any reason.

NO REFUNDS WILL BE GIVEN. Before purchasing, the purchaser should satisfy him/herself that he/she has the technical ability to set up the software, that the software will run on the hardware/software platform that it is intended to run on and that the software is appropriate and capable of fulfilling its required role. If in any doubt, please download and run the free trial version of CyberStrong eShop or contact CyberStrong Internet Services, Inc before purchasing.

Although we encourage the customization of CyberStrong eShop by qualified ASP programmers, you agree that CyberStrong will not be held responsible for the correct operation of its software following the modifying of its source code or database structure in any way, or by the entering or modifying of data in its database by any means other than the supplied Web based database administration screens.

CyberStrong's copyright messages within the software code may not be removed. Branding is not permitted without the expressed consent of CyberStrong Internet Services, Inc.

CyberStrong Internet Services, Inc reserves the right to revoke all licenses sold to a purchaser if the terms of this contract have been breached or CyberStrong's copyright has been violated. In such circumstances, the purchaser agrees to destroy all copies and derivatives of the software in its possession within seven (7) days.

Use this software at your own risk.

  [top]

Upgrading your CyberStrong eShop

The following will assist you in upgrading your CyberStrong eShop software.

Version numbers

CyberStrong eShop is released with version numbers of the following form:

major.minor.revision

CyberStrong eShop releases carrying version number 1.4.0 or later are upgradable without loss of product data. To upgrade your database to the current version, proceed as follows:

  1. Install and test your upgrade package in a new folder as described in the section Installation Instructions above. There is no need to adjust your configuration settings at this time.

  2. Once your upgrade is running properly, copy your old database over the new one. If you are upgrading your CyberStrong eShop from the free trial version, you must first rename your database file, eShop.mdb, to match the name of the database supplied in your eShop distribution.

  3. Log into the admin area of your new eShop. Use the Fix utility found in eShop Setup/Maintenance to bring your old database up to the new revision. Your new eShop now contains your existing data. Test it again.

  4. New releases of CyberStrong eShop often contain new configuration parameters and tables. Each of these are initially supplied with intelligent defaults to get your upgrade up and running quickly. However, to get the most out of your CyberStrong eShop upgrade it's a good idea to review all your configuration parameters at this time.

  5. If you have made changes to the eShop source code in order to customize it, you will have to manually re-apply these changes to your upgrade and re-test.

  6. Rename your old eShop folder to archive it, then rename your new eShop folder back to its production name.

  7. Your upgrade is complete!

Compatibility Issues

Beginning with version 4.0, the meaning of the ReturnValue in your userexit.asp file has changed slightly. If you are upgrading from a pre 4.0 version, and plan to retain your old userexit.asp file, you will need to remove the last line containing the assignment ReturnValue = 0 from the final Case Else clause in this file. The userexit.asp file supplied with version 4.0 and later is correct. Some pre version 4.0 owners may also need to remove the lines:

Case usrCalcShippingCharges' Sample custom shipping calculation ...    ReturnValue = UserVal1 * 0.1If ReturnValue < 1.00 Then    ReturnValue = 1.00End IfUserExit = CBool(True)

also found in their existing userexit.asp file.

Starting with version 3.3 payment gateway information is specified under Edit/Review Payment Methods on eShop Setup/Payment.

With the introduction of version 3.0 the meaning of the General Setup parameter Home State has changed. Please be sure to review the setting of this parameter before running CyberStrong eShop following an upgrade to this version.

Starting with Version 1.5.1, CyberStrong eShop no longer requires the file Global.asa. If you have this file from a previous eShop version, please delete it. Otherwise leave your Global.asa file as is.

Beginning with version 1.5.4 of CyberStrong eShop the meaning of the General Setup parameter Secure Server Prefix was changed to support a broader set of secure server arrangements. If you are upgrading your eShop from a pre version 1.5.4 edition of CyberStrong eShop please visit this parameter in General Setup and review your setting.

In addition, this upgrade requires that you move the following files from your products folder to your images folder:

Order.gif, Top.gif, Home.gif, NoPhoto.gif and BlkPhoto.gif

Starting with version 2.2.0, you will also need to specify your non-secure prefix.

Beginning with version 2.3.0 all administration files have moved to a new folder called admin. The registered version of CyberStrong eShop ships with a file which contains information on how you can use your admin folder to further secure your eShop.

Pre version 1.4.0 eShops

Regrettably, if your version of CyberStrong eShop is pre version 1.4.0 you will not be able to upgrade automatically. In this case you will have to manually move your data from the old to the new database. If you own Microsoft Access you may be able to use it to help you in this process. Otherwise, you will have to re-enter your configuration and product data via the eShop Web based configurations screens at eShop Setup.

Need more help?

If you require additional assistance, please visit our Web site at:

www.CyberStrong.com/eshop

  [top]

Connecting To Your SQL Server

CyberStrong eShop is fully SQL compliant and has been tested using Microsoft SQL Server Version 7.0. This document will assist you in establishing SQL server connectivity with your eShop.

Step 1: Become Familiar With CyberStrong eShop

We suggest that prior to porting your eShop to SQL that you become familiar with its operation using the supplied MS Access database.

Step 2: Import the Database Schema and Test Data

A SQL command file, esCreate.sql, is provided with your eShop distribution. Run  this file on your SQL server following the instructions appropriate for your server.

Step 3: Specify a Connect String

Normally, CyberStrong eShop stores its customization settings within the eShop database. However, because database connection is not possible without a connect string, eShop stores this parameter in its ../userexit.asp file.

To specify your SQL connect string, open the file ../userexit.asp located  in your main eShop folder using Windows Notepad or similar plain text editor. Locate these lines:

Case usrGetDBPath    ' Returns path to MSAccess database. Examples:    ' Simple Path:                   RootPath & eShop.mdb    ' Relative From eShop Folder:    RootPath & data/eShop.mdb    ' Relative From Web Root Folder: /data/eshop.mdb    ' Full Path:                     d:/inetpub/myweb/data/eShop.mdb    ' DSN:                           DSN=eShop    ReturnValue   = RootPath & "eShop.mdb"    cstServerType = "MSAccess"    UserExit      = True

Your file may differ slightly. Change the word True to False in the line beginning UserExit=. Now, in the same file, locate these lines. Note that in the example below we have split the line beginning ReturnValue for clarity.

Case usrGetConnectString    ReturnValue = "Driver={SQL Server};Server=ServerName;                   Database=DataBaseName;UID=UserID;PWD=Password"    cstServerType = "SQL"    UserExit      = False

Enter your SQL connect string between the quote marks following the ReturnValue =. You must also change the word False to True in the line that begins with UserExit =. Save this file.

Log in to the admin area of your eShop in the usual way. To install your eShop's optional features click Maintenance/Upgrade or Fix/Upgrade Database.

Your SQL compliant eShop is now ready to use.

[top]

Revision History

Version Changes
4.0 Redesigned admin area. * Added an Order History report. * Revised optional UPS live shipping rate lookup. * Added support for optional USPS live shipping rate lookup. * Display shipping rates, for all shipping methods, in drop down box on the Payment/Shipping screen. * Allow free shipping to be specified per shipping method. * Implemented ISO 3166 standard country names. * Collect customer's IP address and browser language setting for incoming orders.
3.3 Added PayPal (IPN), VeriSign (Payflow Pro), WorldPay (Select Junior), Authorize.net (ADC Direct) payment services. * Editable record count message. * Enhanced Order Review screen to allow customer and payment editing, and option to enable repeat payments. * Option to suppress collection of credit card information. * Allow those gateways that are able, to collect credit card info.
3.2 Added support for coupons. * Added a check box for customer opt-in mailing list (below customer's e-mail). * Added support for 2CheckOut.com payment service. * Optional state drop down box. * Optional customer login.
3.1 Added support for embedding CyberStrong eShop into an existing Web site.
3.0 Added running cart totals. * Added sale price. * Added list price. * Added support for multiple categories. * Added amount editing per product. * Added support for purchase orders. * Added credit card number greeking. * Added support for free shipping over a set amount. * Added support for credit card encryption. * Added tax override. * Added ability to suppress "View All" button. * Revised Order Review screen. * Added feature enable/disable.
2.3.0 Added support for digital downloads * Created separate admin area for increased security.
2.2.0 Added support for product discounting. * Added support for minimum quantity and minimum order total enforcement. * Added support for SurePay.
2.1.1 Added general parameter to support the display of shopping cart pages as Left/Center/Right. * Added support for DSN or DSN'less connection.
2.1.0 Added support for live UPS rate lookup.
2.0.1 Added stock status feature. * Added "new until" feature for new product introduction. * Added automatic shipping confirmation by e-mail feature. * Improved order review screen. * Added "Create Catalog" feature to create static pages for search engine indexing.
2.0 Redesigned cart look and feel. * Increased width of product description area to support longer descriptions. * Added long description field in Products table.
1.6.0 Added quick table browse. * Added pull-down category sellection to products table maintenance screen. * Added support for CSC collection. * Added support for the JMAIL e-mail send component.
1.5.6 Added support for SQL servers.
1.5.5 Added ability to bypass credit card check for cash sales. * Added automatic display of "No Photo Available" image in place of missing product image.  * Products table now automatically updated on image upload.
1.5.4 Generalized the meaning of the General Setup parameter Secure Server Prefix to cover a wider set of host SSL configurations.
1.5.3 Added drop down category selection on pages 10Browse.asp and 20Review.asp.
1.5.2 Added user exit for remote database location.
1.5.1 Add support for browser upload. * Add automatic delete of product images and options in product table editor.  * Added provision to override automatic deletion of old customer and order records.
1.5.0 Added support for Authorize.net, LinkPoint and VeriSign credit card authorization gateways.
1.4.5 Corrected minor problem with date handling in 10Browse.asp
1.4.4 Corrected problem with Start/End date detection and category browsing in 10Browse.asp
1.4.3 Added support for ASPMail * Removed length restriction on Description field * Added provision to change button face text on "Continue Shopping" button * Added "memory" for login and password * Corrected problem with browse after search * Corrected addition error in eMail confirmation message. * Improved display under Netscape.  * Pre fill login screen input boxes with default login ID "cyberstrong" to assist first time users.
1.4.2 Added instruction "Click picture for expanded view" on 10Browse.asp
1.4.1 Minor wording change on buttons (10Expand.asp)
1.4.0 Added support for product options * Added Keyword field in Products table * Foreign currency symbol support added * Made "top" and "order" buttons user configurable * Browse page size now user configurable * Added "Hide" field to products table * Changed "Type" field to "Category" field * Added support for sub categories * Added user configurable message to bottom of last order screen * Improved table editor displays long fields in input box * Order and customer records retention period now user configurable.
1.3.2 Added search feature on browse screen * Added support for forward and backward paging on browse screen * Added Update > button on all configuration screens * Replaced ASP clear with JavaScript clear for quicker form handling in configuration editor * Corrected problem with currency display on update * Added test for EndDate >= StartDate in Products table update * Strengthened validation on fields in configuration editor * Tightened e-mail verification on customer screen  * Added Reset button to all configuration tables. * Fixed problem with multiple item delete in 20Review.asp. * Added mFix.asp utility.
1.3.1 Add support for CDONTS e-mailing of customer and vendor order confirmation messages.
1.3.0 First external release.

[top]

| | | New Page 2 | Riinvestments Ltd | - | www.bmsofttech.com - /pre | : RIInvestments Ltd : | www.bmsofttech.com - /pre | - | New Page 1 | - | - | www.bmsofttech.com - /pre | www.bmsofttech.com - /pre | - | - | What is Aromatherapy | B M Software-Sample page | Sft2 | Sft3 | Sierrafashions | Top Page | ArrayArrayArrayArray