SalesCart Advanced Problems
This FAQ is being updated on a regular basis,
come back and check for new issues, and tips.
This FAQ contains answers to advanced questions that
pertain to questions regarding advanced customization.
Note: sometimes error
message wording may not be 'exactly' the same as that listed below.
Common Problems
-
I would like to be able to run SalesCart PRO and have my currency
and date values display in Dutch Format. So it looks like fl. 25,- and
19-10-1999.
-
I wish to change from using a
dsn-less connection to a "hardcoded" dsn.
-
How do I keep the customer from
checking out immediately each time they add an item to their cart. This is a typo in the SalesCart documentation section that deals with this.
See the changes below.
-
Can I update the Access97 database
to Access2000 or greater.
-
How do I change or add payment
options?
-
How do I Format Database Results from a
FrontPage Database Results query as Currency?
-
My web site is published on to
the server and I keep getting this error:
Active-X can't create Object.
-
How do I secure my shopping
cart web?
-
My email confirmation and
customer email receipts seem to be delayed.
-
Answers
SalesCart can be localized by editing the global.asa and adding the
localization code for your country. For example, for Dutch, edit the
global.asa file and add the following within the begin session and end session
identifiers.
Session.LCID=1043
A. Edit the global.asa file and change the following line then reboot
your computer.
Before: Session("ConnectionString") = "Driver={Microsoft Access driver
(*.mdb)};dbq=c:\webshare\wwwroot\protest\fpdb\shop.mdb;"
to
After: Session("ConnectionString") =
"DSN=nameofdsn"
Postponing Customer Checkout
This issue is documented in the manual, but the
documented method can cause problems with newer versions of Netscape because
Netscape cannot understand .asp pages.
-
By default, SalesCart PRO automatically takes customers to
the checkout process after a single item is ordered. However, you may want to
keep your customers on the same page without having them start the checkout
process. To configure SalesCart PRO to remain in the current product page,
follow these steps:
- In FrontPage Explorer File>>Open Web Folder and type in the
address of your Web site.
- Click OK.
- Locate the file named shop1.asp in the cgi-bin folder.
- Double-click on the file to open it, then click html mode to make
your changes. Locate the 111th line from the top:
<meta HTTP-EQUIV="Refresh" CONTENT="0;
URL=view1.asp">
- This line tells SalesCart PRO where to go next. Highlight the text.
Replace this entire line with the following.
<script language="javascript"><!-- begin script
history.back(1)
// end script --></script>
-
You may change this line back at a later time if you wish to have SalesCart
PRO go directly to the checkout phase. When done the file should look this
way.
<script language="javascript"><!-- begin script
history.back(1)
// end script --></script>
Yes.
Payment options are easily changed WITHOUT going into the
database. The steps to add or change payment options are as follows:
1. Open the 'payment2.asp' file in the 'cgi-bin' directory.
2. To modify a payment option; right click on the radio button for the option
and select 'form field properties'. Change the Value to 'Diners Club' or
whatever. Now when an order is placed, and you view the order, the payment
method will indicate 'Diners Club' or whatever.
3. To add a new payment simply copy an existing radio button and follow the
instructions in line 2 to modify its value to reflect the new payment option.
You can edit the .htx form as required to add or delete options, add graphics,
change the table widths, columns etc. as necessary.
Microsoft has documented this in a so-called
Q-article #Q250465. Go here.
http://search.support.microsoft.com/kb/c.asp?SD=SO&LN=EN-US
and enter that Q Article Number A250465.
My web site is published on to
the server and I keep getting this error:
Active-X can't create Object.
This is usually an indication that the server you
are running the shopping cart on and this can be a local server at http://localhost
as well is running MDAC 2.5. There is an "undocumented" bug with
Microsoft MDAC 2.5; however, this bug only occurs if you do a so-called
"clean" install of MDAC 2.5. A "dirty-install" works
fine.
Solution: Download and install MDAC 2.1
first and then download and reinstall MDAC 2.5. You can obtain MDAC
2.1.2.4202.3 (GA) at http://www.microsoft.com/data
generally or http://www.microsoft.com/data/download_21242023.htm
specifically.
How do I secure my shopping cart
web?
This is well documented in the online technical
manual and online help files that accompany the product. Search for
"Adding SSL" in the manual.
My email confirmation and customer
email receipts seem to be delayed.
The Microsoft SMTP Service queues email and then
delivers the email all at once. If the email is delayed for more than 1-2
hours, there is probably some kind of problem delivering the email. Troubleshooting email is not an easy thing because there so many layers of
problems. Your ISP can use Telnet along with troubleshooting messages that
the SMTP service creates to help diagnose and solve this sort of problem.
I get this order at the
confirmation page? Does any one know what this is. Mike
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'FormatCurrency'
/cgi-bin/confirm2.asp, line 137
This error occurs because at least one of your
shipping cost options is not a number or has special characters in it. You
should not put "$" or "," or any other special characters
for shipping costs. Only a real number can go in this field.
|
