Supplier delivery management: one price per customer, one account per order

A supplier delivery management system: prices customised per customer group, with different customers getting different product prices in different cycles; the order flow is simplified and demand and orders stay in sync; cost control goes down to every line item, every product price is in plain sight, and product cost is accounted precisely to lift margins. Four modules — order management, product management, customer management and system management.

Industry
Fresh-food delivery / supply-chain services
System type
B2B order management + customised customer pricing + reconciliation and cost control
Key technology
Order search & export · per-page delivery-note printing · customer price matrix · xlsx price import · reconciliation titles · cost-price accounting · user/role/department permissions
Jiding scope
Process shaping, four-module architecture, pricing and reconciliation design, launch support
4modules: order, product, customer and system management — login lands on orders
11order search filters: from order number and status to order and completion time
10product-file fields: name, number, type, cost price, spec, unit and more — cost lives in the file
3permission layers: users, roles (menu + operation rights), departments

System Overview

System overview: the back office opens on orders

Logging in lands directly on order management — orders are the daily main line of a delivery business, so they come first. Four modules on the left; filters and the order list on the right.

Login lands here: orders first — the first screen belongs to order management Login · lands on order management Modules Orders Products Customers System Products split into categories / products Customers incl. companies Order filters · 11 conditions Order no. Status Amount Bill-to company Owning company Consignee name Consignee phone Delivery address Product name Order time Completion time Search Export Order no. Consignee Amount Status Order time Actions JD240918001Lakeview store¥ 3,860In delivery09-18 06:12View · Print · Done JD240918002Central kitchen¥ 12,240Completed09-18 05:47View · Export JD240918003Campus canteen¥ 6,480Completed09-18 05:30View · Export Actions follow status: open orders can be viewed, printed per page and completed; completed orders export straight to reconciliation. Demand and orders stay in sync — no more cross-checking between chat, phone calls and spreadsheets
Order management restored: four modules on the left, 11 filters and the order list on the right — search, export, view, print, complete in one row

Pricing Matrix

One price per customer: one product, three price lists

Pricing is the hardest part of delivery: canteens, restaurant chains and supermarkets each hold their own price list, adjusted every so often. The system grows the price list into product management — every product carries a “customer price” entry.

Customer price matrix: tiered pricing lives in the system, not in Excel files passed around Product \ Customer Canteen Restaurant chain Supermarket Vegetables ¥ 3.2 / jin ¥ 3.8 / jin ¥ 3.5 / jin Meat & frozen ¥ 18.6 / jin ¥ 19.8 / jin This month ¥ 19.2 / jin Grains & oil ¥ 52 / bag ¥ 56 / bag ¥ 54 / bag Condiments Quoted by grade Quoted by carton Quoted by case One shipment, three customers, three price lists; change the cycle, change the prices. How prices are maintained Product management → customer price Customise product prices per customer Company file → import xlsx One import overrides the latest customer prices Cost prices live only in the product file Customers see their own price; costs stay in-house No more re-sending quotation sheets: each customer logs in to their own prices, effective the same day Bulk repricing rides on the xlsx import; one-off tweaks go through the customer-price entry — both paths leave a trail.
Customer price matrix: one price list per customer, cycle adjustments overridden in bulk, cost prices kept inside the product file

Why the price list lives in the system

In many delivery teams the price list lives in Excel: revise, resend, then phone around to confirm receipt. Once the list lives in the system, each customer logs in to their own prices — adjustments take effect the same day, and historical prices stay on file for month-end reconciliation.

Why bulk repricing rides on xlsx

Season shifts, supplier changes and market swings usually move a whole page of prices at once. Importing an xlsx in the company file overrides the latest customer product prices in one shot — operations edit the sheet they already know instead of clicking cell by cell. Single-product tweaks go through the customer-price entry.

Order Lifecycle

One order, end to end: six steps from placement to reconciliation

Order management splits a delivery into six steps, each with a clear action and exit — simplifying the flow is not hiding steps but making every one of them smooth.

