What is the difference between in_stock and available?

in_stock is the total quantity in the warehouse. reserved is stock committed to pending orders. available = in_stock - reserved, representing what can still be ordered.

How do I find products below their reorder point?

In a spreadsheet use a formula like =IF(available<reorder_point,"Reorder","OK"). In SQL, use WHERE available < reorder_point after importing the CSV.

How do I update inventory from a CSV file?

Use the CSV to SQL INSERT or UPSERT converter to generate SQL from the file. Most inventory systems also provide direct CSV import functionality in their admin UI.

Format a CSV Inventory File

Inventory CSV files from warehouse management systems and e-commerce platforms drive purchasing, fulfillment, and reporting workflows. This example shows a product inventory with stock levels, reorder points, and category assignments. The CSV viewer renders columns clearly so you can spot zero-stock items and products below their reorder threshold at a glance. Validate column count consistency before importing to an ERP.

Example

sku,name,category,in_stock,reserved,available,reorder_point,cost,price
KB-100,Wireless Keyboard,Electronics,45,5,40,10,32.00,79.99
HUB-200,USB-C Hub,Electronics,12,2,10,5,18.00,49.99
MS-300,Monitor Stand,Furniture,3,0,3,8,12.00,34.99
LAMP-500,Desk Lamp,Furniture,0,0,0,5,10.00,28.99
CAM-400,Webcam 1080p,Electronics,28,4,24,10,35.00,89.99

[ open in CSV File Viewer → ]

FAQ

What is the difference between in_stock and available?: in_stock is the total quantity in the warehouse. reserved is stock committed to pending orders. available = in_stock - reserved, representing what can still be ordered.
How do I find products below their reorder point?: In a spreadsheet use a formula like =IF(available<reorder_point,"Reorder","OK"). In SQL, use WHERE available < reorder_point after importing the CSV.
How do I update inventory from a CSV file?: Use the CSV to SQL INSERT or UPSERT converter to generate SQL from the file. Most inventory systems also provide direct CSV import functionality in their admin UI.

Related Examples

Format a CSV Sales Report

Sales data CSV files are exported from e-commerce platforms, ERPs, and reporting...

Format a CSV Financial Statement

Financial CSV exports from accounting software, payment processors, and bank API...

Format a CSV User List

User lists exported from databases, CRMs, or admin panels are among the most com...