Results 1 to 8 of 8
  1. #1
    Join Date
    May 2006
    Posts
    43
    Plugin Contributions
    0

    Default PayPal Express - Orders going through, in db but not in orders or in customers accoun

    This is a weird one that I've never seen before. On one of my sites (all of them are set up exactly the same but separate databases and url) any way, on one site when someone uses PayPal, I get the order email, payment is in PayPal and when I go to the admin, it shows on the front page BUT if you click on the order it's not showing up there. Also, it's not showing in the customers account. I looked at the database and it shows there. It shows in all the reports.

    Any thoughts?

    Thank you

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    If you look at that order in the database, I suspect its order_status value is not set to one that matches an entry in the orders_status table.
    ... and that's likely because you recently deleted the order-status value that the paypal module was set to use.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    May 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    How can i fix this?

    Quote Originally Posted by DrByte View Post
    If you look at that order in the database, I suspect its order_status value is not set to one that matches an entry in the orders_status table.
    ... and that's likely because you recently deleted the order-status value that the paypal module was set to use.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    You didn't confirm your findings, so I"m not sure if you're asking how to fix bad data, or asking in theory how to fix a still-not-diagnosed symptom.


    If you have an order whose status is wrong because your payment module is giving it the wrong status upon payment, you need to first fix the payment module's settings by choosing a valid status.

    And then to fix the orders that have been set incorrectly, you can use the admin order search to find the order and then update its status just like you would update it when marking it as shipped, etc.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    May 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    The orders are using a valid order status so I'm not sure where to go from here. The orders are showing on the main admin screen (index) but if I click on one, there's no order showing there.

  6. #6
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    Please provide a detailed list of all the changes in all the admin files, which make your admin folder contents different from original Zen Cart files.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    May 2006
    Posts
    43
    Plugin Contributions
    0

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    I fixed it. Re did the database fields. Thank you for your assistance

    Quote Originally Posted by DrByte View Post
    Please provide a detailed list of all the changes in all the admin files, which make your admin folder contents different from original Zen Cart files.

  8. #8
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: PayPal Express - Orders going through, in db but not in orders or in customers ac

    Quote Originally Posted by samisoaps View Post
    I fixed it. Re did the database fields. Thank you for your assistance
    Can you be more specific? What exactly did you have to "fix"? and why?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v151 Orders not showing up under orders but going through to PayPal
    By dharrison in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 23 Apr 2013, 08:37 AM
  2. This is weird! Customers placing orders but orders not showing up or notifying me?
    By mooncavecrystals in forum Built-in Shipping and Payment Modules
    Replies: 20
    Last Post: 28 Jun 2011, 05:38 PM
  3. Orders not going through
    By redjama in forum PayPal Website Payments Pro support
    Replies: 0
    Last Post: 15 Oct 2008, 05:17 PM
  4. Orders not going through...
    By neoific in forum General Questions
    Replies: 4
    Last Post: 9 Jul 2006, 07:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR