Cost per Item in Shopify and How to Bulk Update it

To run reports about costs, margins, or profit in Shopify, you must set the Cost Per Item for each product variant. Profit reports are shown only for items with the Cost Per Item metric set.

How to Set Cost Per Item Individually via Shopify Admin

From Shopify Admin, you can set the Cost Per Item individually for every product variant by going to the Products - Pricing section and adding the number.

Set Cost Per Item in Bulk with Mixtable Spreadsheet Editor

The Mixtable Spreadsheet app simplifies this process by allowing you to add a Cost Per Item column to your Shopify data spreadsheet and make changes in bulk from the convenience of a worksheet. Changes are then synced back to Shopify with just one click. Here’s how to do it:

1. Install the Mixtable Spreadsheet Editor app.
2. Add a Products - Complete (with Variants) worksheet to your Mixtable workbook (unless you already have one).
3. Choose an empty column in the worksheet and right-click on the column header (which contains the column letter).
4. Click on the Shopify Sync Settings option in the context menu that appears after right-clicking the column header

4. In the window that opens, select Standard Field as the field type. Next, choose Cost from the dropdown menu to map the column to the cost per item field

5. Click the Save button to confirm and apply the new column mapping
6. You’ll notice that the new column begins to populate with the existing cost per item values for the product variants
7. Make any changes to the relevant cost per item cells, and start a sync to send the data to Shopify.

Now you are able to run profit reports in Shopify! With the Mixtable spreadsheet app, you can make any changes to your Shopify data in bulk from the comfort of an Excel-like environment!