Planning a B2B Dealer Ordering Portal: Tiered Price Lists, Credit Limits, Inventory Visibility, and ERP Integration
A sales assistant opens the computer in the morning to a dozen order messages in the chat app, the fax machine has spat out a few handwritten order sheets, and the phone keeps ringing: “Is that item still in stock?” “Did last week’s batch ship?” This is daily life for many manufacturers and brand distributors, and the typical starting point for planning a dealer ordering portal.
The biggest difference between B2B ordering and ordinary online shopping is that every customer has different prices, terms, and limits, and orders also have to go through approval, match inventory and the shipping schedule, and finally be reconciled and collected. Moving those rules out of sales assistants’ heads and spreadsheets into a system is where the portal’s real value lies.
What follows covers the problems a portal should solve, how tiered price lists and trade terms work, credit limits, how much inventory to show, order flow, reconciliation, and what to watch when integrating with an ERP.
What a dealer ordering portal should solve
Start by confirming where your pain actually is, so the portal’s scope does not drift. Common problems in practice:
- Transcription errors: part numbers, quantities, or specifications are copied wrong and only discovered after shipping, making returns and exchanges expensive.
- Repeated questions: dealers ask about stock, shipping progress, and balances, and sales assistants spend much of the day answering the same questions.
- Prices and terms rely on memory: which price list and which special terms apply to which dealer is known only to the salesperson in charge.
- Over-limit discovered too late: a dealer already owes a sizable balance, yet orders keep shipping.
- Reconciliation drags on: at month end each side compares its own records, and every difference has to be chased line by line.
The aim of the portal is to let dealers order and look things up for themselves, freeing internal staff from copying orders and answering questions so they can focus on exceptions and account management.
Tiered price lists and trade terms: rules instead of memory
Prices on a B2B portal are not a single selling price but a set of rules. In design, split “how the price is decided” into several independent mechanisms, so business rules can be adjusted in the back end rather than changed in code every time:
- Customer tiers: dealers are grouped by type or partnership level, and each tier maps to a price list.
- Customer-specific prices: a particular dealer has an individually negotiated price on particular items, which takes priority over the tier price list.
- Quantity breaks: the same item takes different prices depending on order quantity, with break thresholds and their prices set in the back end.
- Time-limited promotions: special pricing for specified items or customer groups during a specified period, expiring automatically when the period ends.
- Minimum order quantities and pack sizes: for example, full cases only, checked by the system at ordering time rather than sent back afterward.
When these mechanisms coexist, you must define their order of priority. When a customer-specific price and a promotion both apply, which wins? Do quantity breaks stack on top of the tier price list? These rules must be written clearly at the specification stage, and the screen should show dealers “how this price was reached,” which reduces disputes later.
You also need to decide price visibility. Can visitors who are not logged in see prices? Can dealers in different tiers see only their own price list? In most cases, prices on a B2B portal are shown only to logged-in dealers, and each sees only the list that applies to them. For how to layer accounts and roles, see User Roles and Permissions Design.
Credit limits: know whether you can ship before the order is placed
Monthly billing and trade credit are the norm in B2B, and credit limits are the key to controlling risk. What the system needs to do is decide at the moment of ordering, not discover the problem after shipping.
The basic design of credit limit control:
- Define clearly what counts against the limit: does used credit include amounts ordered but not shipped, shipped but not invoiced, and invoiced but not collected? Different definitions give very different results, so settle it together with finance.
- What happens when the limit is exceeded: block outright, allow the order but send it for approval, or require payment first; rules can differ by customer tier.
- Link to overdue balances: decide in advance whether an overdue unpaid balance suspends ordering or allows only certain items.
- Show available credit in real time: dealers see their current available credit on the order page, so orders are not rejected after submission.
- Keep a record of adjustments: who approved a temporary increase, when it takes effect, and when it reverts should all be traceable.
The real source of credit data is usually the ERP or accounting system, and the portal must make sure it reads the latest receivables position. If syncing has a lag, credit decisions should err on the conservative side, and the screen should show when the data was last updated.
Inventory visibility: what dealers get to see
Inventory information greatly reduces questions, but more transparency is not always better. First decide which level dealers see:
- In stock or out of stock only: the least information, which keeps dealers from rushing stock or bargaining based on actual quantities; suits stock-sensitive items.
- Orderable quantity: lets dealers know how much they can order at once, cutting over-quantity orders that get sent back.
- Expected arrival date: out-of-stock items show the restock timeline, so dealers can place pre-orders.
Whichever level you show, orderable quantity must subtract quantities already reserved, such as orders placed but not shipped and allocations held for particular customers. Otherwise two dealers both see stock, both order, and the one who ordered second loses out.
With multiple warehouses, you also need to decide whether to show a total or quantities by shipping warehouse. How the inventory itself is managed, such as safety stock, transfers, and stocktakes, is covered more fully in Inventory Management System Development.
Order flow: status design from order to shipment
B2B orders usually do not ship the moment they are submitted; approval, picking, and split shipments come in between. Order statuses should be designed so dealers understand them and internal staff can track them easily.
A common status flow:
- Draft: the dealer is still adjusting and can save to submit later.
- Submitted: waiting for internal confirmation.
- Under review: over the limit, special pricing, or special items that need sales or manager approval.
- Confirmed: the order is accepted and moves into picking.
- Partially shipped: some items ship first, with out-of-stock items to follow.
- Shipped: everything has shipped, with tracking details attached.
- Cancelled or returned: with the reason recorded.
Scenarios to handle deliberately:
- Quick reorder: B2B customers often reorder the same set of items, and “reorder from last time” saves a great deal of time.
- Bulk import: dealers with many items tend to prepare orders in spreadsheets; offer a template import that checks each row during import.
- Sales reps ordering on a dealer’s behalf: a rep creates the order during a visit, and the order should show who created it.
- Shipping notifications: notify dealers when status changes, by email, LINE (the dominant messaging app in Taiwan), or in-portal messages.
Reconciliation: both sides looking at the same numbers
Month-end reconciliation is the most labor-intensive part of B2B dealings. What the portal can do is have both sides looking at the same record from the start.
On the dealer side, consider providing:
- Statements by period, listing every shipment, return, allowance, and payment.
- Unpaid items with due dates.
- A list of issued invoices with downloads.
- Payment reporting, letting dealers upload remittance details for finance to confirm and apply.
The internal side has to handle tracking discrepancies: when a payment a dealer reports does not match what actually arrived, staff need to flag it, assign an owner, and record the outcome. Returns and allowances should be linked to the original order rather than becoming an untraceable adjustment. For issuing e-invoices and handling allowance documents, see the E-Invoice Integration Guide.
ERP integration: first decide who owns each piece of data
Most companies with a dealer network already have an ERP. The portal should not build a second, duplicate set of master records; instead it should define clearly which side is responsible for each type of data.
Use this table to confirm each item with your developer:
| Data type | Usual system of record | Sync direction | What to confirm |
|---|---|---|---|
| Product master | ERP | ERP → portal | Who maintains portal-only images and descriptions |
| Customer master and tiers | ERP | ERP → portal | Which side creates new dealers |
| Price lists and trade terms | ERP or portal | Depends on rule complexity | Rules can be maintained on one side only |
| Inventory | ERP | ERP → portal | Sync frequency and how reserved quantities are calculated |
| Orders | Portal | Portal → ERP | How write failures are retried and reported |
| Shipments and invoices | ERP | ERP → portal | When status is returned |
| Receivables and credit | ERP | ERP → portal | Which point in time the credit check relies on |
The integration method depends on what the ERP itself offers: one with an open API can sync in real time; one that can only import and export files needs scheduled batches, and you accept some lag. Most important of all is error handling: when an order fails to write to the ERP, it cannot sit silently on the portal with nobody aware; there must be a retry mechanism and a list for manual handling. For integration planning principles, see A Guide to System Integration and API Development; if the ERP itself is still being evaluated, start with ERP Selection for Small and Medium Businesses.
Common mistakes
- Converting a B2C store straight into B2B: pricing, credit, and approval all run on exceptions, and every change makes it messier.
- No priority order for pricing rules: the same order produces two prices, and the dealer and the salesperson each insist they are right.
- Credit definition not agreed with finance: the system says the order can ship, while finance says the dealer was over the limit long ago.
- Inventory not net of reservations: two dealers order at once, the second is canceled, and trust takes a hit.
- No alerts on integration failures: an order sits on the portal for days and is only discovered when the dealer calls.
- Pushing it to every dealer at once: going fully live without a trial means all the problems arrive together.
At heart, a dealer ordering portal takes the trading rules scattered among sales, sales assistants, and finance and organizes them into one system both sides can understand. The clearer the rules, the more useful the portal.
If you are working out how to design price and credit rules for a dealer portal, or how to connect it to your existing ERP, talk to NETVANA about your dealer process. Software work is always quoted after a consultation: we first work with you to clarify pricing rules, the credit definition, and which system owns which data, then plan the portal’s scope and integration approach. More on what we offer is in our software services overview.
Further reading: If your ERP is still being evaluated or needs a fresh review, see ERP Selection for Small and Medium Businesses. For connecting the portal to the ERP, read A Guide to System Integration and API Development. For reserved quantities and multi-warehouse management, see Inventory Management System Development. For separating dealer accounts from internal roles, read User Roles and Permissions Design. If you also run retail online sales, compare with the E-Commerce Website Development Guide. And to decide first between building and buying, see SaaS or Custom Software.