
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
- Open Settings › Data › Import & Export.
- Pick Products or Prices.
- Click Download Template to get a CSV with the expected columns, or View Documentation to open the matching guide.
- Format your file (see Prepare your CSV files).
- Click Upload File, drop your file, and follow the wizard: Upload → Mapping → Confirm → Result.
- Review validation errors at the Confirm step (Download error rows). Errors don’t block valid rows.
- 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
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
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.

