How to bulk update product Last cost and Average cost via csv import

Last updated: April 19th, 2024

In this article:

  1. How to bulk update product Last cost and Average cost via csv import?

How to bulk update product Last cost and Average cost via csv import?

Step 1:

  • Create csv file with only 'sku', 'unit_last_cost' and 'average_cost'.

Only create header with 'sku', 'unit_last_cost' and 'average_cost', do not add any other field in header with empty value, else existing data will be replace with empty value.

Step 2:

  • Go to Products > Search Products

Step 3:

  • Click on 'Import' > 'Product'

Step 4:

  • Select 'Ricemill (CSV)' format
  • click on 'Overwrite existing item data'
  • upload the csv file create in step 1 and click 'Upload'