Collection merchandising for Shopify

Meet Colin,
your collection
merchandiser.

Build collections from what’s selling. Give profit contributors a better position. Turn the weekend into a different edit.

Ask about early access ↗

One collection. More commercial possibilities.

Japanese ceramics

Turquoise Twin Handle Vase
Turquoise Twin Handle VaseFind the opportunity
Indigo Serving Plates
Indigo Serving PlatesFollow weekly demand
Sand Glaze Tea Cups
Sand Glaze Tea CupsLead with profit

Illustrated recipes using our ceramics collection.

01 / Advanced Sort

Your best sellers.
By your definition.

Revenue, gross profit, recent momentum, or a deliberate mix of product groups. Give the first row a commercial job.

In this example, a high-revenue vase makes less gross profit than the tea cups. Switch to seven-day gross profit and Colin puts the cups first.

  • Choose rolling sales and profit windows
  • Build distinct product groups with Segment or multi-step ordering with Strategy
  • Apply the saved order during collection sync

Profit needs accurate costs and synchronized sales. Segment and Strategy require Part-time or Full-time.

Illustrated example

Revenue leaders ≠ profit leaders

Same products. A different commercial priority: rank by gross profit over the last seven days.

Revenue leaders ≠ profit leaders: compare states

Ordered by 7-day revenue

Turquoise Twin Handle Vase
Turquoise Twin Handle Vase$1,200 revenue · $180 profit
Indigo Serving Plates
Indigo Serving Plates$1,040 revenue · $520 profit
Sand Glaze Tea Cups
Sand Glaze Tea Cups$900 revenue · $630 profit

The biggest revenue item leads, even though it contributes the least gross profit.

Ordered by 7-day gross profit

Sand Glaze Tea Cups
Sand Glaze Tea Cups$630 gross profit
Indigo Serving Plates
Indigo Serving Plates$520 gross profit
Turquoise Twin Handle Vase
Turquoise Twin Handle Vase$180 gross profit

Tea cups move from third to first. The collection follows your profit priority.

Illustration using real product photos and example sales, costs, and stock. Your results use synchronized store data.

Seven more ways to use Advanced Sort

Open a recipe +
01Give rising products the first row

Sort by Sales growth (7d), descending, to put recent momentum ahead of lifetime popularity. Use synchronized sales data and keep inventory safeguards enabled.

02Reserve space for discoveries and proven sellers

With Segment, select four recently published products for the first group, then eight leaders by Revenue (7d). Place the remaining products afterward. Set claiming priority so overlapping products appear once. Segment requires Part-time or Full-time.

03Lead with products that still have a size run

Use Segment to put products with Size availability of at least 75% first, ordered by Revenue (30d). Follow with the remaining products. This uses distinct Size-option availability and requires a Part-time or Full-time plan.

04Stop one product type taking over the page

Use Strategy to group by product type, sort each group by Revenue (30d), and take round-robin batches from those groups. Configure Strategy on the collection or through ChatGPT. Requires Part-time or Full-time.

05Give deep-stock products their turn

Use Segment to select products with inventory above 50 and fewer than five units sold in seven days. Give that group a deliberate position and order the rest by recent revenue. Requires Part-time or Full-time.

06Refresh the first row without shuffling everything

Sort by Revenue (7d), then shuffle only the top eight products. The strongest recent performers retain the leading positions while their order changes when the sort runs.

07Rotate a curated edit

Use the Rotate action to cycle the leading four products when the collection syncs. Keep this as a rotation setup; it is separate from a multi-step Strategy.

Japanese ceramics collection overview in Colin
Inside Colin · collection overview before enabling automation Open full size ↗

02 / Populate by Colin

Build a collection
from what’s selling.

“At least ten sales this week, with stock to keep going.” That is a collection Colin can maintain as demand changes.

Combine recent sales, growth, gross profit, stock, and dates. Use grouped conditions and a top-N limit for a tightly selected edit.

