richsuccessonline Posted July 12, 2014 Share Posted July 12, 2014 (edited) Hi guys, really need your expertise on my issue. This is my first time use a prestashop to make e-commerce website. When doing some testing, I found there are 3 orders that missing from my Backend. I try to see the database in ps_order, and the missing orders are there. I tried to modified the record so the value exactly the same with "normal" order, but it has no effect. Until now the orders are still missing Let me attach 2 image that show the error. "1.jpg" is come up from the dashboard, it shows that I have 6 orders. Meanwhile, on "2.jpg" which come up from orders page, it show that I only have 3 orders ... Can somebody help me on this? What should I do Thank you, your kindly help greatly appreciated Edited July 12, 2014 by richsuccessonline (see edit history) Link to comment Share on other sites More sharing options...
PSfever.com Posted July 12, 2014 Share Posted July 12, 2014 Hi, What happens if you click on those orders from the dashboard? Are you redirected to an existing order, or a non-existing page? Link to comment Share on other sites More sharing options...
richsuccessonline Posted July 13, 2014 Author Share Posted July 13, 2014 If I click those orders from the dashboard, it will lead to existing order complete with all the detail (the products, the customer, the status, etc) Link to comment Share on other sites More sharing options...
richsuccessonline Posted July 14, 2014 Author Share Posted July 14, 2014 Anyone? Can someone help me thank you Link to comment Share on other sites More sharing options...
NemoPS Posted July 14, 2014 Share Posted July 14, 2014 So they are simply not visible in the order list? Are they taken in consideration in the statistics page? Link to comment Share on other sites More sharing options...
richsuccessonline Posted July 14, 2014 Author Share Posted July 14, 2014 Hi @Nemo1, yes the orders is invisible at order list but it visible on dashboard and statistic page. Do you have any idea why this is happen? Link to comment Share on other sites More sharing options...
NemoPS Posted July 15, 2014 Share Posted July 15, 2014 Really weird, did you modify the AdminOrdersController somehow? Link to comment Share on other sites More sharing options...
richsuccessonline Posted July 15, 2014 Author Share Posted July 15, 2014 Nope at all, I noticed this issue when I my prestashop upgraded from 1.6.0.6 to 1.6.0.8 Link to comment Share on other sites More sharing options...
bellini13 Posted July 15, 2014 Share Posted July 15, 2014 my guess is there is a missing record in one of the joined tables. For example, the customer record may be corrupt for the missing orders. You need to debug the SQL command that is executed for displaying the order list. In the AdminController class is a function getList. This function executes the SQL command, so I would edit this function so it echos the SQL command to the browser window. Then I would suggest reviewing this SQL command in detail and searching each of the joined tables looking for the missing record. Link to comment Share on other sites More sharing options...
El Patron Posted July 16, 2014 Share Posted July 16, 2014 are you using sandbox? sandbox returns a different status than the paypal api understands so it does not post the order in back office properly. Link to comment Share on other sites More sharing options...
richsuccessonline Posted July 16, 2014 Author Share Posted July 16, 2014 Hi El Patron, nopee We're still on development stage, so all the function is still original. Link to comment Share on other sites More sharing options...
bellini13 Posted July 16, 2014 Share Posted July 16, 2014 as i said, you have a missing record and you will need to debug what is missing 1 Link to comment Share on other sites More sharing options...
npiazza Posted August 6, 2014 Share Posted August 6, 2014 We are experiencing the same issue on our store after our upgrade from 1.6.0.6 to 1.6.0.8 We had 2 missing orders since our upgrade last week. Any traction on this issue? Link to comment Share on other sites More sharing options...
bellini13 Posted August 6, 2014 Share Posted August 6, 2014 if a bug report was not opened, then I doubt there would be traction. In this particular case, the order exists in the database but is not being shown in the back office, and that is likely due to a missing database record. So you should use phpmyadmin, and search the ps_orders table to see if those order numbers exist or not. If they exist, then you have the same issue here. If they do not exist, then you have a different issue Link to comment Share on other sites More sharing options...
npiazza Posted August 6, 2014 Share Posted August 6, 2014 Ok, I just went in and the orders ID in the table is the same as the administration panel shows. I am trying to contact the customer for more information. We got the funds via PayPal but again, no order showing in our administration panel. Link to comment Share on other sites More sharing options...
El Patron Posted August 6, 2014 Share Posted August 6, 2014 I would uninstall PayPal, delete, then re-install to ensure that order statues match. without some sort of error, i.e. turning on PrestaShop debug and recreating or finding error in your hosting php log, there is for 'most' not enough information here to help as much as you would like. Link to comment Share on other sites More sharing options...
bellini13 Posted August 6, 2014 Share Posted August 6, 2014 We had 2 missing orders since our upgrade last week. you have a different issue and you should start a new topic. The issue in this thread is the loss of orders that were created BEFORE to the upgrade. I believe your issue is that orders placed AFTER the upgrade are missing. You should start another thread, documenting your issue, including version of Prestashop and version of Paypal (including USA or Europe)? Without knowing this information it would be impossible to assist you further Link to comment Share on other sites More sharing options...
npiazza Posted August 6, 2014 Share Posted August 6, 2014 Yeah, I know. I am trying to troubleshoot it more. I am working with PayPal because it may be related to their PayPal Manager. Just not 100% sure yet. I am still working on this. Thanks for the quick response guys. I have gotten a lot of help from the forums and I already like the power of PrestaShop over OSCommerce. Nick 1 Link to comment Share on other sites More sharing options...
jewelcam Posted August 10, 2014 Share Posted August 10, 2014 @npiassa did you start a new tread on this,, cause im having same issue. thanks my thread is http://www.prestashop.com/forums/topic/349695-paypal-payments-not-showing-in-bo/ Link to comment Share on other sites More sharing options...
Recommended Posts