Spider Sales 2.1 Installation Setup - Demo Version

 

System requirements:

Windows 95, Windows 98, Windows NT 4.0, Windows 2000 or Windows XP
Intel Pentium or higher processor
64mb RAM (128mb or more highly recommended)
World Wide Web server with ASP Script Engine (Microsoft Internet Information Services)

15 MBs of free hard drive space

 

Extracting the zip file

Unzip spider_sales_demo_20.zip to a directory on your hard disk
(e.g. C:\SpiderSales)


After extracting the files, you’ll see 4 directories:
C:\SpiderSales\DataBase
C:\SpiderSales\Export
C:\SpiderSales\Import
C:\SpiderSales\ssEngine

 

Configuring your web server

          Open the Management Console of the Internet Information Services (IIS) or

          Personal Web Server (PWS)


Go to Control Panel => Administrative Tool => Internet Information Services/Personal Web Server

Note: The path my be different depending on your OS version

 

Select your website and create a new virtual directory (right-click on your site and select New => Virtual Directory).

 

Enter a name (alias) for your SpiderSales virtual directory/web site
(e.g. SpiderSales)
enter the name of the directory where you unzipped spider_sales_demo_20.zip file followed by \ssEngine
(e.g. C:\SpiderSales\ssEngine)
and click "Finish".

 