Colin refreshes its own product block during sync. Other Shopify product sets can contribute alongside it.

Illustrated example

This week’s proven sellers

Units sold (7d) ≥ 10 AND inventory ≥ 20. Membership follows recent demand and available stock.

This week’s proven sellers: compare states

Three products to consider

Turquoise Twin Handle Vase
Turquoise Twin Handle Vase4 sold · 35 in stock
Indigo Serving Plates
Indigo Serving Plates26 sold · 64 in stock
Sand Glaze Tea Cups
Sand Glaze Tea Cups18 sold · 42 in stock

A broad ceramics selection says nothing about what is selling this week.

Two products qualify

Indigo Serving Plates
Indigo Serving Plates26 sold · 64 in stock
Sand Glaze Tea Cups
Sand Glaze Tea Cups18 sold · 42 in stock

Plates and cups qualify. The vase has only four weekly sales. Colin refreshes this product block during sync.

Illustration using real product photos and example sales, costs, and stock. Your results use synchronized store data.

Seven more ways to use Populate by Colin

Open a recipe +
01The top 20 revenue makers this month

Require active, in-stock products. Select the top 20 by Revenue (30d). Colin refreshes the membership at sync, so the collection follows the current sales window.

02Rising stars with enough stock to feature

Combine positive Sales growth (7d), at least ten Units sold (7d), and inventory of 20 or more. Limit the result to 12, ordered by growth.

03Back in stock and already moving

Combine a recent Restocked date, in-stock status, and at least five Units sold (7d). Keep a focused selection ordered by recent revenue; restock history must be available in Colin.

04Full-price profit contributors

Require Discounted = No and in-stock status, then select the top 24 by Gross profit (30d). Keep product costs current so the profit data is meaningful.

05Deep stock, slow week

Require inventory of at least 50 and fewer than five Units sold (7d). This makes a working collection for a clearance edit without adding sale prices or discounts.

06New arrivals that have earned a place

Combine a recent Published date with at least three Units sold (7d). Use a top-12 limit ordered by recent revenue to build a collection of new products with demonstrated demand.

07Bestsellers or promising newcomers

Use grouped conditions: in stock AND either at least 20 Units sold (30d), OR a recent Published date with at least three Units sold (7d). One Colin product block can follow both paths.

03 / Campaigns and Schedules

A weekend sale.
A different collection.

Keep everyday markdowns outside your regular edit. When the weekend window opens, include them, send them to the top, and give the collection its sale title.

Use a Calendar Campaign for specific dates, or a Schedule for Saturday and Sunday windows. Here, each day runs from 09:00 to 23:00.

This recipe targets the Colin product block. “Discounted” identifies products with a compare-at markdown. Colin does not set sale prices.

Illustrated example

Colin’s weekend sale

Saturday & Sunday, 09:00–23:00: change the selection, promote existing markdowns, and rename the collection.

Colin’s weekend sale: compare states

Japanese ceramics

Turquoise Twin Handle Vase
Turquoise Twin Handle Vase$300 · full price
Sand Glaze Tea Cups
Sand Glaze Tea Cups$50 · full price
  • Colin condition: Discounted = No
  • Existing compare-at markdowns excluded
  • Regular collection sort

Japanese ceramics — Weekend sale

Indigo Serving Plates
Indigo Serving Plates$40 · compare-at $50 · 20% off
Turquoise Twin Handle Vase
Turquoise Twin Handle Vase$300 · full price
Sand Glaze Tea Cups
Sand Glaze Tea Cups$50 · full price
  • Remove the Discounted = No condition
  • Include markdowns and send discounted products to the top
  • Add “— Weekend sale” to the title

Japanese ceramics

Turquoise Twin Handle Vase
Turquoise Twin Handle Vase$300 · full price
Sand Glaze Tea Cups
Sand Glaze Tea Cups$50 · full price
  • Colin condition: Discounted = No
  • Existing compare-at markdowns excluded
  • Regular collection sort

After each daily window, restore the supported Campaign-owned conditions, sort strategy, and title.

Illustrated recurring Schedule on a Colin product block. Markdown prices already exist in Shopify; Colin changes merchandising, not prices. Other product sets remain independent.

Seven more ways to use Campaigns

Open a recipe +
01A lunch-break edit every weekday

Use a Monday–Friday Schedule from 11:00 to 14:00. Temporarily change the Colin product block to in-stock products priced below $30 with recent sales, sort by Revenue (7d), and append “— Lunch break” to the title.

02Launch night, then back to the regular edit

Use a bounded Calendar Campaign for the launch evening. Temporarily broaden the Colin conditions to include the launch products, prioritize new arrivals, and add a launch suffix to the title.

03A payday premium edit

Choose specific payday dates in a Calendar Campaign. Temporarily select in-stock products above your chosen price threshold and rank them by Gross profit (30d). Restore the supported Campaign-owned settings at the end.

04The last shipping days before a holiday

During your chosen shipping-cutoff dates, feature products you have tagged as ready to ship, require stock, and order by recent sales. Colin follows your product data; it does not calculate or guarantee delivery dates.

05A quiet-hours clearance window

Schedule a daily 20:00–23:00 edit. Select products with deep inventory and low weekly sales, rank the existing markdowns first, and add “— Evening finds” to the title. Product prices stay as set in Shopify.

06Switch the seasonal collection on a date

Use a start-only Calendar Campaign to replace the targeted Colin conditions with the next season’s selection and update the title. The change stays applied because this Campaign has no end-time restoration.

07The weekend’s final-hour sale edit

Set a Sunday 18:00–22:00 Schedule that includes already-discounted products, orders by Discount percentage, and adds “— Last hours” to the title. Keep it separate from other Campaigns targeting the same settings.

Calendar Campaign dates editor
Calendar Campaign editor · unsaved example Open full size ↗
Recurring Schedule editor
Schedule editor · unsaved example, separate timing Open full size ↗
Add to title editor
Title editor · unsaved example Open full size ↗

04 / Product Catalog

Find the opportunity.
Make an edit from it.

Which products have plenty of stock but little recent demand? Which bring in profit? Which new arrivals are earning their place?

Bring the relevant columns together, filter the full catalog, and turn the answer into a saved Preset, a snapshot collection, or a collection Colin keeps updated.

Illustrated example

What needs a merchandising push?

Find products with at least 30 units in stock and fewer than five sales over the last seven days.

What needs a merchandising push?: compare states
Sample ceramics report · last 7 days
ProductStockSold
Twin Handle Vase354
Serving Plates6426
Tea Cups4218

Stock and sales are visible, but the products that need attention are mixed in with the winners.

Sample ceramics report · last 7 days
ProductStockSold
Twin Handle Vase354

The vase is the opportunity to investigate. Save this report as a Preset, or create a collection from the filtered view.

New collections start unpublished. Choose a snapshot or keep the Colin product block updated.

Illustrative report and figures. Catalog collection creation uses structured filters, ordering, and limits.

Seven more ways to use Catalog

Open a recipe +
01Find inventory that needs a plan

Filter inventory above 50 and Units sold (30d) below five. Show stock, weekly and monthly sales, and price together. Save the view as a Preset for the next merchandising meeting.

02See profit behind the revenue

Show Revenue (30d), Gross profit (30d), and unit gross profit. Order by gross profit to find a different set of leaders from a revenue-only report. Accurate costs matter.

03Check this week’s emerging winners

Filter positive Sales growth (7d) and a minimum weekly sales volume. Show inventory alongside the growth signal so a small spike does not automatically become a featured collection.

04Review the markdown shelf

Filter Discounted = Yes. Compare Discount percentage, stock, and recent revenue before choosing which existing markdowns to feature in a Campaign.

05Check whether new launches are moving

