Author: Keith Barnett

QTY in Variations

Comersus Version: 707Database type: AccessFrequency: Permanent issue We have a coffee table and end table set as an item in our store (www.theclassyhome.com) The coffee table and end table are "Variations" A customer wanted to purchase 1 coffee table and 2 end tables. This isn't possible unless they purchase 1 coffee table and 1 end

Optional Limits

Comersus Version: 708Database type: AccessFrequency: Permanent issue I have a customer using the free version. Are there limits on the number of "Options" that they can have on an item. I am finding that I can only add 3.

Error in Checkout

Comersus Version: 707Database type: AccessFrequency: Permanent issue Sorry for the inconvenience. Update Error in saveorder 9, error: Subscript out of range – Err.Number:9 – SQL:INSERT INTO orders (orderDate, idCustomer, details, total, taxAmount, obs, address, zip, state, stateCode, city, countryCode, shippingName, shippingLastName, shippingAddress, shippingZip, shippingState, shippingStateCode, shippingCity, shippingCountryCode, shipmentDetails, paymentDetails, discountDetails, nroRan, orderStatus, idAffiliate, viewed, idCustomerType,

You have to select optionals prior to adding that

Comersus Version: 707Database type: AccessFrequency: Random issue I am getting the above message. We just moved everything to a new server, and to my knowledge we didn't change anything in the settings etc… www.theclassyhome.com Click "Bar Stools" Click "Bar Stool 168" Click Add to Cart… Thanks, Keith

Importing Options for Products

Comersus Version: 707Database type: AccessFrequency: Permanent issue Hi, I am looking for how to import "Options" for products. I have about 700 items to import and each item has different "Options". Can I import this information? Thanks, Keith Barnett

FREE SHIPPING PROBLEM

Comersus Version: 707Database type: AccessFrequency: Permanent issue We selected free shipping on a product in the back office, and it indicated in the store that it was free shipping, however during checkout it wanted to use our "flat fee" price for shipping. How do I correct this. thanks,

Error in Exporting Products

Comersus Version: 707Database type: AccessFrequency: Permanent issue Temporary errors There are errors in your BackOffice+: Error in comersus_backoffice_exportProductsExec.asp, error: Object required – Err.Number:424 – SQL:SELECT * FROM products, suppliers WHERE products.idSupplier=suppliers.idSupplier AND idStore=1

Adding Specials

Comersus Version: 707Database type: AccessFrequency: Permanent issue Hi, We need to add specials to our store. For example. Buy a bed get a matress free … etc. How do I do this?

Order is not pending ???

Comersus Version: 707Database type: AccessFrequency: Random issue Error in Authorize.net AIM SilentResponse. Order is not pending This error doesn't make any sense. The card is processed fine. We are using Authorize.net AIM. Please respond with as much detail as possible. This looks like our last hurdle. Thank you.

New Error in add to cart

Comersus Version: 702Database type: AccessFrequency: Permanent issue Sorry for the inconvenience. Error in itemFunctions, error: [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'dbSession'. – Err.Number:-2147217900 – SQL:SELECT idOptionGroup FROM optionsGroups_products WHERE idProduct=280 – I changed some config settings, then I started getting this.

Several Issues (urgent)

Comersus Version: 702Database type: AccessFrequency: Random issue 1.Email doesn't work (using CDO) on a Win2003 server. CDO is installed on the server 2.Where can I learn about how shipping works? 3.Authorize.net SIM – does it need encryption field?

Random Error

Comersus Version: 707Database type: AccessFrequency: Random issue Sorry for the inconvenience. Error in orderVerification, error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'idProduct='. – Err.Number:-2147217900 – SQL:SELECT MAX(idOrder) AS maxIdOrder FROM orders I am getting this order randomly. It is very frustrating. I get this when clicking products or categories randomly.