order number not set correctly in wp_woocommerce_order_items

Hey Knowlton, so sequential order numbers actually writes the order number to the wp_postmeta table, since it applies to the entire order record, rather than a particular item or itemmeta. Regardless of that though, it should not cause any issues with your custom plugin, nor should your custom plugin cause issues with sequential order numbers. Which plugin is not working exactly? Have you confirmed that sequential order numbers works with your custom plugin disabled, and then vice versa? To make sure that there really is some sort of incompatibility going on?

— Justin

Hi Justin, thanks for the reply. I confirmed my plugin works when I deactivate sequential order numbers, and breaks when I activate it. What my plugin does is, once an order is completed, it looks at the cart contents and any product that requires a serial number it grabs the order_item_id for that line_item, fetches a serial number, and writes it to wp_woocommerce_order_itemmeta with the order_item_id for that product. I think the problem is happening (and I am still trying to fully diagnose the issue) when my plugin goes to display the serial numbers on the order details page it is looking for the order_id stored in wp_woocommerce_order_items to match the serial numbers with the order, but that order_id is the original ID from wp_posts, not the one the sequential order numbers plugin has assigned. The sequential order numbers plugin is working correctly, I think I just have to change the way my plugin is looking for the stored serial numbers so it is pulling the correct ones for the order. Thanks again for the speedy reply.

FYI, after rewriting the way my plugin fetches serial numbers for an order, everything is working properly. Thanks for the plugin!

You got it!