Product Icon


by  Woo
Powerful marketing automation for WooCommerce. AutomateWoo has the tools you need to grow your store and make more money.

Adopt HPOS Schema for abandonded carts

Currently, Abandoned carts are stored in their own table with the products bundled as serialized data.

This makes it extremely difficult to run simple reports like "tell me about all the abandoned carts that include product X".

A much better approach would be using WooCommerce’s new HPOS tables wp_wc_orders, wp_wc_orders_meta, wp_wc_order_product_lookup, etc…

All that would be needed is storing the orders with a custom status like wc-abandoned or aw-abandoned.

Then all the same WC Core API functions could be used to more efficiently query these abandoned carts instead of massive amounts of fragile custom code deserializing carts one by one.



Current Status


Last updated: March 30, 2023


Log in to comment on this feature request.