# How to import products in bulk

> Published: 2026-06-18
> Updated: 2026-07-08
> Category: Manage
> Canonical: https://finalpos.com/help/import-products

To import products in bulk, go to Settings → Import / Export and choose Import Data. Pick Products, upload your CSV or Excel (.xlsx) file (the first row must be column headers), map each file column to a field, preview the changes, and run the import.

## Key takeaways

- Bulk import is in the Merchant Hub under Settings → Import / Export → Import Data.
- Choose Products as the resource, then upload a CSV or Excel (.xlsx) file.
- The first row of your file must contain column headers.
- Map each file column to the matching field in your store; you can apply a saved mapping.
- Preview the changes (and resolve duplicates) before running the import — a Dry run lets you preview only.

## Before you begin

Prepare a **CSV** or **Excel (.xlsx)** file of your products, with **column headers in the first row** (the importer reads the headers to map your data). You'll need permission to manage products / import data.

## How to import products

1. In the Merchant Hub, go to **Settings → Import / Export** and choose **Import Data**.
2. **Choose what to import** — select **Products**.
3. **Upload your file** — a **CSV** or **Excel (.xlsx)** file. Drag and drop or choose a file. The first row must contain **column headers**. (You can also paste rows copied from Excel or Google Sheets.)
4. **Map your columns** — match each **File Column** to the matching field in your store, then continue. If you've imported before, you can **apply a saved column mapping**.
5. **Preview the changes** — review the **Changes Preview** and resolve any **duplicates** (for example, fill empty fields from the import into existing records). You can run a **Dry run (preview only)** to check the outcome without saving.
6. **Run the import** — start it. A progress screen shows the status (you can cancel mid-way), and you'll see **Import Complete** with the results when it finishes.

## FAQ

**Q: What file types can I import?**
A: CSV or Excel (.xlsx). You can also paste rows copied from a spreadsheet.

**Q: My columns weren't detected.**
A: Make sure the first row of your file contains column headers.

**Q: Can I preview before importing?**
A: Yes — review the Changes Preview, and use Dry run (preview only) to check the result without saving.

**Q: What happens with duplicates?**
A: The wizard helps you resolve duplicates, including filling empty fields from the import into existing records.

**Q: Can I reuse a column mapping?**
A: Yes — apply a saved column mapping to your file so you don't have to remap each time.