Delete a product by ID using PHP in WooCommerce

dimitrisr picture dimitrisr · Oct 22, 2017 · Viewed 8.6k times · Source

Since there is a command:

wp_insert_post()

shouldn't there be a command:

wp_delete_post()

Seems like it does not exist, what is an alternative that you use when you have the ID of a product in the database and you want to delete it?

Answer

Raunak Gupta picture Raunak Gupta · Oct 23, 2017

WooCommerce has a methods to delete a product via API, so I have built a method from that function which can delete a product easily.

/**
 * Method to delete Woo Product
 * 
 * @param int $id the product ID.
 * @param bool $force true to permanently delete product, false to move to trash.
 * @return \WP_Error|boolean
 */
function wh_deleteProduct($id, $force = FALSE)
{
    $product = wc_get_product($id);

    if(empty($product))
        return new WP_Error(999, sprintf(__('No %s is associated with #%d', 'woocommerce'), 'product', $id));

    // If we're forcing, then delete permanently.
    if ($force)
    {
        if ($product->is_type('variable'))
        {
            foreach ($product->get_children() as $child_id)
            {
                $child = wc_get_product($child_id);
                $child->delete(true);
            }
        }
        elseif ($product->is_type('grouped'))
        {
            foreach ($product->get_children() as $child_id)
            {
                $child = wc_get_product($child_id);
                $child->set_parent_id(0);
                $child->save();
            }
        }

        $product->delete(true);
        $result = $product->get_id() > 0 ? false : true;
    }
    else
    {
        $product->delete();
        $result = 'trash' === $product->get_status();
    }

    if (!$result)
    {
        return new WP_Error(999, sprintf(__('This %s cannot be deleted', 'woocommerce'), 'product'));
    }

    // Delete parent product transients.
    if ($parent_id = wp_get_post_parent_id($id))
    {
        wc_delete_product_transients($parent_id);
    }
    return true;
}

Code goes in functions.php file of your active child theme (or theme). Or also in any plugin php files.

USAGE

wh_deleteProduct(170); //to trash a product
wh_deleteProduct(170, TRUE); //to permanently delete a product

Code is tested and works.

Hope this helps!