Convert Automated Collections into Manual Collections in bulk

Shopify Collections

With the Excelify app, you can convert Smart Collections (Automated Collections) into Custom Collections (Manual Collections).
This can really come in handy when you have a lot of Smart Collections and Shopify limit of 5000 total Smart Collections is getting tight for you.

Steps in short

  1. Export Smart Collections.
  2. Update Handles in the exported file and import the file.
  3. Download previously exported file and import as Custom Collections.
  4. Download previously exported file and set to delete Smart Collections.
  5. Enjoy!

Warning: Don’t delete Smart Collections before you have imported Custom Collections, because if you will first delete Smart Collections, you will delete all their featured images as well.

1. Export Smart Collections

First, we will need to export all Smart Collections which will need to be turned into Custom Collections.

To do so you will need to go into the Excelify app and in the Export section of the app, you will need to select the checkbox “Smart Collections” with all sub-checkboxes.
Then select export format Excelify: Excel or Excelify: CSV. We strongly suggest using Excelify: Excel file format if exported data will not exceed any of known Excel limits.

Press the “Export” button to start the export.

1 - Export Shopify Smart Collections with Rules linked products and metafields

2. Update Handles in the exported file and import that file

Once the export will be finished you will see the “Download Exported File” button, click this to download the file.

2.1 - Update Shopify Collections Handles

Now we will need to change the Handle for existing Smart Collections so we can import Custom Collections with correct Handles (the same Handles as you had for your collections).
To do so we will rename the current “Handle” column to “Old Handle”:

2.2 - Update Shopify Collections Handles

Once that is done add a new column to the file and name it “Handle”. This will be the column with our new, temporary Handles.2.3 - Update Shopify Collections Handles

With the Excelify, if using Excel file you can also import a file that contains formulas so we will do that here to fast generate temporary Handles in the “Handle” column.
Let’s use a formula to add an ID to the current Handle. Since this is a temporary Handle then it does not matter what we add to it, as long as its different from the existing Handle.

=B2&A2

2.4 - Update Shopify Collections Handles with formula

 

Then select the cell with the formula and in the bottom right corner of the cell double-click on the small square to fill the rest of the file with this formula automatically.

2.6 - Update Shopify Collections Handles with excel

 

2.7 - Update Shopify Collections Handles with excel

Now we have filled the file with our new Handles so we can import save this file and import without any more edits.
Go into the Excelify app Import section, upload the file and press the “Import” button.
This import will update the Handles for your Smart Collections.

2.8 - Update Shopify Collections Handles in bulk with excel file

3. Download previously exported file and import as Custom Collections

While the import is running to update the Handles for your Smart Collections we can prepare the file to import our Custom Collections.

First, navigate back to the Export section of the app and download the exported file again so have a fresh file without any edits.
No need to start new export as our previously exported file has all the information.

In the file locate the sheet/tab name “Smart Collections” and rename to “Custom Collections“.
Nothing more needs to be edited.

3 - Import Shopify Smart Collections as Custom Collections

3.2 - Import Shopify Smart Collections as Custom Collections

Now, wait for the previous import to finish and once it’s done import this file to create Custom Collections.
Once the file is uploaded make sure that the app recognized the sheet as Custom Collections.

3.3 - Import Shopify Custom Collections in bulk

4. Download previously exported file and set to delete old Smart Collections

Now you have created the Custom Collections with all the items and images (because of the images we needed to first create Custom Collections and only then delete old Smart Collections).

Make sure that your new Custom Collections have all the images and products there.

The last step to do is to delete old Smart Collections.
To do this again download previously exported file from the Excelify export section without creating new export.

Since the Handles now are updated then to minimize the confusion we will delete all columns that we do not need. Here we only need the following columns:

  • ID
  • Command

4.1 - Delete Shopify Smart Collections in bulk

Once that is done we change the “Command” columns value to “DELETE” by filling it in the second row and double-clicking on the small square on cells bottom right corner.

4.2 - Delete Shopify Smart Collections in bulk

Make sure that the sheet name is “Smart Collections” as we will be deleting those.

Once that is done we again go into the Excelify Import section and assuming that the previous import is finished we upload the file.
Double check if the app understood that you are uploading Smart Collections and press the “Import” button.

4.3 - Delete Shopify Smart Collections in bulk

5. Enjoy!

Once the import will be finished all those Smart Collections will be deleted. Now you only have Custom Collections in your store so you are no longer affected by the Shopify 5000 Smart Collections limit.

What to do next?