Housecall Pro duplicate SKU

What this means

The SKU (or item code) is an internal identifier for a line item. It’s optional in a Housecall Pro price book, but when you use it, it should be unique per item. Two rows with the same SKU make it unclear which item is which, complicate later updates, and commonly break a QuickBooks sync, where item identifiers are expected to be unique.

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 updates and accounting sync 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 optional. But if you use it, keep it unique per item — duplicates make your catalog ambiguous and commonly break QuickBooks sync.

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.