Cost Per Item in Shopify and How to Update It in Bulk

Cost Per Item is the amount it costs your business to obtain or make one unit of a product variant. It is different from the selling price. Shopify uses recorded costs in its profit reports, and Mixtable can use the current variant cost when calculating supported profit, margin, and cost-of-goods-sold metrics.

Shopify stores this value on each variant. If a product comes in several sizes or colors, each variant can have its own cost.

What should Cost Per Item include?

Shopify describes Cost Per Item as what the product or variant costs you. For a purchased product, that can be the amount paid to the manufacturer, excluding taxes and shipping. For something you make, it can be a value based on materials and labor. See Shopify’s profit-report guidance for its current definition.

Use one consistent method across your catalog. A reliable cost column makes it easier to compare margins and identify products that are priced too close to cost.

Update one variant in Shopify admin

For a single variant, open the product in Shopify admin, find the variant’s pricing information, enter the value under Cost per item, and save the product.

That works for an occasional correction. For dozens or thousands of variants, a Shopify data worksheet is faster and easier to review.

Step 1: Open a Products (with variants) worksheet

Install Mixtable Spreadsheet Editor, then create a spreadsheet from the Full Product Info template. You can also add a Products (with variants) worksheet to an existing spreadsheet.

This worksheet gives each Shopify variant its own row, which is necessary because Cost Per Item belongs to the variant rather than the parent product.

Step 2: Add the Cost Per Item column

In a spreadsheet, create a worksheet that shows your Shopify product variant data.

1. To load new Shopify data, start by selecting an empty column, meaning any column with a non-green header. A green header means the column is already linked to Shopify data. Then click the button in the column header to open the selection window and choose the data you want to pull in.

2. In the dialog that opens, select the Shopify data fields option. A dropdown menu will appear, prompting you to choose the field you want to sync. Find and select the Cost Per Item field. Now, click on the Save Column button.

   

3. You'll now see the column populate with any existing Cost Per Item data.

The column populates with the current value for every variant. Blank cells usually mean no cost has been recorded yet.

Step 3: Enter or calculate the costs

Update the cells directly, paste a prepared list from another spreadsheet, or use formulas when your costs follow a repeatable rule. For example, you might calculate a landed-cost estimate from a supplier cost and a freight allocation before copying the final values into the mapped column.

Before syncing, check that:

• Every cost is attached to the correct SKU or variant
• Currency and decimal separators are consistent
• Blank values are intentional rather than missing data
• Zero is used only when the item genuinely has no cost
• Formula results contain the values you expect

If you only want to update part of the catalog, filter the worksheet first or use a Conditional Worksheet for a vendor, product type, collection, or other condition.

Step 4: Preview and sync the changes

Click Preview changes beside the sync controls. Confirm that the preview shows the expected variants, the Cost Per Item field, and the correct new values.

When everything looks right, click Sync to Shopify. Mixtable saves the pending worksheet edits and intentionally sends them to Shopify. The changes are not pushed automatically while you type.

How Cost Per Item affects reporting

Missing cost data can make profit reporting incomplete. Shopify’s profit reports include products and variants that had a cost recorded at the time of sale. Mixtable’s supported profitability metrics use the variant’s current cost because Shopify does not provide Mixtable with the historical cost from each order.

That difference matters when costs change. Updating a current variant cost can change how Mixtable interprets earlier sales, while Shopify’s own profit reports follow Shopify’s recorded historical behavior.

Once your costs are complete, add gross profit, gross margin, and cost-of-goods-sold metrics beside your product variants with Mixtable Analytics Spreadsheet.

Common questions

Is Cost Per Item the same as the Shopify price?

No. Price is what the customer pays. Cost Per Item is what one unit costs your business. The difference between revenue and cost contributes to gross profit and margin calculations.

Should every variant have a cost?

Record a cost for every variant you want included in dependable profit analysis. Leave a cost blank only when it is genuinely unknown, and use zero only when zero is the true cost.

Does Mixtable sync cost changes automatically?

No. Your edits remain pending in the spreadsheet until you review them and click Sync to Shopify.

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.