Skip to main content
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

Import methods

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: Customers, catalogs, pricebooks, and other objects can’t be imported by CSV. Create them in the app or through the API.
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.

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).
  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
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 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.

Reference

Concepts and rules that apply to every import.

Supported file formats

File format, size limits, and CSV best practices.

Field mapping

How Qwoty matches your CSV columns to its fields.

Uniqueness constraints

Which identifiers create or update records.

Import relations

How to link records to catalogs, categories, and pricebooks.

Error handling

Validation errors and how to fix them.

How-tos

Prepare your CSV files

Format your data correctly before importing.

Import products

Create or update products and attach them to catalogs.

Import prices

Fill in pricebook prices: six pricing models supported.
Last modified on October 27, 2026