| Home > ASP
Version Help > Ecommerce template instructions
Ecommerce Template ASP version instructions
What you need.
For the ASP ecommerce plus templates, you need a windows server
that is capable of using a Microsoft Access database. For this
reason
Linux
servers running Chillisoft ASP are not suitable, as they do not
have the capability to use a Microsoft Access database so
you will probably need the PHP
version.
Setting the database connection.
Access Database (Most Users) The Microsoft Access database is contained in /fpdb/vsproducts.mdb.
The default connection to this location should be correct for the
majority of installations, however if you should need to change
it, the file to edit is in /vsadmin/db_conn_open.asp. Examples are
provided in this file of different types of connection, which can
be edited with notepad or other text editor. (Do not use a word
processor to edit this file).
The directory that contains your database must be writeable, but
not browseable. If the database is not writeable,
then customers cannot add products to their shopping cart. If
the directory is
browseable, then potentially people could download your database
and gain access to your login details and sales records.
Once you have the database connection set up, check that
it is not possible to download it by typing in the URL of the
database location in your browser. This will be something like
www.yoursite.com/fpdb/vsproducts.mdb
A lot of hosts provide a directory below the web root specially for databases,
and it is imperative that you use this if
this is the case. If
not, then your host can set the permissions described above for
you. For more detailed instructions please look at our database
set up page.
 |
 |
SECURITY TIP
The best place for your database is outside the web root. Most hosts provide
a special folder for this with the database permissions already set. Using
a folder outside the web root will make it difficult for anyone to download
your database and gain access to your username and password. Otherwise
you must set the permissions on your database folder so that your database
cannot be downloaded. More information is available here.
|
|
|
 |
|
|
|
SECURITY TIP
Rename your database from vsproducts.mdb to a name of your choice, (keeping
the .mdb extension of course).
Examples would be (though don't use ours) yourstore591.mdb or database2221.mdb
This will make it harder for anyone to find your database if your database
folder permissions are set incorrectly.
|
|
|
|
|
Troubleshooting
If you receive this error when trying to add new products or categories:
Operation must use an updateable query.
...then it means that your database doesn't have write permissions.
You can contact your host and ask them if there is a special folder
on the server where the database should reside or if they could
apply the correct permissions (writeable but not browseable) to
the fpdb folder.
SQL Server database setup. (Advanced users only)
You can use an SQL Server database with your Ecommerce Plus template
and here are the steps to getting your connection setup.
Firstly, you need to contract some space on an SQL Server database
with your host. They will provide you with 4 pieces of information,
and using those you need to fill in the blanks in the database
connection below in your vsadmin/db_conn_open.asp file.
sDSN = "driver={SQL
Server};server=SERVERNAME;uid=USERNAME;pwd=PASSWORD;database=DATABASENAME"
Next, you need to open the file vsadmin/includes.asp in notepad
and look for . . .
sqlserver=false
. . . and change that to . . .
sqlserver=true
Now you need to create the actual SQL Server tables. There are
2 ways to do this. One is to use our SQL Server creation script
which is available here for a small extra charge.
The other way is to use the Access database and "upsize" it
to SQL Server.
For this you can use Access, and go to Tools -> Database Utilities
-> Upsizing Wizard.
However the transformation process never seems to properly create
the autonumeric fields or keyfields and without these the SQL Server
database won't work properly. What you need to do to patch this
up is use the SQL Server Enterprise Manager, go through each table
of the Access database and find what the keyfield is and give the
relevant column in the SQL Server table the keyfield property.
Then check in the Access database to see if one of the columns
(normally the keyfield) has the AUTONUMBER property and if so give
the same column in the SQL Server database the IDENTITY(1, 1) property.
Using mySQL with the ASP version.
Open the file vsadmin/includes.asp in notepad and look for . .
.
sqlserver=false
. . . and change that to . . .
mysqlserver=true
In your vsadmin/db_conn_open.asp file you need to set the following
variables, your host should be able to supply you with the correct
ones.
sDSN = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=dbnamehere;UID=username;PWD=password;OPTION=16427"
You will need the mySQL connector driver and that is available
here. Now
you need to create the actual mySQL tables. We recommend using
our mySQL creation script which is available here for
a small extra charge.
Getting Started.
Once the database connection is correctly set, you can access the
admin area by opening the page /vsadmin/admin.asp in your browser.
The default username and password are mystore / changeme. Take time
to go through the admin pages and configure the settings for your
requirements as detailed below.
Shipping Calculations.
8 kinds of shipping calculations are provided.
No shipping -> Shipping costs are not added. -> (more
information)
Flat rate shipping -> Shipping costs can be set individually
per product. -> (more information)
Weight based shipping -> Here, shipping is calculated
by product weight according to the shipping zone to easily facilitate
international shipping. If Weight based shipping is selected, then
the country zone can be set in the countries admin panel, and new
zones can be edited by following the Edit Postal Zones link in the
main admin panel. -> (more information)
Price based shipping -> Same as above but
based on price rather than weight changes. -> (more
information)
UPS shipping -> (more
information)
USPS shipping -> (more information)
Canada Post
-> (more information)
FedEx Shipping -> more information
Handling - this charge can be set for all your
products in the main admin page.
Setting up Payment Providers.
To set up the details for Payment Providers, chose the link Edit
Payment Providers on the admin home page. The available payment
providers will be show on this page, with the active ones in bold.
Please note it is possible to have more than one payment provider
active at a time, so, for instance giving you the opportunity to
use both a Credit Card based system like 2Checkout together with
a system like PayPal. If more than one is chosen then your customers
are given the choice of payment service in the checkout phase.
For all payment providers you need to ensure that on the store
admin settings the URL to your web site is correct. To set this
go to the main admin page, admin.asp, and chose the Edit Admin Settings
link.
Choose from the list below for detailed instructions on setting
up for the individual payment providers.
Email Notification.
If you chose this option, then your customers can make an order
without actually having to go through a payment routine. You can
use this option if you wish to take orders that are then paid by
bank transfer, check etc at a later date. It's not possible to
send credit card information via email.
Capture
card system.
The Capture Card system is available so that you can safely capture and store
credit card numbers from your customers to process on your own credit card processing
terminal. Requires ASPEncrypt component on your server and an SSL certificate...more
information
Security Considerations.
Firstly, check to make sure that no-one can download your database.
To do this, enter the URL to the database in your browser. For instance
http://www.yourstore.com/fpdb/vsproducts.mdb
If your browser asks if you would like to download the file, that
means that the security settings for your database folder are set
to allow browsing. You need to ask your host to correct this.
The default login and password for the admin area is mystore / changeme.
You are encouraged to change this immediately.
Fraud is always a factor in online sales unfortunately. Always double
check with your payment providers admin area to ensure that a sale
has been properly processed before shipping products.
Checklist
Please do read through our checklist here before
going live with a site.
Email Setup.
If in testing you receive emails with no problem, then you need
do no more here.
If however you do not receive emails, please visit our email
help page.
|
