[Bug]: Error trying to sort orders by: Total / Fulfillment status / Payment status

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

/