Skip to main content
  • Home
  • Get Help
  • How Do I
  • How do I update stock quantities in Google Sheets when order is placed in Ecwid?
Question

How do I update stock quantities in Google Sheets when order is placed in Ecwid?

  • 15 November 2023
  • 1 reply
  • 25 views

Hi all,

In Ecwid we sell individual products and “kits” made up of products. When an order is placed, the stock quantities on the platform adjust automatically. I want to send the new stock quantities from Ecwid to Google Sheets to do some data manipulations (to adjust the quantities of the products in kits) and then send the new quantities back to Ecwid.

How do I create a zap that updates the stock quantities in Google Sheets based on an order from Ecwid?

 

Thanks.

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

1 reply

Troy Tessalone
Userlevel 7
Badge +14

Hi @Linda G 

Good question.

Since Orders can have multiple line items, you’ll need to handle those individually by iterating thru them with the Looping app: https://zapier.com/apps/looping/help

 

Try these Zap actions within the Loop:

  • GSheets - Find Row
  • GSheets - Update Row
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions