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:

Import Redirects into Shopify Store

Shopify Redirects Import

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 or paths 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:

  • In the “Path” column you can put the whole URL with the domain like “https://yourserver.com/products/product-123“, or just the path, like “/products/product-123“.
  • Here you can find full documentation on redirects.
  • You may also want to read, How to Bulk Delete Redirects tutorial.

How to import large Shopify CSV file with the Excelify App

Import large CSV file to Shopify

Your supplier has given you the Shopify CSV file for importing, just there is one small issue – that CSV file is pretty large, but Shopify limits the import of CSV files to 15 MB.

The Excelify App comes to the rescue – with it you can import the same Shopify CSV file up to 2 GB in size.

All you need to do is:

Import Shopify CSV file with the Excelify app

1. Open Excelify application. Scroll to the Import section. Upload your Shopify .csv file:

Import csv file into Shopify with Excelify

2. Press Import and take a nap:

[image of the import progress]

3. Wake up. 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

  • You can zip that CSV file to make it smaller – and upload the .zip file.
  • Since Excel format has a limit of about 1 million rows, the Excelify has also its own “Excelify: CSV” format to work with really large data – with the same columns as “Excelify: Excel” format. You can export and import that format the same way as you do with Excel files. For more details about exporting to “Excelify: CSV” – follow this tutorial.
  • Read about all the formats you can import and export.

Create Smart Collections in bulk by Product Tags

Smart-Collections-with-Tags-rules

Smart Collections are collections where products are included according to some condition (rule). Those collections will be updated dynamically as soon as more products appear that match the condition.

You can create Smart Collections and include in those Products by their Tags, or any other Product fields like Vendor, Type, Price, etc.

To include products into Smart Collections by Product Tags with Bulk Import Export Update App. Follow these steps:

  1. Prepare the Excel file with Smart Collections by Product tag, according to the Excelify template
  2. Import created Excel file into your Shopify Store.

1. Prepare the Excel file with Smart Collections by Product Tag

Create Smart Collection by Product Tag

Basic fields that need to be filled are Title, Primary Row, Must Match, and Rules. In this tutorial, all products that have tag private or business jet will be included in the Smart Collection named Private and Business. So, there will be 2 rules defined – each of them in the separate row.

Decide if you want to include those products that have at least one of the tags (“private” or “business jet”), or the product should have both tags to be included in the Collection. If the value is set to any condition, all products with at least one of two tags will be included. If the value is set to all conditions, only those products that have both tags will be included.

In the Rule: columns I am setting the rules. For Tag property use Equals relation.

Remember to name the sheet as Smart Collections. Save the file.

 

2. Import created Excel into your Shopify store

Now let’s import this Excel document into the Store with Bulk Import Export Update App.

Import Created Smart Collection by Product Tags

 

Now you can see created Smart Collection under Products -> Collections.

Smart Collection With 2 Tag Rules

When clicking on the collection, you will see the products that are included.

Products in Smart Collection by Tag

 

Good to know:

  • You can export the Products that belong to the Smart Collection, by setting the “Collection” filter when exporting Products.
  • In Shopify you can create up to 5000 Smart Collections. This is what you also can bulk import with the Excelify.io app.
  • You can use other Product fields in conditions, like, Vendor, Type, Price, etc. Tags was just one example.
  • Read the full description of all fields of Smart Collection.

Schedule regular Product price update

Scheduled imports

You can schedule imports and updates to your Shopify store using Bulk Import Export Update app.

For the sake of example, in this tutorial, you will schedule Product price update twice per week – to have different prices during the weekend and working week. It will be done following these steps:

  1. Prepare import files.
  2. Schedule import with repeating.

1. Prepare import files

Export all products and variants (or, use filter and export only those that need to be updated regularly).

Then leave only the data that is relevant to the price update: ID, Handle, Variant ID and Variant Price.

Let this be a file for working day prices – so save it to the file “working day prices.xlsx”.Import Working Day Prices

Create the second file with the same products and variants, but different prices – for the weekend. Save the file with the different name “weekend prices.xlsx”:Import Weekend Prices

2. Schedule import with repeating

Now go to the App and upload the first file with weekend prices. Click Options section. Every Friday morning I would like to set Weekend prices.

There is a checkbox “Schedule import at” – switch it on and set the first date and time when import should be processed.

Then mark the next checkbox “Repeat every” as well and set the period of how often this file should be imported. If it is needed once per week, then set every 1 weeks. Then choose how many times to run this import – I am choosing to run until canceled. The import will repeat at the same time every week.

