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 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
- 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. - Export Product Name, SKU, Stock Quantity, Stock Status and Backorders to XLSX, and sort by stock.
- 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:

- 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
5is 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:

- 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. Back up the site 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) 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
- How to Export WooCommerce Products for Google Merchant Center
- Export WooCommerce Orders for Accounting (QuickBooks and Xero-Friendly CSV)
- Find Thin Content in WordPress: Export Word Counts for a Content Audit
Get the free plugin on WordPress.org.

Comments 0
Have a question or a tip to share? Leave it below.