Skip to content
English
  • There are no suggestions because the search field is empty.

How to manually update Product cost for WooCommerce

Follow the guide below to manually update Product cost in WooCommerce or ProfitMetrics

Part 1: Make a copy of our template for WooCommerce

Part 2: Export products from Woocommerce and import them to Google Sheets

Part 3: Import SKU + Product cost in Google sheets

Part 4: Export and import for WooCommerce

Part 5: Export and import for ProfitMetrics


Part 1: Make a copy of our template for WooCommerce

  1. Click here to open PM - product cost template
  2. Click "File"
    Copy and edit a Google Sheets template. - Step 2
  3. Click "Make a Copy"
    Copy and edit a Google Sheets template. - Step 3
  4. Edit Name
    Copy and edit a Google Sheets template. - Step 4
  5. Click "Make a copy"
    Copy and edit a Google Sheets template. - Step 11

Part 2: Export products from Woocommerce and import them to Google Sheets

  1. In WooCommerce admin click "Products"
    Exporting and Importing Products in WordPress Admin - Step 2
  2. Click "Export"
    Exporting and Importing Products in WordPress Admin - Step 3
  3. Select "ID" and "SKU"
    Exporting and Importing Products in WordPress Admin - Step 9 (1)
  4. Click "Generate CSV"
    Exporting and Importing Products in WordPress Admin - Step 11
  5. In Google Sheets, open "1. Import products"
    Importing data by keyboard shortcuts in Google Sheets - Step 2
  6. Click File
    Guide to Importing and Exporting Data in Google Sheets - Step 2
  7. Click "Import"
    Guide to Importing and Exporting Data in Google Sheets - Step 3
  8. Click "Upload"
    Guide to Importing and Exporting Data in Google Sheets - Step 4
  9. Click "Browse" and select the file you just exported from WooCommerce
    Guide to Importing and Exporting Data in Google Sheets - Step 5 (1)
  10. Under "import location", select "Replace current sheet"
    Guide to Importing and Exporting Data in Google Sheets - Step 7
  11. Click "Import data"
    Guide to Importing and Exporting Data in Google Sheets - Step 8

Part 3: Import SKU + Product cost in Google sheets

  1. In Google Sheets, open "2. Import product cost"
    Guide to Importing and Exporting Data in Google Sheets - Step 9
  2. Click "File"
    Guide to Importing and Exporting Data in Google Sheets - Step 18
  3. Click "Import"
    Guide to Importing and Exporting Data in Google Sheets - Step 19
  4. Click "Upload"
    Guide to Importing and Exporting Data in Google Sheets - Step 20
  5. Click "Browse" and select the file containing SKU and Product cost
    Guide to Importing and Exporting Data in Google Sheets - Step 21
  6. Under "import location", select "Replace current sheet"
    Guide to Importing and Exporting Data in Google Sheets - Step 23
  7. Click "Import data"
    Guide to Importing and Exporting Data in Google Sheets - Step 24

Part 4: Export and import for WooCommerce (Recommended)

  1. In Google Sheets, open "3. Export for WooCommerce"
    Guide to Importing and Exporting Data in Google Sheets - Step 25
  2. Click "File"
    Guide to Importing and Exporting Data in Google Sheets - Step 26
  3. Click  "Download" > "Comma separated Values (csv)"
    Guide to Importing and Exporting Data in Google Sheets - Step 28
  4. In WooCommerce admin, click "Products"
    Exporting and Importing Products in WordPress Admin - Step 12
  5. Click "Import"
    Exporting and Importing Products in WordPress Admin - Step 13
  6. Click "Import file" and select the downloaded csv file
    Exporting and Importing Products in WordPress Admin - Step 14
  7. Check "Update existing products"
    Exporting and Importing Products in WordPress Admin - Step 15
  8. Click "Continue"
    Exporting and Importing Products in WordPress Admin - Step 16

The feed is automatically updated and changes are imported into ProfitMetrics


Part 5: Export and import for ProfitMetrics

  1. In Google Sheets, open "1. Export for Profitmetrics"
    Guide to Importing and Exporting Data in Google Sheets - Step 29
  2. Click File
    Guide to Importing and Exporting Data in Google Sheets - Step 30
  3. Click "Download" > Comma Separated Values (.csv)
    Guide to Importing and Exporting Data in Google Sheets - Step 31
  4. In ProfitMetrics, click "Products"
    Access and Upload Cost Prices File in Profitmetrics Dashboard - Step 2
  5. Click Cost price
    Access and Upload Cost Prices File in Profitmetrics Dashboard - Step 3
  6. Click "Select file" and select the downloaded csv file.
    Access and Upload Cost Prices File in Profitmetrics Dashboard - Step 4
  7. Select currency if applicable
  8. Click "Submit"
    Access and Upload Cost Prices File in Profitmetrics Dashboard - Step 5

The cost are automatically updated in ProfitMetrics. Remember to disable feed import to avoid overwriting of cost.