osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Order not in Database

This is a discussion on Order not in Database within the osCommerce 2.2 Discussion forums, part of the osCommerce 2.2 Forums category; I am using OSCommerce 2.2 with payment through PlugnPay. An order goes all the way through, and an email ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 04-13-2007, 02:54 AM
Lurker
 
Join Date: Apr 2007
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
sheldonlg is on a distinguished road
Default Order not in Database

I am using OSCommerce 2.2 with payment through PlugnPay. An order goes all the way through, and an email is sent to the purchaser, but the order is not showing up in the database. The OSCommerce forum on OSCommerce has been very silent in responding to me, so I hope I can get some help here.

Side question: Can osCMax be installed right over OSCommerce?

Shelly
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 04-13-2007, 07:22 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,191
Thanks: 66
Thanked 290 Times in 276 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Order not in Database

You need to provide more details about how the plugnpay mod works. Is it like paypal where it sends the customer to the plugnpay website to process the order? Or is it like Authorize.net where it handles the transaction behind the scenes and the customer never leaves your site?

Side question
: Do not install osCMax over your existing store. It will wipe out your original site. osCMax is a full install package and it will overwrite your entire store. You should do a clean, separate install of osCMax if you want to use it.
__________________
Michael Sasek
osCMax Developer


osCMax Templates - Hundreds of premium quality templates. New designs every month!

xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience


osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 04-13-2007, 07:36 AM
Lurker
 
Join Date: Apr 2007
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
sheldonlg is on a distinguished road
Default Re: Order not in Database

PlugnPay is a separate site. The user is sent there and then is returned to the original site. All the SSL stuff is done there.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 04-13-2007, 08:46 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,191
Thanks: 66
Thanked 290 Times in 276 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Order not in Database

Ok,

Then I suspect the problem is that the customer is not clicking the final link on the payment success page that sends them back to your site with the completed order information.

You would need to somehow get them to understand that their order is not complete until they click back to your site, or see if plug-n-pay has something like the IPN of paypal.

To avoid this altogether, you should probably upgrade and use the plugnpay API module:
osCommerce: PlugnPay - API Payment Method
__________________
Michael Sasek
osCMax Developer


osCMax Templates - Hundreds of premium quality templates. New designs every month!

xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience


osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 04-13-2007, 09:27 AM
Lurker
 
Join Date: Apr 2007
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
sheldonlg is on a distinguished road
Default Re: Order not in Database

First, let me say that I appreciate your comments in trying to help me. That said, the customer is **me**, as this site is not yet live and I am only testing it. I **do** click the "Finish" button, and it still does not register in the orders table (either via the admin interface or through direct MySQL interrorgation.

I thought that it was the API version that I had downloaded and installed. I used the one for where OSCommerce was not with SSL, as PlugnPay was handling the secure transactions. The module that I installed was downloaded from the PlugnPay site, management interface.

Shelly


Quote:
Originally Posted by michael_s View Post
Ok,

Then I suspect the problem is that the customer is not clicking the final link on the payment success page that sends them back to your site with the completed order information.

You would need to somehow get them to understand that their order is not complete until they click back to your site, or see if plug-n-pay has something like the IPN of paypal.

To avoid this altogether, you should probably upgrade and use the plugnpay API module:
osCommerce: PlugnPay - API Payment Method
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 04-13-2007, 09:37 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,191
Thanks: 66
Thanked 290 Times in 276 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Order not in Database

If you leave your site, I do not think it is the API version. The API version should connect in the background without leaving your site.

It could just be that you have not properly installed it. I cannot help much though, as I have never used this mod or plugnpay.

If you downloaded it from plugnpay, contact their support to help you.
__________________
Michael Sasek
osCMax Developer


osCMax Templates - Hundreds of premium quality templates. New designs every month!

xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience


osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
The Following User Says Thank You to michael_s For This Useful Post:
sheldonlg (04-13-2007)
Closed Thread



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
edit order when order is pending chitta_rn osCMax v2 Customization/Mods 0 01-14-2006 08:41 AM
Minimum order with low order fee FSUddin osCommerce 2.2 Modification Help 2 12-14-2004 08:19 AM
Database marbor osCommerce 2.2 Installation Help 1 01-26-2004 07:33 AM
customer comments in order and extra order email karen_l osCommerce 2.2 Modification Help 0 01-03-2003 11:51 AM
What name should database be? Anonymous osCommerce 2.2 Installation Help 2 11-25-2002 06:31 AM


All times are GMT -8. The time now is 11:32 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2008 osCMax