Excelify app works with Excel file template that is organized with Sheets (tabs).
The same data that is exported, can be imported.
Mark with checkboxes, what data to export. In the “Include data” you can include additional data of each kind of item.
Export only the data you need, because that impacts the duration of how long the export will take. Export becomes significantly longer if you include Metafields.
Choose the format in which to export.
If your store is very large, choose the “Excelify: CSV” format. Read more about the formats.
To start the export, press the “Export” button.
To focus on a specific list of items, use the Filters.
You can filter different items by different criteria.
For example, you can filter Products by:
- Title fragments (can put several fragments, split by comma)
- Vendor (list of several vendors, split by a comma; or list of Vendors that must be excluded from the export)
- Tags (list of Tag fragments, split by a comma)
- SKU (list of Variant SKU fragments, split by a comma – exports all products that have variants with at least one such SKU)
- Price (equals, less than, less or greater than, … – exports all products that have variants with at least one such Price)
- Collection (collection ID or Handle – exports all products that belong to a certain collection)
When you apply the filter, the item count and estimates will not change at that point – the estimate will adjust when you actually start the export. For some filters it still has to run through all your store though, to find those items.
List of all filters for all items you can see in our “Export Filters” documentation.
You can specify additional Options for the export, like schedule and/or repeat the export. You can specify a custom file name for the export so that the exported file URL is always the same.
Ideal to use for regular backups or outgoing data feeds.
Exported Item Count
While the export is running you can now see exactly how many items have been exported and how far the app is in the export process from all items.
This comes in handy when you are applying multiple filters to your export to see how many items exactly will be in your file.
Check our all available export filters in our “Export Filters” documentation page.
Now, let’s decode these numbers:
Total Count – This number will display the total count of the item you have in the store. For example, the job is exporting Products and this store has 547 Products.
Processed Count – Displays how far the app is between all items. Some filters might provide the ability for the app to disregard a lot of items in bulk, so you might see the processed count jump at the start.
Exported Count – Displays how many items are actually exported and will be in your exported file.
Supported import formats
At the moment the app can import the following format files:
- Excelify: Excel
- Excelify: Google Sheets
- Excelify: CSV
- Shopify CSV (must be named as “Products.csv” and zipped to make smaller and upload faster)
- Other custom file formats for Enterprise Plan customers
When you upload the file, at first the app is analyzing the file. After that, you can choose the options and press “Import” button if everything is showing ok.
Supported import sheets
Import From Locations
- Upload the file directly into the app
- URL to a file that is hosted on the web
- FTP URL to a file that is stored on FTP server
- SFTP URL to a file that is stored on SFTP server
- URL to a Dropbox file
- URL to a Google Drive file
- URL to a Google Sheet on Google Docs cloud
Export To Locations
Import only columns you need
When you import, you don’t have to import all columns. You can import only the columns you need to update.
The app will identify the product by “ID”, “Handle” or by “Variant SKU”. It can update or create new Collections, Customers, Orders, Pages, etc. with just a few columns, or all of them.
In each sheet, you can use the “Command” column, by which you can tell, what to do with the row that is being imported.
The possible commands are:
- NEW: will try to create a new item with the provided details. If such an item will already exist (with the same ID or same Handle), then the result will be Failed.
- UPDATE: will try to find an existing item by ID or by Handle, and update it with data from the row. If such an item will not be found, then it will create new.
- REPLACE: at first, if such item with provided ID or Handle exists, then the app will delete it. After that, it will create a new one. If an existing item will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of the columns, which were not included in the import file since the item will be deleted and re-created.
- DELETE: the app will delete the existing item, which is found by ID or Handle. If such an item will not be found, then the result will be Failed. This DELETE command is very handy for deleting items in bulk.
If no Command is specified, then the app will assume the UPDATE command.
When updating items with related items – like Product Variants, then it merges your variant rows with existing variants, by find an existing variant of the Product by its Variant ID, then by SKU, then by Barcode, then by Option values.
To delete Variants, use “Variant Command” column with value “DELETE”. Or put “REPLACE” if you want to replace all variants of that product to your new variant rows.
The same principle is used in other sheets and items as well, like Product images. By default, it merges existing images with your image links, but you can DELETE or REPLACE images too.
You can read detailed documentation about each command in the documentation pages of each sheet.
Also, see the complete list of Commands across all the sheets.
This stuff is powerful!
- You can update all images of all Products at once.
- You can link images to Product variants all at once.
- You can add new variants without having to list the existing variants – just import the additional variant rows, and the app will merge them automatically.
- Much more. See Tutorials for more inspiring ideas.
Since Metafields are just additional rows in the same import file, all you need to do is – put the Metafield columns and set their values as you need.
Before starting an import, you can configure the following options:
- Ignore ID – will ignore the ID values of the imported file items. This makes import run faster if importing an export file from another store. Don’t ignore ID if you import data from the same store – then app will use ID values to identify items very fast.
- Check if items already exist – will make sure that if an item with the Handle you are importing, exists, then the app will update it. Remove this checkbox if you are 100% sure that the data you are importing, is new to the store and you need to maximize the import speed. If you remove this checkbox then you may result in duplicates if imported items will already exist in your store.
- Remove images from Body HTML – read more about removing images from Body HTML.
- Schedule import at – choose date and time when to actually do this import.
- Repeat every – choose the time interval, when to repeat this same import.
As it imports, it will show how many items are New, Updated, Replaced, Deleted or Failed.
It will also calculate more precise time estimate as it moves on – from the real speed of your items.
If you notice that you get too many Failed, or just that you forgot to add something, you can cancel the import any time. When you cancel the import, you will have a chance to download the Results file.
After you import the file, the app generates Import Results file with additional two columns that show status for each imported item, and detailed error message, if the import has Failed.
It will contain only those rows, which were imported. That way you can review, what was imported, what were the errors. And that way you know, which items it actually imported, so that if you need to continue, you can exclude those already imported items from the next import.
If your import speed is a concern, read more about improving import speed in the tutorial: How to maximize Shopify bulk import speed?
Maybe strange, but really useful is that each Product (or any other item) will have the same “Import Comment” value for all its rows, so when you read them, consider them about the product as a whole, not about each line. The convenience here is that in case you need to filter rows by the import comment, you can easily filter them in Excel, and know that your filtered results will contain all the rows of that product, because the “Import Comment” column value is the same.
Test Your Imports
Before importing the whole file, import one item to make sure you have set everything as you need.
Once you made your test import, and results are as you need, only then import the whole file.
If you cannot do tests in your live store (and, in fact, you shouldn’t), you can always create the free Shopify store for tests and activate Excelify for free from your paid Excelify app Settings – for free. Meaning, that you don’t need to pay for your second store. That way – you can do safe tests in your test store, and be confident what will happen in your live store.
You can even export everything from your live store to your test store, and then apply the new imports in your test store, to see what will happen to your live data.
Once you gain that confidence, you will be ready to do the same import in your live store and know exactly what will happen with your import there – without guessing, because you already tested in your test shop.
Important: before importing, keep your exported file as a backup. Just in case you mess up the data, you can import the exported file to restore it back.
When pressing the “All Jobs” button, you can see all the past import and export jobs. You can download all the files for each job. And you can see what happened to each of the past jobs.
More than that, you can see the future scheduled jobs as well. And you can cancel any scheduled or running jobs from here, too.
When you run the export or import, you don’t need to keep the browser open – you can close it and come back later to check the progress.
Initial import and export estimates are very approximate average because it really depends on your real data.
Once the export or import actually starts, the estimates become very precise, because then those are showing about your current export or import, with your real data.
Where to go next?