We developed an Inventory Management Software for a Dammam Industrial Spare Parts Manufacturer to Increase the Order Fulfillment Rate from 78% to 96%

Warehouse console with the order fulfillment rate, rack stock levels and today’s reservations, beside the part’s stock in the Android app

Project Overview

Our client is a spare parts manufacturer in Dammam that supplies industrial customers. It maintained its stock records on spreadsheets, so the numbers on screen did not always match what was on the shelf. Salespeople promised parts that were not available, and only 78% of orders shipped on time. The main issue was that 1 in 5 orders missed items or were delayed.

The company wanted an inventory management software that helps its sales team and production team work from one set of stock numbers.

To solve this, we developed an inventory management software with a web app and an Android app. Workers record every part that comes in and goes out. Salespeople see real stock before they confirm an order, and the order fulfillment rate rose from 78% to 96%.

Business Challenges

  • Stock records were not current

    Spreadsheets were updated by hand, so they were often behind the real stock. Sales promised parts that were no longer there.

  • Orders did not reserve parts

    Two orders could rely on the same part, and the second one shipped late or incomplete.

  • Part locations were not recorded

    Workers had to search the warehouse for each part, which slowed picking.

  • Similar parts were easy to confuse

    Parts that look almost the same, such as one valve in two sizes, were sometimes mixed up.

  • Material shortages showed up late

    Production found out that raw material was short only after a job had started.

  • Batch records were on paper

    Finding the material certificate for a shipped part took time.

How We Define Order Fulfillment

At the start, 78% of orders met this rule. The software now checks it for every order.

  1. An order is fulfilled when all items ship in full on the date promised.

  2. If one item is missing, the order is not fulfilled.

  3. If the whole order is late, it is not fulfilled either.

Our Solution

We built a receiving screen in the Android app. When a delivery arrives, the worker scans each box with the phone camera. The software compares the delivery with the purchase order and shows any difference right away.

  • Quantity checked against the purchase order
  • Batch number saved for each delivery
  • Supplier certificate attached to the batch
  • Missing or damaged items flagged for the buyer

The software keeps a location for every part. When a worker puts a part away, they scan the part and enter or scan the location. From then on, the system knows where it is.

  • Moves between locations are recorded the same way
  • One search box that shows every location holding a part
  • Suggested location for incoming parts

When a salesperson enters an order, the screen shows what is in stock, what is already promised to other customers, and what is coming from production. The delivery date is based on real stock.

  • Parts reserved as soon as an order is confirmed
  • Two orders cannot claim the same part
  • Warning when an order is likely to miss its date
  • Backorder list for items that could not ship

The worker gets a pick list in the app. They scan each part, and if it is the wrong one, the app shows an error.

  • Older batches picked first
  • Partial shipments allowed, with unshipped items moved to the backorder list
  • Delivery note and invoice created from the same order
  • Invoice sent to the company’s existing accounting system

For parts the company makes itself, we saved a list of materials for each part. When a production job starts, the software reserves that material and warns the buyer if there is not enough.

  • Finished parts are added to stock with a batch number
  • Minimum and maximum stock levels for each part
  • A purchase request is created for approval when stock drops below the minimum

Workers count a few shelves at a time in the app, so the warehouse does not need to stop for a full count. A supervisor approves any difference before the stock number changes.

Managers see one screen with live stock, late orders, backorders and the fulfillment rate by customer and by week. An alert goes out when an order is likely to miss its date.

  • Roles for salespeople, workers, buyers, supervisors and managers
  • Every stock change saved with the user, the time and the reason
  • Sessions that expire after a short time of inactivity
  • Data encrypted when stored and when sent
Android app: a barcode pick with the part’s location and its order reservation, and the part’s stock by location
Inventory console on a laptop cycling through the results: orders shipped complete and on time, one set of stock numbers, reservations and stock counts

