Post by yaqut » Thu Sep 17, 2020 5:17 am

yesterday we have many customers on the same product,
and we have only 1 qty,
3 customers make an order at the same time and all customer get order number

after this, I found product qty: -2

In the settings, we do not allow customers to complete the order as long as the product is not available
Is there an explanation for that?

Newbie

Posts

Joined
Thu Jun 08, 2017 10:03 am

Post by IP_CAM » Thu Sep 17, 2020 6:06 am

Well, after beeing around for quite some time, one should know, that Extensions
for such exist. And one should also know, that, without mentioning the OC Version
and the Theme used, it's quite impossible, to reply on such ....
https://www.opencart.com/index.php?rout ... h=no stock

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by letxobnav » Thu Sep 17, 2020 7:57 am

This is rare but product stock quantity is subtracted when the order reaches either "processing set" or "complete set" status.

So if a person orders a product but the status of the order remains pending because the payment has not been completed yet and status pending is not part of your processing or complete sets, another person can also order that product because the stock has not been adjusted yet.
So if you have this frequently, check the pending status in the "processing status set" in admin so the stock is immediately adjusted.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by yaqut » Thu Sep 17, 2020 9:21 pm

IP_CAM wrote:
Thu Sep 17, 2020 6:06 am
Well, after beeing around for quite some time, one should know, that Extensions
for such exist. And one should also know, that, without mentioning the OC Version
and the Theme used, it's quite impossible, to reply on such ....
https://www.opencart.com/index.php?rout ... h=no stock
hi,
we use opencart 3.0.2 with journal theme ,
i think the problem on checkout not product page .

The product is converted to out of stock When the order is added, correct?

the problem here when we have 1 qty and 3 customer add this product on same time to cart and try to checkour
we get 3 order!

Newbie

Posts

Joined
Thu Jun 08, 2017 10:03 am

Post by yaqut » Thu Sep 17, 2020 9:33 pm

letxobnav wrote:
Thu Sep 17, 2020 7:57 am
This is rare but product stock quantity is subtracted when the order reaches either "processing set" or "complete set" status.

So if a person orders a product but the status of the order remains pending because the payment has not been completed yet and status pending is not part of your processing or complete sets, another person can also order that product because the stock has not been adjusted yet.
So if you have this frequently, check the pending status in the "processing status set" in admin so the stock is immediately adjusted.
thanks for your raplay ,
i check again
we have 2 payment method

visa and COD

All requests go to a status pending first ,then we check and process it

Newbie

Posts

Joined
Thu Jun 08, 2017 10:03 am

Post by IP_CAM » Thu Sep 17, 2020 9:35 pm

we use opencart 3.0.2 with journal theme
Well, then better read the Topic about Journal:
viewtopic.php?f=202&t=220036#p799608
to find out, that you're probably posting your matter on the wrong Forum Site. ::)
Journal Support would be a much better place for such matters, if it's about a
paid Custom Extension, not bought trough OpenCart.
Good Luck!
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by letxobnav » Thu Sep 17, 2020 9:47 pm

All requests go to a status pending first ,then we check and process it
that is nice but if pending is not set as part of the processing or complete status sets in admin:
settings->store->option
Processing Order Status/Complete Order Status

then the stock is not subtracted when the order is created, it is only subtracted ones the order reaches one of the stati set in one of those sets.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by yaqut » Thu Sep 17, 2020 10:12 pm

IP_CAM wrote:
Thu Sep 17, 2020 9:35 pm
we use opencart 3.0.2 with journal theme
Well, then better read the Topic about Journal:
viewtopic.php?f=202&t=220036#p799608
to find out, that you're probably posting your matter on the wrong Forum Site. ::)
Journal Support would be a much better place for such matters, if it's about a
paid Custom Extension, not bought trough OpenCart.
Good Luck!
Ernie

the problem not on journal,
i test this problem on fresh opencart site ,and get same problem

i will check topic anout journal too , thanks

Newbie

Posts

Joined
Thu Jun 08, 2017 10:03 am

Post by yaqut » Fri Sep 18, 2020 1:03 am

letxobnav wrote:
Thu Sep 17, 2020 9:47 pm
All requests go to a status pending first ,then we check and process it
that is nice but if pending is not set as part of the processing or complete status sets in admin:
settings->store->option
Processing Order Status/Complete Order Status

then the stock is not subtracted when the order is created, it is only subtracted ones the order reaches one of the stati set in one of those sets.
we make it on processing , put we still have the problem.
The problem is that the order is made while another customer is paying
The quantity is deducted upon the arrival of the order and not upon entering the checkout page

Attachments

Capture.PNG

Capture.PNG (3.84 KiB) Viewed 1029 times


Newbie

Posts

Joined
Thu Jun 08, 2017 10:03 am

Post by letxobnav » Fri Sep 18, 2020 7:27 am

The quantity is deducted upon the arrival of the order and not upon entering the checkout page
of course, if you want to deduct stock on entering the checkout page your entire stock will be gone pretty fast with no orders.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by yaqut » Fri Sep 18, 2020 10:05 pm

letxobnav wrote:
Fri Sep 18, 2020 7:27 am
The quantity is deducted upon the arrival of the order and not upon entering the checkout page
of course, if you want to deduct stock on entering the checkout page your entire stock will be gone pretty fast with no orders.

I think there should be a solution to this.
It doesn't make sense for every customer to be compensated for the amount of intake.
It is unreasonable for me to compensate every customer for running out of stock
I am looking for a solution to reserve the quantity for each customer who tries to checkout, for only a few minutes if he does not pay, then the product returns to the store.

Newbie

Posts

Joined
Thu Jun 08, 2017 10:03 am

Post by straightlight » Fri Sep 18, 2020 10:10 pm

yaqut wrote:
Fri Sep 18, 2020 10:05 pm
letxobnav wrote:
Fri Sep 18, 2020 7:27 am
The quantity is deducted upon the arrival of the order and not upon entering the checkout page
of course, if you want to deduct stock on entering the checkout page your entire stock will be gone pretty fast with no orders.

I think there should be a solution to this.
It doesn't make sense for every customer to be compensated for the amount of intake.
It is unreasonable for me to compensate every customer for running out of stock
I am looking for a solution to reserve the quantity for each customer who tries to checkout, for only a few minutes if he does not pay, then the product returns to the store.
By creating an event, this could be accomplished based on the datetime interval and the order statuses or, even better, by your payment service providers' responses.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by letxobnav » Fri Sep 18, 2020 10:31 pm

In addition to deducting stock on order status pending you could do the stock check with stock and the amount of products there are in all shopping carts.
So if you only have 1 of product A in stock, when a user wants to add product A to the cart, not only check the actual stock level but also if another user has product A in their cart. if stock quantity product A - other carts quantity product A < user wanted quantity product A, don't allow add to cart or checkout.
You would have to auto clear customer carts as well though as those are now permanent and that would then mean a permanent reservation.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan
Who is online

Users browsing this forum: No registered users and 2 guests