WooCommerce – Import Cost of Goods and Product Prices Quickly

In a previous guide, we covered how to export WooCommerce cost of goods and product prices to a CSV file so you can edit them outside of WordPress using Excel, Google Sheets, or any other spreadsheet application. This tutorial picks up where that one left off and shows you how to import the updated cost of goods and product prices back into WooCommerce.

If you manage a store with hundreds or thousands of products, updating cost of goods and prices directly inside the WooCommerce product editor is slow and impractical. The typical workflow involves opening each product individually, locating the correct field, entering the new value, saving, and repeating the same process across every SKU. Exporting your data to a spreadsheet, making your edits, and then importing the updated file is a much more practical approach.

To do this, we’ll use the WP Sheet Editor – WooCommerce Products plugin. It gives you a spreadsheet interface inside your WordPress dashboard where you can:

• Apply changes in bulk to thousands of products at the same time
• Run advanced searches using any product field as a filter
• Export product data to CSV with a few clicks
• Import updated product data, including cost of goods and prices, from a CSV file edited in Excel or Google Sheets

Once you have edited your CSV file with the updated cost of goods and product prices, follow the steps below to import the data back into WooCommerce.

Step 1. Open the Products Spreadsheet

Start by opening the products spreadsheet. Go to WP Sheet Editor > Edit Products in your WordPress dashboard.

The spreadsheet will load all your WooCommerce products in a grid layout. Each row represents a single product and each column represents a product field.

You’ll notice the Wc Cog Cost column in the spreadsheet. This column corresponds to the Cost of Goods field managed by the WooCommerce Cost of Goods plugin. This is the field you’ll be updating through the import.

Step 2. Open the Import Tool

With the products spreadsheet open, locate the top toolbar and click the Import button. This will open the import panel where you can configure and run your CSV import.

The Import tool supports CSV files containing any combination of product fields, including the Wc Cog Cost field for cost of goods, as well as the Regular price and Sale price columns. You can import one field or all fields at once depending on your needs.

Step 3. Select the CSV File to Import

The first screen inside the Import tool asks you to specify the file source. Configure the following settings:

• Source: CSV file from my computer
• CSV file: Click Choose File and select your updated CSV file from your computer.
• Click Next to proceed to the configuration step.

Make sure the CSV file you’re uploading uses the same column headers that were present when you originally exported from WP Sheet Editor. This ensures the importer can correctly match each CSV column to the right product field in WooCommerce.

Step 4. Configure the Import Settings

After selecting your file, you’ll reach the import configuration screen. This is where you tell the plugin which columns to import and how to match the imported rows to your existing products.

Use the following recommended settings:

• Click Import all the columns to include every field from your CSV, including the cost of goods and price columns.

• Do you want to update or create items: Create new items and update existing items
• CSV Field: record_id
• WordPress Field: ID
• Click Next to continue.

Using record_id as the CSV field and ID as the WordPress field tells the importer to match each row in the CSV to an existing product by its WordPress post ID. This prevents duplicate products from being created and ensures that cost of goods and price updates are applied to the correct existing records.

If you only need to update specific fields, such as Wc Cog Cost and Regular price, you can deselect the other columns in the column mapping screen rather than importing all columns.

Step 5. Preview and Run the Import

Before the import runs, the plugin displays a preview of how the data from your CSV will look in the spreadsheet. Review this preview to confirm that the cost of goods values and product prices are mapped to the correct columns.

If everything looks accurate, click The preview is fine, start import to run the import.

The plugin will process your CSV file and update each matched product with the new cost of goods and price values. Once the process finishes, you can reload the spreadsheet to verify the updated Wc Cog Cost, Regular price, and Sale price columns.

Working Offline with Exported Data

One practical advantage of this export-then-import workflow is that it works in offline scenarios. If your team needs to update cost of goods or prices without an active internet connection, for example while reviewing a supplier’s updated pricing sheet, you can edit the CSV file locally in Excel or Google Sheets and then import it into WooCommerce once connectivity is restored.

Keeping the CSV file also gives you a record of price and cost changes over time, which can be useful for cost auditing and margin analysis.

Done!

Importing cost of goods and product prices into WooCommerce from a CSV file follows a five-step process with WP Sheet Editor – WooCommerce Products: open the spreadsheet, open the Import tool, select your file, configure the column and ID matching settings, and run the import after reviewing the preview. Whether you’re updating a handful of products or a large catalog, this method avoids the need to open and edit each product individually inside the standard WooCommerce editor.

You can also read:

• WooCommerce – How to Bulk Edit the Cost of Goods