WooCommerce – How to Bulk Edit the Cost of Goods

Learn with us how to bulk edit the cost of goods field for hundreds of WooCommerce products easily.

With WooCommerce Cost of Goods, you can easily track the profit and revenue from your products and variations.

However, it can be really difficult when you first install it and have to edit thousands of products to add the cost of goods.

You can spend lots of hours opening and editing each product with its variations.

That’s why we want to show you the easiest way to bulk update the cost of goods field for hundreds of WooCommerce products with a few clicks.

You won’t have to open and edit the products one by one.

Instead, you’ll save a lot of time because you’ll learn how to:

1. Set the cost of goods in a spreadsheet
2. Search for products based on cost
3. Bulk change cost of goods quickly

We’ll do this with the WooCommerce Products Spreadsheet plugin.

It allows you to bulk edit products using an intuitive spreadsheet inside WordPress. These are some of the things you can do with this plugin:

• Bulk modify any field of your products
• Search for products using any field as a parameter (price, date, category, attribute, tag, shipping class, weight, total sales, etc.)
• Export the products to a CSV file
• Import new products and changes to existing products using CSV files
• Massively edit product variations
• Create variations faster
• Copy variations and attributes between products
• And lots of more things.

Once you install and activate the plugin, you need to follow the steps in the sections below to learn how to massively edit the Cost of goods field in hundreds of products easily.

1- How to set the cost of goods in a spreadsheet

First, we want to show you how to easily set the cost of goods for hundreds of products using the products’ spreadsheet.

You don’t have to open the products and edit them one by one.

You just need to open the spreadsheet under WP Sheet Editor > Edit Products.

Once there, you need to locate the Wc Cog Cost column, which stands for the Cost field.

Tips

• If you don’t find the column in the spreadsheet, go to Settings > Scan DB to find fields. You just need to hover over the Settings field in the top toolbar.
• If you want to display product variations to update the “cost of goods” field, you need to click Display variations on the toolbar, and the plugin will display the variations next to the main products.

Finally, click Save to apply the changes to all the products.

You can save lots of clicks and server resources.

You just save changes once and edit lots of products with a few clicks.

2- How to search for products based on the cost of goods

You can use the Cost of Goods field as a search parameter to find your products.

For example, you can search for all products whose cost of goods is 20 dollars or less.

You can also search for all products whose cost of goods is exactly 20 dollars, or a higher amount.

As an example, we’ll search for all the products whose cost of goods is 20 dollars or less.

You just need to open the Search tool with one click on the toolbar.

Now, click the Enable advanced filters checkbox and select these values:

• Field: Wc Cog Cost
• Operator: <=
• Value: 20
• Click Run Search.

Once you click the Run Search button, all the products that meet the search parameters will be displayed in the spreadsheet. This is how you can easily search for WooCommerce products based on the cost of goods. You can use an exact amount or equal or less/equal or higher values.

3- How to bulk edit the cost of goods for hundreds of products at once

Besides being able to save lots of time using the spreadsheet to edit the cost of goods for hundreds of products, you can massively edit this field.

We’ll bulk edit the search results from the previous section.

We need to open the Bulk Edit tool with one click.

Once there, select the following values to set the same cost of goods to all our selected products:

• Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
• What field do you want to edit: Wc Cog Cost
• Select type of edit: Set value
• Replace existing value with this value: 25, for example.
• Click Execute Now.

Once you set these values, all the products that you searched will have a new value in the cost of goods field.

This is how you can quickly bulk edit the cost of goods for hundreds of products.

Of course, you could have searched for your products by keyword, category, attribute, date, price, tag, etc., and apply the same values.

You can edit your products using any parameter. You can even edit all products.

As you see, you can bulk edit the cost of goods field for hundreds or even thousands of WooCommerce products easily.

You don’t have to use any snippets. You just need to open the spreadsheet and start editing big numbers of products.

The best part, your server won’t have problems because the plugin applies the changes in batches to give your server some rest.

You can also read:

• WooCommerce – How to Export Cost of Goods and Prices to CSV
• WooCommerce – Import Cost of Goods and Product Prices Quickly