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 (with variants) worksheet to your Mixtable workbook (unless you already have one).

3. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.

   

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

   

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. You can:

• change cost per item numbers in bulk
• use formulas
• do copy-paste on thousands of SKUs
• filter products by tags, metafields, product names, or other criteria

When you are done, click the Sync worksheet changes to Shopify button at the bottom right corner of the worksheet.

• Mixtable will update the Cost per item data that has changed to Shopify - no need for manual file import/export or field matching - all is done with just one click!
• Note: It may take a few seconds to see your store’s new information.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.