Implement Sorting for Products API

[Alexandrbig1]

Priority: Medium
Difficulty: Advanced
Type: Backend Feature

---

Description

Enhance the Products API to support sorting via query parameters.
Currently, sorting is done in the frontend. This task adds backend-side sorting for scalability and performance.

---

Requirements

1. Endpoint Update

   • Update GET /api/products to accept a sort query parameter.
   • Supported values:
     • best_selling (default).
     • a_z (alphabetical ascending).
     • z_a (alphabetical descending).
     • price_asc (low to high).
     • price_desc (high to low).
     • rating_asc.
     • rating_desc.

2. Database Query

   • Use Mongoose’s .sort() to return products in the requested order.
   • Ensure products are still filterable by category/goals/etc.

3. Error Handling

   • If invalid sort parameter is provided, fallback to default (best_selling).

---

Acceptance Criteria

• GET /api/products?sort=price_asc returns products sorted by ascending price.
• All 7 options are supported.
• Invalid options gracefully fallback.

[shiv7shukla]

@Alexandrbig1 I would like to work on this. Please assign it to me.

[Alexandrbig1]

@shiv7shukla, thanks for your interest. Have you experienced working on the backend? It's an advanced task.

[shiv7shukla]

@Alexandrbig1 I have worked on the backend. However I have to brush up my mongoose skills so, if you assign the task to me I can complete in 3 days maximum. And thanks for merging my PR :)

[Alexandrbig1]

@shiv7shukla, assigned. If you have any questions, feel free to ask. Thanks for your contributions!