When all options are set, press “Schedule” button.

Schedule Weekend Import

Similarly, set the options for the second file – the working day prices. Set it to run every Monday morning at 1am:

Schedule Working Day Import

Now Scheduled imports are visible in the History and Schedule section:

Scheduled imports

 

Good to know

  • If there is a need to schedule import just once, use only Schedule import at section providing the date and time.
  • There are many variations of how often import can be repeated, for example, every 2 days, every 3 months (quarterly), every 6 months (semi-annually) etc.
  • Scheduled import can be repeated 2 – 99 times, or infinitely. It starts at 2 times because if you want it to repeat just one time then you don’t need to repeat it – you just schedule it to run once.
  • You can schedule Import and Export of products, collections, customers, discounts, orders, and pages, and any combination of those.
  • Scheduled imports and exports can be canceled in the “History & Schedule” page in case they are not needed anymore.

Hide out-of-stock Products from Shopify Store

Out of Stock Products

Sometimes you don’t want to show Products that are out of stock on your Shopify store.

Such products can be easily hidden using the property Published = FALSE, by the app. Let’s take a look at 3 cases:

  • if a Product has only one Variant and it is out of stock, then we will hide this Product;
  • if a Product has several Variants and only some of them are out of stock, we will not hide this Product. Customer will be able to see the Product and select Variants. If out of stock variant will be selected, the appropriate message will appear. Basically, we will not hide this product and any of its Variants;
  • if a Product has several Variants and all of them are out of stock, then we will hide this Product.

Let’s see how it is done, following these steps.

1. Export Products with Variants.

Export Products and Variants

Download and open the exported Excel file. There is Variant Inventory Qty column that contains data about Variant quantities.

Exported Products with Quantities

We need to know, what products to hide. This means we need to know what Products have all Variants with quantity equals 0.

We will find them with the help of Pivot table in the next step.

2. Find all out of stock products

In the Excel file go to Insert -> Pivot Table:

Insert Pivot Table

Click OK.

Drag and Drop field Handle to the Rows, field Variant Inventory Qty to the Values. Ensure, that there is Sum of Variant…  displayed in the Values (this means, that quantities of all Variants for particular Product Handle will be summed up).

Fill Pivot Table

Now we have a table of all Product Handles and Total Variant quantity.

Let’s sort this table by Sum of Variant Inventory Qty from Smallest to Largest:

Sorted Pivot Table

Now we have the Handles for all products that are out of stock and can import them into the Shopify Store with Published column value set to FALSE (this will unpublish your products from your sales channels).

3. Import out-of-stock Products as unpublished

You can create new Excel file. It should have only 2 columns: Handle and Published. Copy Handles of all products with Sum of Variants Inventory Qty that have 0 from the Pivot Table into column Handles. Put FALSE value for all products in the column Published. Remeber to name the Sheet Products.

Unpublished ProductsSave the file and import it with the app.

Import Out of Stock Products

Let’s check on the Store page:

Out of Stock Products are Hidden

5 products of 10 are displayed, as 5 were out of stock and are unpublished at the moment.

 

Good to know.

  • Remember to put Published = TRUE, when you have these Products back in Stock. You can do that in a very similar manner, just find all products with Sum of Variants Inventory Qty > 0 and import their Handles with Published = TRUE.

 

How to add Products to Shopify Custom Collections (also known as Manual Collections)

Added products into Custom Collection Admin

Shopify Custom Collections are most frequently used (also known as Manual Collections), although there are also Smart Collections (also known as Automatic Collections).

It is a better practice to use Smart Collections for grouping Products, as it is more dynamic and you don’t need to attach each product manually. But if defining rules for Smart Collection seem too complicated, or you need to have more than 5000 collections, then Custom Collections are a way to go. Shopify has a limit of 5000 Smart Collections, but no limit on Custom Collections.

In a Custom Collection, products are added manually by Product ID or Product Handle. Typically there are be two cases – 1: you want to create new Custom Collection and add products; or 2: when you want to add products to existing Custom Collection.

1. Create new Custom Collection and add Products to it

To create new Custom Collections with products, you need to know Product IDs or Product Handles for those products you want to add. Let’s get this data by exporting products with Excelify.io app. You might even not need to export any additional details about those products:

Export Products

When Products are exported, open the exported Excel file:

