# Bulk Update "Cost" field on Shopify

**URL:** <https://community.make.com/t/bulk-update-cost-field-on-shopify/36292>\
**Category:** Questions\
**Tags:** shopify, google-sheets\
**Created:** [May 6, 2024, 8:19am UTC](https://community.make.com/t/bulk-update-cost-field-on-shopify/36292 "2024-05-06T08:19:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julie\_CH](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@Julie\_CH](https://community.make.com/u/Julie_CH)\
**Post date:** [May 6, 2024, 8:19am UTC](https://community.make.com/t/bulk-update-cost-field-on-shopify/36292/1 "2024-05-06T08:19:11Z")

</div>

Hello,  
I have a Google Sheet with 900+ products and each of their total cost. I would like to copy paste these costs to the Shopify field “product cost”. Is it possible?

Basically I would need Make to search for the product’s SKU and cost in the Google Sheet. Then find the product’s on Shopify based on the SKU and update the product cost accordingly.

Can you tell me how my Make scenario should look like? I’m not a coder at all

Thank you for your help,  
Julie

![Screenshot 2024-05-06 at 11.15.54](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/6/d60391c53b04db163089950a73b559150f03ffc4.png)

 ![Screenshot 2024-05-06 at 11.17.38](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/d/9d3263685124dd3e0d890e069f25297315162b82.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 6, 2024, 8:22am UTC](https://community.make.com/t/bulk-update-cost-field-on-shopify/36292/2 "2024-05-06T08:22:10Z")

</div>

There’s not really a way to bulk update stuff using the Shopify API. They usually work on single items at a time (e.g.: get single product, update single product).

It’s best if you can actually export a CSV of all the products in a Shopify store, then manually change them, and export them back, or use a [bulk editor UI](https://help.shopify.com/en/manual/products/inventory/managing-inventory-quantities/bulk-editing-inventory), like [Matrixify - Matrixify - Bulk Import Export Update Migrate | Shopify App Store](https://apps.shopify.com/excel-export-import).

> Join the [**Make unofficial Discord server**](https://samliew.com/make-discord-invite)!

---

<div class="post-metadata">

**Author:** ![stfn](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@stfn](https://community.make.com/u/stfn)\
**Post date:** [June 3, 2024, 12:27pm UTC](https://community.make.com/t/bulk-update-cost-field-on-shopify/36292/3 "2024-06-03T12:27:24Z")

</div>

Follow-up question to this:  
If I want to update only a single product, would the scenario described by Julie\_CH be possible? I see two challenges here:

- How to access the cost-per-item field? Seems not to be available in the “update variant” function.
- How to get the variant ID for a specific SKU? Seems you cannot use a SKU for identifying a product.

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [September 1, 2024, 12:34pm UTC](https://community.make.com/t/bulk-update-cost-field-on-shopify/36292/4 "2024-09-01T12:34:02Z")

</div>