Shopify export very large store to CSV file

New format “Excelify: CSV” for truly big data export and import

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:

Shopify exported to CSV files

Shopify import schedule and repeat

Schedule and Repeat Imports to Shopify

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.

To review or cancel the scheduled imports, go to the “History & Schedule”.Shopify schedule and repeat history and cancel

Shopify Update Product Image Alt Text

Product Image Alt Texts are exported fast

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.


Filter Shopify Products export

Improved export of Products filter by Vendor

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


/ Export, Newest Features, Products
Shopify Import Export History

View History of all your Imports and Exports

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.

/ Export, Import, Newest Features
Shopify import Collection Image Alt Text

Import and Export “Image Alt Text” for Collection images

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.

Update Shopify Products by SKU even if they are not unique

Update Products by SKU even if they are not unique

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.


/ Import, Newest Features, Products
Shopify Orders LIne Item Properties

Export and import Line Item Properties for Orders

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.

/ Export, Import, Newest Features, Orders
Shopify filter products by SKU fragment

Filter Products by SKU fragment

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.

/ Export, Newest Features, Products, Tutorials

Update Products by SKU

Now you can bulk update, delete, and do all the other things to Products by just knowing its SKU number. No need for ID or Handle.

The column is called “Variant SKU”.

To find out all about it, read the tutorial: How to update Product by SKU?


/ Import, Newest Features, Products, Update

Product Export – URL column

When exporting Products, the export contains the URL column, which takes to the Product page.


/ Export, Newest Features, Products

“Command” column: NEW, UPDATE, REPLACE, DELETE

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.

Shopify Orders Import

Shopify Orders import is here!

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.


/ Import, Newest Features, Orders, Tutorials

Filter Export by Product Price

When exporting from Shopify, you can filter Products by Price with the following conditions:

  • equals
  • 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.

Shopify filter by product price

Option to remove images from Body HTML descriptions when importing

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?

Option to remove images from Shopify Body HTML

/ Collections, Newest Features, Pages, Products

Fixed mysterious import errors about keys

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.

/ Newest Features, Products

Update Variants by SKU, Barcode, or Options

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:

Update Shopify Variants by SKU, Barcode or Options

You have waited so long, but it’s finally here!!! I hope it was worth the waiting…

Export to Amazon

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.

Read more about the Amazon export format.

/ Newest Features

“Variant Command” for Product Variants

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.

Shopify add variants to existing product variantsFor more information, read the detailed field descriptions about Products.

Filter export by Customer registration date

When exporting Customers, you can filter by Customer registration date interval.

It helps when you have very many customers, but you want to export by specific registration date.

Filter Shopify Customers by creation date

/ Customers, Export, Newest Features

Products: Image Command

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.

/ Newest Features

Filter by many titles

You can filter Shopify Products by many titles – put them in filter split by , (comma), and it will export only products that contain any of those titles.

Shopify search several titles

/ Export, Newest Features, Products

Pages Export & Import

Added Shopify Pages export and import with Excel.

/ Newest Features, Pages

Will stop the import if at least one product image will not be downloaded

In order to prevent further damage of Product images, when importing non-existing images, app will stop as soon as at least one product image will not be possible to download.

Product images loss prevention

/ Images, Newest Features, Products

Improved import speed even further

You can force the import to not check if such items already exist – this will speed up the import even more.

Details in “How to maximize Shopify bulk import speed?” tutorial.

Export as Google Shopping Data Feed

You can export your Shopify Products to Google Shopping Data Feed file.

Select the export format next to Export button.

Export as Google Shopping Data Feed

/ Export, Newest Features, Products

Filter export of Products and Orders

You can filter export of Products by Handle, Title, Vendor, Type, and Tags.

Also you can filter Orders export by date.

Use those filters to make your exports smaller and a lot faster, if you need only certain items exported.

Export filters

/ Export, Newest Features, Orders, Products

Update Image Alt Text

You can export and import Image Alt Text field for Products, and update alt text by importing that back.

Update Shopify Image Alt Text

Export only details that you need to

Now you can choose more finer details what data to export for each item, so that you don’t have to delete unneeded columns and rows when updating data.

Export only details that you need to

Show warning about failed image import

If Shopify will not be able to import all Product images, app will issue warning about that in Import Results file “Import Comment” column.

Image Import Warning

/ Images, Import, Newest Features, Products

Reorder variants by importing Variant Position

Product variant reordering can now be done by changing “Variant Position” number and importing that column in as update.

Base rows/columns filled in export

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.

/ Export, Newest Features

Metafields import

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

/ Import, Metafields, Newest Features, Speed

Import speed dramatically improved

Now the app is choosing the optimal import strategy, depending on your current store size and Excel file contents.

Read: How to maximize Shopify bulk import speed?

/ Import, Newest Features, Speed, Update

Import several product images from a single row

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?

/ Images, Import, Newest Features, Products, Update

Orders Export

Order Export is now in Beta testing – export unlimited Order data to create custom sales reports, check fulfillment, and generate additional business intelligence data for your store.

Read more in: Shopify Orders Export

/ Export, Newest Features, Orders