Upload the Export to FTP directory

Shopify Export to FTP

You can make your Shopify export to send the exported file to an FTP directory.

That export can be scheduled and repeated at any needed time intervals.

The FTP address needs to be written in the following format:

ftp://user:[email protected]/path/to/directory/

If you need to have the specific file name for the exported file, you can set it in the Options field “Custom file name”.

 

Auto-repeat import or export by minutes

Schedule Shopify import export by minutes interval

Previously you could schedule the repeated import or export to Shopify only by hours, days, weeks, months, years.

Now you can also make them repeat by minutes (with 5-minute steps)

And if the previous job will not be finished when the new one is being started, the app will Cancel that new job, and retry on its next time interval.

You will receive an e-mail if the job will get dropped because the previous one is not finished.

How to bulk delete Redirects from Shopify

Shopify Redirects Bulk Delete

In this tutorial, you will learn how to bulk delete redirects from your Shopify store.

Steps to bulk delete redirects:

  1. Export Redirects from your Shopify using the Excelify app.
  2. Download exported Excel file and open it.
  3. Set Command column values to DELETE for those redirects you want to delete. Remove from the file all redirects that you do not want to delete or don’t want to change so that you import only those rows you want to change in some way.
  4. Save your file.
  5. Import the Excel file to Shopify using the Excelify app.

Good to know:

Export Collections as Product Columns

Export Shopify Product Collections

When exporting Shopify Products, you can mark to include additional columns of Collections where each product is listed in.

That will add two additional columns in the exported file:

  • Custom Collections
  • Smart Collections

Those columns will contain a comma-separated list of Handles of those Collections where this product is appearing.

If the cell is empty, that means that this product is not in any of the respective collections. You can use that to find out which product is not listed in any of collections.

For now, this data can only be exported.

Warning: including the Collections in the Products export, will make the product export much slower.

To import product into certain collections, please, use the following tutorials:

Exported columns will look like this:

Exported Products Collections

Export Summary sheet after the export

Export Summary sheet

When running the export, the exported file will contain the “Export Summary” sheet with the summary data about the export – what was exported, and what filters were used.

Also, the filters will reset after each export, so that you don’t have to clear them out each time.

Clone Shopify Blogs, Blog Posts (Articles) and their Comments to other store?

Shopify Blog Posts - Clone

This video will show you how to copy all your current Blogs, Blog Posts (Articles) and their comments to your new store.

This is needed when you are migrating to a new Shopify store, or when you need to set up the test/development store and want to use the data from your real store.

Summary of steps to clone your Articles:

  1. Install the Excelify app on both stores – old and the new one (get the second store for free, remember that you don’t have to pay for two stores here).
  2. Go to source store, select to export all Blog Posts, Blogs, Comments and Metafields (if you have those).
  3. When export is finished, download the exported Excel file.
  4. Go to the new store and upload the exported file.
  5. Press “Import”.
  6. Wait for import to finish.

Done!