If you have a store that is so large that the data don’t fit into an Excel file, now you can choose to Export into “Excelify: CSV” format.
That will still allow you to export several entities in the same export (Products, Collections, Customers, …), because each entity is saved into its own CSV file, and they are all zipped into one nice zip file to take less space.
The only limitation here is that you cannot export Metafields. It’s because each item Metafield can be only discovered when that item is read from Shopify, but CSV files don’t allow to add columns on the fly.
You can import that same zipped CSV format as well.
Similarly, as Excel sheets, each CSV file will have its own name that determines what is in that file. For example, you will find Products in the “Products.csv” file, when unzipping the exported file.
Excel file format is limited to 1 million rows, but this new format allows you to exceed well over 1 million rows in your exports and imports.
All the columns are the same as in our Excelify Excel template. It works exactly the same as with Excel. Also, after the import, you are able to download the Import Results file and see the result columns.
The exported result will look like this:
You can schedule and repeat imports to your Shopify store.
After uploading the import file, you can click the “Options” button and set the scheduling and repeating parameters.
You can combine them as you like. You can set just to schedule the import to start at a certain date and time. And you can set the import to repeat at certain time intervals, for a given amount of times.
You can also set to import now and repeat at the same time at given time intervals.
Now when you export Product Images from Shopify, the Image Alt Text column will be there always.
And the export and import of product image alt texts works super fast now.
You can filter Products by Vendor in finer detail:
- Vendor equals any of several vendors, split by comma
- Vendor not equal to any of several vendors, split by comma
When clicking the “History” button, you can see the whole history of your imports and exports, their statuses.
You can also download all your historically imported and exported files.
Previously you couldn’t, but now you can export and import the “Image Alt Text” for Collection images.
There is a new column “Image Alt Text” in Smart Collections and Custom Collections sheets now.
Now you can update by SKU number all your products, even if they are not unique across your store.
Also, you can do tricks like “delete all variants that have empty SKU”, or delete all products that have a certain SKU.
Read more in this tutorial: How to update Shopify Products by SKU.
You can now export and import Line Item properties for Shopify Orders.
You can find them in the column “Line: Properties”.
Also, you have the Order additional details in the column “Additional Details”.
Read all about those fields in the Orders detailed documentation.
You can filter Products – to export only those, which contain fragments of SKU.
To filter by several fragments, split them by comma.
In this example, if you have the filter set to “SKU-1, AAA”, then it will export only those Shopify Products, where any part of their SKU contains “SKU-1” or “AAA”.
To export all Products, where SKU is empty – set the filter by SKU, and leave the search box empty.
You can apply the filter when exporting to any format, including Excel, Google Shopping Data Feed, Amazon.
When exporting Products, the export contains the URL column, which takes to the Product page.
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 item will already exist (with the same ID or same Handle), then the result will be Failed.
- UPDATE: will try to find existing item by ID or by Handle, and update it with data from the row. If such 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 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 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.
Finally, you can import Orders to Shopify in bulk now with all the details!
Excelify app can import the same Orders data that is being exported and basically is replicating almost exactly the Order as you see it in Shopify Admin.
To test that, you can export orders from one store, and import into another. Ideally, if you include also Products and Customers in that export and import – then it will link orders also to those Products and Customers.
Here is the Orders detailed documentation.
When exporting from Shopify, you can filter Products by Price with the following conditions:
- less than
- less than or equal to
- greater than
- greater than or equal to
When doing the export, it will look into all your product prices and will include in the export only those products, where the price of the product or at least one of its variants will match your given criteria.
You can remove images (<img> tags) from your Body HTML description by selecting a checkbox option “Remove images from Body HTML” when importing.
Also you can update your existing products, collections and pages the same way.
Here is the tutorial: How to remove images from Shopify Body HTML descriptions?
Fixed import errors like:
- Field [metafields.key]: must be unique within this namespace on this resource – was happening because importing Metafield update, giving Metafield name in different small-BIG letters than already exists.
- product_id prefix_option is missing – was happening when retrying to import product because Shopify didn’t download some images
If you notice any other strange and unexpected errors during the import, do let me know.
Update your products by Variant SKU, Variant Barcode or even by Option values, if you don’t have SKUs or Barcodes. It will MERGE Variants in such a smart way that you almost never ever need to use Variant ID to update your variants.
When importing, remember that still you will have to identify the Product as well, by specifying “ID” or “Handle” values.
The import file to update specific variant fields now can look like this:
You have waited so long, but it’s finally here!!! I hope it was worth the waiting…
Now you can sell your Shopify products on Amazon – by exporting in bulk to Amazon Inventory Flat File format, which you can import in Amazon Services.
To export to Amazon format, choose the “Amazon Inventory Flat File” next to the Export button.
To be more safe and exact, what should happen to Product Variants, when you import them, now you need to provide the “Variant Command” for each Variant row:
- MERGE – merges new variants into existing product variants. Updates those that can be found by “Variant ID”, “Variant SKU”, “Variant Barcode” or Option Values. If it will not find such variant to update, then it will add new.
- DELETE – will delete the listed variant. Requires “Variant ID”, “Variant SKU”, “Variant Barcode”, or Option Values – so that it can identify, which variant you want to delete.
- REPLACE – will replace all existing product variants with the ones that are listed in the import. This will delete any variants that are not included in the import for that product.
If the Variant Command column is not provided, then app will assume the MERGE command.
For more information, read the detailed field descriptions about Products.
Previously, to change images, you needed to include all existing images in the import, otherwise those images would get replaced with your new images. That resulted in quite many accidental deletion of images.
Because of that, the behavior of Product images has changed to be non-destructive by default.
You have the “Image Command” column now, where you can specify what do you want to do with this image. Possible commands are:
- MERGE – will keep all existing images for your product, update data of specified images from this import, and add any new images.
- DELETE – if put next to the image, then this particular image will be deleted, while all other images will be kept.
- REPLACE – will delete all other images, and keep only those, which are included in this import.
By default, if you leave this column empty, the MERGE command will be assumed. So – no more accidentally lost images.
More details in Product Columns Documentation.
Added Shopify Pages export and import with Excel.
Product variant reordering can now be done by changing “Variant Position” number and importing that column in as update.
When exporting, all the base rows like Title, Vendor, Tags, etc. are filled also for duplicated rows, so that you can filter and group them easier in Excel.
Speed: Metafields import speed doesn’t depend on Metafield count anymore. Even for 100 Metafields per item, it will import as quickly as with no Metafields.
Delete: You can delete Metafields for items just by clearing values in that Metafield column, and importing.
Set type: Metafield can have “string” or “integer” type, which is now auto-detected from Excel cell type, and set correctly when you do the import.
Read more: Metafields template documentation
To import or update several images for a product, put them all in the same row of “Image Src” column, separated by ; (semicolon).
Read tutorial: How to import several product images from one row?