Technology Stack

  • Web app

    React

    Why we chose it

    Easy to search and filter large lists of parts and orders

  • Mobile app

    Flutter on Android

    Why we chose it

    One app that reads barcodes with the phone camera

  • Backend

    Node.js

    Why we chose it

    Handles many quick updates from the warehouse

  • Database

    PostgreSQL

    Why we chose it

    Saves every stock movement safely

  • Offline mode

    Local storage on the phone

    Why we chose it

    Scanning continues with weak signal and syncs later

  • Accounting link

    REST APIs

    Why we chose it

    Sends invoices to the company’s existing accounting system

  • Cloud

    AWS

    Why we chose it

    Managed databases, backups and monitoring

Saudi Specific Integrations

  • ZATCA e-invoicing

    Invoice data is sent to the client's existing accounting system, which handles the applicable ZATCA e-invoicing requirements

  • VAT

    15% VAT calculated on every line, with amounts in SAR

  • Arabic and English

    Both languages in the web app and the Android app, with right-to-left layout for Arabic

  • Working days

    Delivery dates follow the client's operating calendar and account for Saudi public holidays

  • PDPL

    Role-based access and activity logs help protect staff and customer personal data in line with PDPL requirements

Development Process

  1. Requirement gathering

    We started with discussions to know how stock and invoicing worked, and listed the features the software needed.

  2. UI and UX design

    We designed the screens for the web app and the Android app, Arabic first, and shared clickable prototypes with the client for feedback.

  3. Core development

    Our software development company built stock tracking, locations and the picking flow first, then reordering, production material lists and stock counts.

  4. Data import

    We built a tool to load the client’s existing part list and stock levels from their spreadsheets into the new database.

  5. Accounting integration

    We connected the software to the client’s accounting system through APIs, so invoices flow without retyping.

  6. Testing

    We tested stock updates and offline sync, and checked that two users cannot claim the same part at the same time.

  7. Deployment and support

    Our inventory software development team deployed the software on AWS and supported the client’s team after launch.

What the Client Says

— Authorized Client Representative, Saudi Manufacturing Company

We collaborated with Code Brew Labs to develop inventory management software for our warehouse. Earlier, we kept our stock in spreadsheets, and we often promised parts we did not have. Now our team records every part in the app, and our salespeople give delivery dates based on real stock. Our orders leave on time and complete far more often than before.

Results and Operational Improvements

  • Orders shipped complete and on time rose from 78% to 96%

  • Sales, warehouse and production now work from one set of stock numbers

  • Parts are reserved when an order is confirmed, so two orders cannot claim the same part

  • Stock counts no longer need the warehouse to stop work

  • Material certificates are saved with each batch and order

Planning to Develop an Inventory Management Software in Saudi Arabia?

Connect with our custom software development company in Saudi Arabia to develop a solution that matches your exact needs.

Get a Free Quote
Contact Us

Ready To Fuel Your Vision With AI-Powered Innovation?

Our Presence

Level- 18, Dubai World Trade Centre Tower, Sheikh Rashid Tower, Sheikh Zayed Rd, Dubai, UAE

business@code-brew.com +971-55-645-7972

Plot no I - 36, Sector 83 Alpha, Mohali SAS Nagar 140308

business@code-brew.com +91-771-976-8427

Al Akaria 2, 6926 Olaya Street, RHOA2566, Riyadh, Saudi Arabia.

business@code-brew.com

Av. Miguel Hidalgo y Costilla 1995, Arcos Vallarta, 44600 Guadalajara, Mexico

business@code-brew.com +1(213)2614953

4231 Balboa Ave #512 San Diego, CA 92117 United States

business@code-brew.com +1(213)2614953

2nd floor, College House, 17 King Edwards Rd, London HA4 7AE, UK

business@code-brew.com +44 (20) 82644493

Partner With Experts Who Leverage AI & Tech To Transform Ideas Into Market-Leading Solutions.

Wait! Looking for Right Technology Partner For Your Business Growth?

It's Time To Convert Your Business Idea Into Success!

Get Free Consultation From Top Industry Experts:
gif
I would like to keep it to myself