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
- Before you get started, ensure you have connected Shopify and Google Sheets.
1. 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”:
You can update various elements in your inventory—such as quantities, product information, and variant details—but you cannot create new items. 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 configure the data you want to export to later edit, like columns and filters.
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.
2. Edit an attribute
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.
2. 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.
Ready to sync your Shopify store to Google Sheets? Update your products from Google Sheets now.
Leave a Reply