Posted on

How to Bulk Edit WooCommerce Products, Orders, WordPress Post Types?

Save time and make your life easier. Now bulk edit WooCommerce products, variations, attributes, coupons, orders, users, any WordPress custom post type using Smart Manager plugin.

Last updated on May 17, 2021

In this article, you’ll come to why you should use Smart Manager as your preferred WooCommerce bulk edit plugin.

You’ll also learn how to bulk edit WooCommerce products (simple, variable, all types), orders, users, coupons, any WordPress post type quickly using Smart Manager.

And some applications where bulk edit is highly useful. So stay till the end.

Businesses, believe us, we feel you!

Let us imagine a situation where inflation forces you to increase the price of all products, say 540 on your WooCommerce store by 15%. The thought of manually going to each product is frustrating and editing them one by one is very time consuming.

Another hassle is the filtering option. Without filters, making a simple edit to a particular item among thousands will give you goosebumps(correct me if I’m wrong).

This is just a one-off situation. You and we know what running an online business requires. Remember, you are here to grow your business and not waste time in mundane tasks.

So, if anything like making changes in bulk seems a life-saving option, right?

Yes. The default WooCommerce does provide it but with limitations.

Default WooCommerce bulk edit falls short here

You may have bulk edited WordPress posts and pages or put them in the draft in bulk. But you can also bulk edit products to some extent.

  • Go to your WP Dashboard > Products and check the products you want to edit. Then, select Edit from the Bulk Actions drop-down.
  • Click on Apply. A bulk edit window appears. Now use the appropriate areas to bulk add a product category, change the status, increase/decrease price…and then click on the button Update button.

You’ve now bulk edited a bunch of products.

But here are its limitations

  • Does not work for complex product types such as variable and grouped
  • No filtering option to edit only selected products (it only works by category, stock status, and product type).
  • UX is not that great
  • You cannot select multiple products across multiple admin dashboard pages (you’ll need to edit them 1 page at a time).
  • Can’t bulk update orders, coupons, or any WordPress custom post type

So, if your business requires a more advanced WooCommerce bulk edit plugin that overcomes all these limitations. And provides better features, you need Smart Manager plugin.

Is Smart Manager the best WooCommerce bulk edit plugin?

WooCommerce Smart Manager dashboard

Alright, long things short. Smart Manager gives you the ability to manage your entire WooCommerce store using an Excel-like spreadsheet with ease and peace.

But it’s biggest USP is the Bulk Edit or Batch Update feature. 20K+ users rely on Smart Manager daily to manage their WooCommerce store and accomplish hours of work within a few clicks (and a few seconds).

Bulk edit stock price, product variations, product categories, product description, orders, attributes, coupons, blog posts…any WordPress post type and custom fields quickly. It’s fun and time-saving!

But that’s not it. Smart Manager is compatible with these top plugins selling on WooCommerce.com –

So you can also bulk edit subscriptions, bookings, memberships, SEO fields, etc.

Learn more about Smart Manager

Here’s how to perform bulk edit using Smart Manager

We are showing bulk edit operation for products. You can perform bulk edit for any other post type the same way. Just select the post type from the dropdown.

Bulk edit entire store or selected products

You can directly select some products or the entire store by checking the header checkbox as shown in the image. Once selected, click on the Bulk Edit option.

Select some products or entire store for bulk edit operation

Once you click the Bulk Edit option, it will open up a slide-over panel. To bulk edit all items, chooseAll Items In Store. For selected products, choose Selected Items.

WooCommerce bulk edit operation using Smart Manager

In this example, update the following parameters for all products in bulk – sale price, stock, additional description and tax status. You can add any number of parameters to perform bulk edit. Perform operations like append, prepend, increase, decrease, set to, copy from, etc. using bulk edit.

Click on Update and your changes will be reflected within seconds! Be it 10, 1000 or 100000+ records, the bulk edit operation will be successful without errors.

Bulk edit using search filters

Smart Manager also provides you the flexibility to bulk edit based on simple and advanced search filters.

Smart Manager advanced search

In the above example, you have thousands of products but need to bulk edit only some products based on the conditions.

So, on the Smart Manager dashboard, click on the Advanced Search toggle. It will open up a slide-over panel. Enter your conditions and click on Search.

Your selected products will be shown. Now, perform bulk edit operation as explained earlier.

Try Smart Manager Live Demo

Benefits of using Smart Manager’s bulk edit feature

  • Helps you save your time and effort on manually editing each product.
  • Eliminates the risk of human errors and miscalculations as numbers are involved
  • Reduces the risk of missing out on any record while making an update
  • Gives the simplest store management people always wish for
  • Makes your life easy

