Mailchimp Banner | Q2 2024

added by Latoya

Product Icon

AutomateWoo

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.

Author

jb510

Current Status

Open

Last updated: March 30, 2023

0 comments

Log in to comment on this feature request.