Você está visualizando atualmente WooCommerce: Bulk Replace Product Inside Existing Orders

WooCommerce: Bulk Replace Product Inside Existing Orders

  • Autor do post:
  • Categoria do post:Woocommerce
  • Tempo de leitura:4 minutos de leitura

Manual operations are always a nightmare for WooCommerce store owners. Thankfully, a bit of code can help and actions that would normally take hours can be executed in a few seconds via PHP.

Today, we’ll take a look at a very edge case, but this can still be helpful to understand the code and re-adapt it to other scenarios. If as a store owner you tend to replace products or product lines, it’s possible that you may need to replace the old products with the new ones inside existing orders, retroactively.

It’s a one-off operation that could take hours if it had to be done manually, based on the number of existing orders. With this simple snippet, however, you can edit an unlimited number of orders, and let the code replace ordered items. So, let’s see how this is done. Enjoy!

Login as administrator and append “bb-update-orders” to the current URL. Hit enter. The product replace function will trigger!

PHP Snippet: Function to Bulk Replace Products In Existing Orders, Retroactively

Important Note and Disclaimer: this function could mess up your entire WordPress database. Use only if you know what you are doing and also test it first on staging.

Usage: simply append the “bb-update-orders” URL parameter to any WordPress admin URL (e.g. https://example.com/wp-admin/index.php?bb-update-orders), hit enter in the browser bar, and the function will trigger.

/** * @snippet Bulk Replace Product @ WooCommerce Orders * @how-to Get CustomizeWoo.com FREE * @author Rodolfo Melogli * @compatible WooCommerce 7 * @donate $9 https://businessbloomer.com/bloomer-armada/ */ add_action( ‘admin_init’, ‘bbloomer_update_old_orders’ ); function bbloomer_update_old_orders() { if ( isset( $_REQUEST[‘bb-update-orders’] ) ) { if ( ! current_user_can( ‘manage_woocommerce’ ) ) { wp_die( esc_html__( ‘You do not have permission to bulk update orders’, ‘woocommerce’ ) ); } $old_product_id = 789; $new_product_id = 123456; $new_product = wc_get_product( $new_product_id ); $last_order = get_posts( ‘post_type=shop_order&numberposts=1&fields=ids’ ); $last_order_id = $last_order[0]; for ( $i = 1; $i <= $last_order_id; $i++ ) { $order = wc_get_order( $i ); if ( ! $order instanceof WC_Order ) continue; $replaced = false; foreach ( $order->get_items() as $item_id => $item ) { if ( $item && $item->get_product_id() == $old_product_id ) { wc_delete_order_item( $item_id ); $order->add_product( $new_product, $item->get_quantity(), array( ‘order’ => $order ) ); $order->add_order_note( ‘Replaced product programmatically’ ); $replaced = true; } } if ( $replaced ) $order->save(); } } }

Where to add this snippet?

You can place PHP snippets at the bottom of your child theme functions.php file (delete “?>” if you have it there). CSS, on the other hand, goes in your child theme style.css file. Make sure you know what you are doing when editing such files – if you need more guidance, please take a look at my free video tutorial “Where to Place WooCommerce Customization?”

Does this snippet (still) work?

Please let me know in the comments if everything worked as expected. I would be happy to revise the snippet if you report otherwise (please provide screenshots). I have tested this code with Storefront theme, the WooCommerce version listed above and a WordPress-friendly hosting on PHP 7.3.

If you think this code saved you time & money, feel free to join 14,000+ WooCommerce Weekly subscribers for blog post updates or 250+ Business Bloomer supporters for 365 days of WooCommerce benefits. Thank you in advance 🙂

Need Help with WooCommerce?

Check out these free video tutorials. You can learn how to customize WooCommerce without unnecessary plugins, how to properly configure the WooCommerce plugin settings and even how to master WooCommerce troubleshooting in case of a bug!

Rodolfo Melogli

Business Bloomer Founder

Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis & soccer balls and, of course, wood fired oven pizza.

Follow @rmelogli

Post navigation