How do I update prices in Shopify from Google Sheets?

  • 7 September 2023
  • 8 replies
  • 87 views

I need help because it only updates one product price

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

 

Userlevel 7
Badge +6

Hi there @Manuel S,

Welcome to the Community! 🎉

Could you please try setting up your Zap like this:

  1. Trigger: Google Sheets - New or Updated Spreadsheet Row
  2. Action: Shopify - Find Product by Title
  3. Action: Shopify - Update Product - you will need to map the Product ID from the 2nd step to the “Product” field, and the Variants ID from the 2nd step to the “Product Variant” field.

Please give that a try, and let me know how it goes. 😊

Hi Ken,

Thank you very much. 

I didnt find the option production variant in step 3. 

Also I add Update inventory because when I update product it turns inventory to “0”.

Thank you in advance!

 

Userlevel 7
Badge +6

Hi @Manuel S,

Thanks for the update!

Have you tried mapping a data on the “Price” field on your Update Product step? If you want to only update the price of the product you must map a data in the “Price” field on your Update Product step.

Hopefully, this helps.

Hi, ken it didnt work.

It continues updating variant options and inventory.

 

Check this

Hi ken Check this

Userlevel 7
Badge +6

Hi @Manuel S,

Thanks for the screenshots!

I’m pretty stumped on why this isn’t working. The setup seems correct.

I’d recommend reaching out to our Support Team so that they can take a closer look at the Zap and its logs to determine the cause of the issue. You can reach our Support Team here: https://zapier.com/app/get-help.

 

I appreciate your understanding.