Order no. Status Amount Bill-to company Owning company Consignee name Consignee phone Delivery address Product name Order time Completion time Export to local sheet

▲ Every filter order management supports: combine the 11 conditions to pull the orders that need handling out of the pile.

1

Customer orders

Demand and orders sync in real time; the order carries products, quantities and the customer's own prices.

2

Filter & locate

Combine any of the 11 conditions — number, consignee or time window — to surface the target order.

3

Check details

One click opens the line items, amounts and status of the current order for review.

4

Print the note

The print entry opens an export dialog; pick pages of the delivery note — print only the stops the driver runs.

5

Complete

After delivery, one click marks the order completed — the loop closes with no dangling orders.

6

Reconcile

Export to a local sheet and issue statements per bill-to company and title.

Why “export delivery notes by page” deserves its own line: one order can hold dozens of products and one van run covers several stops, so notes often need splitting. The print entry jumps to an export dialog with page-range selection — print the pages for the stops on that run, no re-printing the whole order and no re-sorting by hand.

Cost Control

Cost control: margin is accounted, not guessed

The brief says it plainly — cost control down to every order, every product price in plain sight, product cost accounted precisely, margins lifted. In the system this is one chain: cost into the product file, prices follow the customer, the account follows the order.

Cost chain: cost into the file, price follows the customer, account follows the order 1. Product file Cost price · spec · unit 10 fields recorded at once 2. Customer price Custom per customer & cycle Bulk via xlsx override 3. Line items Every order to every product Qty, unit price, amount logged 4. Prices in sight A full price list for all products Export and check any time 5. Account the cost Product cost precisely tallied Margin becomes calculable Margin = customer price − product cost, and both sides live in the same system — no stitching two spreadsheets at month-end The key is the line-item breakdown: orders split to products, cost price rides the product file, selling price rides the customer price — which customer segment earns and which category loses shows up in the order roll-up, not in a month-end stocktake. Supporting actions live here too: products can be delisted, categories maintained by level, product information edited any time.
Cost control chain: cost into the file, price with the customer, account with the order — margin is accounted, not estimated

Why cost prices hide in the product file

In the delivery trade, once a quotation sheet circulates the customer's way, your costs go transparent. This system records cost price, spec and unit in the product file while the customer price system only carries selling prices — customers see their own list, and the cost basis stays in-house, keeping the negotiating floor solid.

Why product categories get their own screen

As the catalogue grows, categories are the skeleton of retrieval: filter by name and level, add with image, name and notes, edit or delete at will. Only with clear categories does “every price in plain sight” have a landing spot — not a flat table of hundreds of rows but a tree you can read level by level.

Customer Files

Customer management: the ordering account and the billing company, two lines

Customer groups place the orders; customer companies take the statements — one customer, two files, each with its own job, with reconciliation titles and order reminders hanging on the company file.

Customer groupsthe ordering account

  • Search: locate customers by owning company, account name or contact
  • Create: owning company, account name, password, logo, contact, phone, email
  • Export: export the current page's table in one click

The account is how the customer logs in and orders — hand over the credentials and the customer sees exactly the price list drawn up for them.

Customer companiesthe billing title

  • Search: by company information, contact, phone or reconciliation title
  • Create: company name, contact, phone, address, notes, order reminder, reconciliation title
  • Titles maintained separately: search by company info, contact, phone, then add
  • Import xlsx: override the latest customer product prices directly
Why “order reminder” and “reconciliation title” hang on the company file: the reminder solves the forgotten order — delivery runs at six in the morning, and a missed order is lost revenue. The title solves the month-end mismatch — title, contact and phone recorded in advance mean invoicing never starts with asking around. Record these two small fields once, save trouble every month.

Permissions

System management: users, roles, departments in three layers

A delivery team runs service reps, buyers, drivers and finance — who sees what and who changes what must be layered. System management splits it across three tiers.

User management

Search by username, department, role or status; create users with avatar, username, nickname, real name, gender, phone, department, role and email; export supported. Who is who, in which department, holding which role — one table says it all.

