| Article Information |
Shipping cost is always 0
SYMPTOMS:
Shipping cost calculated is always 0.
VERSIONS AFFECTED:
Q-Shop Lite and Pro v3.5.0 and 3.5.1.
PROBLEM:
This is caused by a syntax error in checkout.asp.
FIX:
To correct this problem, edit the file checkout.asp and where it says:
procchkout.asp" method="POST" name="CheckoutForm>
change it to:
procchkout.asp" method="POST" name="CheckoutForm">
Notice the missing quote (... more)
|
Error message in v3.5.0 and 3.5.1 when resetting an Access database
PROBLEM:
When resetting an Access database the following message is displayed:
Deleting table OrderLines (DELETE * FROM OrderLines)...
Error 9: Subscript out of range
Deleting table ...
VERSIONS AFFECTED:
Q-Shop Lite and Pro 3.5.0 and 3.5.1
SOLUTION:
Edit admin/reset_DB.asp and where it says:
Dim aryTables(1,13)
Change to:
Dim aryTables(1,14)
(... more)
|
How can I make the user area secure with SSL as well?
Yes. If you have your own certificate this is a very simple process, the problems are with shared certificates since the session information cannot be shared across domains. If you do have your own, i.e. your secure and non-secure domains are only different in the https bit then:
1) Edit inc/layoutlib.asp and where it says:
users.asp">My Account
change to:
users.asp">My Account
This appears a couple of times for (... more)
|
List of known bugs in Q-Shop v3.5.0
The list of known bugs in v3.5.0 with how-to instructions to correct them is now available from:
http://www.quadcomm.com/qshop/buglist_v350.asp
A service release (3.5.1) is available, see http://quadcomm.com/forum/topic.asp?topic_id=594&forum_id=2&Topic_Title=Q%2DShop+v3%2E5%2E1+Released&forum_title=Q%2DShop+Technical&M=True&S=True
(... more)
|
How can I change the number of products displayed per page?
You can define the maximum number of products displayed per page by changing the parameter MaxItems in the configuration file inc/parameters.asp. By default this is set to 10:
MaxItems = 10 'Maximum number of items displayed at once in a page
(... more)
|
In v3.5.0 Sitemap link returns error 500 (Type mismatch: 'UBound')
When clicking the sitemap from the left menu this error appears:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
Please try the following:
Click the Refresh button, or try again later.
Open the
bigorange home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support (... more)
|
I have changed the theme default but it is not taking effect.
This is not an error. The theme setting is associated to each user session when it is created. This is to allow users to change their own theme setting without affecting everybody else.
This means that if you change the setting and immediately access the shop it will not take effect since your already have an open session with the old setting. If you close the browser a new session will be created and the new setting will then take effect.
(... more)
|
Using double byte characters and other character sets
If you are using Q-Shop in a language other than English, especially double byte character sets like Japanese, Chinese or Korean, it is possible that the pages won't look correctly. You may also experience other problems like searches not finding terms that are present in the products names or descriptions.
This problem is generally caused by using an incorrect character set. To correct this, use the Shop Settings section in the Control Panel to set the character set to the correct value (... more)
|
Error resetting the local user
SYMPTOMS
When a user access the home page and is recognised as an existing user she will be greeted by the name and the message "(if you are not Xxx Xxxxx, please click here)" will be displayed. When clicking the link a 500 error message is displayed.
VERSIONS AFFECTED
Q-Shop Pro and Lite v3.5.0.
CAUSE
There is a bug in inc/userlib.asp. Follow the instructions below to correct it.
RESOLUTION
Edit inc/userlib.asp in notepad or another plain text/html editor and (... more)
|
Error sending feedback using mail.asp (v3.5.0)
SYMPTOMS
When submitting a message using the "Mail us"/feedback page fmail.asp an error message is displayed even though the message is sent successfully.
VERSIONS AFFECTED
Q-Shop Pro and Lite v3.5.0.
CAUSE
There is a bug in mail.asp. Follow the instructions below to correct it.
RESOLUTION
Edit mail.asp in notepad or another plain text/html editor and where it says: If (errNumber1 < 0) OR (errNumber2 < 0) OR True ThenChange it to: If (errNumber1 < 0) OR (... more)
|
Can I download a demo version?
Since Q-Shop comes with full source code, we do not have a demo version that you can download. However, you can use our full online demo version any time. (... more)
|
Can I download the manual?
Yes, you can download the full manual and quick installation guide from the download area. (... more)
|
I purchased a previous version, can I upgrade it to the latest one?
Customers of version 3.x will get FREE updates for newer 3.x versions.
Customers with older versions can purchase an upgrade to version 3.0 Pro or Lite. Please visit the online order and prices page.
(... more)
|
Migrating the database to MS SQL Server
MS SQL Server is a far more powerful database system than Access. For high traffic sites or where numbers of products are very high, this should be the database of choice. See why choosing MS SQL Server.
Details on how to migrate the provided Access database to SQL Server can be found at in the user manual.
(... more)
|
How can I increase the number of price options, etc?
QUESTION:
How can I increase for a product the number of related products, sections a product can belong to and price options?
ANSWER:
To do this you need to edit in /admin/inc the files addprod.asp and showproddata. There is parameter for each option at the top:
'General constant declaration
nMaxPriceOptions = 5 'Maximum number of Price Options allowed per product
nMaxRelProds = 6 'Maximum number of Products Related allowed per product
nMaxSections = 5 'Maximum number of (... more)
|
How can I check the version I have?
To check the version that you currently have, check the file version.txt in /Manual. The contents will be something like:
Version: v2.5
Revision: A
Date: 20/04/2002
(... more)
|
What are the differences between Q-Shop Pro and Lite?
Q-Shop Lite is base shopping cart, Q-Shop Pro adds a number of advanced features like user reviews and gift certificates.
For a full list of features included in each version check the document Features Summary.
(... more)
|
What payment providers are supported?
With Q-Shop you will be notified every time there is an order but this is only the start of the process. You can then either process payments offline (manually) or use the services of a payment gateway to process credit card transactions in real time.
Q-Shop includes the following payment gateways:
Authorize.Net (AIM)
WorldPay
Paypal (including IPN)
Payflow Link
2checkout.com
Datacash
Paybox.com (France)
Q-Shop can be adapted easily to other systems using one (... more)
|
Is Q-Shop an ASP shopping cart or a full online shop solution?
Q-Shop is not just an ASP Shopping Cart, it is a complete e-commerce online shop solution. Strictly speaking, a shopping cart simply allows customers to select products to be purchased. Q-Shop offers that and much more like a full dynamic catalog, online order process, web-based shop administration and many more feautes.
So don't think of Q-Shop as just an ASP shopping cart but a complete online shop solution. You won't need additional software or a developer to build everything else, it (... more)
|
Can I see a demo?
Yes, just go to http://www.quadcomm.com/qshop/demo.asp and visit the demo shop. You can visit the user front-end and the administrator interface as well (Control Panel). (... more)
|
What are Q-Shop's server requirements?
Q-Shop has very simple requirements. Mainly you just need a Windows host with support of ASP.
For full details and how to check whether your server will be compatible, please check the Q-Shop requirements page.
(... more)
|
Can I have product options?
Yes. Each product can have up to two different selectable option types like size and color plus one optional price option that modifies the final price.
Options
Each product can have up to two option types (color, size, etc). You can have different types for each product with different values for each product (red, blue, green). Some shopping carts will force you to share the option values across products, which isn't very flexible. With Q-Shop you can do this by product to match your (... more)
|
Does Q-Shop allow cross-selling?
Q-Shop offers several cross-promotion tools. One of them is the ability to suggest other products based on the product being displayed or the products in the customer's shopping cart.
Product suggestions allow you to cross-sell products that are related to products your customers have already shown an interest on or are already buying and are therefore likely to be interested in.
Q-Shop Pro will also display the product suggestions in nicely formatted tables with product pictures for (... more)
|
Is Q-Shop search engine friendly?
Q-Shop is a search engine friendly cart. To maximize content relevance and help your page rankings we have implemented the following features:
Relevant page titles:
Product and section names will appear in the page titles, which are key positions for keyword relevance. Most online shop packages will just include a generic title that won't help people looking for your products.
Custom meta tags and keywords for products:
You can override the default meta tags for each product to (... more)
|
Do I get technical support?
Yes. You get three months of free internet technical support when you purchase the software. We cannot add new functionality with the free support but we can generally do it on request with an extra charge per hour of programming. When customers extend the shop we can provide some help but support does not include helping code the additional features.
If you have a support query, please check the support page.
(... more)
|
Can I change the look of the site?
Yes! Q-Shop uses themes or skins to completely modify the look of the site by using CSS files (cascading style sheets).
A theme is basically a couple of CSS files (Cascading Style Sheets) and a set of images. All files for a theme are located on a folder that defines the name of the theme. By simply changing the theme setting through the web Control Panel the whole site's look will be immediately changed!
By using CSS files you can change the look of the whole site by just (... more)
|
I get the error "Operation must use an updateable query". What can I do?
When using an Access database the user used by the web server IIS (normally IUSR_machinename) must have read/write permissions over the database folder to be able to modify and update the database. Add read/write permissions to correct this error.
If using SQL Server, make sure the database account used has write permissions on all the tables.
(... more)
|
Cannot update. Database or object is read-only.
PROBLEM:
When trying to save anything to the database, like adding a product to the cart, saving a product, changes settings in control panel, etc, the following error is displayed:
ASP Error occurred 12/3/2004 12:25:01 PM in Microsoft JET Database Engine
Error number: -2147217911 (0x80040E09)
File: XXXXX, line XXX
Cannot update. Database or object is read-only.
This error normally happens on Access databases.
RESOLUTION:
This error is caused by the web server (... more)
|
Security Vulnerability: SQL Injection attack
PROBLEM:
A security vulnerability (SQL injection attack) on the user login screen has been identified on Q-Shop 2.x.
This vulnerability also affects a previous security patch announced in Article_6CC33.
RESOLUTION:
Customers that have not applied the Q-Shop 2.5A security update should do so.
Customers that have applied the patch should download it again and update /users.asp and /inc/userlib.asp to protect against this vulnerability.
To obtain the security (... more)
|
Security Vulnerability: S-Quadra Vendor Report #2004-01-16
S-Quadra have reported some security vulnerabilities. These affect versions 2.x up to 2.5 rev A. The vulnerabilities have different levels of importance but will be specially important for users running MS SQL Server as the database.
Clients running SQL Server are strongly encouraged not to use an administrator password for the database connection since this will increase the risk.
To obtain a fix for version 2.5, contact Support at support@quadcomm.com. Please include your order ID (... more)
|
Security vulnerability
Vulnerability found:
In the remote administration there is a script that allows the administrator to add images, text etc. on the webserver. This page is by default located at: /qshop/admin/upload.htm . This page is reachable without authentication.
Using this sample upload script it is possible for a remote attacker to upload files like ntdaddy.asp, cmd.asp, explore.asp on the webserver gaining
full access to the webserver.
Versions affected:
Versions 2.x up to 2.5 rev (... more)
|
The message could not be sent to the SMTP server
PROBLEM:
When sending a mail from the shop by using the feedback page or on checkout, the following error message is displayed:
Error sending message:
The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available.
This error would appear using Q-Shop v3.x and CDOSYS.
RESOLUTION:
This is generally caused by using incorrect authentication details. If your SMTP server needs a login/password make sure this is (... more)
|
Error when adding to cart from the manufacturer list page
Problem:
When listing products by manufacturer, if the user enters a quantity and adds clicks in "Add to cart" from the listing page a 500 error is displayed:
ASP Error occurred 5/4/2004 2:25:59 PM in Microsoft VBScript runtime
Error number: -2146828275 (0x800A000D)
File: /demo/cart.asp, line 240
Type mismatch: '[string: ""]'
If a user adds it to the cart from the product details there is no problem.
Versions affected:
Q-Shop Pro and Lite v3.0 up to rev C (... more)
|
What databases does Q-Shop support?
Q-Shop supports MS Access and SQL Server. When you purchase the software it comes with a MS Access database (.mdb) and the T-SQL scripts to create a SQL Server database.
If you have an existing Q-Shop Access database, it can be easily upgraded to MS SQL Server.
If you want to upgrade to MS SQL Server you can read the following articles:
- Migrating to SQL Server
- How to Convert an Access Database to SQL Server (Q237980)
- Microsoft Access Upsizing Tools 97
(... more)
|
Can a product appear in more than one section?
Yes. Products can be included in up to 5 different sections/categories. It is also possible to change this limit to any other by changing the number in one script.
Note: version previous to 3.0 only support one section/category.
(... more)
|
Converting to MS Access 2000 (versions 2.5 or earlier)
Q: Is it okay to convert the database included with Q-Shop from Access 97 to Access 2000?
Yes. You can use the upgrade options from MS Access 2000 to upgrade the database. Please make sure that the database keeps the login information and doesn't get saved as read only.
NOTE:
Q-Shop 3.x uses an Access 2000 database.
(... more)
|
Error uploading files
PROBLEM:
When uploading an image the following error is displayed:
Request object error 'ASP 0206 : 80004005'
Cannot call BinaryRead
/admin/outputFile.asp, line 52
Cannot call BinaryRead after using Request.Form collection.
VERSIONS AFFECTED:
QShop v3.0 Pro and Lite Revision 0
RESOLUTION:
Edit /admin/outputfile.asp and where it says:
<%
Response.Expires = 0
Response.Buffer = True
Change to:
(... more)
|
What are the new configuration parameters in the database in version 3.0?
Q-Shop v3.0 includes a number of additional configuration parameters that are managed via the Control Panel. Some are new fields and some have been moved from being hardcoded in several files. The fields are:
SMTP_Username
SMTP_Password
UserReviews
Shop_Address1
LogoURL
ShowTop10Center
Shop_Address2
smLogoURL
ShowTop10Right
Shop_City
NotAvailImg
Shop_ZIP
Shop_State
Shop_Country
Shop_Telephone
FeatProdsNumber
Shop_Fax
ShowTerms
SECUREURL
TimeOut
TempPath
The following SQL script (... more)
|
Weight units
Q: How are weights entered in the database? Would I enter a 4oz product as .4 or 4? If I enter this as a decimal, then how to I accomodate for something that's 11 oz?
A: Weights are not stored in any particular measurement units. The data is stored in decimal format, which is ideal for metric system. If you need to store data in any other units have in mind that all calculations will be done using decimal system.
e.g.: 1lb 8oz must be entered as 1.5
Note: 16oz. = 1lb.
(... more)
|
User sessions seem to be randomly lost
In Windows 2003, some customers have reported that sessions seem to be lost randomly without inactivity periods.
This is simple to fix. By default in IIS 6.0 the "enable parent paths" in the web config dialog is not the default setting as it was under IIS 5.0. This is especially important when using a shared certificate website. If this option it is not ticked the certificate path will only produce a 500 error with no clue as to why. If the enable parent paths tick box is clicked it (... more)
|
500 error when using a shared certificate
In Windows 2003, some customers have reported that when using a shared certificate, they get a 500 error page with no detials.
This is simple to fix. By default in IIS 6.0 the "enable parent paths" in the web config dialog is not the default setting as it was under IIS 5.0. If this option it is not ticked the certificate path will only produce a 500 error with no clue as to why. If the enable parent paths check box is clicked, it will function exactly as it did under IIS 5.0 and the (... more)
|
CDONTS won't work with Windows XP
Windows XP and 2003 no longer supports CDONTS. Intead, they include CDOSYS, a new component that will include enhanced functionality although it is more complex to use.
Customers running Q-Shop on a Windows XP or 2003 server can request an update by mailing the support team at support@quadcomm.com. Include your order id with your request to be able to receive the update.
Several customers have reported that CDOSYS won't send messages to webmail addresses like hotmail although no (... more)
|
Extending the size of product descriptions
Version 2.5: By default the length for the product description is 255, which is the maximum size of a text field in Access. Depending on the database used: - Access You can increase the size of the Description field in the Products table by changing its type to "Memo". This has several drawbacks as this type of fields cannot be indexed and it uses much more space. If you have a large products database or heavy traffic we do not recommend this change. - SQL Se (... more)
|
Server.CreateObject Failed in checkout
PROBLEM: Using Q-Shop 2.5 and 2.5 Rev A: When submitting the last step of the order the following errors may appear: - Error creating order in database - Server object, -2147221005, 006~ASP 0177~Server.CreateObject Failed~Invalid ProgID This may be a misleading error not reporting the real problem. These versions may carry over an error elsewhere in the page being reported as a problem creating the order. RESOLUTION: Edit prochckoutend.asp and where it says (... more)
|
How can I increase the size of the product description field?
Yes. First you need to increase the size in the Access datbase (design menu) for the table Products or in SQL Server using Enterprise Manager or equivalent. Then you need to change admin/inc/field_size_constants.asp to set the new size. This file contains constants that are used by the admin scripts to cut the size of the data to be saved to the database. In particular you will need to change: CONST lnDescription = 255 Set it to the same size as the database field. If you h (... more)
|
Can I make search.asp single addition?
You can set thi in search.asp. You need to change the parameter to S instead of the default M: '========================================== 'Set Browse types: S (single), M (multiple) '========================================== sBrowseSearch = "M" 'Search results '========================================== (... more)
|
Will I need to install any software?
No, only copy the asp files and database to your IIS web server. There is no need to install any cgi, component or software whatsoever. However, you might need to do it if you want to integrate some of the online credit card gateways, UPS cost calculation or substitute the standard e-mail component of IIS (CDONTS). Some hosting companies have disabled CDONTS, check with your hosting company and ask for what alternative component they have. Q-Shop supports CDONTS, ASPMail and JMail. (... more)
|
Does Q-Shop support SSL?
Yes, you will need an SSL enabled server and your own or a shared certificate. However, there is one restriction: the secure folder must be in the same server. Most of the hosts can point a virtual folder in the shared secure domain to the same physical folder where the ASP files are. Check with you hosting provider. For optimum work we recommend to use your own certificate. (... more)
|
Does Q-Shop use cookies?
Q-Shop uses cookies in two occasions: 1. There is a session cookie storing a session id. This cookie will expire after 20 minutes of inactivity or when the user closes the browser. This is the cookie used on all ASP applications to allow sessions. This cookie is stored in memory and not in the user PC. 2. There is another optional cookie storing the user id that allows the system to recognise existing users, greet them and pre-fill their data during the checkout process (no credit (... more)
|
Does Q-Shop calculate taxes?
Q-Shop calculates taxes using the models of the US, Canada and the European Union. Additional systems can be easily implemented based on these. Visit our tax calculation information page for further details. (... more)
|
Does Q-Shop calculate shipping costs?
Yes. Q-Shop calculates shipping costs based on several systems (cost, weight, percentage, flat rate,...). The manual also explains how to easily use a system based on a list of pre-defined options (for example, US Air, US Ground,...). Visit the Shipping Cost page for more details. Also available real time UPS cost calculation (for this module it is required the use of the free AspTear component or equivalent). If none of these sy (... more)
|
What databases does Q-Shop support?
Q-Shop supports MS Access and SQL Server. When you purchase the software comes with a MS Access database (.mdb), however it can be easily upgraded to MS SQL Server. If you want to upgrade to MS SQL Server read the easy tutorial: Migrating to SQL Server Additional links: Upsizing Microsoft Access-Based Applications more)
|
Can Q-Shop be integrated with online credit card processing systems?
Q-Shop includes versions of the modules for integration with several gateways and can be integrated with others. Visit our transactions page for further information or request information to obtain a US merchant account. (... more)
|
How will I know that a customer has placed an order?
Every time a customer places an order a mail is sent to the customer and to you attaching the order details (no credit card information), you can then go to the administration site to view the full order details. (... more)
|
Do I need some special skills?
You will need some knowledge of HTML and ASP to install the site. If you do not have this knowledge we can install the site for you ( ask for prices ). You can have an introduction to ASP technology here or here . (... more)
|
Can I use Q-Shop with FrontPage?
No, the system is completely based on ASP scripts and FrontPage is not intended to develop this kind of applications. It is however possible to use FrontPage 2000 or later but only if you don't edit files using the visual editor; this can sometimes lead to problems so we don't recommend it. We recommend you to edit the pages with MS Visual Interdev, Macromedia HomeSite or any HTML/ASP editor that supports direct HTML and VBScript editing. (... more)
|
How many levels of sections and subsections can there be?
There can be an unlimited number of sections organised in an unlimited level of subsections. (... more)
|
Can I translate the shop?
Yes, as all the storefront is completely written in ASP without any compiled file. This allows you to do any modifcation from changing expressions to translate the whole store easily . Some of our resellers maintain a version in their own language: - For the version in Italian and adapted to the Italian market, please, visit OMNIA OFFICE at http://www.q-shop.it - For the German version visit sun (... more)
|
Do I need to install any ASP component?
Q-Shop does not need to have installed any component. However, if you want to install an on-line transaction processor, or real-time UPS cost calculations then you will probably need to install a component that can connect to an external server to send/retrieve information. Maybe your ISP already provides you one or you may install a component that is free and easy to installa (visit alphasierrapapa.com for more information). You could adapt the code to use the XMLHTTP free component from (... more)
|
We don't have our own SSL certificate. Can we use the one from our ISP?
Yes, but only if the ISP certificate is in the same machine as your server and the secure URL points to the same files as your non-secure site. If you redirect the user to another server the system won't be able to access the database and therefore it won't be able to proceed with the checkout. (... more)
|
Do I get technical support?
Yes. You get three months of free internet technical support when you purchase the software. We cannot add new functionality with the free support but we can do it on request with an extra charge per hour of programming. (... more)
|
