Sales not marked as "Paid (confirmed)"

Hey @chako . The exact criteria varies from payment processor to payment processor, simply because each payment processor has it’s own method of ‘completing’ an order in WooCommerce. With that in mind, if the order is put into ‘completed’ status, this is more or less guaranteed to put the tickets into ‘paid confirmed’ status, unless some strange edge case has occurred (like in the paypal issue mentioned below). This means that if you manually update an order in the admin to be ‘completed’ (instead of something like ‘on-hold’), then your tickets will get marked as ‘paid’.

I have no idea which payment processor you are using; however, based on past experience with our own clients as well as other community users, this sounds very similar to the behavior that results from using BACS or Cheque as the processor. These processors throw orders into ‘on-hold’ until you manually update them in the admin as a paid order. If you never take that step, then the orders are never completed, and the tickets remain as simply confirmed.

Along the same lines, early on, we had an issue with the Paypal processor, where the order was not being marked completed during checkout because of a flow change from an earlier version of woocommerce. This could be a similar situation to that. This could even be a new problem, if none of the above applies.

We could probably make a better guess or even do some investigation into the problem if we had more information. Usually the following questions help the troubleshooting process on our side. Which payment processor are you using? What versions of OpenTickets, WooCommerce and WordPress are you running? Are you able to successfully checkout yourself? Are you able to create an order in the admin, mark it complete, and have it show as ‘paid’ on the report? During any of the processes of creating orders (either checkout or creating one in the admin) are you getting any notable error messages? Are you able to ‘view the tickets’ on the orders that are not showing paid?

Hopefully these questions will lead to a solution, or at least help to clarify the cause of the problem.

Loushou

Hey @chako . We tracked this down. As it turns out this was yet another nuance due to the way that the Paypal IPN processor handles completing orders. The process has been patched with a new flow that prevents this problem from happening to future orders, in OpenTickets Community Edition v1.8.2. With that in mind, this does not solve your inventory problem.

In fact, after more research was done, it seems that the not only were the tickets never getting marked paid (when using paypal), but they were never actually marked as confirmed in the database. This means that they basically all became available after about 1 hour after the order was completed. Obviously this is less than optimal. We did some thinking on this, and decided to add a tool that repairs this issue.

If you look in the admin (after getting v1.8.2+) you will see a new menu item OpenTickets -> System Status (similar to the WooCommerce system status screen). On that page, you will see a tab labeled ‘tools’. Browsing to that tab will unlock the tool I referring to. If you click the ‘Resync order items to tickets table’ button, then the system will run a script to repair those orders and tickets that are not marked paid where they should be. Using this button does run the script on page load, so it could take a minute or two to run, depending on how many orders you have (anything less than 1000 will take a couple seconds, so this is just a warning really). If you think you have too many orders or you don’t want to way for the page to refresh, and your setup supports it, you can try clicking the ‘Background: resync order items to tickets table’. This button does the exact same thing only it does it behind the scenes, and can run much longer if needed (think 100,000s of orders).

This patch will resolve the Paypal issue you identified for all future orders, and the tool will give you the power to repair the incomplete data that this issue has caused you. We have been meaning to add this System Status page and the accompanying tools page for a while now, so this was a good excuse to throw some time at it.

Thanks again for reporting this, and let us know the results,
Loushou

No problem at all @chako . Glad we were able to resolve it.

Loushou

Hey @chako . As it turns out, it seems there was an edge case that can cause the _new_ process (as of that last update) to still not work. Unluckily, it would seem that most of your purchasers fell into that category.

Instead of re-patching the problem in hopes to solve it, we have just completely re-thought it all together. Now the method in which tickets become marked paid for is completely dependent upon the order being marked completed. This will only really affect future orders, so if you have any orders that are still messed up prior to installing the new version, 1.8.3, then you will need to use that tool again to repair them.

On another note, thank you for copying that report block, and pasting it in this thread. It really did help me narrow down parts of the issue. We also noticed that you blocked out the uploads path from the copy and paste, which is actually a very good idea. That report has been changed to not show the path on the copy paste version, and we also added some more information that could help with any future issue track downs. If you are still having issues after this, please recopy this once more, because it does contain new information that could help. It is a bit more hidden now (another bug we fixed) so that it now only shows on the OpenTickets -> System Status pages, instead of every page like before. Just FYI.

Let me know how this works for you,
Loushou

P.S. – thanks for your continued communication on this. effective communication does easy the process of tracking down bugs like this, so thank you for being clear as to what the problem is, as well.

Hey @chako . Thanks for the extra information you pasted. I probably was not clear about it, but I really only needed this if you continue to have an issue with the tickets not being marked paid. Despite that, I have copied this information to a safe place on my local computer, so that I can reference it in the future if needed.

As for the removal of the comments containing the information, I don’t have the ability to do that. Actually according to http://codex.wordpress.org/Using_the_Support_Forums you have to petition the forum moderators to get it removed, and I cannot even do that for you. In light of this, I am going to be thinking of a new way to obtain the information, once permission is given, so that it does not appear in a public forum like this, because as you say, it is a lot of information that some people may not be comfortable with.

Let me know if I can help,
Loushou