Skip to content
Van Oosten Advies B.V.

Last updated: 17 November 2026

Prices and availability in CustomerGate 365

Since version 1.1.0 your website can show prices and availability from Business Central. A signed-in portal user sees their own price per item, as a sales quote would show it today; where you turn it on, a visitor sees a list price; and the catalog says per item and variant whether it can be delivered. The website calculates nothing: Business Central calculates every price ahead in the prices job, and the website reads the result. Everything is off until you turn it on.

The settings

In the group Prices and Availability on CustomerGate Setup. The setup guide asks for the first four on its web catalog step; the others have a starting value.

Prices in the Portal
A signed-in portal user sees the price of their own customer per item, with their line discount. In the plans Portal and Complete.
List Prices for Visitors
A visitor who is not signed in sees a list price: the price of the model customer, without a discount. Turning this on publishes those prices. In every plan.
Model Customer for List Prices
The customer whose price a visitor sees, for example a cash customer with the standard price group. Without it there are no list prices.
Availability on the Website
The catalog tells the website per item and variant whether it can be delivered: In Stock, Limited or On Request. In every plan.
Calculate Prices per Customer
Off, customers without prices of their own share their prices per price profile (see below). On, every customer is calculated apart; turn it on when an extension prices on something else of the customer.
Price Provider
How the prices are calculated. Sales Quote, the provider of CustomerGate 365 itself, calculates each price on a sales quote that is rolled back at once. An extension can bring a provider of its own.
Show Quantities
The catalog also gives the available quantity, in the base unit of measure. Off, the website only gets the state, which does not show your stock position to competitors.
Availability Location Filter
The locations whose inventory counts for the website, as a filter such as MAIN|EAST. Empty counts every location.
Limited Below
At or below this available quantity an item is Limited; at or below zero it is On Request. Zero by default.
Prices Job, Availability Refreshed At
Whether the prices job is running, and when it last recalculated the availability of the catalog.

After an update everything is off, so an installation that upgrades shows exactly what it showed before. Recalculate Prices, Website Item Prices and Prices Job are among the actions of the setup page.

Calculated ahead, never during a call

A price depends on the customer, the item, the variant, the unit of measure, the quantity and the day. The website asks for a price, Business Central looks it up in its table of calculated prices, and answers with one of three:

The price
When it is calculated for today: the unit price, the line discount and the line amount a sales quote line would show, in the customer's currency, with or without VAT as on the customer's sales documents.
Pending
When it is not calculated for today yet. The price is queued for the prices job and is normally there within a minute; the website shows that the price is being calculated and asks again.
On request
For an item that is Not Orderable Online, while prices are off, and when Business Central gave no price or the calculation failed.

The prices job puts the item on a real sales quote for the customer, dated today, fills in the line as a salesperson would, keeps the result and rolls the quote back at once, as the posting preview does. Your price lists, quantity breaks, line discounts and the pricing of any extension therefore all count, and nothing the quote wrote stays behind. The job calculates with the rights of the user who runs it, so the website's account needs no right on any price table, customer or item ledger.

Price profiles

Most customers do not have prices of their own: they get them through their price group, their discount group, or a price for everyone. CustomerGate stores such prices once per price profile instead of once per customer, so thousands of customers in a few dozen groups cost a few dozen calculations per item.

  • A price profile is what a customer's prices depend on: Customer Price Group, Customer Disc. Group, VAT Bus. Posting Group, Currency Code, Prices Including VAT, Allow Line Disc. and Price Calculation Method. Customers with the same profile get the same price.
  • A customer with a price, a discount or a campaign of its own (or of its contact) keeps its own prices, under its own number. So does a blocked customer, and a customer that is invoiced to another customer.
  • A customer's first question waits one round of the job while its profile is computed.
  • When an extension prices on something the profile does not hold, turn on Calculate Prices per Customer: then nobody shares.

