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.

How to deactivate the automatic import

How to update cost prices manually

How to update cost prices using a CSV file

How to deactivate the automatic import

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
   
2. Under "Automatic Import Interval" select Disable 
   
   
3. Click Save Feed Configuration
   
4. Click OK
   

Done

How to update cost prices manually

IMPORTANT NOTE: Please deactivate the automatic import before you continue.

1. Login to 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
   
   
4. Click the Cost Price of the product you wish to update
   
5. Type the new Cost Price in the field and click anywhere or hit Enter on your keyboard.
   
6. Repeat for each product you wish to update

How to update cost prices using a CSV file

IMPORTANT NOTE: Please deactivate the automatic import before you continue.

1. Navigate to Products > Cost Prices
   
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
   
3. Click Submit
   
   
4. Go to https://sheets.google.com (Recommended) or use any other spreadsheet software you prefer.
5. Click Blank spreadsheet
   
6. Navigate to File > Import
   
7. Click Upload
   
8. Click Browse and select the file you just downloaded
   
9. Click Import data
   
10. Edit the Cost prices in the "price_buy" column
    
11. Navigate to File > Download > Comma Separated Values (CSV) and download the updated CSV file.
    
12. In ProfitMetrics, ensure you are on the Products > Cost Price page, click Select File, and select the updated CSV file you just created.
    
    
13. (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.
    
14. Click Submit
    

Done.