Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 6 of 6

Thread: Denied orders

  1. #1
    jacksam2010 is offline Junior Member
    Join Date
    Jun 2010
    Posts
    10

    Default Denied orders

    Hi,

    Is there anyway to see the denied orders? Few of customer orders were denied when authorize.net FDS was configured. We are trying to pull up the order numbers from view/manage orders. We don't see those orders existing. Is there any way to view those orders.

  2. #2
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    You can see Failed Transactions under Orders->View Failed Transactions

  3. #3
    jacksam2010 is offline Junior Member
    Join Date
    Jun 2010
    Posts
    10

    Default

    Thanks. I do see it in failed orders. But is there any way we see the cart i meant the products they were trying to buy.

  4. #4
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    Quote Originally Posted by jacksam2010 View Post
    Thanks. I do see it in failed orders. But is there any way we see the cart i meant the products they were trying to buy.
    I don't think you can, I think when an order is denied the data is cleaned up (deleted). I could be wrong, maybe someone else will chime in to say for sure.

  5. #5
    osdude is offline Senior Member
    Join Date
    Nov 2007
    Location
    earth
    Posts
    202

    Default

    yes, you can do a phone order to see what was in their cart.

  6. #6
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    If you have access to Sql Server Management Studio.

    Presuming the goods are still left in the basket:

    Code:
    SELECT * FROM [ShoppingCart] WHERE [CustomerID] = x
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!