--- title: How to manually update cost prices in Profitmetrics description: There are two ways to update cost prices in ProfitMetrics. You can either edit the cost price manually or update the cost prices using a CSV file. --- [Skip to content](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#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. [Product Feed & Costs](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en) 3. [Product Feed](https://knowledge.profitmetrics.io/product-feed-costs?hsLang=en#product-feed) # How to manually update cost prices in Profitmetrics ## There are two ways to update cost prices in ProfitMetrics. You can either edit the cost price manually or update the cost prices using a CSV file. [Part 1: How to deactivate the automatic import](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#part1) [Part 2: How to update cost prices manually](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#part2) [Part 3: How to update cost prices using a CSV file](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#part3) --- ### [Part 1: How to deactivate the automatic import](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#part1) *IMPORTANT: This is required to ensure any manual changes are not overwritten by the automatic import. This means that new products will no longer be imported automatically and cost prices will no longer update.* 1. Navigate to **Products \> Product feed ![A Guide to Importing and Exporting Products - Step 50 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2050%20(1).png?width=655&height=366&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2050%20(1).png)** 2. Under "Automatic Import Interval" select **Disable  ![A Guide to Importing and Exporting Products - Step 51](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2051.png?width=655&height=366&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2051.png)** 3. Click **Save Feed Configuration ![A Guide to Importing and Exporting Products - Step 51 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2051%20(1).png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2051%20(1).png)** 4. Click **OK ![A Guide to Importing and Exporting Products - Step 52](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2052.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2052.png)** **Done** --- ### [Part 2: How to update cost prices manually](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#part2) *IMPORTANT NOTE: Please deactivate* the automatic import before you continue. 1. Login to [https://my.profitmetrics.io/](https://my.profitmetrics.io/) 2. If you have multiple websites, ensure you are on the correct website by clicking **"Site:"** at the top of the screen. 3. Navigate back to **Products ![A Guide to Importing and Exporting Products - Step 51 (2)](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2051%20(2).png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2051%20(2).png)** 4. Click the Cost Price of the product you wish to update ![A Guide to Importing and Exporting Products - Step 4 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%204%20(1).png?width=655&height=366&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%204%20(1).png) 5. Type the new Cost Price in the field and click anywhere or hit Enter on your keyboard. ![A Guide to Importing and Exporting Products - Step 9 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%209%20(1).png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%209%20(1).png) 6. Repeat for each product you wish to update --- ### [Part 3: How to update cost prices using a CSV file](https://knowledge.profitmetrics.io/how-to-manually-update-cost-prices-in-profitmetrics#part3) *IMPORTANT NOTE: Please deactivate* the automatic import before you continue. 1. Navigate to **Products \> Cost Prices ![A Guide to Importing and Exporting Products - Step 53](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2053.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2053.png)** 2. Uncheck **"Only those missing cost price"** if you want to export all products Check **"Include external\_sku"** if your feed contains an additioanl id needed to identify each product/variant ![A Guide to Importing and Exporting Products - Step 57](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2057.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2057.png) 3. Click **Submit ![A Guide to Importing and Exporting Products - Step 58](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2058.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2058.png)** 4. Go to [https://sheets.google.com](https://sheets.google.com) **(Recommended)** or use any other spreadsheet software you prefer. 5. Click **Blank spreadsheet** ![A Guide to Importing and Exporting Products - Step 60](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2060.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2060.png) 6. Navigate to **File \> Import** ![A Guide to Importing and Exporting Products - Step 62](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2062.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2062.png) 7. Click **Upload** ![A Guide to Importing and Exporting Products - Step 65](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2065.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2065.png) 8. Click **Browse** and select the file you just downloaded ![A Guide to Importing and Exporting Products - Step 65 (1)](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2065%20(1).png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2065%20(1).png) 9. Click **Import data** ![A Guide to Importing and Exporting Products - Step 66](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2066.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2066.png) 10. Edit the Cost prices in the **"price\_buy"** column SKU: Please note that while column A is named 'sku', the values here are the variant IDs from your product feed. If you put the sku values here instead of the ID, the import will fail.   ![A Guide to Importing and Exporting Products - Step 77](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2077.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2077.png)   1. Navigate to **File \> Download \> Comma Separated Values (CSV)** and download the updated CSV file. ![A Guide to Importing and Exporting Products - Step 82](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2082.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2082.png) 2. In ProfitMetrics, ensure you are on the **Products \> Cost Price** page, click **Select File**,and select the updated CSV file you just created. **![A Guide to Importing and Exporting Products - Step 83](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2083.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2083.png)** 3. **(OPTIONAL)** Select the currency of the Cost Prices you are importing, If the cost prices are in a different currency then the website they are uploaded to. ProfitMetrics will automatically do the currency conversion at the time of import. ![A Guide to Importing and Exporting Products - Step 84](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2084.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2084.png) 4. Click **Submit ![A Guide to Importing and Exporting Products - Step 85](https://knowledge.profitmetrics.io/hs-fs/hubfs/A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2085.png?width=670&height=375&name=A%20Guide%20to%20Importing%20and%20Exporting%20Products%20-%20Step%2085.png)**Done. - [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