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: inventory controls not working

  1. #1
    iberniztok is offline Junior Member
    Join Date
    Mar 2009
    Posts
    23

    Exclamation inventory controls not working

    Our site has been working great but just recently the inventory control started acting up. All the variants for a particular item have an inventory count of 0 but for some reason, some customers are still placing orders for it.

    How can this happen? I believe there are multiple checks against inventory control before the final gateway transaction? Our site even disables the add to cart button on the product page when that variant is out of stock so I dont know how this is possible. I then thought maybe they added it to their cart and that it was cached on their system so would that be it? even if that were it, right before the final transaction it would check against inventory again?

    Another possibility would be if a customer added the product to their wistlist before the item went out of stock.. and then the customer moves the product from their wishlist to the cart?

    Please help.

    Thanks

  2. #2
    iberniztok is offline Junior Member
    Join Date
    Mar 2009
    Posts
    23

    Default

    i think it might have to do with the cache setting turned on. is there a way to have the cache setting on and inventory control to work more precisely, concurrently? When the cache was on, and i manually changed the inventory to 0, and refreshed the product page, i was still able to select the item. Would this be a server setting?

    thanks.

  3. #3
    iberniztok is offline Junior Member
    Join Date
    Mar 2009
    Posts
    23

    Default

    actually i was just informed that the product was out of stock back in Nov. so it was definately not a cache issue? back to square one...

  4. #4
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    What version is this? I assume you were setting Inventory.LimitCartToQuantityOnHand to true? Actually, I don't heard of anything like this occurring before.

  5. #5
    iberniztok is offline Junior Member
    Join Date
    Mar 2009
    Posts
    23

    Default

    we resolved the issue. Just wanted to post my fix for this. We did not know that a force refund credits it back into inventory. thanks for the quick response!

  6. #6
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Yep, the stored proc aspdnsf_AdjustInventory will be called once a force refund is performed.