Role permissions

Create roles with a name and description, then set menu permissions and operation permissions — which modules a role can see is one layer, which buttons it may press inside them is another. A service rep can look up orders without repricing them.

Departments

Set up departments along the org chart; users belong to departments and departments carry roles. Transfers change only the department — permissions follow the role, no per-person re-wiring.

FAQ

Four common questions

How are different prices for different customers and cycles achieved?

Two paths: day-to-day repricing goes through the “customer price” entry in product management, customising product prices per customer; bulk repricing goes through importing an xlsx in customer company management, overriding the latest customer product prices in one shot. The same product can carry a separate list for canteens, restaurant chains and supermarkets, with a new batch of prices each cycle — the price list lives in the system, not in Excel files passed around.

How does an order flow from placement to completion?

Logging in lands on order management: filter by any of the 11 conditions (order number, status, amount, bill-to company, owning company, consignee name, phone, address, product name, order time, completion time) to locate the order; view the line items; print, exporting the delivery note by page; after delivery, complete the order and the status flips to completed; finally export to a local sheet for reconciliation. Demand and orders stay in sync, and delivery efficiency rides the flow.

How do cost and margin get accounted clearly?

Cost price, spec and unit are recorded when the product file is created — cost lives only there; every order breaks down to product lines, so every price sits in plain sight; cost and selling price share the same system, so product cost is accounted precisely and margin becomes calculable — customers see their own list while the cost basis stays in-house.

Is this the same kind of system as the cross-border supply-chain platform?

Both are order-and-supply-chain systems with different jobs: the cross-border platform handles outward collaboration — syncing marketplace orders from a third-party ERP, supplier scan-to-accept and dual reconciliation; this supplier delivery system handles in-house delivery — one price per customer, per-page delivery notes, reconciliation titles riding with orders. The methods rhyme: stateful tracking, tiered pricing, systematic reconciliation.

Deliverables & Results

Deliverables and effect

Deliverables

  • Four modules — order, product, customer and system management — with login landing on order management
  • Order management: 11 search filters, detail view, per-page delivery-note export, completion flow, local-sheet export
  • Product management: categories (name / level / image / notes) and 10-field product files, delisting, custom customer prices
  • Customer management: customer groups (account / password / logo / contacts) and companies (order reminders / reconciliation titles) on two lines, titles maintained separately
  • Price maintenance: customer-price entry for single tweaks plus xlsx import that overrides the latest customer prices
  • System management: three permission layers — users, roles (menu + operation rights), departments

Effect & de-identification

The most direct change is on pricing: quotations moved from Excel attachments to one list per customer in the system, adjustments take effect the same day, and bulk repricing rides one xlsx import.

The second change is on orders: 11 filters surface the orders first, delivery notes export by page and print on demand, and one click completes the order with nothing dangling; demand and orders stay in sync instead of being counted over chat and phone.

The third change is on the books: cost prices live in product files and orders break down to every line, so product cost is accounted precisely and margin becomes calculable. As agreed, this page shows no client name and no production screenshots.

Building a supplier-delivery or B2B ordering system? Settle three questions first: how customer prices tier, how delivery notes export by page, and how reconciliation titles ride with orders.

MORE CASES

More Related Cases

Supplier delivery management system
EMSDelivery management, order system

Supplier delivery management system

A supplier delivery management system: prices customised per customer group, with different customer...

View Details →
Cross-border apparel supply-chain collaboration platform
EMSCross-border e-commerce, supply chain system

Cross-border apparel supply-chain collaboration platform

A supply-chain service provider for cross-border apparel sellers: shops live on Amazon and other ove...

View Details →
Intelligent finance & tax management platform
EMSSmart finance and taxation, agency bookkeeping

Intelligent finance & tax management platform

An all-in-one internal management platform for a bookkeeping and fiscal-service company: customer pi...

View Details →

View All Cases →

Planning a similar production line or enterprise system?

Start with our pricing logic, then let's talk requirements — cost structure, technology comparison and acceptance criteria, all laid out in the open.