Import to Shopify from any file

Import to Shopify from any file (with video)

To see how it’s done, watch the video.

Short summary how to import to Shopify from any file

  1. Open your file, save it to Excel and give the sheet name “Products”.
  2. Take the Excelify.io template file – to take needed column names from it.
  3. Look into your source file columns one by one, and copy the appropriate column names from the template.
  4. Import the file.

You can do that with any other Excel sheets to import not just Products but any Shopify data.

 

Export to custom file name with dynamic placeholders

Shopify export custom file name with placeholders

When exporting, under Options you can specify the “Custom file name” for the export.

This is especially useful for scheduled exports so that you can specify what the file name should be for your exports.

You can include the dynamic fields of the Export starting date and time in the file name, using the placeholders like this:

Placeholder Meaning Example
%Y Year with 4 digits 2018
%y Year with 2 digits 18
%m Month with padded zero (01 – 12) 04
%-m Month, not padded (1 – 12) 4
%B Month full name April
%^B Month full name uppercase APRIL
%b Month abbreviated Apr
%^b Month abbreviated uppercase APR
%d Day of the month with padded zero (01 – 31) 05
%-d Day of the month, not padded 5
%j Day of the year (001 – 365) 124
%H Hour in 24-hour format, with padded zero 01
%I Hour in 12-hour format, with padded zero 01
%P Meridian indicator, lower case am
%p Meridian indicator, upper case AM
%M Minute 45
%S Second 23
%z Time zone as hour and minute offset from UTC +0900
%Z Time zone abbreviation name UTC
%A Full weekday name Thursday
%^A Full weekday name, uppercase THURSDAY
%a Weekday abbreviation Thu
%^a Weekday abbreviation, uppercase THU
%u Day number of the week where Monday is 1 (1 – 7) 4
%w Day number of the week where Sunday is 0 (0 – 6) 4
%U Week number of the year where the week starts with Sunday (00 – 53) 14
%W Week number of the year where the week starts with Monday (00 – 53) 13

You can use those placeholders in any combination inside your filename.

Some examples:

Example Resulting file name
%Y-%m-%d at %H-%M-%S 2018-04-05 at 01-45-23
%m%d_%H%M 0405_0145
Products_%Y-%^b-%-d Products_2018-APR-5

Improve import speed when importing from another Shopify store

Import to Shopify by ignoring ID

When you export from one store and import to another, the import file includes items with their IDs. If you would import that same file into the existing store (like when you update some items), that ID allows to identify existing items very quickly, so the import speed to the same store is very good.

But when you copy your data to another store, those IDs don’t exist in the other store, so that causes the app to make an additional request to API to find that out. You can improve the speed by checking the “Ignore ID” box and that will tell the app not to try to use those IDs.

It will improve your import speed by at least 20%.

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 cancelHere’s the tutorial on one typical scenario: Schedule regular Product price update.

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 Excelify.io 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.