Story 29.1. Backend Workspaces & Dual-Sorting Logic

General info

We are introducing two sorting "Keys" (indexes) in the database so the Sales team can manage the "New In" color gradient independently from the "Featured" VIP list.

  • Key A (menu_order): Controls the global "New In" sort.

  • Key B (_featured_sort_index): Controls the sort of Starred items only.

User story

As a Merchandiser

I want to sort my "New In" items by color without being disrupted by "Price Drop" items (and vice versa)

So that I can maintain a perfect aesthetic feed while still highlighting important VIP bags in a separate view.

Acceptance criteria

ID

Scenario (Gherkin)

Screenshots / Wireframes

01

Scenario: Sorting in "New In" Workspace

Given The Admin is in the Product List

And The filter "New In / All" is selected

When The Admin drags and drops an item (e.g. a new upload)

Then The system updates the standard menu_order (Key A)

And This change does NOT affect the order inside the "Featured/Starred" view (Key B)

And If a new product is created OR comes back in stock, it automatically moves to position #0 (Top).

And Admin can “Star” ★ a bag to add it to the “Featured” Workspace

02

Scenario: Sorting in "Featured" Workspace

Given The Admin is in the Product List

And The filter "Starred★ Only" is selected

When The Admin drags and drops a Starred item

Then The system updates the _featured_sort_index (Key B)

And This change does NOT alter the menu_order (Key A) used for the “New In” sort.

03

Scenario: Pending Boost Queue

Given A product triggers "Price Drop", "Trending", or "Back in Stock"

When The event occurs

Then The item is added to a "Pending Boost" counter/list

And It is NOT automatically moved to the top of the frontend Featured view yet

And The Admin must click "Approve/Star★" to officially push it to the top of Key B.

And The Admin has an option to bulk edit “Add/Remove ★”

Bildschirmfoto 2025-12-04 um 11.59.53.png

Comments

Leave a Reply