Back to blog
4 min read 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 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
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
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. 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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

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

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE