Page 1 of 2

Stock Level not decreasing

Posted: Fri Jan 31, 2020 6:41 am
by brickmodder
I've been trying to fix this for almost a year now to no avail. Can someone help me? I use PayPal Express Checkout on my website. Stock levels are not decreasing when someone makes an order. OC Version 3.0.3.2

PayPal Settings
Image

Store Settings
Image

Thanks!!!

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 6:54 am
by straightlight
What is the order status of the latest order with PP Express in your sales order? Did you also monitored the transaction by using the debug in the OC admin PP express checkout payment extension module form to ensure the order has been successfully processed?

Do you also see a copy of the invoice on your PayPal account?

In addition, are you using any recurring products with PP Express?

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 8:17 am
by brickmodder
Order status (I think) changes to complete first, then when I ship the order in Shiprush (a program on my pc), it changes to shipped. So, as of right now all orders have shipped and are showing shipped in my dashboard.

I do have a record in my PP account of all transactions, as well as emails from my OC store with order details.

I have no recurring products. All stock levels should decrease and they are all set to decrease.

I do not know about debugging. Can you explain?

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 9:40 am
by Burt65
brickmodder wrote:
Fri Jan 31, 2020 8:17 am
Order status (I think) changes to complete first, then when I ship the order in Shiprush (a program on my pc), it changes to shipped. So, as of right now all orders have shipped and are showing shipped in my dashboard.

I do have a record in my PP account of all transactions, as well as emails from my OC store with order details.

I have no recurring products. All stock levels should decrease, and they are all set to decrease.

I do not know about debugging. Can you explain?

If you check your picture posted above you have "Complete" selected in both Processing and complete order status. That's wrong.
Take the "complete" off from the processing list and add "complete" (you already have that) and "shipped" to the complete order status.

Practically you need to tick each status you use for each situation you have.. So in the "Processing order status" tick all the one you want/need/use but not the one that you will use for when the transaction is finalised. They go into the "Complete order status" like Shipped and Complete and Refunded...

Does it make sense?

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 9:41 am
by straightlight
brickmodder wrote:
Fri Jan 31, 2020 8:17 am
Order status (I think) changes to complete first, then when I ship the order in Shiprush (a program on my pc), it changes to shipped. So, as of right now all orders have shipped and are showing shipped in my dashboard.

I do have a record in my PP account of all transactions, as well as emails from my OC store with order details.

I have no recurring products. All stock levels should decrease and they are all set to decrease.

I do not know about debugging. Can you explain?
Instead, from your admin - > catalog - > products page, ensure before each of the active products get purchased that the subtract option is set to: 'Yes' before reaching the cart. The debug will not be necessary, in this case.

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 9:50 am
by brickmodder
Like this?

Image

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 9:54 am
by straightlight
While validating your order statuses, ensure to read my previous post about the subtract option.

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 10:04 am
by Burt65
brickmodder wrote:
Fri Jan 31, 2020 9:50 am
Like this?

Image
Yes just like that. Is not mentioned in the documentation and it takes lots of people by surprise...

Off course you also need to check what Straighlight just mentioned above

EDIT:
Sorry I actually spoke too quickly.
You need to tick each status for both the processing order status (to activate stock subtraction) and in complete order status (for downloadable products)
So if you had the "shipped" not market in the Processing Order Status, it wouldn't have worked...
For instance in the picture above the "failed" and "Refund" should not actually be in the Complete order status. Sorry for the confusion...

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 10:21 am
by Burt65
Ok let me try again..
In the first picture you posted you only have "Complete" in the processing order list...
What I was trying to say is that you need to tick all the status that you need when the transaction is good...

So everything but "Denied, Chargeback, Refunded....

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 10:49 am
by brickmodder
Ha, now my brain is swimming...
Could you list the ones I need checked, vs the ones I do not need checked?

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 10:54 am
by brickmodder
Order Status:
Processed?

Processing Order Status:
Status
Canceled
Complete
Failed
Processed
Processing <- only this one?
Refunded
Shipped
Voided

Complete Order Status:
Canceled
Complete <-this one?
Failed
Processed <-this one?
Processing
Refunded
Shipped <- and this one?
Voided

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 11:00 am
by Burt65
brickmodder wrote:
Fri Jan 31, 2020 10:49 am
Ha, now my brain is swimming...
Could you list the ones I need checked, vs the ones I do not need checked?
I'm sorry I confused you with my first post..

In the Processing order Status you need to tick every single status where you want Opencart to actually remove the stock..
So tick everything but not Cancelled, Chargeback, Denied, Failed, Expired.... and so forth.

The Complete Order Status is for the downloadable item/product only, so again you would only have ticked the one that do finalise the transaction such as Complete and shipped...
That's it. I think in the beginning it was not working for you because from the first picture it looked like you only had Complete select in the Processing order Status and then you mentioned that you used shipped. So unless shipped was also ticked, Opencart would not remove the stock..

Is good that you also changed the "Order Status" from complete to Processing or Processed. If you have complete there, again it will not work
I hope this is better...
Cheers..

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 11:05 am
by brickmodder
Subtract Stock: Yes

is checked on every product. Confirmed.

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 11:08 am
by straightlight
brickmodder wrote:
Fri Jan 31, 2020 11:05 am
Subtract Stock: Yes

is checked on every product. Confirmed.
Was this option checked for every products before reporting the issue? If so, then the issue is definitely related to the order statuses as you'd need to ensure to follow Burt65's instructions to balance the order statuses and the orders between your default store settings with the payment and shipping order statuses whenever implied.

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 11:11 am
by Burt65
Order Status:
Processed? >Yes

Processing Order Status: (to tell Opencart when to start stock Subtraction)
Cancelled > No
Complete > Yes
Failed > No
Processed > Yes
Processing > Yes
Refunded > No
Shipped > Yes
Voided > No

Complete Order Status: (to tell Opencart when to allow access to downloadable products)
Complete > Yes
Shipped > Yes

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 11:18 am
by brickmodder
Straightlight, yes

Burt, thanks I'll try those.

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 11:38 am
by straightlight
Added order statuses steps to FAQ. Thanks.

Re: Stock Level not decreasing

Posted: Fri Jan 31, 2020 8:21 pm
by paulfeakins
straightlight wrote:
Fri Jan 31, 2020 11:38 am
Added order statuses steps to FAQ. Thanks.
Please link to the FAQ when you mention it to help users.

Re: Stock Level not decreasing

Posted: Sat Feb 01, 2020 7:53 am
by Burt65
paulfeakins wrote:
Fri Jan 31, 2020 8:21 pm
Please link to the FAQ when you mention it to help users.
Hmmm.. A déjà vu :laugh:

Re: Stock Level not decreasing

Posted: Thu Feb 20, 2020 8:35 am
by brickmodder
Still not decreasing. Please help.

Store settings:
Image

Catalog item sample:
Image

PayPal Express settings:
Image