HPOS “Sync X pending order(s)”

Hi @shameemreza,

Is the wc_run_batch_process task responsible for manual syncing (when clicking “Sync X pending orders”) or for preventing the “Sync X pending orders” message from appearing in the first place?

The issue we’re having is not the former (getting the message to disappear when manually clicked) but rather the latter (preventing the message from reappearing after being in sync). On the now 3 sites where I’ve enabled HPOS, all wc_run_batch_process tasks show a Status of “Complete” and the button to “Delete the custom orders tables” is greyed out. Also I have not enabled compatibility mode.

I manage dozens of sites and don’t want to install yet another plugin like WP Crontrol to avoid this recurring message.

Thanks.

Hi @nothin7 !

Thank you for reaching out and for sharing details on the issue.

We want to dive deeper into this. Since every setup is unique, kindly create your own topic so we can look further into this issue and assist you properly. This will also help us follow with the forum guidelines.

You can create a new topic here: https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0.

Please include all the details you know about it or what you have done so we can start where you left off.

We are looking forward to hearing from you.

Cheers!
-OP

Hi @shameemreza,

Posting here so others with the same question see this. I think I understand what’s going on. The “problem” we are all reporting is less of a problem and more of a confusing interface. After switching to HPOS, the following message now only applies to compatibility mode, but its wording suggests that it is still preventing HPOS from being fully active:

There are 3 orders pending sync. You can switch order data storage only when the posts and orders tables are in sync.
Sync 3 pending orders

If you don’t enable compatibility mode, this message will (eventually) appear regardless, but after switching to HPOS this message should only appear when the “Enable compatibility mode” checkbox is checked. That’s because it’s irrelevant whether your posts and orders tables are in sync if you’ve already synched and activated HPOS. No orders should end up in the posts table after enabling HPOS without compatibility mode, right? So don’t present a scary bold message to users who don’t need to see it. And don’t tell us something is “pending” when in reality it does not require our attention. In addition to conditionally hiding this message, the second sentence should be removed altogether once a user has switched to HPOS:

You can switch order data storage only when the posts and orders tables are in sync.

That sentence is technically incorrect when HPOS is active because it speaks of a future event (switching order data storage) that has already transpired. At this point it technically should say:

If you ever switch back to legacy storage and then decide to enable HPOS again, you will need to resync the posts and orders tables.

But it’d be less confusing to just hide that sentence after HPOS is successfully enabled, then show it again only in the rare event that a user switches from HPOS back to legacy storage. From a programming standpoint, the logic is simple:

1. If orders pending sync > 0:
   • If Order Data Storage legacy radio button = selected:
     • Show link to sync orders and message “You can switch order data storage only when the posts and orders tables are in sync.”
   • Else if Compatibility Mode checkbox = checked:
     • Show link to sync orders and message “Compatibility mode will be fully enabled when the posts and orders tables are in sync.”
   • Else: Hide message and link to sync orders
2. Else: Hide message and link to sync orders