Hi,
This is not the first time its happened but 2 customers have checked out with the same product in there cart & both paid with paypal, but there was only 1 of these products available which leaves the stock quantity on -1.
The time the orders were added in the database, there is 26 seconds between them.
On a previous ocasssion, the same thing happened but one paid with paypal & the other with card, but there was just over 2 minutes difference between the orders being added to the database.
Is there some way of avoiding this or can something be changed in the coding in order to prevent this from happening? Because having to contact one of the customers & explain to them that the item is no longer available, is not ideal or the best way to run an ecommerce store?
regards
Add To Cart Confirm Ajax Popup for OC 1.5.1.3 --> 1.5.5.1 - Add to Cart Confirmation Popup
Image Map Banner Module - Image Map Banner Module
----------------------------------------------------------------------
Womens Famous Name Fashion Clothing at bargain prices - Next2nowt.com
The only way I can think this happened is the users both got to PayPal at the same time. Once they are on PayPal's website there is no way of actually checking the stock before payment because they are temporily on another site. I can't be sure without trying it myself.
When they are returned to your website the payment has already been taken and that is when the order is placed on your database, despite your stock levels. At that point you can't check the stock level and deny the order because the customer has technically paid.
There are work arounds which I can think of:
1. For each product, add 2 less to your quantity. For example if you had 10 pencils in stock, add 8 to OpenCart that way you have 2 on standby if anything goes wrong.
2. I am not sure if this has been done on OpenCart. But some websites (like ticket websites) change the stock whilst the user at the checkout. For example, when if I try buy 5 pencils, the stock will be changed then. This gives OpenCart enough time to check if the item is actually in stock before the user reaches the checkout. This also means any other users trying to order the same might get an error saying that the product is now unavailable.
Peter
For OpenCart & PHP/MySQL support feel free to PM me
Click here for my extentions
Did I help you? Donate here to show support
I agree with this part but your first point would not work for us as most products are one offs meaning we do not have quantities of them.pedro1993 wrote:2. I am not sure if this has been done on OpenCart. But some websites (like ticket websites) change the stock whilst the user at the checkout. For example, when if I try buy 5 pencils, the stock will be changed then. This gives OpenCart enough time to check if the item is actually in stock before the user reaches the checkout. This also means any other users trying to order the same might get an error saying that the product is now unavailable.
Peter
Having the cart deduct the item from the total stock as soon as its added to cart sounds like a good idea & would solve the problem but like you both say, it needs to be only for a certain time, such as 1 hour.
If the customer has not checked out in one hour or they logout of there account or they simply leave there computer for hours, the item would then show back on the site for others to purchase, but implementing this would mean changing quite a bit I would have thought, but it would certainly solve the problem we have had on more than one occasion.
Other people may not experience this problem because they probably have quantities per product but when 98% of your products have a quantity of 1, then its starting to create problems for us.
Add To Cart Confirm Ajax Popup for OC 1.5.1.3 --> 1.5.5.1 - Add to Cart Confirmation Popup
Image Map Banner Module - Image Map Banner Module
----------------------------------------------------------------------
Womens Famous Name Fashion Clothing at bargain prices - Next2nowt.com
As for tons of shoppers, no matter how many you have, you could always do with more lol
Add To Cart Confirm Ajax Popup for OC 1.5.1.3 --> 1.5.5.1 - Add to Cart Confirmation Popup
Image Map Banner Module - Image Map Banner Module
----------------------------------------------------------------------
Womens Famous Name Fashion Clothing at bargain prices - Next2nowt.com
I think it is ticket master in the UK who have a system like this. It is really clear and helpfull for the user because it has a five minute countdown showing. The countdown is reset to 5 minutes each time the user completes a stage at the checkout, so the only way it reaches 0 is if the user leaves or does nothing on the website. Of course the timer is not a must have. I'd imagine some website operate link this without the user knowingharryo40 wrote:I doesn't happen often but I do know it has happened on at least 3 occasions & the 3rd time was yesterday. I know there was only 26 seconds between when they were added into the database but the last time, which was around 4 weeks ago, there was over 2 minutes between them & one paid with paypal & the other using a credit / debit card.
As for tons of shoppers, no matter how many you have, you could always do with more lol
This is something I can do, or as avvici said, pop on to the commercial forums
For OpenCart & PHP/MySQL support feel free to PM me
Click here for my extentions
Did I help you? Donate here to show support
Sound like it will stop people being able to check out with the same products.pedro1993 wrote:The countdown is reset to 5 minutes each time the user completes a stage at the checkout, so the only way it reaches 0 is if the user leaves or does nothing on the website. Of course the timer is not a must have. I'd imagine some website operate link this without the user knowing
This is something I can do, or as avvici said, pop on to the commercial forums
I am away for 2 weeks very soon but is it ok for me to PM you when I return & we can discuss this more?
thanks for the help by the way
Add To Cart Confirm Ajax Popup for OC 1.5.1.3 --> 1.5.5.1 - Add to Cart Confirmation Popup
Image Map Banner Module - Image Map Banner Module
----------------------------------------------------------------------
Womens Famous Name Fashion Clothing at bargain prices - Next2nowt.com
For OpenCart & PHP/MySQL support feel free to PM me
Click here for my extentions
Did I help you? Donate here to show support
Users browsing this forum: stefansmith129 and 198 guests