Skip to content

List orders

Florin D edited this page Jun 4, 2019 · 19 revisions

About

  • Lists commands that fit the filters

Class

celmarket\Orders\OrdersList

Method

listOrders

API

  • method: orders
  • action: listOrders

Parameters

  • start = start position for the list
  • limit = maximum number of returned values
  • filters = list filters -> array
    • minDate = starting date
    • maxDate = end date
    • customer = partial name
    • customerSign = comparison sign
      • ee = equal
      • ne = not equal
    • product = partial name
    • productSign = comparison sign
      • ee = equal
      • ne = not equal
    • order = order's id
      • null, 0 or empty string will render the filter not applicable
    • invoice = invoice's number
      • null, 0 or empty string will render the filter not applicable
    • order_status = order's status
      • null, 0, 99 or empty string will render the filter not applicable
    • group_by_status = true or not set for the orders to be grouped by status (implicitly), false, otherwise
    • order_by_date_purchased = if it's not set, it will sort by orders_id, if it's set to ASC it will sort ascending by date_purchased and if it's set to DESC it will sort descending by date_purchased
    • min_order = if it's unset or 0, it will not enforce a minimum value for the order and will sort descending by orders_id, otherwise it will impose a minimum limit on orders_id and sort the results ascending by orders_id
    • last_changed = last change
      • minDate = minimum date
      • maxDate = maximum date
    • phoneNumber = client's phone number

Response

