Skip to main content

How to Convert a Shopify Smart Collection to a Manual Collection

Convert automated smart collections to manual collections to gain full control over which products appear in your collection.

Goal: Change a smart (rule-based) collection into a manual (hand-picked) collection. The collection keeps its current products, its ID, and its URL, and you can then add or remove products by hand instead of through rules.

Prerequisites:

  • You have Altera installed on your Shopify store

  • A smart collection: a collection whose products come from one set of rules

  • A spreadsheet app, such as Excel or Google Sheets

Step 1 - Export the collection with its products

In your Shopify admin, go to Products > Collections and open the collection that you want to convert. From the More actions menu, click Export with Altera. Altera opens the export page with the Collections data type and a filter for this collection.

Select the Basic Columns, Sources & Conditions, and Linked Products field groups. Linked Products adds one row for every product that is in the collection now. Click Start export and download the file when the export is complete. Keep a copy of this file, because it records the collection's original rules.

Step 2 - Copy the source ID

Open the file. The first rows of the collection show its rules in the Condition: Field, Condition: Relation, and Condition: Value columns. Copy the number in the Source: ID column. This number identifies the set of rules that you replace with hand-picked products.

Step 3 - Turn the product list into hand-picked products

Copy the Sort: Product Handle column into the Condition: Value column, so that each row names one product. Delete the rows that have no product handle in Condition: Value.

On every row, set Condition: Field to Manual Selection, Inclusion: Type to Include, Source: Type to Products, and Source: Command to REPLACE, and put the number from step 2 in Source: ID. Clear the Condition: Relation, Condition: Match, and Inclusion: Match cells, because hand-picked products do not use them.

Step 4 - Remove the columns that you don't need

Set Command to MERGE on every row. Then delete every column except ID, Handle, Command, Source: ID, Source: Command, Source: Type, Inclusion: Type, Condition: Field, and Condition: Value. Save the file.

MERGE updates the existing collection, and Source: Command set to REPLACE replaces the rules of that source with the products in your file. The collection's title, description, image, and SEO fields stay as they are.

Step 5 - Import the file

In Altera, click Upload file on the home page and select your file. Check that Altera detects the Collections data type, then click Start import.

Step 6 - Check the collection

When the import is complete, click the collection link in the import results to open the collection in your Shopify admin. The collection has no conditions, and it lists the products from your file as hand-picked products.

Outcome

Your collection now contains the same products as before, but they are hand-picked instead of added by rules. New products that match the old rules are no longer added automatically. The collection keeps its ID and URL, so menus and links to it still work.

Example

A file that converts the peak-performance collection, which had three products, looks like this:

ID

Handle

Command

Source: ID

Source: Command

Source: Type

Inclusion: Type

Condition: Field

Condition: Value

46193729812

peak-performance

MERGE

23778787514

REPLACE

Products

Include

Manual Selection

trail-runner-shoe

46193729812

peak-performance

MERGE

23778787514

REPLACE

Products

Include

Manual Selection

summit-jacket

46193729812

peak-performance

MERGE

23778787514

REPLACE

Products

Include

Manual Selection

alpine-backpack

Next Steps

Did this answer your question?