How to sort products in a collection by meta-field value?

Topic summary

A user is migrating 1,000 products from WooCommerce to Shopify and wants to preserve the original product order. Their approach involves:

  • Adding the legacy index as a metafield to each Shopify product
  • Creating a collection and sorting by this metafield value

However, Shopify’s native sorting options are limited and don’t support custom metafield sorting, making manual arrangement of 1,000 products impractical.

Suggested solutions:

  • SortWise app: Provides advanced sorting and custom merchandising rules beyond standard Shopify capabilities
  • Matrixify app: Recommended as a third-party tool for handling this requirement

The discussion remains open with no definitive resolution on the best approach, though app-based solutions appear to be the primary workaround for Shopify’s native limitations.

Summarized with AI on October 23. AI used: claude-sonnet-4-5-20250929.

Hi,
I migrate my products from woocommerce site to a Shopify.
I have a 1k products to move, and wants to set the same order as the legacy.
I thought to add the index of the product at the legacy as a metafield to the shopify created product,
And create a collection for all the products and sort them by this index value.
However I see that the sorting option are very minimize, and I don’t want to sort 1k products manually.
There is a better solution under the hood?

Hey, just circling back on this for anyone still looking for a solution! If you need a robust app to handle advanced sorting and custom merchandising rules—giving you way more control over your collections than the standard Shopify options—definitely check out SortWise. We built it specifically to solve problems like this!

Hello,

As your requirement, I recommend you use the third party app to do this. You can try the Matrixify app.