[Bug]: Error trying to sort orders by: Total / Fulfillment status / Payment status · medusajs/medusa#15353

(1 comment) (0 reactions) (0 assignees)TypeScript (22,539 stars) (2,090 forks)batch import

good first issuetype: bugversion: 2.0

Description

Package.json file

{
  "dependencies": {
    "@fast-csv/format": "^5.0.5",
    "@fast-csv/parse": "^5.0.5",
    "@imgproxy/imgproxy-node": "^1.1.0",
    "@medusajs/admin-sdk": "2.13.6",
    "@medusajs/framework": "2.13.6",
    "@medusajs/medusa": "2.13.6",
    "@opentelemetry/api": "^1.9.0",
    "@opentelemetry/core": "^1.30.1",
    "@opentelemetry/exporter-trace-otlp-grpc": "^0.211.0",
    "@opentelemetry/sdk-trace-base": "^1.30.1",
    "@opentelemetry/semantic-conventions": "^1.39.0",
    "@sentry/node": "^10.45.0",
    "@sentry/opentelemetry-node": "^7.114.0",
    "@slack/webhook": "^7.0.8",
    "axios": "^1.15.2",
    "axios-ntlm": "^1.4.6",
    "basic-ftp": "^5.2.0",
    "chardet": "^2.1.1",
    "dayjs": "^1.11.20",
    "envalid": "^8.1.1",
    "express-rate-limit": "^8.3.1",
    "ioredis": "^5.10.1",
    "jsbarcode": "^3.12.3",
    "nanoid": "^5.1.7",
    "node-expat": "^2.4.1",
    "nodemailer": "^8.0.3",
    "pretty-ms": "7",
    "prom-client": "^15.1.3",
    "rate-limit-redis": "^4.3.1",
    "react-email": "^6.0.0",
    "react-to-print": "^3.3.0",
    "stack-trace": "^1.0.0-pre2",
    "stream-chain": "^3.5.1",
    "stream-json": "^2.0.0",
    "typesense": "^3.0.3",
    "winston-daily-rotate-file": "^5.0.0",
    "xml2js": "^0.6.2"
  },
  "devDependencies": {
    "@commitlint/cli": "^20.5.0",
    "@commitlint/config-conventional": "^20.5.0",
    "@medusajs/cli": "2.13.6",
    "@react-email/ui": "6.0.0",
    "@release-it/conventional-changelog": "^10.0.6",
    "@slack/types": "^2.20.1",
    "@swc/core": "^1.15.30",
    "@types/node": "^25.5.0",
    "@types/node-expat": "^2.3.5",
    "@types/nodemailer": "^8.0.0",
    "@types/react": "^19.2.13",
    "@types/stack-trace": "^0.0.33",
    "@types/xml2js": "^0.4.14",
    "commitizen": "^4.3.1",
    "concurrently": "^9.2.1",
    "cz-conventional-changelog": "^3.3.0",
    "husky": "^9.1.7",
    "lint-staged": "^16.4.0",
    "oxfmt": "^0.46.0",
    "oxlint": "^1.61.0",
    "oxlint-tsgolint": "^0.21.1",
    "react": "^18.3.1",
    "release-it": "^20.0.0",
    "ts-node": "^10.9.2",
    "tsc-alias": "^1.8.16",
    "typescript": "^5.9.3",
    "vite": "^5.4.21"
  }
}

Node.js version

v22.21.0

Database and its version

16, 17, 18

Operating system name and version

Fedora 43 / Debian 13

Browser name

No response

What happended?

I am unable to sort orders by fields mentioned in title on admin orders table, there is possibility that sorting by other keys also do not work.

Expected behavior

It should sort orders just like it is doing with date of creation, custom display id.

Actual behavior

It errors and does not complete request to sort orders.

error:   Trying to order by not existing property Order.total
{
  message: 'Trying to order by not existing property Order.total',
  name: 'Error',
  stack: 'Error: Trying to order by not existing property Order.total\n' +

Link to reproduction repo

Contributor guide

Tech stack: typescriptnodejssql
Domain: backendapi
Issue type: bug
Difficulty: 3
Estimated time: half day
Activity status: fresh
Clarity: clear
Prerequisites: Basic understanding of MedusaTypeScriptMedusa Order module
Newbie friendliness: 55
Research direction: The error indicates that sorting by 'total' fails because 'Order.total' is not a recognized property. This suggests that the sorting logic for orders is defined in a configuration or query builder that only allows specific fields. Investigate the Medusa order service (e.g., packages/medusa/src/services/order.ts or similar) to find the list of allowed sortable fields. Also check if 'total', 'fulfillment status', 'payment status' are computed or require joins; if so, they need to be added to the sortable list with appropriate database column references. Look at the error stack trace in the issue comments for exact file paths.