How to bulk delete Redirects from Shopify

Bulk Delete Redirects

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:

Import Redirects into Shopify Store

Import Redirects

In this tutorial, you will learn how to import redirects into your Shopify store.

Those are also known as 301 Redirects – they tell the browser that the URL has permanently moved to another URL.

Steps to import redirects:

  1. To import redirects, create new Excel file and copy column names from the Excelify template file Redirects sheet.
  2. Leave ID column empty, fill in Path column with URLs you want to redirect from, Target column with URLs you want to redirect to, set Command column values to NEW.
  3. Rename the Excel file sheet (tab) to “Redirects” so that the Excelify app knows what’s inside that sheet.
  4. Import the new Excel file to Shopify using the Excelify app.

When do you need Redirects?

  • The typical reason for making redirects – when you are migrating from your old eCommerce Platform to Shopify. Usually, search engines have indexed your old URLs and it takes time to reindex your new site, so visitors will still be sent to your old URLs. Your domain will remain the same, but the path to products or pages will be completely different. Customers also might have saved those URLs in their bookmarks, or there may be precious “backlinks” referring to your site which you don’t want to get the 404 error that page is not found – you want them still to get to the new correct page.
  • Another case for using redirects is, when you changed handles of the products, collections or pages, or any other items, but URLs with old product handles are still in place. To make those URLs working, you can add redirects from URLs with old handles to URLs with new handles, for example, redirect from https://yourdomain.myshopify.com/products/old-product-handle to https://yourdomain.myshopify.com/products/new-product-handle.

Good to know:

Migrate Blog Posts from WordPress to Shopify

Blog Posts - WordPress to Shopify

This video tutorial shows you step by step instructions how to migrate your Blog Posts (Articles) from WordPress to Shopify Blogs.

Steps to migrate articles from WordPress to Shopify:

  1. Go to your WordPress site, and install the Plugin: All Export.
  2. Export all your WordPress blog posts using “All Export” plugin to the CSV file.
  3. Open the CSV file, save it as Excel file.
  4. Rename the Excel file sheet (tab) to “Blog Posts” so that the Excelify app knows what’s inside that sheet.
  5. Set the column titles of the columns you want to import – copy column names from the Excelify template file.
  6. Import the new Excel file to Shopify using the Excelify app.

 

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!

 

How to import Shopify CSV file with Excelify app

Import csv file into Shopify with Excelify

You may need to import Shopify CSV file into your Shopify Store. You can easily do it with Excelify App. This is better, to export Products from your Shopify store into Excelify format and then import that file (especially because in any paid plan you have additional store included), but in case you have already Shopify CSV file with your products data, you can import it straight away.

All you need to do is:

Import Shopify CSV file with Excelify app

Open Excelify application. Go to import. Upload your Shopify .csv file. And press Import.

Import csv file into Shopify with Excelify

That’s all. Products are imported:

Import Shopify csv with Excelify app

You may also compress the file, if needed and upload and import .zip file:

Import compressed Shopify CVS file

Good to know

  • At the moment it is possible to import only Products from Shopify .CSV file
  • Excel file format is limited to 1 million rows. In case your store has more then 1 million product variants, this is very useful to use .CSV format. You also can export your products to Excelify CSV format, following this tutorial.

Rearrange Product Variant Positions

Shopify Product Variants

To rearrange Shopify product variants:

  1. Export Products + Inventory / Variants (without images or Metafields)
  2. Find the column “Variant Position” and change the numbers as you like them to be. (no need to change the row order, just change the numbers)
  3. You could just import that same file back but it will update all the columns that you import. So, to make the import smaller and quicker, and to update just the positions and nothing else, you can select just the following columns:
    • ID
    • Handle
    • Variant ID
    • Variant Position
  4. Copy those columns to new empty Excel file.
  5. Set the name of the sheet “Products” (so that the app knows that those are the Products data there).
  6. Import that file. It will just update the variant positions of those variants.

You can, of course, import only the product rows that you really want to change. No need to import all the products back.

