Duplicate product handling

Skip, update or add duplicate products during import

During review, My Inventory Items identifies existing products by SKU, then barcode, then name. Choose Skip them to add only new records, Update them to apply spreadsheet values, or Add as new to create records even when they look the same.

Open My Inventory Items See the import steps

Choose the behavior before importing

Skip keeps existing product records. Update uses the sheet’s values while blank cells keep old values. Add as new deliberately creates additional records; use it only when those are genuinely separate products.

Use stable SKUs to avoid unintended matches based on names.
Check the preview counts for added, updated, existing and problem records.
Do not retry an import without first checking what the previous run saved.

Understand the limits of undo

The import screen states that undo removes what an import added. Records used since the import are kept, and updated records are not changed back. Save a copy of existing data before a bulk update if you need to reconstruct earlier values.

Do not treat undo as a complete rollback for updates.
Review the completion counts before importing again.
Open Products and compare a sample of the saved records.

From your old catalog to your new product list

Upload, match columns, review, then import. These screens show the product import workflow in My Inventory Items.

Step 1

Upload your product file

Open Settings → Import → Products. Upload Excel (.xlsx or .xls), CSV or OpenDocument (.ods), up to 20 MB.

Step 2

Match columns

Choose the sheet and header row. Inspect automatic matches and example values. Set unused columns to Don’t import.

Step 3

Review products and duplicates

Check the preview and problem counts. Choose Skip them, Update them or Add as new for existing products. Save a reusable mapping if needed.

Step 4

Import and verify

Confirm the import and keep the tab open while it runs. Review the completion counts, then open Products to check the saved records.

Product fields to check before importing

These are preparation checks, not a replacement for the current sample file and field list in your account.

Product import fields and validation checks
Field	Check
Name	Use a clear product name; the matching screen marks Name as required.
SKU and barcode	Preserve leading zeros and keep one stable identifier per separately stocked product.
Category, brand and unit	Use consistent names and confirm whether quantities mean pieces, cartons or another unit.
Selling price and purchase price	Match the right cost and sales columns; review sample values and decimal formatting.
Tax and opening stock	Use the current sample file for available fields. Check the stock date and location before importing quantities.

Verify the result before importing the rest

After the first batch, check the added, updated, skipped and problem counts. Open Products and compare a sample of names, SKUs, barcodes, units, prices and opening quantities with your source file. Fix any mapping issues before continuing. Undo can remove added records that have not been used; it does not restore updates to existing products.

Frequently asked questions

When are product records saved?

The workflow separates upload, column matching, review and import. Review the preview and confirm the import before the uploaded rows are saved as product records.

How should I check a completed import?

Review the added, updated, skipped and problem counts, then open Products. Compare names, identifiers, units, prices and any mapped opening quantities with the source spreadsheet.

Which product import formats are supported?

The product upload screen accepts Excel (.xlsx and .xls), CSV and OpenDocument (.ods) files up to 20 MB.

Is this a direct connection to my old software?

This workflow transfers a file you upload. It does not provide continuous synchronization or automatically sign in to the other software.

What happens if a product already exists?

Products are matched by SKU, then barcode, then name. During review, choose whether to skip existing records, update them or add new records. Blank cells keep old values when updating.

Can I undo a product import?

Undo removes records added by an import when they have not been used since. Records used since are kept. Updates to existing records are not changed back.

Ready to bring over your product list?

Open My Inventory Items, then go to Settings → Import → Products to upload your prepared file.

Open My Inventory Items

More product import guides

Import products from Vyapar to My Inventory Items Import products from Zoho Inventory to My Inventory Items Import products from TallyPrime to My Inventory Items Import products from QuickBooks Online to My Inventory Items Import products from myBillBook to My Inventory Items Import products from Marg ERP to My Inventory Items Import products from Khatabook to My Inventory Items Import products from Excel, CSV or OpenDocument Match product import columns, SKUs and prices

All migration guides Product import help Inventory spreadsheet Invoice & billing