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'

Was this article helpful?
Thank you!