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
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
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: