Housecall Pro duplicate SKU

A SKU is meant to identify one item uniquely. When two rows share the same SKU, your catalog becomes ambiguous and later edits get harder to track.

What this means

The SKU (or item code) is an internal identifier you may keep in your own catalog. It is not one of Housecall Pro’s documented price-book import fields, so a duplicate SKU will not block a Housecall Pro import — this is a data-quality check, not an HCP requirement. Still, if you track SKUs, keeping them unique per item avoids ambiguity when you update or reconcile items later.

Why duplicates happen

  • Copy-pasting a row and forgetting to change its SKU.
  • Exporting from another system that reused codes across categories.
  • Blank SKUs that a spreadsheet auto-filled with the same value.
  • The same physical part listed twice under different names.

How to fix it, step by step

  1. Sort or use a duplicate-highlight rule on the SKU column to see repeats.
  2. For genuine duplicates (the same item listed twice), remove the extra row.
  3. For different items that happen to share a code, give each a unique SKU.
  4. If you don’t track SKUs, it’s fine to leave the column blank rather than repeat a value.
  5. Re-check and re-import.

Common mistakes

  • Assuming a duplicate SKU is harmless — it makes later updates and item lookups ambiguous.
  • Filling every blank SKU with the same placeholder.
  • Deleting the wrong row when two items legitimately differ.

Prevent it next time

Keep one SKU per item, or leave it blank. The price book checker flags duplicate SKUs and points to the exact rows, so you can decide which to keep before you import — it never deletes a row for you. The template keeps SKU as its own optional column.

FAQ

Is a SKU required in a Housecall Pro price book?
No. SKU is not a documented Housecall Pro import field, so it is not required and will not block an import. If you keep SKUs in your own catalog, making them unique per item avoids ambiguity later.
Does ImportFix delete duplicate rows automatically?
No. It flags duplicate SKUs and shows you the exact rows so you can choose which to keep or fix. It never removes an item for you.

See also the full list of import errors.

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.

Compare two files freeScan one file free

Findings preview is free. Payment is required only to unlock a corrected-file download.