Skip to main content

How do I update prices in Shopify from Google Sheets?

  • Sep 7, 2023 9:24 PM UTC
  • 8 replies
  • 218 views

Manuel S

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

Manuel S
  • Author
  • Beginner
  • Sep 7, 2023 9:25 PM UTC

 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Sep 8, 2023 6:59 AM UTC

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


Manuel S
  • Author
  • Beginner
  • Sep 8, 2023 5:34 PM UTC

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!

 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Sep 11, 2023 7:02 AM UTC

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.


Manuel S
  • Author
  • Beginner
  • Sep 11, 2023 12:52 PM UTC

Hi, ken it didnt work.

It continues updating variant options and inventory.

 


Manuel S
  • Author
  • Beginner
  • Sep 11, 2023 1:00 PM UTC

Check this


Manuel S
  • Author
  • Beginner
  • Sep 11, 2023 1:00 PM UTC

Hi ken Check this


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Sep 12, 2023 6:49 AM UTC

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.