How to Import Your Inventory from CSV: Step-by-Step Guide

Moving your inventory data from spreadsheets to a dedicated management tool does not have to be painful. Whether you are migrating from Excel, Google Sheets, or another inventory management system, a well-prepared CSV import can get you up and running in minutes, not days.

This guide walks you through the entire CSV import process in Vantura -- from preparing your file to verifying your data after import.

Why CSV Import Matters

CSV (Comma-Separated Values) is the universal data format. Every spreadsheet application, inventory tool, and database can export to CSV. This makes it the bridge between your current system and your next one. A smooth import means:

• No re-entering data: If you have hundreds or thousands of products, manual entry is not an option. CSV import handles bulk data efficiently.
• Accurate starting point: Your inventory system is only as good as its data. Importing from your existing spreadsheet preserves the work you have already done.
• Fast time-to-value: Instead of spending weeks setting up a new tool, you can be operational in minutes.

Step 1: Prepare Your CSV File

Before importing, your CSV file needs to be properly formatted. Vantura accepts CSV files with the following columns:

Column	Required?	Description
name	Yes	Product name (e.g., "Blue Widget - Medium")
sku	No	Stock Keeping Unit identifier
quantity	No	Current stock quantity (whole number)
unit_cost	No	Cost per unit in your base currency (e.g., 12.50)
category	No	Product category for grouping
location	No	Storage location name
reorder_point	No	Low-stock alert threshold
barcode	No	Barcode or UPC number

Formatting tips:

• Use UTF-8 encoding (most spreadsheet apps default to this).
• Keep one product per row.
• Do not include currency symbols in number columns ($12.50 should be 12.50).
• Use consistent category names (do not mix "Electronics" and "electronics").
• Remove any blank rows at the end of your file.
• If exporting from Excel, save as "CSV UTF-8" rather than plain CSV.

Step 2: Export from Your Current System

If you are migrating from another inventory tool, export your product catalog as a CSV file. Most tools offer this under Settings or Data Export. Common sources:

• Google Sheets: File > Download > Comma-separated values (.csv)
• Excel: File > Save As > CSV UTF-8 (Comma delimited)
• Sortly: Settings > Export > CSV
• inFlow: Reports > Product List > Export CSV
• Cin7: Products > Export > CSV

Your exported file may have different column names than Vantura expects. That is fine -- the import wizard handles column mapping in the next step.

Step 3: Upload and Map Columns

In Vantura, navigate to Products and click the Import button. Select your CSV file and the import wizard will display a preview of your data.

The column mapping step is where you tell Vantura which column in your file corresponds to which field. The wizard will attempt to auto-match common column names:

• Product Name, Item Name, or Name maps to name
• SKU, Item Code, or Product Code maps to sku
• Qty, Stock, or On Hand maps to quantity
• Cost, Unit Price, or Purchase Price maps to unit_cost

If auto-matching does not find the right column, you can manually select the mapping from a dropdown. Columns you do not map will be skipped (they will not be imported but no data is lost in your source file).

Step 4: Review Validation Results

Before the actual import runs, Vantura validates your data and shows any issues it found:

• Errors (red): Must be fixed before import. Examples: missing required product name, invalid number format in quantity column.
• Warnings (yellow): Import will proceed, but you should review. Examples: duplicate SKU (existing product will be updated), negative quantity.
• Info (blue): Informational notices. Examples: new categories that will be created, empty optional fields.

The validation screen shows a row-by-row breakdown so you can fix issues in your CSV and re-upload, or accept the warnings and proceed.

Step 5: Confirm and Import

Review the import summary: total products to create, products to update (if matching SKUs exist), and any rows to skip. Click Confirm Import to execute.

The import runs in the background. For small files (under 500 products), it completes in seconds. Larger imports (thousands of products) may take a minute or two. You will see a progress indicator and a completion notification.

Step 6: Post-Import Verification

After import, take five minutes to verify your data:

1. Check product count: Compare the number of products in Vantura to the number of rows in your CSV (minus the header). They should match.
2. Spot-check quantities: Pick 5-10 products at random and verify their quantities match your records.
3. Verify costs: Check that unit costs imported correctly, especially if you had currency formatting in your spreadsheet.
4. Check categories: Navigate to your product list and filter by category to ensure groupings are correct.
5. Set reorder points: If you did not import reorder points, set them now for your most critical products.

Common CSV Import Issues and Fixes

• Encoding errors (garbled characters): Re-export your CSV using UTF-8 encoding. In Excel, specifically choose "CSV UTF-8" as the file format.
• Numbers imported as text: Remove currency symbols, thousands separators (commas in numbers like 1,000), and percentage signs from numeric columns.
• Duplicate products: If you have duplicate SKUs in your file, Vantura will warn you. Decide whether to keep the first or last occurrence.
• Missing header row: Vantura expects the first row to contain column names. If your file starts with data, add a header row.
• Extra whitespace: Leading or trailing spaces in product names can cause duplicates. Trim your data in the spreadsheet before exporting.

Migrating from Spreadsheets to Vantura

If you have been managing inventory in a spreadsheet, your CSV is probably already close to what Vantura needs. The key difference is that spreadsheets are static snapshots while Vantura tracks movements in real time. After importing your baseline data, every stock adjustment, purchase order receipt, and sale is tracked automatically.

Your spreadsheet becomes your starting point. From there, Vantura handles the ongoing tracking, cost calculations, and inventory valuation that spreadsheets cannot do reliably.