What should you check before reimporting a Housecall Pro price book?
Do not review the whole spreadsheet equally. Focus first on what changed, then confirm the file still has the structure and required values Housecall Pro expects.
1. Keep the original file
Do not overwrite the export you started from. You need it as a source of truth for change review and rollback.
2. Check what changed
- How many rows changed?
- Which columns changed?
- Did any price or cost become zero?
- Did categories or industries change?
- Did any identifier disappear?
- Was any source column removed?
3. Check required values
Confirm that required service or material fields are still populated and mapped correctly. Blank required values can be introduced accidentally during filtering, fills, copy and paste, or spreadsheet cleanup.
4. Check the CSV or Excel structure
Verify the real header row, column alignment, quoting, workbook sheet structure, and file type before uploading. A file that opens in Excel is not automatically a safe import file.
5. Review unusual business changes
Structural validity and business correctness are different checks. A valid file can still contain an unintended zero price, category move, missing column, or large bulk change. The free Change Audit is designed for this before and after review.
6. Test small before going large
Use a limited test import when practical. Confirm the result in Housecall Pro before applying the full update.
FAQ
- Is a valid CSV enough to make a reimport safe?
- No. File validity checks structure. You should also verify that the business changes inside the file are the changes you intended.
- What should I review first in a large file?
- Start with changed rows and fields, especially prices, costs, categories, identifiers, and removed columns.
- Does ImportFix upload my price book data for analysis?
- The scan and comparison run locally in your browser. Your price book rows are not uploaded to an ImportFix server for analysis.
Edited a price-book file already?
Compare the original and edited CSV/XLSX first, then scan the final file for supported import issues. No account or Housecall Pro API key required.
Findings preview is free. Payment is required only to unlock a corrected-file download.