Sellasist MCP by usefulapi

List orders, newest first, with status, buyer billing address, payment, total, source (Allegro, eBay, Amazon, shop...) and comment. Filter by status, email, name, external id, payment, source or date. Use sellasist_get_order for line items and shipments. GET /orders.

{
  "type": "object",
  "properties": {
    "status_id": {
      "description": "Order status id - see sellasist_list_order_statuses.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "email": {
      "description": "Exact buyer email.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "email_contains": {
      "description": "Buyer email starting with this text.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "first_name": {
      "description": "Buyer first name (billing address, LIKE match).",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "last_name": {
      "description": "Buyer last name (billing address, LIKE match).",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "external_id": {
      "description": "The order id in the shop or marketplace it was imported from.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "exact_date": {
      "description": "Orders placed on exactly this date (YYYY-MM-DD).",
      "type": "string"
    },
    "date_from": {
      "description": "Orders placed at or after this date.",
      "type": "string"
    },
    "date_to": {
      "description": "Orders placed at or before this date.",
      "type": "string"
    },
    "payment_status": {
      "description": "Payment status.",
      "type": "string",
      "enum": [
        "paid",
        "unpaid",
        "excess",
        "partial",
        "returned"
      ]
    },
    "payment_id": {
      "description": "Payment method id - see sellasist_list_payment_methods.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "shipment_id": {
      "description": "Delivery method id - see sellasist_list_shipment_methods.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "currency": {
      "description": "Currency code, e.g. PLN.",
      "type": "string",
      "pattern": "^[A-Za-z]{3}$"
    },
    "source": {
      "description": "Order source.",
      "type": "string",
      "enum": [
        "allegro",
        "ebay",
        "arena",
        "ceneo",
        "extsources",
        "amazon",
        "empik",
        "shopee",
        "erli",
        "wms",
        "marketplace",
        "baselinker"
      ]
    },
    "from_id": {
      "description": "Only orders with an id greater than this.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "sort": {
      "description": "Sort by id, default desc (newest first).",
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

One order by id: status, buyer and delivery address, payment, shipment method, line items (product ids, EAN, quantities, prices), notes, waybills with tracking numbers, payments and additional fields. GET /orders/{order_id}.

{
  "type": "object",
  "properties": {
    "order_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Sellasist order id (the id from sellasist_list_orders, not the marketplace's number)."
    }
  },
  "required": [
    "order_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Find up to 100 orders created in a date range and/or in one status (id, date, status). Read-only: it uses POST only because the criteria go in the body. POST /orders_search.

{
  "type": "object",
  "properties": {
    "creation_date_from": {
      "description": "Created at or after this date.",
      "type": "string"
    },
    "creation_date_to": {
      "description": "Created at or before this date.",
      "type": "string"
    },
    "status": {
      "description": "Order status id - see sellasist_list_order_statuses.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "order_id_from": {
      "description": "Start from this order id (for the next batch, pass the last id returned).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

The order statuses configured in the account. Use the ids to filter orders or to change a status. GET /statuses.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Notes written on one order (author id, date, text, visibility). GET /notes/{order_id}.

{
  "type": "object",
  "properties": {
    "order_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Sellasist order id."
    }
  },
  "required": [
    "order_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

The audit log of order actions (create, edit, status change, delete, merge, invoice and receipt actions) with date and user id. Filter by order ids, action type or date. GET /orders_logs.

{
  "type": "object",
  "properties": {
    "orders": {
      "description": "Only these order ids.",
      "minItems": 1,
      "maxItems": 50,
      "type": "array",
      "items": {
        "type": "integer",
        "exclusiveMinimum": 0,
        "maximum": 9007199254740991
      }
    },
    "operation_tag": {
      "description": "Only this kind of action.",
      "type": "string",
      "enum": [
        "order_create",
        "order_edit",
        "order_position_edit",
        "order_status_change",
        "order_delete",
        "order_merge",
        "invoice_create",
        "invoice_edit",
        "invoice_remove",
        "receipt_create",
        "receipt_edit",
        "receipt_remove"
      ]
    },
    "date_from": {
      "description": "Actions at or after this date.",
      "type": "string"
    },
    "date_to": {
      "description": "Actions at or before this date.",
      "type": "string"
    },
    "sort": {
      "description": "Sort order (asc or desc).",
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Waybills (shipping labels) with order id, tracking number, creation and delivery date. Filter by order or date. Label files are not returned inline. GET /ordersshipments.

{
  "type": "object",
  "properties": {
    "order_id": {
      "description": "Only waybills of this order.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "date_from": {
      "description": "Created at or after this date.",
      "type": "string"
    },
    "date_to": {
      "description": "Created at or before this date.",
      "type": "string"
    },
    "sort": {
      "description": "Sort order (asc or desc).",
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

List products with id, name, EAN, symbol, catalog number, location, price, promo price, stock quantity, reserved quantity and variants. Filter by category, manufacturer, EAN, symbol or catalog number. GET /products.

{
  "type": "object",
  "properties": {
    "status": {
      "description": "Only active products (omit for all).",
      "type": "string",
      "enum": [
        "active"
      ]
    },
    "manufacturer": {
      "description": "Exact manufacturer name.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "category_id": {
      "description": "Category id, or several separated by commas - see sellasist_list_categories.",
      "type": "string",
      "maxLength": 200,
      "pattern": "^\\d+(,\\d+)*$"
    },
    "ean": {
      "description": "Exact EAN.",
      "type": "string",
      "minLength": 1,
      "maxLength": 64
    },
    "symbol": {
      "description": "Exact product symbol.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "catalog_number": {
      "description": "Exact catalog number.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "auction_id": {
      "description": "Offer id in an external marketplace (Allegro, shop...).",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "from_id": {
      "description": "Only products with an id greater than this.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "sort": {
      "description": "Sort by id (asc or desc).",
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

One product by id: title, category, prices, VAT, stock, sold counts, EAN, symbol, location, weight, qualities, availability, manufacturer and more. GET /products/{product_id}.

{
  "type": "object",
  "properties": {
    "product_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Sellasist product id."
    }
  },
  "required": [
    "product_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Stock quantity of one product, found by id, EAN, symbol or catalog number (the first one given in that order counts); with none of them, a page of stock levels for all products. GET /products_stock.

{
  "type": "object",
  "properties": {
    "id": {
      "description": "Product id.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "ean": {
      "description": "Exact EAN.",
      "type": "string",
      "minLength": 1,
      "maxLength": 64
    },
    "symbol": {
      "description": "Exact product symbol.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "catalog_number": {
      "description": "Exact catalog number.",
      "type": "string",
      "minLength": 1,
      "maxLength": 200
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Products ranked by units sold in the last month (sold_last_month), with stock and price. GET /products_bestsellers.

{
  "type": "object",
  "properties": {
    "page": {
      "description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100000
    },
    "limit": {
      "description": "Products per page, 1-100 (default 18).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Product categories. GET /categories.

{
  "type": "object",
  "properties": {
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

One category: names per language, parent category and status. GET /categories/{category_id}.

{
  "type": "object",
  "properties": {
    "category_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Category id."
    }
  },
  "required": [
    "category_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Warehouses (id, title). Needs the warehouse-management feature, otherwise Sellasist answers HTTP 406. GET /storages.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Registered customers (the account's buyers). GET /users.

{
  "type": "object",
  "properties": {
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

One customer: email, registration date, billing and delivery address. GET /users/{user_id}.

{
  "type": "object",
  "properties": {
    "customer_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Customer id."
    }
  },
  "required": [
    "customer_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Invoices (id, number, date). Filter by order, document series or issue date. GET /invoices.

{
  "type": "object",
  "properties": {
    "order_id": {
      "description": "Only invoices of this order.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "series_id": {
      "description": "Only this document series.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "date_from": {
      "description": "Issued at or after this date.",
      "type": "string"
    },
    "date_to": {
      "description": "Issued at or before this date.",
      "type": "string"
    },
    "sort": {
      "description": "Sort order, default desc.",
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

One invoice: number, dates, seller, buyer, currency, line items (net, gross, VAT), total and paid amount. GET /invoices/{invoice_id}.

{
  "type": "object",
  "properties": {
    "invoice_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Invoice id."
    }
  },
  "required": [
    "invoice_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Return documents (RMZ): number, status, source, linked order, refund value and tracking number. Filter by date, order, status, source or return number. GET /returns.

{
  "type": "object",
  "properties": {
    "date_from": {
      "description": "Created at or after this date.",
      "type": "string"
    },
    "date_to": {
      "description": "Created at or before this date.",
      "type": "string"
    },
    "order_id": {
      "description": "Only returns of this order.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "status_id": {
      "description": "Return status id.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "source_id": {
      "description": "Return source id.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991
    },
    "return_number": {
      "description": "Exact return number, e.g. RMZ120072026.",
      "type": "string",
      "minLength": 1,
      "maxLength": 64
    },
    "sort": {
      "description": "Sort by id, default desc.",
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "limit": {
      "description": "Results per page, 1-100 (default 25).",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100
    },
    "offset": {
      "description": "Number of results to skip (default 0). Pass the previous reply's next_offset.",
      "type": "integer",
      "minimum": 0,
      "maximum": 1000000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

One return document with status, refund and payment details, tracking, courier and the returned items. GET /returns/{id}.

{
  "type": "object",
  "properties": {
    "return_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Return document id (from sellasist_list_returns)."
    }
  },
  "required": [
    "return_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Payment methods (id, title) for filtering orders. GET /payments.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Delivery methods (id, title) for filtering orders. GET /shipments.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Order sources available in the account (id, name, type: Allegro, shop, marketplace...). GET /sources.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Accounts connected in external services (id, login, type). Only these three fields are returned. GET /external_accounts.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Active alerts and system messages shown on the Sellasist dashboard (type, severity, title, message). GET /alerts.

{
  "type": "object",
  "properties": {
    "page": {
      "description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 100000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

WRITE: add a new note to an order. Notes are visible to the account's staff; each call adds another note (nothing is overwritten). POST /notes.

{
  "type": "object",
  "properties": {
    "order_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Sellasist order id."
    },
    "text": {
      "type": "string",
      "minLength": 1,
      "maxLength": 5000,
      "description": "The note text."
    }
  },
  "required": [
    "order_id",
    "text"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

WRITE: change the status of one order (PUT /orders/{order_id} with only the status). Sellasist may run the status's automations (emails, stock moves). By default the new status is NOT pushed to the marketplace; set send_status_to_external to true to push it. Find status ids with sellasist_list_order_statuses.

{
  "type": "object",
  "properties": {
    "order_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "Sellasist order id."
    },
    "status_id": {
      "type": "integer",
      "exclusiveMinimum": 0,
      "maximum": 9007199254740991,
      "description": "New status id - see sellasist_list_order_statuses."
    },
    "send_status_to_external": {
      "description": "Also send the new status to the external marketplace or shop the order came from.",
      "type": "boolean"
    }
  },
  "required": [
    "order_id",
    "status_id"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}