Product column mapping

Match product import columns, SKUs and prices

Column matching connects each source column to a product field in My Inventory Items. Select the sheet and header row, inspect the example values, correct automatic matches and mark unused columns as “Don’t import” before reviewing.

Open My Inventory Items See the import steps

Match by meaning, not just the heading

A column called Rate may mean selling price or purchase price. Inspect its sample values and the source system’s definition. A product code may be a SKU, whereas a barcode is the identifier printed for scanning.

Map product name to Name and product code to SKU when appropriate.
Keep Barcode distinct from SKU.
Check Unit, Category, Brand, Selling price and Purchase price separately.

Reuse a mapping only for the same layout

The review screen lets you remember column matching and give it a name. Reuse that mapping when a future export has the same layout, then inspect the matches again if the source file changes.

Name the mapping for its source and layout.
Check the correct sheet and column-header row.
Review sample values before confirming the import.

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 Skip, update or add duplicate products during import

All migration guides Product import help Inventory spreadsheet Invoice & billing

Product column mapping

Match product import columns, SKUs and prices

Open My Inventory Items See the import steps

Match by meaning, not just the heading

Map product name to Name and product code to SKU when appropriate.
Keep Barcode distinct from SKU.
Check Unit, Category, Brand, Selling price and Purchase price separately.

Reuse a mapping only for the same layout

The review screen lets you remember column matching and give it a name. Reuse that mapping when a future export has the same layout, then inspect the matches again if the source file changes.

Name the mapping for its source and layout.
Check the correct sheet and column-header row.
Review sample values before confirming the import.

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

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

All migration guides Product import help Inventory spreadsheet Invoice & billing