The Official Website of AgoraCart and Agora.cgi
AgoraCart.com Demos Download AgoraCart User Manuals & Wiki Gold Members Forum Go Gold Now! Gold Version Memberships

AgoraCart.com

About
Features
Download
Payment Gateways
Send a Donation
Founders Club
BLOG: News & Updates

Showcases & Demos

AgoraCart Demos
Shop Live Stores

Downloads & Add-ons

Gold Version Downloads
DBwizz Database Mgr.
AgoraCart.com Store

Help & Support

User Manuals
Gold Version Users Forum
Gold Version Chat
Tech Support
Certified Agora Pros
Certified Designers
Hire a Freelancer

Gold Version Members

Member Benefits
Join Today!
Gold Members Home
Gold Version Users Forum
Gold Version Chat Rooms
Gold Version Downloads

For Store Owners

Merchant Accounts
Cool Resources
Advertise Here
"Powered by" Logos
Web Hosting Search

Misc.

Contact Us
MEET's Talking Guide
The Ancient Greek Agora






AgoraCart Free User Forums

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software


Official Sponsors of the AgoraCart Project:

       


RegisterSearchFAQLog in
Reply to topic Page 1 of 1
No items have been selected message at checkout.
Author Message
Reply with quote
Post No items have been selected message at checkout. 
I got a phone call from a customer who had purchased from my site just several days before, saying that when she went to checkout she got an error message at the final stage of the checkout saying "No items have been selected."

She had selected 3 items and they showed correctly all the way through the process, until the final click.

I had her give me the information on the phone and duplicated her purchase myself. She ordered 3 good items, everything went properly, shipping and sales taxes were computed as they should have been, but when I clicked the final button, after filling in all of the credit card info, etc. I also got the same message.

I saved the sale by entering the card info through the gateway virtual terminal, but I can't help but wonder how many sales I've lost because folks haven't called, just moved on......

I've been with iTransact for 4 or 5 years, before getting the Agora cart and this is the first time I've gotten a call of this sort.

Any ideas?

View user's profile Send private message Send e-mail
Reply with quote
Post  
What is the URL to your store?


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Reply with quote
Post  
http://www.gifts-specialties.com

View user's profile Send private message Send e-mail
Reply with quote
Post  
Something I am seeing that may be a problem is that you have your store URL without the www. at the beginning.
You really need to have your store URL set up as:
http://www.gifts-specialties.com/agora.cgi
Another thing is that it should be in a 1st level directory, something like:
http://www.gifts-specialties.com/store/agora.cgi

I really think that this is something at iTransact. You might want to contact them to find out what might be happening at their end. It might help us to determine what changes might need to be made to the gateway, if any.

HTH!


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Reply with quote
Post  
the problem is the www. you need to set up your store url with www and you need to link to your store with www. you may have to do a redirect that when someone enters domain.com they are redirected to www.domain.com. you would be better off doing the redirect. and always remember to link to your site with the www. regardless of where the link is.
sometimes setting up your store url with the www will automatically change the url in the address bar when ppl enter the store but to rely on this you need to test how your sever handles it.
set up your store url with www then go to i transact and your gateway setting (if necessary) and set your store urls there with the www. do some test purchases to see if that doesn't resolve the issue.
also, the index.html is a java script redirect. this may not suffice in all instances. furthermore, this would be bad for SEO. you may want to do a 301 or 302 to make search engines happy. you should aslo be able to set the default file for your domain name with htaccess. so instead of your deafult home page being index.html, htm, shtml, php and the like you could put agora.cgi as a qualifier.
dan

Reply with quote
Post  
I will certainly get hot on what you suggest. BUT - the store has been running fine for over a year, just as it is. And I've used iTransact for several years prior to that.

So, while having everything set up the way you say to do it might help with things in general, I just could not believe that they would be the cause of this sudden problem, particularly since I've gotten other orders since the problem.

So, I dug a little deeper. They had ordered 3 items. I looked at the database to see if there was anything to set these items apart from other items, or each other. I could see little that would make a difference.

I then went to the site and did a test order on each of the individual items. The first two went through just fine. It was only on the third item that I got the message about nothing being ordered.

