--- title: How to update product cost in WooCommerce by exporting and importing all products description: Follow the steps below to update product cost in WooCommerce by exporting, updating and importing all products. --- [Skip to content](https://knowledge.profitmetrics.io/how-to-update-product-cost-in-woocommerce-by-exporting-and-importing-all-products#main-content) [![ProfitMetrics logo black version](https://knowledge.profitmetrics.io/hs-fs/hubfs/pm_logotype_blue.png?width=193&height=28&name=pm_logotype_blue.png)](https://knowledge.profitmetrics.io/?hsLang=en) Open main navigation Close main navigation - [Contact Support](https://knowledge.profitmetrics.io/kb-ticket/new) [Contact Support](https://knowledge.profitmetrics.io/kb-ticket/new?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge base](https://knowledge.profitmetrics.io/?hsLang=en) 2. [E-commerce Platforms](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en) 3. [WooCommerce](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#woocommerce) # 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. NOTE: This guide assumes you use the default cost-price field generated by the ProfitMetrics plugin. If you are using a different field to manage your cost price read this guide instead: LINK PENDING --- 1. [Export Products from WooCommerce](https://knowledge.profitmetrics.io/how-to-update-product-cost-in-woocommerce-by-exporting-and-importing-all-products#part1) 2. [Update the cost prices of each item](https://knowledge.profitmetrics.io/how-to-update-product-cost-in-woocommerce-by-exporting-and-importing-all-products#part2) 3. [Import Products in WooCommerce](https://knowledge.profitmetrics.io/how-to-update-product-cost-in-woocommerce-by-exporting-and-importing-all-products#part3) ### Part 1: Export Products from WooCommerce 1. Login to WooCommerce 2. Click **"Products" ![Exporting and Importing Products Data into Google Sheets - Step 3](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%203.png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%203.png)** 3. Click **"All Products"** ![Exporting and Importing Products Data into Google Sheets - Step 4 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%204%20(1).png?width=655&height=366&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%204%20(1).png) 4. Click **"Export" ![Exporting and Importing Products Data into Google Sheets - Step 5](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%205.png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%205.png)** 5. Select **ID** and **SKU** under "Which columns should be exported" ![Exporting and Importing Products Data into Google Sheets - Step 10](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%2010.png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%2010.png) 6. Under "Export custom meta?" check **"Yes, export all custom meta"**  ![Exporting and Importing Products Data into Google Sheets - Step 20](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%2020.png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%2020.png) 7. Click **"Generate CSV"** ![Exporting and Importing Products Data into Google Sheets - Step 22](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%2022.png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%2022.png) 8. Open the downloaded file in a spreadsheet and remove/delete all columns except **ID, SKU, Meta: \_cost\_price** and **Meta: \_cost\_price\_variation ![Skærmbillede 2024-03-19 kl. 20.17.46](https://knowledge.profitmetrics.io/hs-fs/hubfs/Sk%C3%A6rmbillede%202024-03-19%20kl.%2020.17.46.png?width=688&height=412&name=Sk%C3%A6rmbillede%202024-03-19%20kl.%2020.17.46.png)** ### Part 2: Update the cost prices of each item TIP: We recommend using Google Sheets 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. ![Skærmbillede 2024-03-19 kl. 20.37.14](https://knowledge.profitmetrics.io/hs-fs/hubfs/Sk%C3%A6rmbillede%202024-03-19%20kl.%2020.37.14.png?width=688&height=426&name=Sk%C3%A6rmbillede%202024-03-19%20kl.%2020.37.14.png) Once you are done, export your file as a new csv. ### Part 3: Import Products in WooCommerce 1. Click **"Products"** ![Exporting and Importing Products Data into Google Sheets - Step 3](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%203.png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%203.png) 2. Click **"All Products"** ![Exporting and Importing Products Data into Google Sheets - Step 4 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%204%20(1).png?width=688&height=385&name=Exporting%20and%20Importing%20Products%20Data%20into%20Google%20Sheets%20-%20Step%204%20(1).png) 3. Click "Import" ![Importing and Updating Products from CSV in WooCommerce - Step 3](https://knowledge.profitmetrics.io/hs-fs/hubfs/Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%203.png?width=688&height=385&name=Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%203.png) 4. Click **"Select file"** and select the CSV file you just created ![Importing and Updating Products from CSV in WooCommerce - Step 4](https://knowledge.profitmetrics.io/hs-fs/hubfs/Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%204.png?width=688&height=385&name=Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%204.png) 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" ![Importing and Updating Products from CSV in WooCommerce - Step 6](https://knowledge.profitmetrics.io/hs-fs/hubfs/Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%206.png?width=688&height=385&name=Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%206.png)** 6. Click **"Continue"** ![Importing and Updating Products from CSV in WooCommerce - Step 6 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%206%20(1).png?width=688&height=385&name=Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%206%20(1).png) 7. Check the **Column name** and **Map to field** match and click **"Run the importer" ![Importing and Updating Products from CSV in WooCommerce - Step 7](https://knowledge.profitmetrics.io/hs-fs/hubfs/Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%207.png?width=688&height=385&name=Importing%20and%20Updating%20Products%20from%20CSV%20in%20WooCommerce%20-%20Step%207.png)** **Thats it.** The cost prices are now being updated.   - [Getting Started](https://knowledge.profitmetrics.io/getting-started?hsLang=en#main-content) - [Learn the Basics](https://knowledge.profitmetrics.io/getting-started?hsLang=en#learn-the-basics) - [Prepare for Onboarding](https://knowledge.profitmetrics.io/getting-started?hsLang=en#prepare-for-onboarding) - [Account Setup](https://knowledge.profitmetrics.io/getting-started?hsLang=en#account-setup) - [E-commerce Platforms](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#main-content) - [Shopify](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#shopify) - [WooCommerce](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#woocommerce) - [Magento](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#magento) - [PrestaShop](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#prestashop) - [BigCommerce](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#bigcommerce) - [Shopware](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#shopware) - [DanDomain & Related](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#dandomain-related) - [Universal Integration (Clientside)](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#universal-integration-clientside) - [Universal Integration (Server-side Hybrid)](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#universal-integration-server-side-hybrid) - [Other Platforms](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#other-platforms) - [Developer Documentation](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#developer-documentation) - [Ad Channels](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#main-content) - [Google Ads](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#google-ads) - [Meta (Facebook/Instagram)](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#meta-facebook-instagram) - [Microsoft Bing Ads](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#microsoft-bing-ads) - [Google Analytics 4](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#google-analytics-4) - [Partner-ads](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#partner-ads) - [Other Channel Configuration](https://knowledge.profitmetrics.io/ad-channels?hsLang=en#other-channel-configuration) - [Tracking & Conversion Setup](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#main-content) - [Overview](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#overview) - [Conversion Booster for Google Ads](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#conversion-booster-for-google-ads) - [Conversion Booster for Meta](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#conversion-booster-for-meta) - [Conversion Booster Custom Pixels](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#conversion-booster-custom-pixels) - [Enhanced Conversions](https://knowledge.profitmetrics.io/tracking-conversion-setup?hsLang=en#enhanced-conversions) - [Shopping Booster](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#main-content) - [Overview & Setup](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#overview-setup) - [Supplemental Feeds](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#supplemental-feeds) - [Campaigns & Labels](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#campaigns-labels) - [Troubleshooting](https://knowledge.profitmetrics.io/shopping-booster?hsLang=en#troubleshooting) - [Product Feed & Costs](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#main-content) - [Product Feed](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#product-feed) - [Shipping & Payment Costs](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#shipping-payment-costs) - [Expenses](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#expenses) - [Dashboard, Orders & Reporting](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#main-content) - [Dashboard & Orders](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#dashboard-orders) - [Looker Studio](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#looker-studio) - [Google BigQuery](https://knowledge.profitmetrics.io/dashboard-orders-reporting?hsLang=en#google-bigquery) - [Account & Billing](https://knowledge.profitmetrics.io/account-billing?hsLang=en#main-content) - [Users & Access](https://knowledge.profitmetrics.io/account-billing?hsLang=en#users-access) - [Billing & Invoices](https://knowledge.profitmetrics.io/account-billing?hsLang=en#billing-invoices) - [Privacy & Consent](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#main-content) - [GDPR](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#gdpr) - [Consent Management Platforms](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#consent-management-platforms) - [Google Consent Mode](https://knowledge.profitmetrics.io/privacy-consent?hsLang=en#google-consent-mode) - [For Agencies](https://knowledge.profitmetrics.io/for-agencies?hsLang=en#main-content) - [Getting Started as an Agency](https://knowledge.profitmetrics.io/for-agencies?hsLang=en#getting-started-as-an-agency) - [Agency Certification](https://knowledge.profitmetrics.io/for-agencies?hsLang=en#agency-certification) - [Shopify](https://knowledge.profitmetrics.io/shopify?hsLang=en) - [PrestaShop](https://knowledge.profitmetrics.io/prestashop?hsLang=en) - [Google Ads](https://knowledge.profitmetrics.io/google-ads?hsLang=en#main-content) - [troubleshoot](https://knowledge.profitmetrics.io/google-ads?hsLang=en#troubleshoot) - [Meta (Facebook / Instagram)](https://knowledge.profitmetrics.io/meta-facebook-instagram?hsLang=en) - [Uncategorized](https://knowledge.profitmetrics.io/uncategorized?hsLang=en) - [Billing](https://knowledge.profitmetrics.io/billing?hsLang=en) - [Google Sheets](https://knowledge.profitmetrics.io/google-sheets?hsLang=en) - [Account](https://knowledge.profitmetrics.io/account?hsLang=en) - [Ideal Shop](https://knowledge.profitmetrics.io/ideal-shop?hsLang=en) [![ProfitMetrics logo black version](https://knowledge.profitmetrics.io/hs-fs/hubfs/pm_logotype_blue.png?width=193&height=28&name=pm_logotype_blue.png "ProfitMetrics logo black version")](https://profitmetrics.io) [mailto:support@profitmetrics.io](mailto:support@profitmetrics.io) Copyright © 2026, ProfitMetrics ApS