---
title: "How to get customer prices"
description: "Guide to fetching the customer prices for an product using GraphQL mutations. Includes example queries, and responses for each step."
lang: en
languages:
  en: https://docs.vismasoftware.no/businessnxtapi/examples/howto/customerprices/index.md
lastmod: 2026-07-10
---

> Documentation index: https://docs.vismasoftware.no/businessnxtapi/examples/howto/llms.txt


# How to get customer prices

Last modified July 10, 2026

> Guide to fetching the customer prices for an product using GraphQL mutations. Includes example queries, and responses for each step.


There is no direct way to fetch product customer prices but it can be achieve as follows:

- create an order
- add lines with the desired products
- read the `priceInCurrency`
- delete the order (and lines)

This can be achieved with a single request that also avoids the last step, by using temporary rows (defined with the `temporary : true`).

```graphql { title = "Query" }
mutation get_customer_price($cid : Int!, $customer : Int, $prod : String)
{
   useCompany(no : $cid)
   {
      order_create(
         values:[
            {
               customerNo : $customer,
               orderLines : [
                  { productNo : $prod, quantity : 1 },
               ]
            }
         ],
         temporary : true
      )
      {
         affectedRows
         items
         {
            customerNo
            orderLines: joindown_OrderLine_via_Order
            {
               items
               {
                  productNo
                  quantity
                  priceInCurrency
               }
            }
         }
      }
   }
}
```

```graphql { title = "Result" }
{
   "data": {
      "useCompany": {
         "order_create": {
            "affectedRows": 1,
            "items": [
               {
                  "customerNo": 10001,
                  "orderLines": {
                     "items": [
                        {
                           "productNo": "1001",
                           "quantity": 1,
                           "priceInCurrency": 995
                        }
                     ]
                  }
               }
            ]
         }
      }
   }
}
```


---

[View this page](https://docs.vismasoftware.no/businessnxtapi/examples/howto/customerprices/)