Exported ProductsNow I will create new Excel document. There will be only one Sheet, called “Custom Collections”.

As a bare minimum, you need only 4 columns in my Excel:

  • Title (Custom Collection Title)
  • Body HTML (Short description of the Collection. This column can be skipped if you don’t need a description)
  • Image Src (Image for the collection. Also can be skipped, but I want it to look nicer on the store page)
  • Product: Handle (Handles of the products I want to add to this collection).

You will have as many rows, as many Products you want to include into this Collection. And it is important to provide Title on each row, as this will tell the app that the Product will be included in this Collection. Take “Product: Handle” column values from the exported Product file.

Remember to call this Excel Sheet: “Custom Collections”.
New Custom CollectionNow I am importing this Excel file with the app:

Imported new Custom Collection

My Manual Collection is imported and I can check that in the Admin:

New Custom Collection in the Admin

 

2. Add Products to Existing Custom Collection

Here is the second case, when you already have Custom Collection and want to add additional products to it.

First of all, I will export my Products and Custom Collections with Linked Products with the app. It is good to export those both, because then you will have them both in the same file, and in Custom Collections you will see also “Product: Handle” values for existing products, not just the “Product: ID” values.

Export Products and Custom Collections

Download exported Excel file and open it.

Exported Products and Custom CollectionsThere are 2 products in the Collection “Our favourites”. I would like to add 3 more products to it. I will find their handles in the Products sheet and add 3 more lines for collection with the same ID and Handle values, so that app knows that those lines belong to the same Shopify manual collection.

Existing Custom Collection with New Products

To make it easier, you can just copy the previous row – to mark the spot for additional product in that manual collection.

Now I will delete Products sheet from this file because I don’t want to import products now – I want to import just Custom Collections. Save the file and import it into your Shopify Store with the app.

Imported products into Custom Collection

Let’s check in the Admin. There are 5 products now in the Custom Collection Our Favourites.

 

Good to know:

Bulk Delete Discounts from Shopify

Bulk Delete Discounts Tutorial

So you need to bulk delete Discounts from your Shopify store.

Here’s how you delete any Shopify Discount with Excelify.io app:

1. Export your existing Discounts from Shopify to Excel

Just click the checkbox for the Discounts and all your Shopify store Discounts will be exported to Excel.

Export Discounts

2. Edit exported Excel file to mark discounts you need to delete

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

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

Like this:

Discounts Delete Command
3. Import prepared file to delete those Discounts

Import Deleted Discounts
That’s it – those Discounts 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 Discounts, you might want to do the full export of all Discounts details to Excel file. You can keep that file for reference, or even restore deleted discounts later to your Shopify store if you need to.

 

Bulk Delete Pages from Shopify

So you need to bulk delete Pages from your Shopify store.

Here’s how you delete any Shopify Page with Excelify.io app:

1. Export your existing Pages from Shopify to Excel

Just check the checkbox for the Pages and all your Shopify store Pages will be exported to Excel.

Export pages

2. Edit exported Excel file to mark pages you need to delete

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

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

Like this:

Pages Delete Command
3. Import prepared file to delete those Pages

Import Deletes Pages
That’s it – those Pages 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 pages, you might want to do the full export of all Pages details to Excel file. You can keep that file for reference, or even restore deleted pages later to your Shopify store if you need to.

 

Bulk Delete Collections from Shopify

Bulk Delete Collections from Shopify Tutorial

So you would like to bulk delete Collections from your Shopify store.

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

1. Export all your existing Collections

Because there are two kinds of collections in Shopify: Smart and Custom, you can delete Collections of just one kind or both.

In the Export section, click the Smart Collections/Custom Collections or both checkboxes to Export needed Collections.

Export Collections from Shopify

2. Leave in Excel file only the collections you want to delete

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

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

Like this:

Delete Shopify Smart Collections

If you need to delete Collections of both kinds, pay attention, that there are two sheets in the Excel and add set the “Command” column to “DELETE” on both sheets.

Delete Shopify Custom Collections

3. Import that file with the app to delete collections

Bulk Delete Collections from Shopify with import

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

Good to know

  • You can bulk delete any other Shopify items the same way, like Products, Discounts, Pages, Orders, etc.
  • Before you delete Shopify Collections, you might want to do the full export of all Collections with the app. You can keep that Excel file for reference, or even restore deleted collections later to your Shopify store if you need to.
  • You can combine commands for the same import – delete some collections, but update other collections, and even create new collections, all at the same time.