Post by brickmodder » Fri Jan 31, 2020 6:41 am

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!!!

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by straightlight » Fri Jan 31, 2020 6:54 am

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?

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 brickmodder » 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?

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by Burt65 » Fri Jan 31, 2020 9:40 am

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?

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by straightlight » Fri Jan 31, 2020 9:41 am

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.

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 brickmodder » Fri Jan 31, 2020 9:50 am

Like this?

Image

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by straightlight » Fri Jan 31, 2020 9:54 am

While validating your order statuses, ensure to read my previous post about the subtract option.

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 Burt65 » Fri Jan 31, 2020 10:04 am

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...

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by Burt65 » Fri Jan 31, 2020 10:21 am

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....

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by brickmodder » 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?

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by brickmodder » Fri Jan 31, 2020 10:54 am

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

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by Burt65 » Fri Jan 31, 2020 11:00 am

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..

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by brickmodder » Fri Jan 31, 2020 11:05 am

Subtract Stock: Yes

is checked on every product. Confirmed.

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by straightlight » Fri Jan 31, 2020 11:08 am

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.

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 Burt65 » Fri Jan 31, 2020 11:11 am

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

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by brickmodder » Fri Jan 31, 2020 11:18 am

Straightlight, yes

Burt, thanks I'll try those.

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am

Post by straightlight » Fri Jan 31, 2020 11:38 am

Added order statuses steps to FAQ. Thanks.

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 paulfeakins » Fri Jan 31, 2020 8:21 pm

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.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by Burt65 » Sat Feb 01, 2020 7:53 am

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:

Over 95% of all computer problems can be traced back to the interface between the keyboard and the chair...


User avatar
Active Member

Posts

Joined
Mon Nov 18, 2013 3:23 pm
Location - Oz

Post by brickmodder » Thu Feb 20, 2020 8:35 am

Still not decreasing. Please help.

Store settings:
Image

Catalog item sample:
Image

PayPal Express settings:
Image

Newbie

Posts

Joined
Sat May 04, 2019 10:49 am
Who is online

Users browsing this forum: AdsBot [Google], Ask Jeeves [Bot], Google Adsense [Bot], W3C [Validator] and 35 guests