INVENTORY & ORDERS

Inventory Management and Ordering System Development

When one product sells on several channels at once and stock is split between a warehouse and suppliers, stock counts tend to drift and items are more likely to be sold twice. Here are cases of a core system that handles allocation of tens of thousands of stock items and status management from order to shipment, an ordering site for business partners, and ordering for construction sites, and how we approach them.
Related Service: System Development

CONSULTATIONS

Common Requests About Inventory Management and Ordering

The hard part of building inventory and ordering systems is the rules, not the screens: which stock to allocate to which order, and when an order may move on to the next status. Here are the requests we hear most often, and how we approach them.

Inventory and Allocation

We review each sales channel’s orders, and a person decides which stock to allocate

Our Approach

We collect orders in one place and allocate stock to them automatically

When order entry points are split among a wholesale ordering site, Rakuten Ichiba, and your own e-commerce site, the work of checking stock for each order grows in proportion to the number of orders. The more the decisions depend on people, the more likely allocation mistakes become.

In the core business system for a furniture and interior wholesaler, we built a mechanism that collects the orders of multiple shops in one place and allocates them automatically from warehouse and supplier stock. It also automatically calculates an estimate of when each order can ship, based on stock and expected arrivals.

Warehouse stock and supplier direct-ship stock get mixed up, and the counts do not match

Our Approach

We manage each type of stock separately, with its own counting method and shipping procedure

Products shipped from your own warehouse and products delivered directly by suppliers differ in both how stock is counted and how shipping is handled. Handling them together in a single table puts the stock counts out of sync and leads to stockouts and items being sold twice.

We separated the management of warehouse stock and supplier stock and prepared a dedicated shipping screen for each. Everything from checking shipping instructions to registering the tracking number can be done in one flow.

Tens of thousands of stock items are moving at once, and status management cannot keep up

Our Approach

We manage the status of orders, purchase orders, arrivals, and shipments under one consistent set of rules

One product sells on multiple sales channels at the same time, and expected arrivals change from day to day. If it is unclear when an order may move on to the next status, the handling of exceptions ends up concentrated on particular people.

We decide with you, one by one, the statuses of orders, purchase orders, arrivals, and shipments, along with the conditions for moving on to the next status, exceptions included, before turning them into specifications.

Ordering and Order Management

Our ordering is split across LINE, phone, and fax

Our Approach

We put orders into one standard format and let people send them from a smartphone on site

When each person places orders in a different way, errors in part numbers and quantities occur and no record remains. Communication about delivery schedules and changes also ends up depending on phone calls and fax.

In the construction site ordering system “Di-ORDER,” we built a mechanism that puts orders into one standard format and lets people place them from a smartphone on site. According to the service website, ordering effort has fallen by 65% and ordering mistakes by 92%.

Our ordering site is hard to use, and we keep having to explain it to new business partners

Our Approach

We make products easier to find and shorten the steps for ordering and payment

Usability problems such as having to download all product information before you can find anything, payment by bank transfer only, and a complicated invoice process turn into explanation and support work every time a new business partner comes on board.

For the full redesign of a furniture and interior wholesaler’s ordering service, we introduced a search that narrows results by conditions and lets you download only the products you need, credit card payment, and shorter ordering and billing steps. It was released about five months after we started.

STRENGTHS

How We Can Help with Inventory and Ordering System Development

We put our effort into nailing down the allocation and status rules rather than into the number of screens. Here we describe mainly what we actually did in our case studies.

  1. Nailing Down the Allocation and Status Rules All the Way

    What makes an inventory management system difficult is not the number of screens but the logic. We decide completely, exceptions included, which stock is allocated to which order and when an order may move on to the next status, so that the numbers do not drift even when tens of thousands of stock items move across multiple sales channels at the same time.

    CasesCore Business System for a Furniture Wholesaler

  2. Connecting Sales Channels, Warehouses, and Suppliers in One Flow

    In addition to API integration of stock and orders with Rakuten Ichiba and your own e-commerce site, we prepare dedicated screens for warehouse staff and for suppliers, so that everything from shipping instructions to tracking number registration runs as one flow. We can also integrate with existing core business systems and external e-commerce services.

    CasesCore Business System for a Furniture WholesalerOrdering Site for a Furniture Wholesaler

  3. Building Step by Step, Starting from Where Sales Come In

    You do not need to rebuild everything at once. In the furniture and interior wholesaler case, we started with the redesign of the ordering service for business partners. We then set up, one at a time, automatic product information updates, the company’s own e-commerce site, and the sales entry points, and finally built the core business system that takes in everything.

    CasesOrdering Site for a Furniture WholesalerA Company’s Own E-commerce Site on ShopifyCore Business System for a Furniture Wholesaler

  4. AI That Lets You Check Stock by Talking to It

    We built an AI assistant into the core business system: you simply ask a question such as “How many orders did we receive today?” or “Are any products out of stock?” and it looks up the data and answers. For ordering at construction sites, we have also developed a feature that reads a PDF delivery schedule and imports it into the screen.

    CasesCore Business System for a Furniture WholesalerOrdering for Construction Sites

