Posted on

WooCommerce: How to Bulk Edit Products?

You want your website visitors to checkout fast, pay you faster and receive their item quickly. However, speed matters for us WooCommerce store owners as well.

By looking at this year’s time-sheets for my own business, about 50% of the time was spent between marketing and admin – and the “admin” part is the one we’re tackling today.

If you run a busy WooCommerce shop with hundreds of products, you probably noticed how annoying it is to edit products one by one.

Yes, the WooCommerce admin dashboard allows us to do certain bulk edits a la WordPress, however you must play with the “screen options” and also the filtering is not good enough.

On the other end, as WooCommerce managers we’re probably more familiar with Excel-alike spreadsheets where all our products are editable with a single click in a specific cell.

Good news is there are plugins that can make your life easier, your admin time more efficient and your product management simpler. And today we’re taking a look at the best options.

1) Default WooCommerce Bulk Product Editing

I’d be surprised if you never used this before. The default WooCommerce bulk editing is actually a WordPress functionality. You probably bulk assigned a category to multiple posts before – or maybe bulk edited posts to draft.

Many WooCommerce entrepreneurs completely underestimate this tool. So, let’s make a little reminder here so that at least you know what you can and cannot do.

a) Go to WP Dashboard > Products and check the products you want to edit. Then, from the “Bulk Actions” drop-down, select “Edit”

Bulk Edit @ WooCommerce Products dashboard

b) Click on “Apply”. A bulk edit window appears. Now use the appropriate areas to bulk add a product category, change the status, increase/decrease prices, feature, manage inventory… Then click on the blue button “Update”

Bulk Edit window @ WooCommerce Products dashboard

That’s it – you’ve now bulk edited a bunch of products πŸ™‚

However, while this system works like a charm, it doesn’t really have the best UX. You cannot select multiple products across multiple admin dashboard pages (you’ll need to edit them 1 page at a time, mostly if you have hundreds of items), it doesn’t really give you enough filters to select only the products you want to edit (it only works by category, stock status and product type) and does not work for complex product types such as variable and grouped.

If you only have simple products and need to bulk edit simple fields, this is probably sufficient. But if your management and marketing require more advanced stuff and a handy tool to bulk edit products, then you’ll need a reliable plugin.

2) YITH WooCommerce Bulk Product Editing Plugin

Here comes YITH again. Surely, they know what the biggest WooCommerce weaknesses are and of course they have a plugin for bulk editing products as well.

With this plugin you can easily filter the products you want to bulk edit, and then modify any information: prices, description, custom fields, basically anything. You can even add products and export and import data πŸ™‚

YITH WooCommerce Bulk Product Editing comes as a freemium model, therefore there is a free version you can happily test on your development website before committing to the premium plugin.

The main features of YITH WooCommerce Bulk Product Editing premium, in my opinion, are the following:

  • Bulk edit any default product field
  • Filter by category, title, date, SKU, tag, price and attributes
  • Bulk edit variable products
  • Create new products
  • Import/export XML data
  • Bulk edit custom fields
  • Add prefix/suffix to any text/description

As usual make sure to ask all your questions to the pre-sales team in case you require specific functionalities, compatibilities or are not sure about something. YITH has a great support team, usually replies quickly and it’s often very open to implement new features if you request so.

So, let’s take a few screenshots to learn more.

a) Go to WP Dashboard > YITH > Bulk product editing and select your criteria for filtering products. Click on “Get Products”

Bulk edit products with YITH plugin – Filters

b) Your products now appear in an Excel-alike table. Each cell is editable

Bulk edit products with YITH plugin – Filter Result

c) Use the Show/Hide button to display/hide the product fields you want to edit

Bulk edit products with YITH plugin – Product columns

d) Edit products in the table. Each edit will get a red background so that you know what you’ve changed. Then click “Save”. That’s it!Β 

Bulk edit products with YITH plugin – Product editing

You can even Undo, import/export, create a new product and manage variations. It’s awesome and you’ll thank me for this.

Price point: approx $75/€65. If YITH WooCommerce Bulk Product EditingΒ saves you at least 60 minutes of work this week (which it will), then you’d pay back your investment in 7 days.

3) WooCommerce CSV Import/Export

Another way to bulk edit products is by using Excel spreadsheets (CSV is just an Excel format) and a reliable Import/Export plugin for WooCommerce products.

Because there are hundreds of import/export plugins it’s hard to say which one works best. I used WP All Import + WooCommerce Add-on in the past and never had to look for an alternative.

Rodolfo Melogli

Author, WooCommerce expert, WordCamp speaker and Internet marketer, Rodolfo Melogli has worked as a WooCommerce freelancer since 2011. He helps entrepreneurs and developers overcome their WooCommerce nightmares πŸ™‚ Rodolfo is the organiser of WordCamp Dublin, the Dublin WooCommerce Meetup, the Dublin Ecommerce Meetup and the Dublin WordPress Meetup. He enjoys interacting with people, travelling and chasing tennis & soccer balls. Of course, he loves pizza too.

4 thoughts on “WooCommerce: How to Bulk Edit Products?

  1. Hello Rodolfo

    That are all good ways, but there is exists best one: https://wordpress.org/plugins/woo-bulk-editor/ – WOOBE – WooCommerce Bulk Editor Professional – tons of features and they for free

    1. Hey there, thanks for your comment! 50 active installations is not sufficient for my standards, so at least for now I don’t feel like recommending this one I’m afraid. If it gets more popular let me know again and I will add this to the list πŸ™‚

  2. Perfect timing on this article. The YITH plugin sounds like just what I need. Thanks for reviewing it.

    1. Carole, thanks for your comment! And let me know how that goes πŸ™‚

Questions? Feedback? Support? Leave your Comment Now!
If you're writing code, please wrap it between: [php] code_here [/php]

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