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.

 

Automatically synchronize your Shopify store with your other store daily/weekly/monthly

Sync Shopify

You have more than one stores on Shopify, and now you need to synchronize their contents regularly.

Here’s how you do that using Excelify.io app.

Steps to automatically synchronize data from one Shopify store to another

  1. Store A: Setup the scheduled regular export of the data you want to synchronize.
  2. Store A: Wait for the first export to finish and copy the exported file URL.
  3. Store B: Setup the scheduled regular import from the URL of the regular export.

Let’s get to it!

Store A: Setup the scheduled regular export of the data you want to synchronize

Sync Shopify store - Setup the regular exportMark the items you want to export.

You can even set the filters, for example, to export only Products that have a certain Tags, or products that exist only in certain Collection. Use any of the available filters in the app.

Then, under the Options button, you need to set up the:

  • Schedule export on: choose the starting date of the first export and time. In this example, it will start the first export today at midnight of the store time zone.
  • Repeat every: set the interval when to repeat that same export, and how many times to repeat it. In this case, it will export every day and will repeat it forever.
  • Custom file name: and this is the most important part. You need to set the custom file name for your export because this will ensure that your exported data will always be available at the same URL. We will use that URL in the scheduled import.

Then press “Schedule Export” to schedule it.

2. Store A: Wait for the first export to finish and copy the exported file URL

If you have set the repeated export to start today at the time that has already passed, the app will start the export shortly after you schedule it – to complete the today’s export.

Open the “History & Schedule” page and see that the export is done. If it is not yet finished, you will need to refresh this page manually to update the status.

When your first export is finished, the page should look like this:

Sync Shopify - copy the exported file URLThere you will see the next scheduled export for tomorrow, and the export that finished today.

You will see that the completed export has the file there – your custom defined file name.

Right-click on it, and “Copy Link Address“.

This link will be the same for all the future exports of this scheduled export. So now you will use it for the scheduled import.

Store B: Setup the scheduled regular import from the URL of the regular export

Now, open the app on your other store – that where you want the data to get imported from the store A.

And scroll to the Import section of the app.

There you will see the box where you can paste the URL of the file to upload.

Paste your copied URL there, like that:

Sync Shopify - paste the export URL in the Store B

Then press the “Upload from URL” button.

It will upload the file, and the app will analyze it. And just hold the horses, don’t press the Import button here.

Instead of that, press the Options button.

And then set up your schedule so that it always starts at the time that is after your export would finish. In this example, we have set the export to be on midnight, so we will set the import to happen at 1am every day, starting from today.

Notice that the checkbox is removed for the option “Stop if images cannot be downloaded for updated items.” – that is useful when updating your existing items, the app will not stop if some images will not get imported. It’s what you most likely want, right?

Also, notice how it has the “Take import file from URL:” filled with your URL – it means that every time the app will run this repeated import, it will use the fresh file from that URL you pasted earlier.

Sync Shopify - import from scheduled export fileWhen everything looks nice, press the “Schedule Import” button.

Again, if the time for today’s import is already passed, the app will shortly start the import to complete the first import for today. And that is a good way to check that it did work as you expected.

You can find that import status in the “History & Schedule” page.

Sync Shopify - see scheduled import statusThat’s it!

Now it will sync your stores just the way you want it!

Good to know

  • You can synchronize any kinds of items – Products, Collections, Discounts, Customers, Pages, even Orders.
  • You can synchronize items partially by using Filters when setting up your repeated export. For example, you can synchronize just products with certain Tags, or that are in just the certain Collection.
  • You can have several syncing processes happen at the same stores. No limitations, but just bear in mind that running two processes at the same time will make their speed two times slower.
  • You can set up the same synchronization both directions – just set up the same logic from store B to store A.
  • The scheduled time uses the time zone from your Shopify store.

Schedule import to Shopify from FTP server

Schedule Import to Shopify from FTP

You are in this situation that you have your Master Data auto-refreshed regularly and is available on your FTP server.

So you need to import it every day to Shopify from that FTP server.

This is how you do it with the Excelify.io app.

Steps to schedule import from FTP

  1. Prepare your FTP URL to the import file.
  2. Paste the URL into the Excelify.io app.
  3. Verify that the app has found the file and sees its contents.
  4. Schedule to import it at regular intervals.

1. Prepare your FTP URL to the import file

We will do that with our Demo import file.

Here I have uploaded our demo file to the FTP server /data directory:

Uploaded Shopify import file to FTP serverFor the sake of example, let’s assume that your:

  • FTP server address is: ftp.my-data-server.com
  • FTP user name is: master
  • FTP server password is: secure123
  • File is in the directory: /data
  • File name is: Shopify-Import-Demo.xlsx

Then the URL to access the file on that server is the following:

ftp://master:[email protected]/data/Shopify-Import-Demo.xlsx

Universally, you construct your FTP URL in the following form:

ftp://user:[email protected]/path/to/file.xlsx

2. Paste the URL into the Excelify.io app

Open the Excelify.io app, and paste the URL into the upload from URL box, like that:

Import to Shopify from FTP server URL - paste the URL

Then press the blue “Upload from URL” button to start the upload.

3. Verify that the app has found the file and sees its contents

If everything will connect as expected, you should see that the file got uploaded and the app will analyze its contents.

The successful result should look like this:

Successfully analyzed Shopify import file from FTP

If you just want to import it right away, you can press the Import button and it will start the import. Maybe it’s even the right thing to do for the first time – to test if your file is prepared well so that it imports without any issues.

But if you want to schedule repeated import from that file, then…

4. Schedule to import it at regular intervals

Press the Options button.

Then setup the checkboxes for regular import and set the time when to import, and when to repeat, at what intervals.

For example, this will import every day at 02:15 starting from today:

Shopify FTP schedule import optionsNotice that “Take import file from URL” has your file FTP URL.

The app will re-download the fresh file each time it will do the new auto-repeated import.

Now, press the “Schedule Import” button, and you are all set.

If you need to see the historical results of those scheduled and repeated imports, press the “History & Schedule” button.

You can also cancel your repeated imports from there.

Good to know

 

Tags can be merged, deleted or replaced

Shopify Add Tags

When you import the data, you can specify the “Tags Command” column for Products and for Customers.

By that you can tell the app, what to do with Tags you are importing:

  • MERGE: will add Tags to existing tags. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore it.
  • DELETE: will delete the Tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it.
  • REPLACE: will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use MERGE, it means that the app will need first to load existing tags which takes additional time.

If Tags Command is not set, the app will assume the REPLACE command by default.

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 Customers from Shopify

Shopify bulk delete Customers featured

So you are in this situation when you need to bulk delete Customers from your Shopify store.

You can do it with Excelify.io app like that:

1. Export all your existing Customers

In the Export section, click the Customers checkbox to export Customers. You can also include their addresses if you will need that data to select, which customers you need to delete.

Export Shopify Customers to Delete

2. Edit the Excel file to keep customers you need to delete

Make sure to remove all those customer rows from that Excel file, which you want to still keep in your store. So that your file contains only Customers you want to delete.

And then set the “Command” column to “DELETE” for all of them.

Like this:

Shopify Customer Delete command3. Import that file with the app

Shopify bulk delete customers result

That’s it – those customers will be deleted now.

Good to know

  • If any customer deletion will fail, then most likely that customer has an Order, and Shopify doesn’t allow to delete customers which have orders. To delete that customer, first, you need to delete their Order. You can bulk delete Shopify orders the same way too.
  • You can bulk delete any other Shopify items the same way, like: Products, Discounts, Pages, Orders, etc.