---
title: "Export Low-Stock and Out-of-Stock WooCommerce Products to Excel"
url: "https://wpimportexport.com/export-low-stock-out-of-stock-woocommerce-products/"
description: "Export WooCommerce products that are out of stock, on backorder or running low to Excel or CSV for reordering, including single variations."
type: post
published: 2026-11-16T05:00:00+00:00
modified: 2026-11-14T10:45:04+00:00
categories: ["Export Guides", "Tutorials", "WooCommerce"]
tags: ["Import Export by RockStarLab", "WooCommerce", "WordPress Excel export"]
docs_topics: ["Export guides"]
---

# Export Low-Stock and Out-of-Stock WooCommerce Products to Excel

WooCommerce shows stock on the Products screen and can email you when a product runs low, but it doesn’t give you a list you can send to a supplier or check off while you reorder. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) PRO, two filters export every product that is out of stock, on backorder or below your reorder level to Excel or CSV. The example is a reorder list for a small merch shop.

**PRO:** WooCommerce product export is part of PRO. **Free:** posts, pages and media.

## Short Answer

1. In **Export**, choose **Products** and add the filter **Stock Quantity** **Less or Equal** your reorder level, for example `5`. Products that don’t track stock aren’t matched.
2. Export Product Name, SKU, Stock Quantity, Stock Status and Backorders to XLSX, and sort by stock.
3. For variable products, turn on **One row per variation** on the format step: the filter then checks each variation.

## Filter for low stock

Our shop has 19 products. Some track stock, some don’t: a grouped product, an external product and the variable T-shirts have no stock quantity of their own. The filter **Stock Quantity** **Less or Equal** `5` gives the reorder list; the **Manage Stock** filter in our screenshot is optional:

![Product export filters: Manage Stock Equals yes and Stock Quantity Less or Equal 5; total items available 6](https://wpimportexport.com/wp-content/uploads/2026/11/01-stock-filters.webp)

_Products with 5 or fewer in stock. Manage Stock = yes is optional._

- Products that don’t track stock, like our grouped, external and variable products, have no quantity and aren’t matched. The filter found the same 6 products with or without **Manage Stock** **Equals** `yes`.
- **Stock Quantity** **Less or Equal** `5` is your reorder level. Use the number that fits your delivery times.

## Export and sort

We exported Product Name, SKU, Stock Quantity, Stock Status and Backorders to XLSX and sorted by stock_quantity:

![Spreadsheet sorted by stock_quantity: Beanie 0 outofstock, Sunglasses 0 onbackorder with backorders notify, Logo Mug 1, Belt 2, Polo 3, Cap 4 in stock](https://wpimportexport.com/wp-content/uploads/2026/11/02-low-stock-sheet.webp)

_The reorder list: two products at 0, four running low._

- **Beanie**, 0, `outofstock`: customers can’t buy it.
- **Sunglasses**, 0, `onbackorder`: the product allows backorders (`notify`), so customers can still order it and wait. Reorder it first, because you already owe those orders.
- **Logo Mug**, **Belt**, **Polo** and **Cap**, 1 to 4: still for sale, but running low.

Add a column for the quantity to order and send the file to your supplier. Keep the SKU column: suppliers and your accounting know products by SKU, not by name.

## Only out-of-stock products

For a list of what customers can’t buy right now, use one filter instead: **Stock Status** **In** `outofstock,onbackorder`. It returned Beanie and Sunglasses in our shop. Use `outofstock` alone to leave out backorders.

## Variable products

A variable product keeps stock per variation, for example per size or color. With **Variations: One row per variation** turned on in the format step, the stock filters check each variation, and every matching variation becomes its own row.

Our Hoodie has one variation, “Blue, Yes”, at 0. The low-stock export with one row per variation had 7 rows: the six products from the list above and “Hoodie – Blue, Yes” with its own SKU, at 0 and `outofstock`. The Hoodie’s other variations, which don’t track stock, weren’t included. Add **Parent SKU** to see which product a variation belongs to.

## After you reorder

When the delivery arrives, update the quantities in the same file and import it back by SKU; see [updating prices and stock by SKU](https://wpimportexport.com/how-to-update-woocommerce-prices-stock-by-sku-csv/). [Back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before an import that changes stock, and try a few rows first.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can check stock on request:

```
Which products that track stock have 5 or fewer left?
```

In our run, the agent called `rsl-ie-pro/export-preview` with the product export, the filters `manage_stock` equals `yes` and `stock_quantity` `equals_or_less` 5. It returned the same six products as the wizard, from Beanie and Sunglasses at 0 to Cap at 4.

## FAQ

### Does the export use WooCommerce’s low stock threshold?

No. You set the level in the filter, so it can differ from the threshold for low-stock emails in WooCommerce settings.

### Does the list include variations?

Yes, when you turn on One row per variation. Each variation that matches the filter becomes its own row.

### Are draft products included?

Yes, unless you add a **Status** filter. Add Status Equals `publish` to see only products in the shop.

## Related Guides

- [How to Update WooCommerce Prices and Stock by SKU Using CSV](https://wpimportexport.com/how-to-update-woocommerce-prices-stock-by-sku-csv/)
- [How to Export WooCommerce Products for Google Merchant Center](https://wpimportexport.com/export-woocommerce-products-google-merchant-center/)
- [Export WooCommerce Orders for Accounting (QuickBooks and Xero-Friendly CSV)](https://wpimportexport.com/export-woocommerce-orders-for-accounting/)
- [Find Thin Content in WordPress: Export Word Counts for a Content Audit](https://wpimportexport.com/find-thin-content-wordpress-word-count-export/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
