CSV Import & Export

StockrHub supports CSV (Comma-Separated Values) files for bulk data operations. You can export reports and stock data to CSV for analysis in spreadsheet applications, and import data from CSV files to speed up operations like stock counts.

Exporting to CSV

Available Exports

You can export the following data to CSV from StockrHub:

Procurement Spend Report — historical spending by supplier, product, or time period.
Sales Velocity Report — product sales rates and trends.
Inventory Adjustments Report — all stock adjustments with reasons and timestamps.
Stock Levels — current inventory levels across locations.
Purchase Order Line Items — detailed PO data for a specific order or date range.

How to Export

Navigate to the relevant section (e.g., Reports or Stock Levels).
Apply any filters you need (date range, supplier, location, etc.).
Click the Export CSV button.
The CSV file will download to your device automatically.

Importing from CSV

Stock Count Import

You can import stock count data from a CSV file instead of manually entering or scanning each item:

Navigate to Stock Counts and create a new count or open a draft.
Click Import CSV.
Select your CSV file.
Map the columns if prompted (StockrHub will auto-detect standard column names).
Review the imported data before submitting.

CSV Format Requirements

Your CSV file must follow these formatting rules:

Requirement	Details
File encoding	UTF-8
Delimiter	Comma (`,`)
Header row	Required — first row must contain column names
Text qualifier	Double quotes (`"`) for values containing commas
Line endings	Windows (CRLF) or Unix (LF) both accepted

Required Columns

The specific columns depend on the import type. For a stock count import:

Column	Required	Description
`sku`	Yes	The product variant SKU
`barcode`	No	Product barcode (alternative to SKU for matching)
`quantity`	Yes	The counted quantity
`location`	No	Location name (defaults to primary location if omitted)

Example CSV Templates

Stock Count Template

sku,quantity,location
WIDGET-BLU-SM,25,Warehouse
WIDGET-BLU-MD,18,Warehouse
WIDGET-RED-SM,30,Warehouse
GADGET-001,12,Retail Store
GADGET-002,8,Retail Store

Stock Count with Barcodes

barcode,sku,quantity
4901234567890,WIDGET-BLU-SM,25
4901234567891,WIDGET-BLU-MD,18
4901234567892,WIDGET-RED-SM,30

Common Import Errors

SKU Not Found

Error: SKU "WIDGET-XYZ" not found in catalog (row 5)

Cause: The SKU in your CSV does not match any product variant in your Shopify catalog.

Fix: Verify the SKU is correct and exists in Shopify. Check for extra spaces or typos.

Missing Required Column

Error: Required column "quantity" is missing

Cause: Your CSV file is missing a required column header.

Fix: Ensure your CSV header row includes all required column names exactly as specified.

Invalid Quantity

Error: Invalid quantity value "abc" (row 3)

Cause: The quantity column contains non-numeric values.

Fix: Ensure all quantity values are whole numbers (no decimals, letters, or special characters).

Duplicate SKUs

Warning: Duplicate SKU "WIDGET-BLU-SM" found (rows 2 and 7)

Cause: The same SKU appears multiple times in your CSV.

Fix: Consolidate duplicate rows into a single row with the combined quantity, or ensure each row represents a distinct location.

Bulk Operations via CSV

For large-scale inventory updates, the CSV import workflow is significantly faster than manual entry:

Export current data — start by exporting current stock levels to CSV.
Edit in a spreadsheet — open the CSV in your preferred spreadsheet application and make changes.
Re-import — import the modified CSV back into StockrHub.

This workflow is particularly useful for:

Annual or quarterly full stock counts
Bulk adjustments after a physical inventory audit
Migrating data from another system
Updating stock levels across multiple locations at once