Material inventory

Turn raw material inventory spreadsheets into cleaner availability views.

Join the waitlist for a tool that cleans messy material inventory exports and highlights available stock, allocated material, reorder gaps, and inconsistent descriptions.

Join the waitlist See example

Example

Clean raw material inventory spreadsheets.

Preview how raw material rows could be grouped into a clearer stock status report.

Example input

Uploaded file: raw_material_inventory.csv

Material,Grade,Size,Length,Qty,Location,Allocated Job,Min Qty,Notes
Round Bar,1018,1.000 in,144 in,6,Rack A2,,3,
RD BAR,1018,1",12 ft,2,A-2,JOB-1842,3,same as above?
Plate,A36,0.250 x 48 x 96,96 in,1,Rack P1,,2,low
Tube,304 SS,2 x 2 x .120,240 in,4,,JOB-1831,1,no location
Flat Bar,6061,0.5 x 2,144 in,,Rack A5,,2,qty missing
Round Bar,1018,1.500 in,72 in,0,Rack A3,,1,out

Example output

Report summary

Raw material spreadsheet converted into normalized dimensions and stock status.

medium

Material rows checked

Dimension fixes

Allocated stock

Reorder flags

Detected findings

Dimension formats normalized

medium

Values like 2 x 4 x 96, 2x4x8ft, and 2.00/4.00/96 were converted into consistent inch dimensions.

Allocated material separated from available stock

medium

Rows marked reserved, job hold, or allocated were excluded from available quantity.

Grade naming inconsistent

low

A36 plate and ASTM A36 were grouped into the same material grade.

Reorder required

high

Three material groups are below their minimum available quantity after allocation.

Normalized inventory sample

Material	Dimensions	Available	Status
A36 Bar	2 x 4 x 96 in	6	OK
304 SS Tube	1.5 OD x 72 in	1	Reorder
6061 Plate	0.25 x 24 x 48 in	0	Allocated
A36 Plate	0.5 x 48 x 96 in	2	Low

Recommended next step: Use the normalized available quantity view to decide what needs reorder before the next job release.

Waitlist

Get notified when this tool opens

Leave your email and optionally describe the exact file or workflow you would want checked.

FAQ

Questions before you join

Is this an ERP replacement?

No. The concept is a focused spreadsheet cleaner for raw material inventory, allocations, dimensions, and reorder flags.

What material formats would it handle?

The target is common messy rows for bar, tube, plate, sheet, drops, remnants, racks, jobs, and available quantity fields.

Does it give purchasing advice?

No. It only organizes and flags inventory records; buying decisions stay with the shop.

What should I write in the use case box?

Describe the messy fields you have: grades, dimensions, rack locations, allocated jobs, remnants, min quantities, or unit conversions.