No need to write code, no paid plug-ins, easy to realize WooCommerce products batch upload and download!

WooCommerce In store operation, product uploading and downloading is a common but critical operation. When there are many commodities, one by one manual modification is inefficient and prone to errors. The good thing is that you don't have to write code or pay for plug-ins, you can easily realize the batch upload and download. In this article, we will teach you to use the system comes with features and free plug-ins to quickly get it done.

WooCommerce comes with the "batch edit" function (suitable for beginners)

WooCommerce The self-contained product list supports simple batch operation, which is suitable for small-scale product management.

Operational Steps:

• go into WordPress Backstage → Products → All Products

• Tick the items that need to be shelved or taken off the shelf

• Select "Batch operation" in the upper drop-down menu → click "Edit" → Apply

• In the batch edit screen that pops up, set the "Status" to:
  • Published: Products on the shelves
  • Draft or Pending Review: Products are taken off the shelves.

• Click "Update" to finish

Applicable Scenarios:

Suitable for users who have a small number of products and only need to manually filter and manipulate them

The advantage is that no plug-in, easy to operate; the disadvantage is that the filtering function is limited, you can not quickly locate the product by category, label, inventory and other conditions

Second, use free plug-ins WP Sheet Editor(Basic version) for more flexible operation

WP Sheet Editor provides a table interface to quickly filter and batch edit WooCommerce products like Excel. There is a free version, and the functionality is already sufficient to deal with the basic shelving needs.

Installation method:

existBackend → Plugins → Add PluginSearch and Installation "WooCommerce Products Bulk Editor - WP Sheet Editor"

Operational Steps:

• After installation, click "WP Sheet Editor → Edit Product" in the backend sidebar

• Plugin will load all product tables

• Find the Status column to see the current status of the product (e.g. published, draft)

• You can click directly on the cell to modify it to:
  • publish
  • draft or pending

The free version supports the following features:

• Filter products by product name, SKU, price, etc.
• Visualize bulk edit status fields
• Intuitive operation, suitable for webmasters who can't write code

III. Special Tips: Matching "screening"Perform precise batch operations

Using the free version of the plugin, you can also improve efficiency with the filtering feature:

• Filter products categorized as "promotional products" and then batch shelve them.
• Filter products with prices greater than $300 and then batch shelve them.
• Filter products with 0 stock as drafts to automatically drop sold-out products.

This approach paired with filtering and batch status modification can greatly improve the efficiency of product management.

IV. Summary

Method I:WooCommerce Self-contained batch editing function, no need to install plug-ins, suitable for simple operation of small stores
Method 2: WP Sheet Editor free version, support form-based batch management, high efficiency, suitable for daily operation of merchants with a large number of goods

V. Conclusion

Easy to manage without writing code or spending money WooCommerce Up and down shelving of goods. Whether you're shelving new products or downselling promotional items, learning these two methods can dramatically increase efficiency.

Contact Us
Can't read the tutorial? Contact us for a free answer! Free help for personal, small business sites!	Customer Service
① Tel: 020-2206-9892
② QQ咨询：1025174874
(iii) E-mail: info@361sale.com
④ Working hours: Monday to Friday, 9:30-18:30, holidays off