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

Shopify export very large store to CSV file

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

Schedule and Repeat Imports to Shopify

Shopify import schedule and repeat

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

Bulk Delete Orders from Shopify

So you need to bulk delete Orders from your Shopify store because you created those orders while testing or those are just unneeded for some reason.

Through Shopify Admin you might not be able to delete them because they are already archived, or there is just too much of them that deleting them one by one is just too time-consuming.

Here’s how you delete any Shopify Order with app:

1. Export your existing Orders from Shopify to Excel

You might even not need to export any other details about those orders – that way your exported Excel file will have just one row per Order, which will be convenient in this situation.

Export Shopify Orders to Excel2. Edit exported Excel file to mark orders you need to delete

Delete from that Excel file all the orders which you want to keep in your store – so that your file contains only Shopify Orders you want to delete.

Then set the values for “Command” column to “DELETE”.

Like this:

Mark Shopify Orders as deleted in Excel file3. Import prepared file to delete those Orders

Status of deleted Shopify OrdersThat’s it – those Orders will be deleted from your Shopify store permanently.

Good to know

  • You can delete any other items from your Shopify store the same way.
  • Before deleting orders, you might want to do the full export of all Order details to Excel file. You can keep that file for reference, or even restore deleted orders later to your Shopify store, if you need to.


“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 is here!

Shopify Orders Import

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.


Orders Export

Shopify Orders export to Excel and Pivot report

Shopify Orders Export are now in unlimited Beta, which means that you have unlimited capability of Shopify Orders export to Excel, regardless of the plan you have.

Here is the video showing basic information of what kind of data get in the Shopify Orders export to Excel, and what can you do with that.

Play with that Orders data it and tell what you think.

Read the full documentation about Orders columns and rows that can be exported and imported.