1. Overview

The loaded file, column mapping, edited quantities and excluded items, and saved order lists are saved in the browser. They stay in place after a refresh or a later visit.

Connected at rollout: automatic stock sync with store or warehouse software, emailing or faxing orders to suppliers, reading Excel (xlsx) files directly (for now, save as CSV and upload), and server storage for sharing the same list across devices.

2. Challenges

1. Orders are calculated by hand in Excel every time.

Add incoming stock to current stock, subtract outgoing orders, compare against safety stock, then round to minimum order quantity and box units — repeated for every item. Uploading the file should finish this calculation in one step.

2. One bad row breaks the whole calculation.

When rows with a missing supplier or text in a number field slip in, totals go wrong without anyone noticing. Rows that can't be read should be shown separately with the reason.

3. Orders go out to each supplier separately.

Splitting the results by supplier and pasting them again takes even more time. Items, quantities, and amounts should be grouped per supplier and ready to download.

3. Structure

The calculation happens entirely on the first screen. File loading, column mapping, and calculation settings are on the left; results and supplier tabs are on the right. Saved Lists and List View have their own addresses, so the back button and refresh keep you on the same screen.

4. Key Features

Order Quantity Calculation and Summary

Only items whose available stock (current + incoming − outgoing) is below safety stock remain. It suggests the larger of the amount needed to reach target stock and the minimum order quantity, rounded up to the order unit, and shows the number of items and the total cost of ordering as suggested in one line at the top.

Edit, Exclude, and Reset Quantities

When you edit a suggested quantity, the original stays beside it (e.g. "직접 고침 · 제안 96", edited · suggested 96), and a red mark warns if it isn't a multiple of the order unit. Uncheck items you won't order this time, and reset everything to suggested quantities in one step.

View by Supplier

Each supplier tab shows its item count and amount; tap one to see only that supplier's items. The total in the bottom bar and the CSV download follow the selected supplier.

Reopen Saved Order Lists

Name a list and save it; it is stored with the save time, file name, number of suppliers, and amount. Opening it shows tables split by supplier, and you can download all of it or one supplier as CSV. Lists you no longer need can be deleted.

• Notice for Rows Left OutRows with a missing supplier or text such as "열둘" (twelve, in words) in a number field are left out of the calculation, with the row number and the reason shown. Fix the source file and upload it again.
• Column Mapping for Files with Different HeadersEleven columns such as item code, supplier, and current stock are mapped automatically by header name (SKU, vendor, stock, and so on). Required columns that aren't mapped are marked in red; pick one manually and it recalculates at once.

6. QA

Results from running the pages on PC 1440 and mobile 390 screens and clicking through in the order a real user would. We also checked that data is still there after saving and refreshing. (2026-09-23)

The 16 function tests: first screen display · loading the sample inventory file and calculating · checking calculated values (available stock, unit rounding) · notice for rows left out · column mapping display · view by supplier · editing quantities, unit warning, reset · excluding items · item search · work kept after refresh · CSV download · saving an order list · viewing saved lists after refresh · supplier CSV from a saved list · uploading a file with different headers and mapping columns manually · deleting a saved list

Speed and quality scores (out of 100; mobile measured three times on a slow connection, median shown)

Mobile: First Contentful Paint 1.0s · Largest Contentful Paint 1.3s · Layout Shift 0.000 · Blocking Time 60ms PC: First Contentful Paint 0.4s · Largest Contentful Paint 0.4s · Layout Shift 0.000 · Blocking Time 0ms

7. Result