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

Step 2: Export from ProfitMetrics

Step 3: Add Exports to Google Sheet

Step 4: Prepare sheet and Complete vlookup 

---

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

1. Login to https://admin.shopify.com 
2. Click Products, then "Export":
   
3. Select "All Products"
   
4. Select "Plain CSV file"
   
5. Click "Export Products" and save the CSV file.

Step 2: Export from ProfitMetrics

1. Log in to 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
2. Click "File" > "Import"
   
3. Click "Upload"
   
4. Browse or drag and drop your Shopify Export file to the "Browse" area:
   
5. Select "Replace Spreadsheet"
   
6. Click "Import Data"
   
7. Right click "Sheet 1" at the bottom of the sheet and click "Rename"
   
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.