How to update product cost in WooCommerce by exporting and importing all products

Follow the steps below to update product cost in WooCommerce by exporting, updating and importing all products.

1. Export Products from WooCommerce
2. Update the cost prices of each item
3. Import Products in WooCommerce

Part 1: Export Products from WooCommerce

1. Login to WooCommerce

2. Click "Products"
   
   

3. Click "All Products"
   

4. Click "Export"
   
   
5. Select ID and SKU under "Which columns should be exported"
   
6. Under "Export custom meta?" check "Yes, export all custom meta" 
   
7. Click "Generate CSV"
   
8. Open the downloaded file in a spreadsheet and remove/delete all columns except ID, SKU, Meta: _cost_price and Meta: _cost_price_variation
   

Part 2: Update the cost prices of each item

For simplicity, we recommend updating both "Meta: _cost_price" and "Meta: _cost_price_variation" with the same cost value. This saves you the time and hassle of having to identify which products are variations and which are not.
If you need to combine data from WooCoomerce with data from another system you can use the VLOOKUP formula to combine the data.

Once you are done, export your file as a new csv.

Part 3: Import Products in WooCommerce

1. Click "Products"
   
2. Click "All Products"
   
3. Click "Import"
   
4. Click "Select file" and select the CSV file you just created
   
5. Under "Update existing products" check "Existing products that match by ID or SKU will be updated. Products that do not exist will be skipped"
   
   
6. Click "Continue"
   
7. Check the Column name and Map to field match and click "Run the importer"