The only thing I can see about the third item is that it has "double quotes" around the product name and the others do not. Now many of the products have a double quote mark as an indicator or inches in the description area. In fact, all 3 of these products do. So it can't be that. The quotes in the product name are the only possible thing I can find.

Any thoughts on this?

In the meantime, I'm going to edit out the quotes in the name, just to see if that makes a difference.

Here's the line from the database -

33915037 Dragons 9.97 "No Evils" Dragons <IMG SRC="%%URLofImages%%/33/33915.gif" BORDER=0> These dragons make a colorful trio as they urge all to see, hear, and speak no evil. Alabastrite.<p>Each approx. 3 1/2" x 3 1/4" X 4 1/8" high. 33/33915.jpg 19.95 33915 <font color=blue><b>Exclusive with us!</b></font>

View user's profile Send private message Send e-mail
Reply with quote
Post  
you link above to your store is...
http://www.gifts-specialties.com/
but when clicked it resolves to...
http://gifts-specialties.com/agora.cgi
this is incorrect. and whether or not your store had run in the past maybe incorrect too. though some orders have gone through is it possible that more had not and you weren't aware because the client clicked out of your site because of errors?
just a suggestion. you shoud set your store url to www. this way the www will or should automatically be added is someone comes in whithout the www. a 301 redirect should help too.

could you copy and paste the product line from your dB that you're having problems with complete with delimiters?
dan

Reply with quote
Post  
Actually, the post above yours has the line from the database, actually an Excel csv file.

I used no delimiters, since the "s in the description seemed to have no ill effects. I had seen a number of places that going from a csv file to MySQL required no delimiters, so I didn't bother.

As I mentioned, I did remove the quotes from the description and found something very interesting -

In the Edit a Product screen the Description field was blank! In the store it read "No Evils" Dragons, but the field was totally empty. This after I removed the quotes in the Excel file and imported without the quotes.

I don't understand how the field was empty, but the old description still showed in the store. I refreshed the page to make sure it was not an old version. No change. Still quotes in the store.

I also don't understand why the new description, without the quotes did not "take" in the description field. I had to enter "by hand" in the Edit Product mode to get the new description to take.

Anyhow, the change of descriptions did the trick. With the field blank I can understand how the checkout could think nothing had been chosen. It works fine now.

Now I'll have to go through the Excel file and remove all quotes from descriptions, not a big deal. Unfortunately, it looks like I will then have to go through each item's Edit Product screen to really remove the quotes in the program.

Doesn't make sense to me, but I'm a salesman, not a database guru.

And I will get the www. stuff straight.

Thanks!

View user's profile Send private message Send e-mail
Reply with quote
Post  
you must use delimiters. it's what tells all programs that handle the file where a field begins and there it ends. here is an example of the native format of your dB. this is what your csv is contverted to when you import...
0001|PERL|23.96|Learning Perl|<IMG SRC="%%URLofImages%%/0001.gif" BORDER=0>|In this smooth, carefully paced course, a leading Perl trainer teaches you to program in the language that threatens to make C, sed, awk, and the Unix shell obsolete for many tasks. This book is the "official" guide for both formal (classroom) and informal learning. It is fully accessible to the novice programmer. <a href="http://www.amazon.com/exec/obidos/ASIN/1565922840/dial411com">Learn More</a>|4.95|||%%IMG%%sm_0001.gif|||%%OPTION%%var_opt.html


the pipes | are the delimiters. the delimiters for csv look,like,this,when,comma,delimited

because of the nature of comma delimited you must be very careful which characters you use. this is true regardless of format. you must also be very careful about the program you use to edit the file. the program must not add column headers and it must not add any characters anywhere you do not specify. when saving you must export to plain text and only in the format you open the file with. do not save or export as an xls file.
after exporting open in notepad and examine the file and check for illegal character insertion. this should now be a plain text file so if you see a bunch of gobbletygook then you messed it up. it wasn't exported properly to plain text.
editing the dB directly isn't that difficult. however, as you found out a few characters here and there can cause unexpected troubles even though the store imports the dB and doesn't crash. so be careful.
dan

Reply with quote
Post  
Thanks for your help.

View user's profile Send private message Send e-mail
Reply with quote
Post  
Have you gotten it resolved?


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum