> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qwoty.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data migration

> Import and export your products and prices in bulk with CSV files.

Import and export your catalog data with CSV files. It's the fastest way to bring an existing product list or price list into your workspace without writing code.

![Settings › Data › Import & Export with the Products and Prices cards](https://mintcdn.com/qwoty-45352a33/eWpiS0eDlFAhkSLr/images/app/settings-import-export.jpg?fit=max\&auto=format\&n=eWpiS0eDlFAhkSLr\&q=85\&s=7941367e4de83c253ad325168352d341)

## Import methods

| Method | Best for | Limit |
| - | - | - |
| **CSV import** | One-time migrations, periodic bulk updates | 10,000 rows and 10 MB per file |
| **API** | Large migrations, continuous syncs, automations | See the [developer docs](https://docs.qwoty.io/developers/introduction.md) |

For very large datasets or recurring syncs from your ERP or CRM, use the Qwoty REST API. The CSV importer is the fastest path for one-time migrations and admin-driven bulk updates.

## What you can import

**Settings › Data › Import & Export** has two resources:

| Resource | What it does |
| - | - |
| **Products** | Creates products (each new row creates a product with its default variant) or updates existing ones. Links products to catalogs, categories, and existing variant options. |
| **Prices** | Updates the prices Qwoty generated in your pricebooks: pricing model, amounts, tiers, VAT, commitment. |

Customers, catalogs, pricebooks, and other objects can't be imported by CSV. Create them in the app or through the API.

> [!NOTE]
>
> **Fields must exist before import.** Uploading a CSV creates records, not fields. To fill product custom fields, create them first under **Settings › Data › Data Model**. See [Data model](https://docs.qwoty.io/user-guide/data-model/introduction.md).

### Steps

1. Open **Settings › Data › Import & Export**.
2. Pick **Products** or **Prices**.
3. Click **Download Template** to get a CSV with the expected columns, or **View Documentation** to open the matching guide.
4. Format your file (see [Prepare your CSV files](https://docs.qwoty.io/user-guide/data-migration/how-tos/prepare-csv-files.md)).
5. Click **Upload File**, drop your file, and follow the wizard: **Upload → Mapping → Confirm → Result**.
6. Review validation errors at the Confirm step (**Download error rows**). Errors don't block valid rows.
7. After the import, click **Download unimported rows** if some rows failed, fix them, and import them again.

## Import order

Qwoty objects reference each other:

* A **Product** can be attached to one or more **Catalogs** and **Categories**, and to **variant option values**
* A **Price** belongs to a **Product** and a **Pricebook**

> [!WARNING]
>
> **Import order matters.** The record you reference must exist first:
>
> 1. **Catalogs, categories, pricebooks, and variant options**: create them in the app.
> 2. **Products**: import them with their catalogs in `catalog_api_names`. Qwoty links each new product to these catalogs (plus the default catalog) and generates its price entries.
> 3. **Prices**: export them, fill in the values, and import them back.

See [Import relations](https://docs.qwoty.io/user-guide/data-migration/reference/import-relations.md) for how relation columns work.

## Export data

Each resource page also has an **Export** panel. Choose **All data** or a filter (**Filter by catalog** for products, **Filter by pricebook** for prices), then click **Export CSV**. Use exports to:

* Back up data before a bulk update
* Get the UUIDs you need to update existing records
* Edit data in a spreadsheet, then import it back

## Permissions

Import and export depend on the **Apps** block of your role:

* **Import CSV**: required to upload files
* **Export CSV**: required to download exports

Contact your workspace admin if these are missing. See [Manage roles](https://docs.qwoty.io/user-guide/settings/users/manage-roles.md).

## Reference

Concepts and rules that apply to every import.

> [card] [Supported file formats](https://docs.qwoty.io/user-guide/data-migration/reference/file-formats.md)
>
> File format, size limits, and CSV best practices.

> [card] [Field mapping](https://docs.qwoty.io/user-guide/data-migration/reference/field-mapping.md)
>
> How Qwoty matches your CSV columns to its fields.

> [card] [Uniqueness constraints](https://docs.qwoty.io/user-guide/data-migration/reference/uniqueness-constraints.md)
>
> Which identifiers create or update records.

> [card] [Import relations](https://docs.qwoty.io/user-guide/data-migration/reference/import-relations.md)
>
> How to link records to catalogs, categories, and pricebooks.

> [card] [Error handling](https://docs.qwoty.io/user-guide/data-migration/reference/error-handling.md)
>
> Validation errors and how to fix them.

## How-tos

> [card] [Prepare your CSV files](https://docs.qwoty.io/user-guide/data-migration/how-tos/prepare-csv-files.md)
>
> Format your data correctly before importing.

> [card] [Import products](https://docs.qwoty.io/user-guide/data-migration/how-tos/import-products.md)
>
> Create or update products and attach them to catalogs.

> [card] [Import prices](https://docs.qwoty.io/user-guide/data-migration/how-tos/import-prices.md)
>
> Fill in pricebook prices: six pricing models supported.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.