Filter by a recent Published date, then inspect Units sold (7d) and Revenue (7d). Save the columns and filters as a Preset for a repeatable launch review.

06Turn today’s edit into a snapshot

Set structured filters, order the matching products, and apply a product limit. Create a one-time collection from that Catalog view; it starts unpublished for you to review in Shopify.

07Turn a report into a living collection

From the same structured Catalog view, create a collection with “Keep this collection updated by Colin” enabled. Colin maintains its product block during sync. Publish the collection separately in Shopify.

Catalog search for ceramics showing product names and statuses
Inside Colin · real Catalog search; the report above uses illustrative figures Open full size ↗

05 / Shareable Lists

Define the group once.
Give it more places to work.

A weekly winners selection can belong in Gifts, Tableware, and Staff picks. Maintain one Shareable List and reuse the group across those collections.

Create the list from Catalog conditions. Colin reconciles its membership when Shareable Lists sync; Shopify propagates it to linked collections.

Illustrated example

One winners group. Three destinations.

Reuse in-stock products with at least ten weekly sales across compatible Shopify collections.

One winners group. Three destinations.: compare states

GiftsMaintain a weekly winners selection

TablewareRebuild the same selection

Staff picksRemember the third copy

Three separate selections for the same product group.

Indigo Serving Plates
Indigo Serving Plates26 weekly sales
Sand Glaze Tea Cups
Sand Glaze Tea Cups18 weekly sales
Weekly winners · Shareable ListUsed by Gifts · Tableware · Staff picks

Colin maintains the group. Linked collections reuse it and can keep their own other product sets and sorting.

Illustrative connections. Requires a Shopify plan that supports Shareable Lists; list capacity depends on your Colin plan.

Seven more ways to use Shareable Lists

Open a recipe +
01One launch group for several destinations

Combine a recent Published date, in-stock status, and at least three Units sold (7d). Create a Shareable List and reuse the products with early demand in New arrivals and your category collections.

02Reuse a full-price profit edit

Build a Shareable List with Discounted = No and a minimum Gross profit (30d). Use the group in several collections without maintaining a separate copy of its conditions in each.

03Keep restock discoveries together

Use recent Restocked date, in-stock status, and recent sales as the shared conditions. Reuse the group in discovery and returning-favorites collections.

04A common pool of proven gifts

Combine your gift tag, a price ceiling, and minimum Units sold (30d). Reuse that qualifying group across several gift collections; each destination can still have its own other product sets.

05Share a seasonal core

Combine a seasonal tag with stock and recent sales conditions. Link the resulting Shareable List wherever that same seasonal core belongs.

06Reuse a deep-stock opportunity group

Select products with substantial inventory and low recent sales. Share the group across the collections where your team wants to give those products more exposure; this does not change their prices.

07Separate shared membership from local ordering

Reuse one Shareable List across two collections, then give each destination its own Advanced Sort. The product group is shared; the merchandising order belongs to each collection.

06 / Colin in ChatGPT

Talk merchandising.
Right in ChatGPT.

“Give me a stronger first row.” “Keep this collection focused on weekly winners.” “Make it a sale edit this weekend.” Work through the idea with Colin in the same conversation.

ChatGPT can work with Colin’s collection conditions, Advanced Sort, Campaigns, and Shareable Lists through MCP. The configured rules keep running in Colin.

Requires Colin Agent Access and a compatible ChatGPT plan/workspace. Available actions and plan limits still apply.

A weekly winners editChatGPT + Colin
You

Keep Japanese ceramics focused on what sold this week, with enough stock to feature.

Colin

How about at least ten units sold in seven days and at least 20 in stock?

You

Yes. And put the strongest profit contributors first.

Colin

Use those sales and stock conditions for the Colin product block, then order the collection by seven-day gross profit.

Illustrative conversation, not a live transcript. Example thresholds can be adjusted to your store.

Seven more ways to use Colin in ChatGPT

Open a recipe +
01Build a top-20 monthly revenue edit

