SortSwift Docs
Getting Started
Core Features
Integrations & Tools
Support
Column Mapping
Map CSV columns to inventory fields, auto-mapping rules, and field validation.
After uploading your CSV, you'll map your columns to inventory fields:
- Review the detected CSV headers
- For each field (skuId, quantity, price, etc.), select the corresponding CSV column
- Auto-mapping attempts to match common column names (e.g., "SKU", "Qty", "Price")
- Verify all required fields are mapped
- Optional fields can be left unmapped if not in your CSV
Auto-Mapping Rules
- SKU ID: Matches "skuId", "sku_id", "SKU", "SKU ID"
- Product ID: Matches "productId", "product_id", "Product ID", "PRODUCT_ID"
- Quantity: Matches "quantity", "qty", "Quantity", "QTY", "count"
- Price: Matches "price", "Price", "PRICE", "sell_price"
- Cost: Matches "cost", "Cost", "COST", "buy_price", "purchase_price"
- Condition: Matches "condition", "cond", "Condition", "CONDITION"
- Language: Matches "language", "lang", "Language", "LANGUAGE"
- Printing: Matches "printing", "Printing", "PRINTING", "finish", "foil"
Field Validation
The system validates mapped fields:
- Condition: Validates against accepted values (NM, LP, MP, HP, DMG) with auto-conversion
- Language: Validates language codes (EN, JP, FR, etc.) with auto-conversion
- Printing: "Normal" or "normal" = Normal, anything else = Foil
- Quantity: Must be positive integer (comma-separated values sum together)
- Price/Cost: Must be valid decimal numbers