SCOPE

Features We Cover in Inventory Management and Ordering Systems

We connect everything from receiving orders through allocation, shipping, and billing in one set of data. We can also develop only the parts you need.

Centralized Order Intake

We gather orders from multiple sales channels, such as an ordering site, Rakuten Ichiba, and your own e-commerce site, in one place.

Stock Allocation

We allocate stock to each order automatically, based on warehouse and supplier stock and expected arrivals.

Status Management

We manage the status of orders, purchase orders, arrivals, and shipments under consistent rules.

Shipping and Tracking Numbers

Shipping instructions for warehouses and suppliers, and registration of tracking numbers.

Ordering Site for Business Partners

Product search you can narrow by conditions, downloads of only the products you need, card payment, and invoices.

On-Site Ordering

Ordering from a smartphone and sharing of delivery schedules.

External Integrations

Integration with Rakuten Ichiba, your own e-commerce site, existing core business systems, and accounting and payment services.

Data Migration and Switchover

Migration of existing data and switchover of existing users’ accounts.

HOW TO CHOOSE

Choosing Between an Off-the-Shelf Inventory Management System and Custom Development

You do not need to custom-build everything. The right approach depends on the number of sales channels and warehouses and on the terms for each business partner.

SituationSuitable Approach
One sales channel and one warehouse, with a standard workflowOff-the-shelf inventory management or ordering system
The same stock is sold on multiple sales channelsCustom development of stock allocation
Warehouse stock and supplier direct-ship stock are mixedCustom development of stock management and shipping flows for each stock type
Prices and ordering flows differ by business partnerCustom development of an ordering site for business partners
A core business system and an e-commerce site are in place, but the connections between them are missingDevelopment of only the integration parts

We compare the options, including cost and timeline, and recommend the one that fits.

FLOW

Our Process for Inventory Management and Ordering System Development

We settle the workflow and rules first, then build out the system in stages, starting where the impact is greatest.

  1. Sort Out the Flow of Orders and Stock

    For each sales channel, warehouse, and supplier, we sort out how orders and stock move. We decide which stock is allocated to which order and when an order moves on to the next status, exceptions included.

    Once the rules are decided, the required screens follow

  2. Check the Screens with Stakeholders

    We organize the information in wireframes and design the screens for each type of user, such as warehouse staff, suppliers, and business partners, confirming them with stakeholders as we go.

  3. Development and Integration

    We develop everything, including integration with your core business system and e-commerce site and migration of your existing data. When we are left waiting on requests made to outside parties, we reorder the work so that progress does not stop.

  4. Switchover and Operations

    We notify existing users in advance and support them through the switchover of their accounts. After the system goes live, we continue to add features and make improvements.

    The full redesign of the ordering service for business partners was released about five months after we started

FAQ

Frequently Asked Questions About Inventory Management and Ordering System Development

Here are the questions we are asked most often before a consultation. Please feel free to ask about anything not covered here.

Can stock counts stay accurate even if we sell the same stock in multiple shops?

Yes. In the core business system for a furniture and interior wholesaler, we prevent stock counts from drifting by collecting orders from across shops in one place and allocating stock to them automatically from warehouse and supplier stock.

Can you handle a mix of warehouse stock and supplier direct-ship stock?

Yes. We have a case in which we managed warehouse stock and supplier stock separately and prepared a dedicated shipping screen for each.

Can you connect it with the core business system or e-commerce site we use now?

Yes. In the redesign of the ordering service, we handled integration with the existing core business system and external e-commerce services as part of the requirements. We also have a track record of API integration of stock and orders with Rakuten Ichiba and companies’ own e-commerce sites.

How should we choose between an off-the-shelf inventory management system and custom development?

If you have few sales channels and warehouses and a standard workflow, an off-the-shelf product lets you get started sooner. If you sell the same stock on multiple sales channels, have warehouse and supplier stock mixed together, or have different terms for each business partner, custom development or development of the integration parts is a better fit. We compare the options, including cost and timeline, and make a recommendation.

How long does development take?

It depends on the scope. The full redesign of an ordering service for business partners was released about five months after we started. We can also proceed in stages, starting where the impact is greatest, instead of rebuilding everything at once.

Can you carry over the data from our current system or spreadsheets?

Yes. In the redesign of the ordering service, we handled the migration of existing data and the switchover of existing users’ accounts. In the case of a company’s own e-commerce site, we also built a mechanism that automatically updates the e-commerce site with product information managed in a spreadsheet.

Can we look up stock and order status by asking AI?

Yes. We built an AI assistant into a core business system: you simply ask a question such as “How many orders did we receive today?” or “Are any products out of stock?” and it looks up the data and answers.

How is the cost determined?

It varies greatly with the number of sales channels, warehouses, and suppliers, the complexity of the allocation and status rules, the number of systems to integrate, and the volume of data to migrate. Before we prepare an estimate, we sort these out together with you.