Hero Image

Case Study

Inventory Shrink Reporting that counts before the count

Kawaii Slime Company × AUTOBIZZ

Sometimes, products were shown as in-stock but were physically missing, delaying fulfillment and making shrinkage difficult to identify. An automated shrink report was needed to quickly flag these discrepancies.

"Instead of discovering shrink through manual audits, the team now have an instant, reliable count the moment it finishes"

Client

Kawaii Slime Company (KSC)

Sector

E-commerce

Solution

Shrink Reporting & Inventory Management

Timeline

March 2026

AutoBizz gave Kawaii Slime Company a Shrink Number they could Trust and Act on.

AutoBizz built an automated shrink reporting system that pulls sales, purchases and Inventory data straight from Shopify, reconciles them against Actual counts in BigQuery, and turns five manual reconciliation steps into one consistent report. The result saves 5 hours of manual calculation of the team and lifted the order-flow upto 30% than before.

  • Shopify Analytics
  • BigQuery
  • Excel online
  • Microsoft Office Script
  • ShopifyQL
  • Inventory Reconciliation

The Situation

Orders were being missed, but the reasons were unclear

Stock was sometimes being shown as available when it was not. By the time the difference was noticed, an order could already have been affected.

Services We Provided

  • Data Automation
  • System Integration
  • Custom Dashboard Development

Old Routine

  1. 01Reports showing products are in-stock, but actually products were out of stock already
  2. 02Many orders get stuck just because of products are not in stock but it was informed before
  3. 03Inventory miscalculations increased manual checks leading to increase operational cost

The same investigation had to be repeated: "What was sold? What was received? What should still be there?"

And most importantly: "Where did the difference begin?"

Image of Client's Previous Situation

The Challenge

Every mismatch creates delay in order fulfillment

One mismatch was enough to slow everything down. Fulfillment could not move forward with confidence until the difference was understood.

FlowGraph_of_Challenges_image
  1. Products stock MismatchThe expected stock and the physical count did not always tell the same story.
  2. Shrink Was Easy to MissSmall inventory differences could go unnoticed until they started affecting orders.
  3. Build confusionSometimes unusual stock up down creates confusion on procurement chain.
  4. Orders Were Left WaitingUntil the stock difference was understood, the next step could not be taken with certainty.
  5. THE REAL COSTThe real loss was in orders that could not be fulfilled and money that could not be recovered until the shrink can be calculated correctly.

System Architecture

The System Design Board

System_Architecture_image_of_core_solution

SEE THE DELAY BEFORE IT BECOMES A CUSTOMER PROBLEM

The Turning Point

Orders now go out on time, and faster than ever.

As the numbers became more reliable, on-time orders started telling a different story improving month after month.

Growing Statistics after using the solution
The change was immediate.

Interface Portfolio

"Shrink" Finally Got Its Moment in the Spotlight

An interface prototype of the dashboard solution

The Solution

Five manual steps, rebuilt as one automated workflow

The Shrink Report now automated five manual steps: pulling numbers, consolidating product history, calculating expected stock, reconciling physical counts, and generating the final report consistently, every time.

01

Automated Data Ingestion

The process starts by bringing the numbers in automatically. Sales, purchases, transfers, and other stock movements are collected without the team having to pull reports or rebuild the data every time.

02

Centralized Inventory Ledger

Once the data arrives, everything comes together in one place. Each product keeps its own history of what came in, what went out, and how its stock changed over time. So nothing gets lost between reports.

03

Expected Stock Calculation

With the full movement history, the system works out what should still be there. Every sale, transfer, and adjustment is accounted for, turning a long manual calculation into one consistent expected-stock figure.

04

Shrink & Overage Detection

When the physical count comes in, the system compares it against the expected stock. Missing and excess quantities are identified product by product, so no variance is overlooked.

05

Automated Shrink Reporting

Finally, the differences come together as the Product Shrink Report. Instead of rebuilding the analysis from scratch, the team gets a consistent view of missing stocks, rate of variance and where the difference began.

What Changed

From Inventory Confusion to Complete Clarity

Before

Facing difficulty to count product availability or shrink

Now

Product availability and shrink counted automatically

Before

Order fulfillment was unable to complete on time

Now

Accurate stock keeps order fulfillment on schedule

Before

Uncontrolled procurement chain

Now

Procurement guided by reconciled, trustworthy numbers

Before

No reliable, real-time view of what's the status of product shrink level

Now

Near real-time visibility into stock across every location

The business outcomes after using our solution

The Results

The results that moved the number

160

Units

PRODUCTS SAVED FROM MISCALCULATION & STOCK-OUT

59%

MORE ORDERS SHIPPING ON TIME

5 Hrs

OF TEAM SAVED EACH MONTH

2.4x

FASTER TO CLOSE AN ORDER

References

Documentation this build relies on

  1. 01

    Shopify API Documentation

    The source for sales, purchase and transfer data the ledger is built from.

    View Source
  2. 02

    Microsoft Excel Online

    This platform is used for the user-side visualization and calculation.

    View Source
  3. 03

    Google BigQuery Documentation

    It has been used as store engine for the massive data coming from source.

    View Source
  4. 04

    Microsoft Office Scripts Documentation

    This documentation has been used for the Excel Online mapping layer.

    View Source

Get Started

Ready to Get your Report Accurate?

If your team is still recounting stock by hand, or if your orders are stuck just because of not knowing the currect stock count, AutoBizz can eliminate the guesswork with one automated, reconciled report.

FAQ

Frequently asked questions

Still have questions? Book a call and we'll answer anything.

What is automated shrink reporting?

Automated shrink reporting is the use of a system to calculate expected stock from sales, purchases and transfers, then compare it against a physical count without anyone rebuilding the numbers by hand. It flags the products where the shelf, the system and the customer order don't agree, and shows where the difference began. It replaces the spreadsheet-and-recount routine most retail and inventory teams start with.