Knowledge base
Guides
Academy
Video tutorials
Try searching for:
Recently viewed articles:

Table of contents

Managing inventory with Google Sheets

You can connect your Ecwid online store with Google Sheets to manage your inventory. For example, you can connect the two services so that when you add a new product in Google Sheets, it automatically appears in your Ecwid store. Or you can make the product’s stock automatically update in the store once you change it in Google Sheets.

To connect Google Sheets to your Ecwid store, you will need to use the Zapier service. You won’t need any coding skills for that. You just need to create a “zap” and select a trigger and an action. This way you set up what action must happen in one system when a certain event (trigger) happens in the other one, i.e. update a product in your Ecwid store when you make changes in Google Sheets.

Plan availability: You can use Zapier service to connect Google Sheets on Venture, Business, Unlimited plans.

Google Sheet Requirements

You can connect your existing Google Sheet or create a new one. In any case, your Google Sheet must contain:

  • Column names or column headers.
    This is the first row in your Google Sheet with the names of the columns that your file contains. The product ID field is required as changes are synced by product ID. Other fields are optional. For example, you can have such columns: product ID, SKU, name, quantity.
  • At least one row.
    Create at least one row with product details. You can fill in this row with details of an existing product from your Ecwid admin. You’ll need this later to test that a zap you make works correctly.

Here is an example of a Google Sheet file:

Manage_inventory_with_Google_Sheets__1_.png

Once your Google Sheet file is ready, you can go to Zapier and connect Google Sheets to your Ecwid store.

Connecting Google Sheets to Ecwid

As an example, below is an instruction on how to sync changes from Google Sheets with your Ecwid store. You can set up other triggers and actions in Zapier depending on your goals.

To connect Google Sheets to your Ecwid store:

  1. Sign up for an account with Zapier or log in to your existing Zapier account, if you already have one.
  2. In your Zapier account, click Create and select Zaps.
  3. Click Trigger, then select Ecwid by Lightspeed. In the opened menu on the right, click the Trigger event dropdown and select New Product
  4. If you're not automatically logged in into your Ecwid account, in the Account dropdown, click Sign In to login to your Ecwid account.
  5. Click Action and select Google Sheets. In the opened menu on the right, click the Action event dropdown and select the action you want to perform. For example, Create Spreadsheet Row.
  6. If you're not automatically logged in into your Google Sheets account, in the Account dropdown, click Sign In to login.
  7. Click Continue.
  8. Set up details of your connection and click Continue.
  9. Click Test step to check if the right store has been connected and if the right trigger is set up. You can skip this step.
  10. Click Publish.

That’s it, your zap is ready! With this setup, any changes in the quantity column will be automatically reflected in your Ecwid store, i.e. product's stock will be updated. You can also create zaps for other actions and triggers.

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
10 out of 21 found this helpful
10
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline