---
title: How to prepare a Google Sheet to manually update cost prices in ProfitMetrics for Shopify websites
description: Follow this guide to merge ProfitMetrics cost exports and Shopify Product exports to update cost prices in ProfitMetrics for Shopify Websites
---
[Skip to content](https://knowledge.profitmetrics.io/how-to-prepare-a-google-sheet-to-manually-update-cost-prices-in-profitmetrics-for-shopify-websites#main-content)
[](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. [Shopify](https://knowledge.profitmetrics.io/e-commerce-platforms?hsLang=en#shopify)
# How to prepare a Google Sheet to manually update cost prices in ProfitMetrics for Shopify websites
## Follow this guide to merge ProfitMetrics cost exports and Shopify Product exports to update cost prices in ProfitMetrics for Shopify Websites
---
[Step 1: Export from Shopify](https://knowledge.profitmetrics.io/how-to-prepare-a-google-sheet-to-manually-update-cost-prices-in-profitmetrics-for-shopify-websites#step1)
[Step 2: Export from ProfitMetrics](https://knowledge.profitmetrics.io/how-to-prepare-a-google-sheet-to-manually-update-cost-prices-in-profitmetrics-for-shopify-websites#step2)
[Step 3: Add Exports to Google Sheet](https://knowledge.profitmetrics.io/how-to-prepare-a-google-sheet-to-manually-update-cost-prices-in-profitmetrics-for-shopify-websites#step3)
[Step 4: Prepare sheet and Complete vlookup](https://knowledge.profitmetrics.io/how-to-prepare-a-google-sheet-to-manually-update-cost-prices-in-profitmetrics-for-shopify-websites#Step4)
---
Updating cost prices in ProfitMetrics for Shopify is best done directly in Shopify, but sometimes, a CSV with cost prices may need to be manually uploaded.
This can become complicated because Shopify doesn't use variant ID as the primary Product identifier.
---
### Step 1: Export from Shopify
If you already have Matrixify app installed, you can [follow this guide](https://knowledge.profitmetrics.io/how-to-export-products-with-id-in-shopify?hsLang=en) to export from Shopify with costs and variant IDs.
If you don't have Matrixify and don't want to install it, please follow the steps below to manually sync exports between Shopify and ProfitMetrics.
1. Login to [https://admin.shopify.com](https://admin.shopify.com)
2. Click **Products**, then "**Export"**:
-png.jpeg?width=860&height=681&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%202%20(3)-png.jpeg)
3. Select "**All Products"**
-png.jpeg?width=688&height=522&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%204%20(1)-png.jpeg)
4. Select "**Plain CSV file"**
-png.jpeg?width=688&height=513&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%203%20(1)-png.jpeg)
5. Click "**Export Products" and save the CSV file.**
### Step 2: Export from ProfitMetrics
1. Log in to [https://my.profitmetrics.io/](https://my.profitmetrics.io/)
2. Click Products
3. Click **Cost Prices
**
4. Click all checkboxes: **Include titles, Include external\_sku, and Include sales price**. If you want to update only products with no cost price, leave '**Only those with missing purchase price**' checked. If you want to change existing product costs as well, uncheck that box.
5. Click **Submit
**
6. **A CSV file will be downloaded to your computer**
### Step 3: Add Exports to Google Sheet
Next we will import both exported csv files into different tabs in a Google sheet
1. Open a new tab and go to [https://sheets.new](https://sheets.new)
2. Click "**File**" \> "**Import**"
-png.jpeg?width=688&height=385&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%209%20(1)-png.jpeg)
3. Click "**Upload**"
-png.jpeg?width=688&height=385&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%2010%20(1)-png.jpeg)
4. Browse or drag and drop your Shopify Export file to the "**Browse**" area:
-png.jpeg?width=688&height=385&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%2017%20(1)-png.jpeg)
5. Select "**Replace Spreadsheet**"
.png?width=688&height=385&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%2019%20(1).png)
6. Click "**Import Data**"
.png?width=688&height=385&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%2022%20(1).png)
7. Right click "**Sheet 1**" at the bottom of the sheet and click "**Rename**"
.png?width=688&height=435&name=Export%20Products%20from%20Shopify%20to%20Google%20Sheets%20-%20Step%2027%20(2).png)
8. Set name to "**Shopify Export**"
9. Click + to add another tab, then follow the step above to rename that to **ProfitMetrics**.
10. Repeat steps 2-6 to import your ProfitMetrics csv
### Step 4: Prepare sheet and Complete vlookup
1. Go to **Shopify Export** tab and move column '**Variant SKU**' to Column 1
2. Go to **ProfitMetrics** tab. Select cell G1 and enter the name "**Variant SKU**"
3. Go to cell G2 and enter this formula:
=VLOOKUP(D2, 'Shopify Export'!A:B, 2,false)
4. Select cell G2 and copy it (cmd+c or ctrl+c)
5. Highlight the remaining cells in column G and paste the formula (cmd+v or ctrl+v)
6. Add costs to **price\_buy** manually, or perform a vlookup based on suppliers csv to add price\_buy/cost information.
7. When you are done, columns A and B are the only columns necessary to import costs into ProfitMetrics \> Products \> [Cost Prices](https://my.profitmetrics.io/customer/products_pricebuyio.php).
- [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)
[](https://profitmetrics.io)
[mailto:support@profitmetrics.io](mailto:support@profitmetrics.io)
Copyright © 2026, ProfitMetrics ApS