Type "mid-century walnut coffee tables" into Google and look at what ranks. It is not blog posts — it is category pages from furniture retailers, because someone searching that phrase wants to compare eight coffee tables, not read about them. Google matches query intent to page type, and for commercial queries with plural product nouns, the page type that wins is a collection.
That makes collection pages the natural rankers for the queries closest to money. A blog guide can win "how to choose a coffee table for a small living room", but "walnut coffee tables" belongs to a collection, and no amount of blog optimization changes that.
A quick decision rule: if the query implies browsing — a plural product noun, often with a material, style, or audience qualifier — target a collection. If the query asks a question or starts with "how" or "which", target a blog post. Most Shopify stores invest heavily in the second category and leave the first to whatever the theme generates by default, which is why collection page work is usually the cheapest win available.