When a price is calculated again

  • A stored price counts for the day it was calculated for. Each night the job calculates again the prices that were asked in the last seven days; an older price is calculated again when it is asked.
  • A change of a price list line, a sales price or discount, an item's unit price, sales unit of measure or discount group, a price list's status or dates, an exchange rate or the customer marks the prices it touches at once.
  • A change Business Central does not report, such as a price table of another app, shows the next day. To have it sooner, choose Recalculate Prices on CustomerGate Setup: the job calculates every website price again in its next rounds, and until a price is done the website gets pending for it.
  • A price nobody asked for in 30 days is removed. Business Central keeps at most 10,000 prices for visitors, so a website cannot fill the table with every quantity a visitor types.

The prices job

Prices Job on CustomerGate Setup opens the job queue entry. It runs every minute and is created On Hold. Set it to Ready once prices or availability are on, as a user who may make sales quotes: that user's rights calculate the prices. While it is on hold, every price the website asks for stays pending and the availability is not updated.

  • A round calculates prices for at most 45 seconds: first the prices a website asked for, oldest question first, then those of earlier days.
  • Once an hour it reads the availability of every item and variant in the web catalog.
  • A price that cannot be calculated keeps its error, the website gets on request for it, and the round goes on with the others.
  • Each calculation briefly inserts a sales quote and rolls it back: a short lock on the sales tables per price, in the job, never on a page.
  • While Prices in the Portal, List Prices for Visitors and Availability on the Website are all off, the job does nothing.

Website Item Prices

Website Item Prices lists every price Business Central calculated ahead for the website, with the ones that failed and why. It is read-only: the prices job writes the rows.

Price Profile
The customer number of a customer with prices of its own, or the code of a profile that customers share. A code that starts with a tilde (~) is a customer's first question, before the job has computed its profile.
Item No., Variant Code, Unit of Measure Code, Quantity
What the website asked a price for.
Status
Pending until the job has calculated the price for today, Priced when there is a price, No Price when Business Central gave none, Failed when the calculation stopped with an error.
Unit Price, Line Discount %, Line Amount, Currency Code, Prices Including VAT
What a sales quote line for this customer would show. Empty currency is the local currency.
Unit Price per Price Unit, Price Unit of Measure Code
The price per the unit it is calculated in, for an extension that prices per a unit of its own, such as per kilogram. Otherwise the same as the unit price and its unit of measure.
Price Date, Calculated At, Last Asked
The day the price counts for (the website gets it on that day only), when the job last calculated it, and the last day a website asked for it.
Error Text
Why the calculation failed. The website gets on request for this price until it is calculated again.
Recalculate
Calculates the selected prices now, with your own rights, instead of waiting for the job. Use it after fixing what made a calculation fail.

Availability

Available is the inventory minus the quantity on sales orders, in the base unit of measure, over the locations in Availability Location Filter. Purchase orders and production do not count. Once an hour the prices job compares it with Limited Below:

StateWhen
In StockMore is available than Limited Below.
LimitedThe available quantity is at or below Limited Below, and above zero.
On RequestNothing is available.

The website gets the state, and the number too while Show Quantities is on. While Availability on the Website is off, or before the job has looked, the website gets no state at all.

What Diagnostics says

While prices or availability are on, CustomerGate Diagnostics shows two more lines under Job queue:

Prices job
Passed when it is Ready. A warning while it is on hold, because every price the website asks for stays pending. Failed when the entry stands on Error or does not exist; for a missing entry Fix opens CustomerGate Setup.
Website prices that could not be calculated
A warning with a count. Open Website Item Prices, do what the Error Text of each price says, and choose Recalculate. A common cause is a user of the prices job who may not make sales quotes.

The checklist of the setup guide counts the prices job in its line Job Queue Entries while one of the three switches is on.

What leaves Business Central

A price leaves Business Central only as the calculated price of the customer who is signed in, or as the list price of the model customer. Unit cost, margin, another customer's price, a price list as a whole and the discount structure behind a price never leave.

A competitor can register as a customer and read the prices it gets. Who receives a portal account is your choice, and it is the reason List Prices for Visitors is off by default. A price on the website is the price Business Central would propose; the quote stays the offer that binds.

Related help