Edit your Shopify store inventory from Google Sheets

Follow these steps to manage your store directly from your spreadsheet, allowing for bulk edits on products, variants, and inventory.

How eCommix imports works?

eCommix – Google Sheets Sync is a powerful tool that automatically imports your Google Sheets store data into your Shopify store.

Prerequisites

Create your Import

Once you’ve installed eCommix in your store and connected your Google Account, the first step is to export the latest data to a spreadsheet. This ensures you’re working with up-to-date information before starting the import process.

Navigate to “Sheets” and click on “New”. Then select “Import”:

Please select the dataset you want to work with:

Follow the same steps as described in Export your Shopify store data to Google Sheets to filter the data you want to export to later edit.

Click on “Create” when you are ready. The export process may take a few seconds to a few minutes, depending on the number of rows being extracted and inserted. This will create and populate your spreadsheet with products.

Edit an attribute

You can modify different parts of your inventory—like quantities, product details, and variant information—but you can’t create new items or remove existing ones. Additionally, only the attributes already present in the spreadsheet can be updated; adding new columns won’t be recognized.

In the created Google Sheets, let’s update the “Price” of the first 4 products:

Updated items will be highlighted in yellow to show the changes that will be applied after you confirm the import.
To proceed, return to eCommix, select the Sheet, and click on ‘Import’:

A new execution of type ‘Import’ is added to the execution summary, as you are syncing changes from Google Sheets to Shopify. Once the execution is complete, you’ll see that 4 rows have been processed:

Now, if you open the Sheet, you’ll see that the first four rows show ‘UPDATED’ as their STATUS_MESSAGE.

You can confirm in Shopify that the prices for those variants have been updated.

Troubleshooting

Sometimes, errors might be introduced during editing. For example, let’s say we accidentally change the Weight Unit of the first variant to “WRONG WEIGHT UNIT”:

In that case, after clicking ‘Import’ and waiting for the process to complete, you’ll see an error in the STATUS_MESSAGE column for that specific row, indicating what went wrong and how to fix it:

Here it says that Weight Unit was expected to be one of KILOGRAMS, GRAMS, POUNDS, OUNCES.

Frequently Asked Questions

The ‘Data’ sheet cannot be renamed or removed

The automation needs this sheet name to be present to export the data.

I can’t find a field or is not formatted as I want

If you’re unable to find a field or it’s not formatted as you expect, check the Custom Attributes and Metafields sections. If the information you’re seeking comes from a third-party app, there’s a good chance it’s stored in one of these fields.

If not, please reach out to us at contact@ecommix.io. We listen to what our users need and add features based on their feedback. If the request is feasible, we usually implement it within a day or two.

Seeing #ERROR! in your formulas?

By default, the sheet is created with the United States locale, as some formulas used by the app require this setting to function properly. If you’re using formulas to modify values, ensure to write formulas using this locale.

For example:

  • United States: =SUM(A1,A2,A3) (uses commas ,)
  • Spain: =SUM(A1;A2;A3) (uses semicolons ;)

Currently, only the United States locale is supported.

Import failing?

The import process only updates existing products or variants—it does not create new ones or add new attributes. To avoid issues, don’t add extra rows or columns to the sheet, as this may break the import. If that happens, you can simply create a new import.

Only the columns to the right of the column separator are editable.

If there are any issues (like incorrect data types or values), they’ll be detailed in the STATUS_MESSAGE column.


Ready to sync your Shopify store to Google Sheets? Update your products from Google Sheets now.

Leave a Reply

Your email address will not be published. Required fields are marked *