Zen Cart Logo
Forums / Managing Customers and Orders / Orders Not Appearing

Orders Not Appearing

Locked

Views: 10,474

Results 1 to 20 of 55
This thread is locked. New replies are disabled.
18 Oct 2006, 2:29 AM
#1
designsbytrina avatar

designsbytrina

New Zenner

Join Date:
Jul 2006
Location:
Kentucky
Posts:
34
Plugin Contributions:
0

Orders Not Appearing

I've read through other threads, but I can't find the solution to my problem in them. I've been using Zen Cart since April 2006...everything worked properly. A few days ago, however, my orders stopped showing up in the admin area.

I'm receiving notification that PayPal payment has been made.
I'm not receiving order confirmation, nor are my customers.
The orders aren't showing in the admin area.
Customers can't access their downloads, and there's no history of the order in their account area.

So, not having success in finding a solution, I upgraded my cart to the newest version...and NOW I'm getting the message that my database appears to need patching to a higher level.

I'm not a programmer...and have very little knowledge about how these things work, so I hired someone from getafreelancer and it was promised to be repaired within a certain time frame - which has passed.

I'm losing quite a bit of money (by my standards) every day by not having a functional cart, and it's wearing on my soundness of mind.

18 Oct 2006, 2:48 AM
#2
redxiii avatar

redxiii

New Zenner

Join Date:
Jun 2006
Posts:
58
Plugin Contributions:
0

Re: Orders Not Appearing

Same here. I never changed nor upgraded anything in ZC.

I wonder... Anyone else experiencing this? This could be PayPal's fault, for all we know.

18 Oct 2006, 2:54 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Not Appearing

PayPal issues have magically cropped up in the last week ... on sites that have made no changes ...

Could you confirm on your PayPal account that your settings are all correct and that they were not accidentally reset or changed on the paypal.com site in any manner?

Primary Email matches exactly what is in Zen Cart including case ...

IPN URL is correct ...

Everything as in what you did the first time you setup PayPal ... from the /docs

18 Oct 2006, 3:23 AM
#4
designsbytrina avatar

designsbytrina

New Zenner

Join Date:
Jul 2006
Location:
Kentucky
Posts:
34
Plugin Contributions:
0

Re: Orders Not Appearing

Ok, just checked PayPal:

Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: http://www.myezshop.com

I have no idea how or why myezshop.com is listed there. Should I put my the URL to my website, along with the subfolder zen cart is installed in?

18 Oct 2006, 3:51 AM
#5
redxiii avatar

redxiii

New Zenner

Join Date:
Jun 2006
Posts:
58
Plugin Contributions:
0

Re: Orders Not Appearing

PayPal
Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: https://www.myshop.com/~myaccount/ipn_main_handler.php

ZenCart
Instant Payment Notification (IPN) On
Instant Payment Notification (IPN) URL: https://www.myshop.com/ipn_main_handler.php

Alright. ZenCart seems to have auto-detected the URL since I followed one of the topics here about reinstalling PayPal module. And since I managed to get that SSL cert, I'm no longer using the shared SSL of the webhost (the ~myaccount https address). The emails are the same for both.

I guess I have to redo the order testing and see the results. Still, is mine really a URL issue? The shared SSL URL and the new secure URL are the same thing, right?

18 Oct 2006, 3:53 AM
#6
redxiii avatar

redxiii

New Zenner

Join Date:
Jun 2006
Posts:
58
Plugin Contributions:
0

Re: Orders Not Appearing

That goes with Checkout Success page... I think...

https://www.myshop.com/index.php?main_page=checkout_process

was...

https://www.myshop.com/~myaccount/index.php?main_page=checkout_process
18 Oct 2006, 4:28 AM
#7
designsbytrina avatar

designsbytrina

New Zenner

Join Date:
Jul 2006
Location:
Kentucky
Posts:
34
Plugin Contributions:
0

Re: Orders Not Appearing

OK, I found this when I clicked on PayPal IPN in Payment Modules:

set your Instant Payment Notification Preferences URL to:
http://mystore.com/subfolder/ipn_main_handler.php

in Website Payments Preferences set your Automatic Return URL to:
http://mystore.com/subfolder/index.php?main_page=checkout_process

I've made the changes and hopefully this will correct the problem.

What I don't understand is why it worked all along until just a few days ago??? Somehow the settings were changed in my PayPal account.

Now, onward to the "database appears to need patching to a higher level" error message. After upgrading to the newest ZC version, I started getting this. So, I ran the install, used the upgrade database option...still have the message.

