Common Import Errors
Most import issues are caused by file formatting. Here are the most common problems and how to fix them.
“No columns detected”
Cause: The file does not have a header row, or the header row uses non-standard delimiters.
Fix: Open your CSV in a text editor and verify the first row contains column names separated by commas. If your file uses tabs or semicolons, re-export it as a standard CSV.
“Duplicate entries found”
Cause: LSPRO detected rows that match existing inventory by title and issue number.
Fix: Review the duplicates in the import preview. You can choose to skip duplicates, overwrite existing entries, or merge data from both sources.
“File too large”
Cause: The CSV exceeds the processing limit for a single import batch.
Fix: Split your file into smaller batches (under 3,000 rows per import) and import them sequentially.
“Column mapping failed”
Cause: One or more columns could not be automatically mapped to LSPRO fields.
Fix: Use the manual mapping interface to assign unmapped columns. Columns with unusual names (like abbreviations or non-English headers) may need manual assignment.
Import Seems Stuck
Cause: Large imports can take 15-30 seconds to process. Google Sheets has a 30-second execution limit.
Fix: Wait for the progress indicator to complete. If it times out, try importing in smaller batches. Do not close the tab during processing.