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
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).
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.