WooCommerce – Import Cost of Goods and Product Prices Quickly

In a previous post, we showed you how to export the cost of goods and product prices to a CSV file that you can edit with Excel, Google Sheets, or any other spreadsheet editor software out there. Here, we’ll show you how to import the cost of goods and product prices quickly.

We’re using the WooCommerce Products Spreadsheet plugin, which allows you to:

• Apply changes in bulk to thousands of products
• Do advanced searches using any product fields as search parameters
• Export products with a few clicks
• And even create or update hundreds of products by importing the information from a CSV file.

Therefore, if you already applied the changes you needed, you can easily import the cost of goods and product prices for thousands of products using a CSV file edited with Excel or Google Sheets. Just follow these steps:

Step 1. Open the products spreadsheet

You need to open the products spreadsheet. For that, go to WP Sheet Editor > Edit Products.

You’ll see all your products with their complete information displayed in the spreadsheet. It’s important to keep in mind that every product is a row and every field is a column. You can see the Wc Cog Cost column in the spreadsheet. It stands for the Cost of Goods field.

Step 2. Open the Import tool with one click

After opening the products spreadsheet, you need to open the Import tool with one click on the top toolbar.

Step 3. Select the file you’ll import

After opening the Import tool, you need to select the file you’ll import. Select these values:

• Source: CSV file from my computer
• CSV file: Click Choose File and open the file from your computer.
• Click Next to go on.

Step 4. Configure the import of cost of goods and product prices

After selecting the file you’ll import, you need to configure the import. For that, we recommend the following values:

• Click Import all the 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.

Step 5. Finish the import

Finally, you’ll see a preview of how the cost of goods and product prices will look on the spreadsheet. If everything is right, click The preview is fine, start import.

Done! The cost of goods and product prices will be added to your products.

That was really simple!

As you can see, importing cost of goods and product prices is no problem for the WooCommerce Products Spreadsheet plugin. You can definitely forget about editing products one by one. If you don’t have an internet connection, you can still edit the cost of goods and product prices (and any information). Once you have an internet connection again, you just need to import the products following the steps in this tutorial, and everything will be done quickly.

You can also read:

• WooCommerce – How to Bulk Edit the Cost of Goods