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.

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:

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 Make a zap.

Now you will need to set up a trigger and an action. These are two steps in Zapier. In the first step, in our example, you will set up Google Sheets and in the second — your Ecwid store.

Step 1. When this happens …

1. Choose App & Event:
   • Type “Google Sheets” in the search field and click on the icon to choose it.
2. Choose Trigger Event:
   • Select New or Updated Spreadsheet Row.
3. Click Continue.
4. Choose Account:
   • Log into your Google account.
5. Click Continue.
6. Customize Spreadsheet Row:
   • Spreadsheet.
     Select the Google Sheet that you set up earlier.
   • Worksheet.
     Select the worksheet in your Google Sheet where you have product details. You can see the name of a worksheet at the bottom of your Google Sheet:

• Trigger Column.
  Select the column that should trigger the updates in your Ecwid store. In our example, we want to track the inventory changes, so we choose the quantity column.

7. Click Continue.
8. Click Test Trigger. If you’ve set up everything according, you’ll see congrats and the data that Zapier found in your Google Sheet:

9. Click Continue.

Step 2. Do this …

1. Choose App & Event:
   • Type “Ecwid” in the search field and click on the Ecwid icon to select it.
2. Choose Action Event:
   • Select Update Product.
3. Click Continue.
4. Choose Account:
   • Log into your Ecwid account.
5. Click Continue.
6. Customize Product:
   • Fill in the Product ID (required)
     This field is required as all product changes are synced by the product ID. From the drop-down, select the product ID column.
   • Fill in other fields (optional)
     Click on each field and select an appropriate value from the suggested options.
7. Click Continue.
8. Click Test & Continue.
   Warning! At this step, the product from your Google Sheet will actually be updated in your Ecwid store. So, make sure that the quantities you have in Google Sheets won’t mess up your online store inventory.
9. If the test goes fine, click Turn on Zap.

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.