An object with the following attributes

  • (attribute) = object containing information about orders with a specific status
    • (attribute's name) = status
    • (attribute's value) = an object with the following attributes
      • limit = maximum number of returned campaigns
      • start = start position
      • moreavailable = 1 -> there are more orders that haven't been returned, 0 -> there are no more orders to be returned
      • list = orders list -> array
        • (array element) = an order that fits the filter conditions -> object
          • customer_company = company / personal name of the client
          • data = order date
          • ora = order hour
          • mod_plata = payment method
          • status = order's status
          • valoarecomanda = order's value
          • mod_livrare = delivery method
          • orders_id = order's id
          • id_adresa_afiliat = pick-up address' ID
          • source = order's originating site

Example - PHP

https://github.com/celdotro/marketplace_examples/blob/master/Orders/2.listOrders.php

Example - JSON

{
  "request": {
   "start": 0,
   "limit": 1,
   "arrOptions": {
    "minDate": "01-01-2018",
    "maxDate": "01-01-2018",
    "customer": "X",
    "customerSign": "X",
    "product": "X",
    "productSign": "X",
    "order": 1,
    "invoice": 1,
    "orders_status": 1,
    "group_by_status": true,
    "order_by_date_purchased": "X",
    "min_order": 1,
    "payment_method": "X"
   } 
  },
  
  "response": {
    "moreavailable": "X",
    "limit": 1,
    "start": 0,
    "list": [
      {
        "customers_name": "X",
        "date_purchased": "01-01-2018",
        "payment_method": "X",
        "status_plata": 1,
        "order_total": 1,
        "delivery_company": "X",
        "orders_id": 1,
        "platit": 1,
        "serie": "X",
        "nr_fact": 1,
        "awb": "X",
        "customers_state": "X",
        "status": 1,
        "timestamp": 1
      }
    ],
    "count": 1
  }
}
  • Prima pagina [RO] | First page [EN]
  • Instalare [RO] | Install [EN]
  • Informatii generale [RO] | General information [EN]
  • AWB [RO] | [EN]
    • Adaugare [RO] | Import [EN]
    • Stergere [RO] | Delete [EN]
    • Listare [RO] | Print [EN]
    • Status [RO] | Status [EN]
    • Generare AWB [RO] | Generate AWB [EN]
  • Campanii [RO] | Campaigns [EN]
    • Adaugare campanie [RO] | Add campaign [EN]
    • Salvare campanie [RO] | Save campaign [EN]
    • Citire campanie [RO] | Read campaign [EN]
    • Adaugare produs in campanie [RO] | Add product to campaign [EN]
    • Salvare produs in campanie [RO] | Save product in campaign [EN]
    • Eliminare produs din campanie [RO] | Remove product from campaign [EN]
    • Listare campanii active [RO] | List active campaigns [EN]
    • Setare stoc limitat [RO] | Set limited stock [EN]
    • Preia campaniile de cupoane [RO] | Get coupon campaigns [EN]
    • Date campanie cupoane [RO] | Coupon campaign data [EN]
    • Adaugare campanie cupoane noua [RO] | Add new coupon campaign [EN]
    • Genereaza cupon [RO] | Generate coupon [EN]
    • Schimbare status cupon [RO] | Change coupon status [EN]
    • Verifica utilizarea cuponului [RO] | Check coupon usage [EN]
    • Date cupon [RO] | Coupons data [EN]
    • Adaugare grup de produse in campanie [RO] | Add group of products to campaign [EN]
  • Facturi [RO] | Invoices [EN]
    • Listeaza facturi [RO] | List invoices [EN]
    • Adaugare factura [RO] | Add invoice [EN]
    • Printare factura [RO] | Print invoice [EN]
    • Stergere factura [RO] | Remove invoice [EN]
  • Comenzi [RO] | Orders [EN]
    • Listare [RO] | List [EN]
    • Actualizare [RO] | Update [EN]
    • Datele unei comenzi [RO] | Order's data [EN]
    • Anulare [RO] | Cancel [EN]
    • Sumar [RO] | Summary [EN]
    • Setare date AWB [RO] | Set AWB data [EN]
    • Adaugarea de noi produse in comanda [RO] | Add products to order [EN]
    • Stergerea unui model de produs din comanda [RO] | Remove product model from order [EN]
    • Confirmare comanda [RO] | Confirm order [EN]
    • Listare statusuri anulare [RO] | List cancelling statuses [EN]
    • Verifica plata pentru comanda [RO] | Check payment for order [EN]
    • Reactiveaza comanda [RO] | Reactivate order [EN]
    • Preluare lista statusuri pentru comenzi [RO] | Retrieve list of statuses for orders [EN]
    • Actualizare SN [RO] | Update SN [EN]
    • Adauga observatiile comenzii[RO] | Add order observations [EN]
    • Import factura [RO] | Import Invoice [EN]
    • Stornare comanda [RO] | Order cancellation [EN]
    • Schimba statusul unui produs din comanda [RO] | Changes the status of a product from a specific order [EN]
    • Listare statusuri comenzi [RO] | List orders statuses [EN]
    • Listeaza statusurile produselor din comanda [RO] | List order product statuses [EN]
    • Preia metode de plata [RO] | Get payment methods [EN]
    • Schimba modul de plata [RO] | Change order payment method [EN]
    • Finalizeaza comanda [RO] | Finish order [EN]
    • Tipareste comanda [RO] | Print order [EN]
    • Retur produs [RO] | Return product [EN]
    • Finalizare combinata [RO] | Finish combined [EN]
    • Adaugare greutate [RO] | Add weight [EN]
    • Schimba data finalizarii [RO] | Change finishing date [EN]
    • Disputa comanda [RO] | Mark order as disputed [EN]
  • Pagini [RO] | Pages [EN]
    • Listare [RO] | List [EN]
    • Salvare [RO] | Save [EN]
    • Stergere [RO] | Remove [EN]
  • Produse [RO] | Products [EN]
    • Listare categorii [RO] | List categories [EN]
    • Listare produse [RO] | List products [EN]
    • Import produse [RO] | Import products [EN]
    • Listare status import produse [EN] | List product import status [EN]
    • Actualizare stoc, pret, status [RO] | Update stock, price, status [EN]
    • Adaugare bonus [RO] | Add bonus [EN]
    • Listare bonus [RO] | Get bonus [EN]
    • Stergere bonus [RO] | Delete bonus [EN]
    • Actualizare date [RO] | Update data [EN]
    • Listeaza caracteristicile unei categorii [RO] | List characteristics of a category [EN]
    • Adauga noi valori unei caracteristici [RO] | Add new values to a characteristic [EN]
    • Listeaza filtre [RO] | List filters [EN]
    • Listeaza caracteristicile obligatorii ale unei categorii [RO] | List mandatory characteristics of a category [RO]
    • Preluare produse live din categorie [RO] | Retrieve live products from category [EN]
    • Adauga o noua oferta unui produs existent [RO] | Add offer to existing product [EN]
    • Preia produsele live pe categorii [RO] | Get live products categories [EN]
    • Actualizeaza status produs [RO] | Update products status [EN]
    • Exporta produse [RO] | Export products [EN]
    • Listeaza familiile de produse [RO] | List product families [EN]
    • Adauga produs in familie [RO] | Add product to family [EN]
    • Preia produs din familie [RO] | Get product from family [EN]
    • Elimina produs din familie [RO] | Remove product from family [EN]
    • Actualizare promotie produs [RO] | Update product promotion [EN]
    • Preia ID producator [RO] | Get manufacturer ID [EN]
    • Adauga familie de produse [RO] | Add products family [EN]
    • Preia lista produselor in asteptare [RO] | Get waiting products list [EN]
    • Preia lista produse respinse [RO] | Get rejected products list [EN]
  • Email [RO] | Email [EN]
    • Listare email-uri pred`efinite pentru comenzi [RO] | Predefined email list for orders [EN]
    • Preia email-urile unui client pentru o comanda [RO] | Get client emails for an order [EN]
    • Trimite email aferent comenzii [RO] | Send predefined order email [EN]
    • Trimite email personalizat aferent comenzii [RO] | Send custom order email [EN]
    • Trimitere raport bug [RO] | Send bug report [EN]
    • Preia email-urile pentru produse [RO] | Retrieve products emails [EN]
    • Raspunde email-ului unui produs [RO] | Answer a specific email for a product [EN]
    • Preia cererile de service [RO] | Get service requests[EN]
    • Raspunde unei cereri de service [RO] | Answer service request [EN]
    • Preia cererile de retur [RO] | Get return requests [EN]
    • Raspunde cererii de retur [RO] | Answer return request [EN]
    • Notificare eliminare factura [RO] | Notify invoice removal [EN]
    • Preia intrebari comanda [RO] | Get order questions [EN]
    • Raspunde intrebarii comenzii [RO] | Answer order's question [EN]
    • Descarca atasamentul email-ului comenzii [RO] | Download order email attachment [EN]
    • Numara cererile de retur [RO] | Count return requests [EN]
    • Trimitere notificare de stergere a AWB-ului [RO] | Send AWB notification removal [EN]
    • Preia cerere retur [RO] | Get return request [EN]
    • Preia cerere service [RO] | Get service request [EN]
    • Preia mesajele comenzilor [RO] | Get orders messages [EN]
    • Preia numarul de mesaje fara raspuns ale comenzilor [RO] | Get unanswered orders message number [EN]
  • Informatii administrative [RO] | Administrative information [EN]
    • Date plati facturi [RO] | Invoices payment data [EN]
    • Date plati pentru o factura [RO] | Detailed payment data for an invoice [EN]
    • Istoric importuri [RO] | Import history [EN]
    • Adaugare adresa [RO] | Add address [EN]
    • Editare adresa [RO] | Edit address [EN]
    • Listare adrese [RO] | List addresses [EN]
    • Stergere adresa [RO] | Delete address [EN]
    • Actualizeaza informatiile contului [RO] | Update account information [EN]
    • Listeaza informatiile contului [RO] | List account information [EN]
    • Listeaza produsele facturabile [RO] | List billable products [EN]
    • Factureaza produse [RO] | Bill products [EN]
    • Preia cererile de service [RO] | Retrieve service requests [EN]
    • Preia taxa de transport [RO] | Retrieve transport tax[EN]
    • Actualizeaza taxa de transport [RO] | Update transport tax[EN]
    • Actualizare in grup a taxelor de transport [RO] | Bulk update transport taxes [EN]
    • Actualizeaza informatiile livrarii [RO] | Update delivery information [EN]
    • Preia informatii despre livrare [RO] | Get delivery information [EN]
    • Seteaza gata de livrare [RO] | Set as ready for delivery [EN]
    • Preia notificarile [RO] | Get notifications [EN]
    • Marcheaza notificare drept citita [RO] | Mark as seen [EN]
    • Adauga curier [RO] | Add courier [EN]
    • Preia date despre afiliat [RO] | Get affiliate's data [EN]
    • Marcheaza toate notificarile drept citite [RO] | Mark all as read [EN]
    • Preia lista curieri [RO] | Get couriers [EN]
    • Preia FAQ categorii [RO] | Get categories FAQ [EN]
    • Continut FAQ categorie [RO] | Category FAQ contents [EN]
    • Preia coduri MCC [RO] | Get MCC Codes [EN]
    • Atribuie cod MCC [RO] | Add MCC Code [EN]
    • Preia MCC-uri atribuite [RO] | Get currently used MCC [EN]
    • Elimina MCC [RO] | Remove MCC Code [EN]
    • Preia informatii despre accesul la categorii [RO] | Retrieve information about categories access [EN]
    • Cere acces la o categorie [RO] | Request category access [EN]
    • Lista cereri acces la categorii [RO] | Category access request list [EN]
    • Abonare la newsletter API [RO] | Subscribe to API newsletter [EN]
    • Dezabonare de la newsletter API [RO] | Unsubscribe from API newsletter [EN]
    • Status abonare newsletter API [RO] | Subscription status to API newsletter [EN]
    • Preia informatii combinate [RO] | Get combined information [EN]
    • Preluare prefix [RO] | Get prefix [EN]
    • Listare pagini cu incalcari de contract [RO] | List pages that breach the contract [EN]
  • Rapoarte [RO] | Reports [EN]
    • Plati cu cardul [RO] | Card payments [EN]
    • Diferenta pret [RO] | Price difference [EN]
  • Plati [RO] | Payments [EN]
    • Preia platile lunare cu cardul [RO] | Monthly card payments [EN]
    • Lunile platilor cu cardul [RO] | Card payments months [EN]
    • Lunile borderourilor [RO] | Payments summary months [EN]
    • Comisioane nefacturate [RO] | Unbilled commissions [EN]
    • Comisioane facturate [RO] | Billed commissions [EN]
    • Aproba comanda [RO] | Approve order [EN]
    • Respinge comanda [RO] | Reject order [EN]
    • Genereaza factura [RO] | Generate invoice [EN]
    • Descarca factura [RO] | Download invoice [EN]
    • Descarca borderou XLSX [RO] | Download summary XLSX [EN]
    • Descarca borderou PDF [RO] | Download summary PDF [EN]
Clone this wiki locally