You: “For Japanese ceramics, keep the 20 strongest monthly revenue products that are in stock.”

Colin: “Use In stock = Yes with a top-20 limit ordered by Revenue (30d) for the Colin product block. Membership will refresh during sync.”

02Describe the mix you want on the first page

You: “Lead with four new arrivals, then eight products with the strongest weekly revenue, then everything else.”

Colin: “That fits a Segment: new arrivals first, weekly revenue leaders next, and a remaining-products group.” Requires Part-time or Full-time.

03Plan the weekend sale in one conversation

You: “On Saturday and Sunday, include our existing markdowns, move them first, and call this Japanese ceramics — Weekend sale from 09:00 to 23:00.”

Colin: “That is a recurring Schedule with condition, sorting, and title changes for that daily window.”

04Change the focus from revenue to profit

You: “This collection should lead with monthly gross-profit contributors.”

Colin: “Use Gross profit (30d), descending, as its Advanced Sort field. The result depends on synchronized sales and product costs.”

05Give an existing Campaign a different window

You: “Move our ceramics sale to 10:00–22:00.”

Colin: “Which ceramics Campaign do you mean?”

You: “The weekend one.”

Colin: “Keep its merchandising changes and update the Schedule window.”

06Create a reusable group

You: “Make a Shareable List of in-stock products with at least 20 sales in the last 30 days.”

Colin: “Use In stock = Yes and Units sold (30d) ≥ 20. The list’s membership will be reconciled when Shareable Lists sync.”

07Apply the settings you have already chosen

You: “Sync Japanese ceramics now.”

Colin: “I can queue a managed collection sync to apply its enabled population and sorting.” The conversation reports queue or completion status from the actual response.

Choose Colin’s workload

Start focused.
Give him room to grow.

Choose capacity for the collections you want Colin to maintain. All three public plans include Campaigns, Advanced Sort, Populate by Colin, and Catalog.

A managed collection has Advanced Sort or Populate by Colin enabled. A daily sync slot is a scheduled time for collection updates.

Intern

$9/month

10 managed collections
  • 2 Shareable Lists
  • Sort up to 1,000 products per collection
  • 1 daily sync slot
Ask about early access
Full-time

$99/month

200 managed collections
  • 20 Shareable Lists
  • Sort up to 10,000 products per collection
  • 2 daily sync slots; Segment and Group by Tags
Ask about early access

USD monthly pricing with a seven-day trial. Shopify determines final billing and trial eligibility.

Colin’s Shopify App Store listing is coming soon. Questions about early access? Email colin@ramiapps.com.

Before you hire Colin

A few practical questions.

Where should I start?

Choose a collection and a commercial goal: feature recent profit contributors, build a weekly bestsellers selection, or plan a weekend sale. Start with the matching recipe above and adapt its thresholds to your store. The in-app Learn course walks through these tools.

Does Colin replace my Shopify conditions?

No. Collections can combine Shopify product sets with a Colin product block. Colin updates the product block it owns; Campaign condition changes target the selected supported source.

Are changes instant?

Saved configuration and applied changes are different. Collection syncs apply enabled population and sorting strategies; Campaigns run at their configured times. Check sync and Campaign activity rather than assuming a save has changed Shopify.

Does every Campaign restore the collection?

No. Restoration applies to supported settings in bounded Campaigns. It is not a whole-collection rollback, and activation-only Campaigns have no end-time restoration phase.

Do I need ChatGPT or AI?

No. Colin’s merchandising follows the rules, store data, and schedules you configure. ChatGPT and Claude are optional ways to communicate with Colin.

What counts as a managed collection?

A collection where Advanced Sort or Populate by Colin is enabled. A snapshot collection created once from Catalog does not consume managed-collection capacity.

Your collection merchandiser

One collection is
a good place to start.

Tell us what you’d like Colin to take care of. Email colin@ramiapps.com about early access.

Ask about early accessRevisit the ceramics example