See the full tutorial in the video.

How to remove duplicates from Shopify store

Remove duplicates

To see how to remove duplicated Products from your Shopify store, watch this video or read on.

How to remove duplicate Products from your Shopify store?

So you have this store with your products duplicated for some unfortulate chain of events.

Shopify store with duplicate products

1. Export your Products to Excel file – without any variants or images, just plain Products

This will give you one row per product.

Export only Products from Shopify

 

2. Sort your exported Excel file by two columns at the same time: Title, Handle

Take your exported file, open it.

Use the Excel “Sort” feature to sort by two columns at the same time:

  • Title
  • Handle

This will make all the same titles get together one after the other. And then it will sort those same Titles by Handle – in such a way that your correct product will be the always the first one.

If you have another reason for duplication and you don’t have equal titles then you still can find other factors that could allow you to sort all the rows so that the correct one is always the first one.

Sort exported Products by Title and by Handle

3. Make the formula that will show TRUE for duplicated row of the same title, and FALSE for the first one

Now that all your duplicate rows are nicely sorted together with the first row as the correct one, you can proceed to mark – which ones you want to keep, and which to delete.

Add new column with name “Duplicate?” and put the following formula in the row 2 there:

=IF(D2=D1,TRUE,FALSE)

Excel Formula to mark the duplicates

Copy this formula all the way down.

4. Filter Excel rows to show only the duplicate rows

Set the filter to keep only those rows where “Duplicate?” equals TRUE.

Filter Excel to show only duplicates

5. Copy the columns ID, Handle and Command to the new clear sheet

Select the A, B, C columns and copy filtered values to a new clear file.

Then set the name of the sheet to “Products” so that the app knows that those are Products in this sheet (double-click the “Sheet1” to rename it).

And then change the Command column value to “DELETE” for all those copied products.

Result should look like this:

Copy duplicate products to new Excel sheet and set to delete

6. Import that file with Excelify app

Upload that file to Excelify app and press “Import” button.

Watch your duplicate products get deleted.

Excelify results of deleted duplicates

See in your Shopify Admin – and be pleased by the result that all the duplicates are now gone, and you have just one copy of each product.

It should look like this now:

Shopify store with duplicates removedGood to know

  • You can de-duplicate also Collections, Customers, Pages, Orders, or anything else – the same way.
  • If you have the export file with Variants, just first copy your ID, Handle, Command, Title columns to new sheet and use Excel function “Remove Duplicates” – then you will have just one row for each product. And then you can use this tutorial from there.
  • If you have more advanced situation, our Support can help you remove duplicates.

 

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.

 

Schedule import to Shopify from Google Sheets

Google Sheets to Shopify

Importing from Google Sheets is a bit different than importing from a file that is saved on Google Drive, that’s why we will look at it as a separate tutorial.

If you want to import Excel or CSV files that are stored on Google Drive, read this tutorial: Schedule import to Shopify from Google Drive.

Steps to import file from Google Sheets to Shopify

  1. Prepare your Google Sheet on your Google Docs account.
  2. Make that Google Sheet viewable from a public link.
  3. Paste your Google Sheet link in the app.
  4. Schedule the regular import from that Google Sheet URL.

1. Prepare your Google Sheet on your Google Docs account

Your Google Sheets document needs to be prepared in the same manner as the “Excelify: Excel” file – with the sheet names, and columns that are understandable by “Bulk Import Export Update with Excel” app.

Basically, it will look like this:

Google Sheet to Shopify import - prepare Google Sheet

2. Make that Google Sheet viewable from a public link

Press the “SHARE” button and make the publicly shareable link to this Sheet.

You just need to give it permission “Anyone with the link can view” – no need for a write permission.

Copy that link.

Google Sheet to Shopify import - share the sheet as view only

3. Paste your Google Sheet link in the app

Open the “Bulk Import Export Update with Excel” app in your Shopify store, install it if you haven’t already.

Scroll down to the “Import” section, and paste the URL there.

Google Sheet to Shopify import - paste the URL in the app