More benefits of using Smart Manager

  • Inline edit: Make multiple changes directly in the spreadsheet and save it all at a tap. No need to go through each entry one-by-one.
  • Quick & easy export CSV: Export the data as per your requirements – entire store or based on date, search and column filters.
  • Duplicate : Easily make a copy of selected records or all the existing records for any post type.
  • Robust search: Our simple and advanced search feature will help you find what you need within seconds!
  • Add & Delete: Easily add or remove data rows as per requirements. You can also bulk delete WooCommerce products.
  • Column management: Sort data in ascending or descending order, show or hide data columns you like to deal with.

Get Smart Manager plugin

Eight applications where bulk edit is a boon

Listed below are some of the widely use cases that can make your work-life simpler and easier at a very gradual effort! There may be countless use cases and Smart Manager will prove the perfect plugin for that.

Increase / decrease prices by a set percentage (%) or value ($)

It’s the biggest sales season of the year – Black Friday and Cyber Monday. You don’t want to leave any stone unturned to earn maximum revenue.

To make this quick, you offer a flat discount of 30% on all your products – which includes variations as well. Your product inventory says you have 3600 products.

Imagine doing this manually.

Oh sorry!! Why imagine when you have Smart Manager?

Use Smart Manager’s Bulk Edit /Batch Update feature and get this done within minutes!

Modify sale price based on the regular price

Imagine you are a grocery store owner. Now, due to inflation, seasonal changes, and demand, the prices of commodities like fruits and vegetables keep fluctuating and you have to be quick.

Say, you need to up the sale price by 20% compared to the regular price for 10 days. For the next corresponding 10 days, reduce the sale price down by 15%.

Editing prices and managing stock of perishable items is a tedious task.
But with StoreApps Smart Manager bulk edit feature, you can save your company’s cost and effort to a high level in this case.

Update inventory for simple products within a product category

The rainy season is lined up in a month and you need to add stock of ponchos, dri-fit pants, rain-cover for bags, etc. beforehand.

Assume your product category is ‘Rainwear’ and you want to increase the inventory of all products falling into this category by 200 units.

Simply, search for product category using Smart Manager and all your products will be listed belonging to Rainwear. Select all items in the search result by checking the ‘header checkbox’, increase stock by 200 and it will be reflected in all the products.

Bulk edit sale price of all variation products within a product category

There’s a huge competition in the smartphone market; say in the $200-$250 range.

And you have three phones with nine variations falling into this segment.

Since you see a downfall in sales, you want to attract customers by offering a discount on top-selling variants.

Switch to Smart Manager and you can get this done within minutes, saving cost and being real-time!

Update description and SEO ‘Noindex’ status of multiple blog posts

Pruning old, non-performing blog post can result in more qualified traffic as your website get a higher rank in Google.

So, instead of going through each post-one-by-one and non-indexing them, simply search and select those blog posts, add a description as ‘Poor performing post’ and ‘Deindex’ them using Smart Manager.

Increase coupon limit for purchasers between a particular date range

Customers may not continue the subscription or may not purchase from you the second time. But you can at least try to nudge them to renew or buy again.

For this, you can select specific customers who made a purchase one year ago using a coupon, say a 15% off.

So, simply select all these users and extend their coupon usage to two or three times further.

Btw…no need to manually do this one-by-one. Smart Manager will get this done for you.

Update subscription statuses in bulk

We know some customers keep on using the free-trial and ask to extend. But in the end, they don’t convert even if you try your best.

You want to cancel/suspend subscriptions of these customers (say twenty in number) who have taken the free plan from March 2021 to April 2021 and haven’t migrated to the paid plan.

Manually doing this sounds painful, right? Smart Manager’s bulk edit feature makes this process a no-brainer!

Update order statuses

Let’s say, during the sale period, you launched a new product and offered ‘Free Shipping’ on the first 100 orders.

Now, orders are shipped and you want to update the statuses of these 100 orders from ‘Shipping Pending’ to ‘Shipped’.

As usual, use the bulk edit feature to do it quickly.

Your turn to reap Smart Manager benefits

Bulk edit, one-page store management, excel-like spreadsheet, compatibility…what more do you need? Smart Manager is a complete package.

9+ years into business and Smart Manager continues to be a popular and reliable plugin for tons of WooCommerce users. It’s a promise, you won’t be disappointed.

Get Smart Manager now

2 thoughts on “How to Bulk Edit WooCommerce Products, Orders, WordPress Post Types?

  1. Hello,

    Can I update orders line items using SM? I actually deliver milk. Some customer take milk day by day and some take more / less quantity than per-ordered. Ours is post payment system.

    Srinivas

    1. Currently, this is not possible with the Smart Manager. However, we do have plans to add this functionality in Smart Manager.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.