18 Oct 2006, 5:29 AM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Not Appearing

designsbytrina:

Now, onward to the "database appears to need patching to a higher level" error message. After upgrading to the newest ZC version, I started getting this. So, I ran the install, used the upgrade database option...still have the message.

If you have this message ... does that mean that since April you have had this message and PayPal was working?

Or, this is an unrelated message to PayPal not working?

Or, you were upgrading this week and PayPal stopped working?

I got lost at the stop sign ... :unsure:

18 Oct 2006, 1:33 PM
#9
designsbytrina avatar

designsbytrina

New Zenner

Join Date:
Jul 2006
Location:
Kentucky
Posts:
34
Plugin Contributions:
0

Re: Orders Not Appearing

Ajeh:

If you have this message ... does that mean that since April you have had this message and PayPal was working?

Or, this is an unrelated message to PayPal not working?

Or, you were upgrading this week and PayPal stopped working?

I got lost at the stop sign ... :unsure:

PayPal stopped working. I upgraded my cart, and then started receiving the "database" message when I did the upgrade. Now, after correcting the information for PayPal (I still don't understand how it got "became" wrong in the first place), everything is working perfectly. EXCEPT my database still needs patching to a higher level.

19 Oct 2006, 8:42 AM
#10
redxiii avatar

redxiii

New Zenner

Join Date:
Jun 2006
Posts:
58
Plugin Contributions:
0

Re: Orders Not Appearing

Finally working.
Thanks all.

21 Oct 2006, 12:43 AM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Not Appearing

designsbytrina:

PayPal stopped working. I upgraded my cart, and then started receiving the "database" message when I did the upgrade. Now, after correcting the information for PayPal (I still don't understand how it got "became" wrong in the first place), everything is working perfectly. EXCEPT my database still needs patching to a higher level.

What version of Zen Cart do you think you are running?

What happens if you run the /zc_install and hit the Upgrade? Does it show any versions checked?

22 Oct 2006, 3:57 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Not Appearing

Could you check the file on the server for:
/includes/version.php

Do the match the one in your download of Zen Cart v1.3.5 ...

23 Oct 2006, 11:06 AM
#13
dickturpin avatar

dickturpin

New Zenner

Join Date:
Oct 2006
Location:
UK
Posts:
27
Plugin Contributions:
0

Re: Orders Not Appearing

I too have been searching this forum and the net for answers to this problem. I have checked double checked and then checked again all my settings on paypal and my site. I have followed all the solutions in wikki/forum and net with out prevail. I have been so worked up as paypal is the only payment method my site offers at this moment in time!

If any of you get a bug fix, or real answer, please contact me:down:

23 Oct 2006, 4:38 PM
#14
adamb avatar

adamb

New Zenner

Join Date:
Oct 2005
Location:
Colorado
Posts:
11
Plugin Contributions:
0

Re: Orders Not Appearing

I'm having the same problem after upgrading from 1.2.7 to 1.3.5

Everything appears fine through the checkout process, but everytime it always says the order number is #14774, which was the first transaction after I updated the Cart. Last night I took the site offline, and reuploaded the zc_install folder to check the DB version and make sure it was patched, It said that it was ok for 1.3.5 is there a way i can manually check?

Another weird thing I noticed, is that under the Configuration Instructions it says:

set your Instant Payment Notification Preferences URL to:
https://www.my_site.com//ipn_main_handler.php

I'm not sure where the extra / is coming from...

it's also in the automatic return url..

https://www.my_site.com//index.php?main_page=checkout_process

i'm running ultimate seo urls, though as far as I know that shouldn't be an issue..

I've currently turned off Paypal, only about 8% of our customers use it so it's not a huge problem but I'd like to get this worked out this week. Any help would be appereciated..

23 Oct 2006, 5:14 PM
#15
adamb avatar

adamb

New Zenner

Join Date:
Oct 2005
Location:
Colorado
Posts:
11
Plugin Contributions:
0

Re: Orders Not Appearing

I knew this would happen.. I triple checked my admin/includes/configure.php and includes/configure.php.. to make sure there were no trailing /'s

and somehow I always missed the last one in admin/includes/configure.php..

Everything seems groovy now..

I'd just like to say great work on 1.3.5 other than this silly problem everything has been great!

23 Oct 2006, 5:50 PM
#16
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Orders Not Appearing

DickTurpin:

I too have been searching this forum and the net for answers to this problem. I have checked double checked and then checked again all my settings on paypal and my site. I have followed all the solutions in wikki/forum and net with out prevail. I have been so worked up as paypal is the only payment method my site offers at this moment in time!

If any of you get a bug fix, or real answer, please contact me:down:

Did you try to uninstall then reinstall the PayPal Payment module then reconfigure it using the exact Primary email address with the same upper/lower case that you have on the PayPal Site?

23 Oct 2006, 5:56 PM
#17
aeonmedia avatar

aeonmedia

Suspended

Join Date:
Jul 2006
Posts:
28
Plugin Contributions:
0

Re: Orders Not Appearing

This has been a real problem for me, too. I tried removing the paypal ipn and then reinstalling it. This did not work. I tried installing the 'stuck orders' contribution, but that did no real good because all i got was a string of unintelligable encrypted information.

this is a HUGE and BAD problem, because now no orders at all are showing up. First, only the ones when the customers didn't return manually from clicking 'return to merchant' in paypal. now that i modified paypal account to automatically return to my merchant page - NONE of the orders are getting returned. This website only takes paypal. Profitibility is coming to a complete halt.

In order to create a mechanism that allows me to capture information if an order is placed, i write a text file to the server in a new folder with the contents of the order in place. this is just until one of the programming gurus of Zen can explain a fix for this issue. At this point, the file is writing OK.

Here's the problem, i need to capture some info about each item in the order. i want to write a description of each order - and put in the attribute information. but i only get the attribute for the first product. if there are multiple products in the order, the first item in the order shows the attribute but the others do not.

in the code in the orders.php page, there is another variable and incremental count on a value of j. this is the code from that file: orders.php (line 401).

$order->products[$i]['attributes'][$j]['option'] . ': ' . nl2br($order->products[$i]['attributes'][$j]['value']

What follows is the code that i have now - it's based heavily on the code above:

$description = '';
for ($i=0; $i<sizeof($order->products); $i++) {

  $description .= $order->products[$i]['name'] .  ' ' . $order->products[$i]['attributes'][$i]['option'] . ': ' .  $order->products[$i]['attributes'][$i]['value'] . '(qty: ' . $order->products[$i]['qty'] . ') + ';

}

here's an example of what's getting written:

10232006,firstname,lastname,me*me.com,street address,city,state,zip,Genetic size: Xtra Large(qty: 1) + Bar Code Shirt : (qty: 1) + Explosive Tee : (qty: 1) + Pocket Watch : (qty: 1) ,70

can one of you codemasters give me a tip as to why the attribute of only the first item - in this example - the genetic tee shirt size comes through, but the others - do not come through.

23 Oct 2006, 6:26 PM
#18
aeonmedia avatar

aeonmedia

Suspended

Join Date:
Jul 2006
Posts:
28
Plugin Contributions:
0

Re: Orders Not Appearing

Hi,

How did you fix this? I have done all steps suggested and am getting absolutely nowhere.

24 Oct 2006, 10:47 AM
#19
dickturpin avatar

dickturpin

New Zenner

Join Date:
Oct 2006
Location:
UK
Posts:
27
Plugin Contributions:
0

Re: Orders Not Appearing

Good news every body i got the answer
basically there's a bug in the code of the paypal module!

/includes/modules/payment/paypal/paypal_functions.php

line 60 -- alter it like this:
Code:
if (strtolower($postArray['business']) != strtolower(MODULE_PAYMENT_PAYPAL_BUSINESS_ID)) {

This definatly works, Im now using it! I knew my settings were correct

24 Oct 2006, 7:53 PM
#20
aeonmedia avatar

aeonmedia

Suspended

Join Date:
Jul 2006
Posts:
28
Plugin Contributions:
0

Re: Orders Not Appearing

Wow- thanks for the response, DickTurpin. It seems that you are the only one who responds to my question. I implemented your code change, but i am not getting anywhere. What could be wrong?

Maybe i skipped a step that you need. Here are the steps I have taken:

  1. verify the primary paypal address is the one in the email for zen, case sensitive - it matches exactly. (it does)
  2. turn off the paypal account and then re-set one up.
  3. made certain that paypal is redirecting back to zencart - it always returns now. at first, i thought this only happened when the user didnt return. Now, no payal purchases register at all.
  4. installed the 'paypal orders stuck' contribution and the follow up to that - which helps me 'push' the orders through. However, this is not really the best way to handle this.
  5. I got your response and made the code change.
  6. I tested - and not a single paypal order gets written to the appropriate fields in the database without a little help from that contribution.

Paypal didnt change, and the server didnt put new firewall measures in place. I don't have the SEO contribution changed, and someone posted information about trailing /s but i am not sure which files I need to check.