Then press the blue “Upload from URL” button – so that the app can upload the file and analyze it.

Don’t worry – it will not import that just yet, you will need to set additional options first.

4. Schedule the regular import from that Google Sheet URL

After the app has finished uploading and analyzing the file, you will see the “Options” button there.

Press that button and set up the import options – the scheduled time for your next import in your Shopify store time zone.

And repeating time interval.

Your eventual options will look like this:

Google Sheet to Shopify import - setup options to schedule and repeat import

Notice the “Take import file from URL” – that is pointing to your Google Sheet. The app will download the fresh file each time it repeats the import.

Now, press the “Schedule Import” button.

It will schedule the import and if the date and time for the first import have already passed, then the app will start the first import shortly after you schedule it.

Good to know

  • You can see the progress of all your scheduled imports and exports in the “History & Schedule”. You can also cancel any of those jobs from there. You can download the import results file from there, too.
  • The scheduled time is in your Shopify store time zone.
  • You can also schedule import files to Shopify store from FTPDropbox or Google Drive the same way.
  • You can also import files from Google Sheet manually – by just pasting that Google Sheet link.
  • Import, not just Products data – import and update any of supported by Excelify.io formats.

Schedule import to Shopify from Google Drive

Google_Drive

You can sync your files with Google Drive, and in this tutorial, you will see how to seamlessly upload and import that file into your Shopify store – every day, automatically.

It basically means that the app will use the file that is on your computer and import it daily to Shopify. Thanks to the Google Drive file syncing.

To sync files on your computer with Google Drive, you need to install the “Backup and Sync” app, provided by Google.

It will import any of the supported Excelify.io formats.

To import the Google Sheet directly, read this tutorial: Schedule import to Shopify from Google Sheets.

Steps to import file from Google Drive to Shopify

  1. Sync your file to Google Drive.
  2. Copy Google Drive public shared link.
  3. Paste your Google Drive link in the app.
  4. Schedule the regular import from that Google Drive URL.

1. Sync your file to Google Drive

When you have successfully set your synchronization of files from your computer to Google Drive, you should see your file on your https://drive.google.com.

Locate it in your Google Drive folder and see that it’s really there.

Make sure that any changes you make to it on your computer, is really synced to the cloud.Sync Shopify from Google Drive - make sure Excel file gets synced

2. Copy Google Drive public shared link

Right-click mouse on that file, and choose the “Get shareable link“.

That will generate a unique public link that points to this file.

Copy that link.Sync Shopify from Google Drive - get shareable link

3. Paste your Google Drive link in the app

Open the “Bulk Import Export Update with Excel” app in your Shopify store, install it if you haven’t already.

Scroll down to the “Import” section, and paste the URL there.

Sync Shopify from Google Drive - paste the URL into the import appThen press the blue “Upload from URL” button – so that the app can upload the file and analyze it.

Don’t worry – it will not import that just yet, you will need to set additional options first.

4. Schedule the regular import from that Google Drive URL

After the app has finished uploading and analyzing the file, you will see the “Options” button there.

Press that button and set up the import options – the scheduled time for your next import in your Shopify store time zone.

And repeating time interval.

Your eventual options will look like this:Sync Shopify from Google Drive - setup the schedule and repeating

Notice the “Take import file from URL” – that is pointing to your file in the Google Drive. The app will download the fresh file each time it repeats the import.

Now, press the “Schedule Import” button.

It will schedule the import and if the date and time for the first import have already passed, then the app will start the first import shortly after you schedule it.

Good to know

  • You can see the progress of all your scheduled imports and exports in the “History & Schedule”. You can also cancel any of those jobs from there. You can download the import results file from there, too.
  • The scheduled time is in your Shopify store time zone.
  • You can also schedule import files to Shopify store from FTP and Dropbox the same way.
  • You can also import files from Google Drive manually – by just pasting that Google Drive link. That will make your file upload much faster because you will not need to upload the file from your own computer.
  • Import, not just Products data – import and update any of supported by Excelify.io formats.