Field guide · Wholesale distributors · QuickBooks Desktop

A dealer portal so wholesale customers stop emailing for status

Most “where’s my order?” emails exist because your dealers can’t see what you can see. Before building anything, count those emails for two weeks and start sending status before you’re asked. If the count stays high, a read-only dealer portal that shows each customer their own open orders, promised dates and tracking is usually the fix.

Published · Get the PDF

How do you count the status emails?

In Outlook, create a color category called “Order status,” then for two weeks tag every status question as it arrives: right-click the message in the list, choose Categorize and pick the category. Microsoft’s help page covers the same steps for new and classic Outlook, and notes that categories can’t be assigned in an IMAP email account.

Multiply status emails per week by minutes to answer one (time three of them) and you have the hours a week your team spends being a lookup service. Some of those emails are dealers catching late, short-shipped or wrong orders before you do. That is worth fixing whatever you decide about a portal.

Why do dealers keep asking?

  • Status lives in three places. The order is in QuickBooks, what was picked and packed is on a paper sheet or a warehouse spreadsheet, and the tracking number is in the carrier’s system.
  • Partial shipments and backorders. The confirmation said 40 units. Twenty-five shipped, and the dealer has no idea when the other 15 will follow.
  • Promised dates aren’t written down, or they change without anyone telling the customer.
  • Dealers have customers too. Their customer is asking them, so they ask you.
  • Replies come from personal inboxes. When the person who answered last time is out, nobody knows what the dealer was told.

How do you cut the emails yourself?

  1. Keep every open order in one place. If you run QuickBooks Desktop, use sales orders for orders you will ship later. Intuit’s help page notes that “Sales order is only available in QuickBooks Desktop Premier and Enterprise.” To switch them on, go to Edit > Preferences > Sales & Customers, open the Company Preferences tab, turn on sales orders and click OK.
  2. Write the promised date on every order, in the same place every time.
  3. Review open orders every morning. On Intuit’s community forum, the QuickBooks Team gives the path as Reports > Sales > Open Sales Orders by Customer. Look for anything past its promised date before a dealer does.
  4. Send status before you’re asked. When an order ships, reply in the same email thread as the order confirmation with the tracking number. When a line goes on backorder, tell the dealer the new date that day.
  5. Answer from one shared address, so anyone covering can see what was said last time.
  6. Write three standard replies: shipped with tracking, shipped in part with a date for the rest, and delayed with a new date.

Keep tagging status emails while you make these changes. If the weekly count drops and stays down, you may not need anything more.

What does a dealer portal do?

It is a website where each dealer logs in and sees only their own records: open orders, each line’s shipped and backordered quantity, promised dates, tracking numbers and invoices. It reads from your records and changes nothing, which keeps it smaller and safer than an ordering site. If you also want dealers to place orders online, see B2B wholesale ordering portals.

Two things need care. How the portal reads your data depends on how and where your QuickBooks Desktop company file runs. And every dealer must see only their own orders. The FTC’s guide for businesses puts the principle plainly: “Not everyone on your staff needs unrestricted access to your network and the information stored on it.” The same applies to your customers, and it is why the guide also asks for strong logins.

What are your options?

OptionGood whenWatch for
Do it yourselfA modest number of dealers, and status mostly inside QuickBooksIt depends on someone doing the review every day
Buy a toolYou also want online ordering and will move your orders into itMoving your order process, fees that grow with users or orders, setup time
Hire a freelancerYou can write the spec and test the resultReading QuickBooks Desktop data reliably, login security, who maintains it
Bring in an outside team (Custom software)Status is spread across several places, or dealers want answers outside office hoursThey need read access to order data; put the limits in writing

FAQ

Is a dealer portal the same as an online ordering site?

No. A status portal only shows information. An ordering site takes orders, applies each dealer’s prices and checks credit, which is a bigger and riskier build. Many wholesalers start with status and add ordering later.

Will dealers actually use it?

Some will and some will keep emailing. Put the portal link in every order confirmation and shipping email, keep tagging status emails, and watch the count. The number tells you whether it’s working.

Can the portal show carrier tracking?

Only if the tracking number is recorded against the order somewhere the portal can read. If tracking numbers live on paper or only in the carrier’s software, that gap gets fixed first.

Do we need to change accounting software first?

Not necessarily. The portal reads from your records as they are. It is worth planning for a future move, though, so the portal doesn’t have to be rebuilt when you change systems.

Sources

Have one problem in mind?

Walk us through it on a free 30-minute call. Within two business days you get a one-page note on what we’d fix first, yours to keep.

Walk us through one problemFree 30-minute call.