Managing Daily Gachapon Machine Counts
with AnyDB
Brick-and-mortar gachapon retailer
Not specified
Retail and entertainment
Around 200 machines with daily counts and refills
Keywords: Gachapon inventory management, daily stock count, machine inventory, capsule toy inventory, mobile inventory count, machine refill tracking, retail sales reporting
Location: Not specified
The company is opening a physical store with around 200 gachapon machines dispensing capsule toys from Japan.
Each day, an employee needs to walk the store and record the capsules remaining in every machine using a mobile device.
The counts must be fast while still supporting refills, purchasing decisions, and sales reporting by product, machine, zone, manufacturer, and period.
Result: A connected inventory system for manufacturers, products, machines, daily counts, count lines, and refills.
In practice, that meant:
The owner had already planned Products, Machines, Daily Inventory, and Daily Inventory Lines.
The main challenge was preparing one line per machine so employees only entered the remaining quantity during the daily count.
The structure also needed to support refills, capsule sales, product stock, reporting, and future purchasing without complicating the launch.
Each manufacturer connects to its products, and each product connects to the machines where it is sold.
Each count records the sale date, employee, progress, capsules sold, and estimated sales.
The button creates one prefilled line for every active machine, leaving only the remaining quantity to enter.
Employees follow a table-style list organized by zone or room while walking through the store.
Separate refill records show which product and quantity were added to each machine.
Count lines support sales reporting by product, machine, zone, manufacturer, and period.
Faster daily machine counts
Less setup and fewer field changes
Cleaner machine-by-machine history
Clearer refill and purchasing signals
Sales reporting across machines and products
Employees only enter remaining quantities, while each count line already carries the machine, product, manufacturer, zone, and sale date needed for reporting.
The same structure can later expand into purchasing, order lines, refill planning, inventory valuation, and deeper product performance reporting.