Verify if the virtual directory points to \ssEngine\default.asp (select the virtual directory, click on “Properties” option and click on “Documents” button

 

Note: If you want to create a separate virtual directory for your store (e.g. http://www.your_store.com), create a new virtual directory followed by \ssEngine\Carts\your_store_folder (e.g. C:\SpiderSales\ssEngine\Carts\your_store_folder), and after that verify if the virtual directory points to \ssEngine\Carts\your_store_folder\default.asp (select the virtual directory, click on “Properties” option and click on “Documents” button

 

Note: If you have not access to configure Internet Information Services (IIS) and create new virtual directories then:
- Create a new directory (e.g. SpiderSales) in a directory that contains a virtual directory/web site (e.g. C:\WebSite\Script)

- Unzip spider_sales_demo_20.zip to SpiderSales directory
(e.g. C:\WebSite\Script\SpiderSales)

- go to ssEngine folder, and open path.asp file
(e.g. C:\WebSite\Script\SpiderSales\ssEngine\path.asp)

- replace the following lines:

pathApp = request.ServerVariables("APPL_PHYSICAL_PATH")  with

pathApp = request.ServerVariables("APPL_PHYSICAL_PATH") & “SpiderSales\ssEngine\”

virtualPathApp = theHost & "/" & virDir with

virtualPathApp = theHost & "/" & virDir & “/SpiderSales/ssEngine/”

 

 

Database requirements:

Spider Sales 2.1 supports MSAccess, MS SQL Server or MySql Server

Go to ssEngine folder, and open settings.asp file

Here is a part of the code from this file

 

'---------------------------- SETTINGS FOR MS ACCES DATABASE ---------------

'dbType = "MSACCES" 'connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&pathApp()&"..\dataBase\storeDatabase.mdb;User Id=admin;Password=;"

'const dateSepChar = "#"

'---------------------------- SETTINGS FOR MS SQL DATABASE ------------------

'dbType = "MSSQL" 'const dateSepChar = "'"

'const sqlVersion = "SQL 2000"

'const sqlVersion = "SQL 7.0"

'dim provider

'if sqlVersion = "SQL 2000" then

          'SQL 2000

'         connectionString =  "User ID=your_user_id;" &_

'                                                         "Password=your_password;" &_

'                                                         "Persiste Security Info=True;" &_

'                                                         "Extended Properties="";" &_

'                                                         "DRIVER=SQL Server;" &_

'                                                         "SERVER=your_server;" &_

'                                                         "DATABASE=your_database;" &_

'                                                         "Network=DBMSSOCN;" &_

'                                                         "Address=your_adress,1433"""

'         provider = "MSDASQL"

'else

          'SQL 7.0'

'         connectionString =  "User ID=your_user_id;" &_

'                                                         "Password=your_password;" &_

'                                                         "Persiste Security Info=True;" &_

'                                                         "Extended Properties="";" &_

'                                                         "DRIVER=SQL Server;" &_

'                                                         "SERVER=your_server;" &_

'                                                         "Catalog=your_database;" &_

'                                                         "Network=DBMSSOCN;" &_

'                                                         "Address=your_adress,1433"""

'         provider = "SQLOLEDB"

'end if

'---------------------------- SETTINGS FOR MY SQL DATABASE ------------------

'dbType = "MySQL" 'connectionString = "Driver={MySQL};DATABASE=ss2;USER=;Password="

'const dateSepChar = "'"

' -------------------------------------------------------------------------------------

 

Settings for MSAccess:

If you are using MSAcces, then modify settings.asp as follows:

 

dbType = "MSACCES"

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&pathApp()&"..\dataBase\storeDatabase.mdb;User Id=admin;Password=;"

const dateSepChar = "#"

 

Important: The rest of the code must be disabled using the ' character before any instruction of the database settings

 

 

Settings for MS SQL Server:

If you are using MS SQL Server 2000 then modify settings.asp as follows:

 

dbType = "MSSQL"

const dateSepChar = "'"

const sqlVersion = "SQL 2000"

'const sqlVersion = "SQL 7.0"

dim provider

if sqlVersion = "SQL 2000" then

          'SQL 2000

          connectionString =  "User ID=your_user_id;" &_

                                                          "Password=your_password;" &_

                                                          "Persiste Security Info=True;" &_

                                                          "Extended Properties="";" &_

                                                          "DRIVER=SQL Server;" &_

                                                          "SERVER=your_server;" &_

                                                          "DATABASE=your_database;" &_

                                                          "Network=DBMSSOCN;" &_

                                                          "Address=your_adress,1433"""

          provider = "MSDASQL"

else

          'SQL 7.0'

          connectionString =  "User ID=your_user_id;" &_

                                                          "Password=your_password;" &_

                                                          "Persiste Security Info=True;" &_

                                                          "Extended Properties="";" &_

                                                          "DRIVER=SQL Server;" &_

                                                          "SERVER=your_server;" &_

                                                          "Catalog=your_database;" &_

                                                          "Network=DBMSSOCN;" &_

                                                          "Address=your_adress,1433"""

          provider = "SQLOLEDB"

end if

 

If you are using MS SQL Server 7.0 then modify settings.asp as follows:

 

dbType = "MSSQL"

const dateSepChar = "'"

'const sqlVersion = "SQL 2000"

const sqlVersion = "SQL 7.0"

dim provider

if sqlVersion = "SQL 2000" then

          'SQL 2000

          connectionString =  "User ID=your_user_id;" &_

                                                          "Password=your_password;" &_

                                                          "Persiste Security Info=True;" &_

                                                          "Extended Properties="";" &_

                                                          "DRIVER=SQL Server;" &_

                                                          "SERVER=your_server;" &_

                                                          "DATABASE=your_database;" &_

                                                          "Network=DBMSSOCN;" &_

                                                          "Address=your_address,1433"""

          provider = "MSDASQL"

else

          'SQL 7.0'

          connectionString =  "User ID=your_user_id;" &_

                                                          "Password=your_password;" &_

                                                          "Persiste Security Info=True;" &_

                                                          "Extended Properties="";" &_

                                                          "DRIVER=SQL Server;" &_

                                                          "SERVER=your_server;" &_

                                                          "Catalog=your_database;" &_

                                                          "Network=DBMSSOCN;" &_

                                                          "Address=your_address,1433"""

          provider = "SQLOLEDB"

end if

 

Note:  your_user_id, your_password, your_server, your_database, your_address will be replaced with your values.

Important: The rest of the code must be disabled using the ' character before any instruction of the database settings

 

Create the MS SQL Server database

Open Microsoft SQL Server Enterprise Manager, right click on the "Database", select "New database" option and create a new Database (e.g. SpiderSales). After you have created the new database, open Microsoft SQL Query Analyzer, connect to your SQL Server Database and select the SpiderSales database.

Click on "File->Open" and select mssql.sql file from SpiderSalesFolder/Database.

Click on "Query->Execute" to run sql script you loaded. After that close the Query Analyzer.

 

At this moment, the database is created, but the tables are empty. To fill tables with default information, you must import the MSAccess SpiderSales database (Database/storeDatabase.mdb) to MSSQL SpiderSales database.

From Microsoft SQL Server Enterprise Manager, right click on your SpiderSales database, select "All Tasks->Import data" and click "Next".

Select the data source as Microsoft Access and enter the path of MSAccess database (Database/storeDatabase.mdb) in the "File Name" box.
Click "Next" and make sure the destination data source is your MSSQL Spider Sales database.
Click "Next" and select "
Copy table(s) from source database".

Click "Next" and click on "Select All" button to select all tables to be copied.

Click "Next" and make sure if "Run Immediately" check box is checked.

Click "Next" and "Finish"

 

Settings for MySQL Server:

If you are using MySQL Server then modify settings.asp as follows:

 

dbType = "MySQL"

connectionString = "Driver={MySQL};DATABASE=your_database;USER=;Password="

const dateSepChar = "'"

 

Note: your_database will be replaced with your database name.

Important: The rest of the code must be disabled using the ' character before any instruction of the database settings

 

Create the MySQL database

Open your MySQL Server and create a new database (e.g. SpiderSales)

Run your MySQL client, connect to the SpiderSales database and execute the mysql.sql script from SpiderSalesFolder/Database/mysql.sql

The MySQL script will create the tables in the database, and also fill tables with default information, so it is not necessary to import MSAccess SpiderSales database to MySQL database.

 

 

Getting Started:

Spider Sales 2.1 includes 4 built-in demo stores.
The login information for these stores is:

Book Store – user name : book, password : book

Computer Store – user name : computer, password : computer

Electronics Store – user name : electronics, password : electronics

Multi Store – user name : mstore, password : mstore

The default values for Mall Admin sections are – user name : mall, password : mall

 

Note: There are some external modules/DLLs uses in Spider Sales 2.1 Shopping Cart. Spider Sales 2.1 support files upload, automatic email notification, real time credit card processing, real time shipping.
We recommend you to install in your system the following components, depending of the admin settings : Microsoft XML Parser, ABC Upload, ASP Smart Upload, ASP Email.
Please read carefully the admin options to view/modify the settings for these components.

 

Note: The demo version does not contain the Check out part from the store.

The Full version of Spider Sales 2.1 is 100% Open Source.

 

 

Support and Services:

For any question regarding installation, configuration or any other issue about Spider Sales 2.1 please contact our support team at support@spidersales.com

 

Purchase information:

http://www.spidersales.com

info@spidersales.com