Import products

The Products import creates the sellable items of your catalog, or updates existing ones. Each row is one product variant:

Row without product_id: Qwoty creates a new product and its default variant. You don’t need to create the product (master) first: the import does it.
Row with product_id: Qwoty updates that existing variant and its product.

You need the Import CSV permission in the Apps block of your role. Catalogs, categories, and variant options you reference must already exist.

Open the import

Open Import & Export

Go to Settings › Data › Import & Export and click Products.

Download the template

Click Download Template to get a CSV with all supported columns and a few example rows.

Upload your file

Click Upload File and drop your CSV. The wizard runs in four steps: Upload → Mapping → Confirm → Result.

Check the mapping

Each column of your file is matched to a Qwoty field (groups Main information, Settings, Inventory, External identifiers, Shipping, Accounting, Custom fields). Pick Ignore this column for columns you don’t want to import.

Confirm and import

Review the number of products and variants, download the error rows if any, then click Start import.

The Result step shows how many products were imported. If some rows failed, click Download unimported rows to get them back with the reason in an erreur column.

CSV columns reference

Column	Required	Type	Description
`product_id`	—	UUID	Leave empty to create a product. Set the UUID of an existing variant (from an export) to update it.
`product_name`	—	Text	Product name. On creation, it’s used for both the product and its default variant.
`product_api_name`	—	Text	Stable API identifier. Must not already exist on another product.
`reference`	—	Text	Internal reference.
`product_description`	—	Text	Description shown on quotes and in the Dealroom.
`primary_image_id`	—	UUID	UUID of an image already uploaded to the media library.
`settings[recurrence_type]`	✱	Enum	`one_off` or `recurring`.
`settings[is_active]`	—	Boolean	`true` or `false`.
`settings[product_type]`	—	Enum	For example `finished_good`, `component`, `accessory`, `consumable`, `service`, `consulting`, `training`, `subscription`, `licence`, `rental`, `support`, `one_time_fee`.
`settings[unit_of_measure]`	—	Text	Display unit (for example `unit`, `license`, `hour`).
`settings[language_code]`	—	Enum	`en`, `fr`, `de`, `es`, `it`, or `pt`.
`settings[unit_per_pack]`	—	Number	Units per pack, when sold in packs.
`catalog_api_names`	—	Text	Comma-separated catalog API names.
`category_api_names`	—	Text	Comma-separated category API names.
`inventory[sku]`	—	Text	SKU of the variant.
`identifiers[erp]`, `identifiers[crm]`, `identifiers[accounting]`	—	Text	External identifiers.
`accounting[ledger_account]`	—	Text	Ledger account code.
`shipping[weight]`, `shipping[height]`, `shipping[length]`, `shipping[width]`	—	Number	Shipping dimensions.
`shipping[weight_unit]`, `shipping[length_unit]`	—	Text	Units of the dimensions (the product form uses `kg` / `lbs` and `cm` / `inch`).
`shipping[country_of_origin]`	—	Text	ISO 2-letter country code (`FR`, `DE`).
`shipping[harmonized_system_code]`	—	Text	Harmonized System (HS) code.
`options[N][name]`, `options[N][value]`	—	Text	API names of an existing variant option and of one of its values (for example `size` / `m`). `N` starts at 1.
`custom[<api_name>]`	—	Text, Number, or Date	Value of a product custom field. The API name must exist in Settings › Data › Data Model.

When catalog_api_names or category_api_names contain several values, wrap the cell in double quotes: "france,partner_pricing". Without the quotes, the comma inside the cell breaks the row.

Catalogs and prices

On creation, Qwoty links the product to the catalogs listed in catalog_api_names and always to the workspace’s default catalog, then generates the matching price entries. Catalog API names that don’t exist are skipped. On update, catalog links are replaced only if the catalog_api_names column is mapped. After the products import, fill in their prices with the Prices import.

Variant options

The options[N][...] columns link a variant to option values that already exist in Products & pricing › Product options. The import doesn’t create options or values. If an option or value isn’t found, the Result step reports an error for that row.

Common scenarios

Create simple products

product_id,product_name,product_api_name,settings[recurrence_type],catalog_api_names,inventory[sku]
,Wireless Mouse,wireless_mouse,one_off,france,SKU-001
,USB-C Cable,usb_c_cable,one_off,france,SKU-002
,Support Plan,support_plan,recurring,france,SKU-003

Update existing products

Export your products first (Export panel › Export CSV) to get their product_id, then import only the columns you want to change:

product_id,product_name,inventory[sku]
6ddb0e85-1d1e-4c11-b45d-c9c7ff7c62e8,Wireless Mouse Pro,SKU-001-PRO
9b7ccfa9-1234-5678-aabb-c0ffee123456,USB-C Cable v2,SKU-002-V2

Only mapped columns are updated. Other fields stay untouched.

Troubleshooting

Invalid recurrence_type

The only accepted values for settings[recurrence_type] are one_off and recurring (lowercase, with an underscore).

The product isn't in the expected catalog

Check the catalog API names in Products & pricing › Catalog. Names that don’t match an existing catalog are skipped. For several catalogs, wrap the cell in double quotes: "france,partner_pricing".

primary_image_id is rejected

The UUID must be a valid UUID of an image in your media library. Upload your images first, then export your media list to get their UUIDs.

The generated technical name already exists

Another product already uses this product_api_name. Change the value in your file, or set product_id to update the existing product instead.

Option definition or value not found

Create the variant option and its values in Products & pricing › Product options first, then use their API names in options[N][name] and options[N][value].

My boolean field returned an error

Use true or false.

Next steps

Import prices

Now that products exist, fill in their prices.

Prepare your CSV

Universal formatting rules.

Catalogs

Manage where products live.

Product options

Create the categories and variant options your import references.

Quotes

Catalog & Products

Customers

Templates

Approvals & Workflows

Dealroom

Documents & Models

Settings (Admin)

Data migration

Data Model

Troubleshooting

Import products

Open the import

CSV columns reference

Catalogs and prices

Variant options

Common scenarios

Create simple products

Update existing products

Troubleshooting

Next steps

Import prices

Prepare your CSV

Catalogs

Product options

​Open the import

​CSV columns reference

​Catalogs and prices

​Variant options

​Common scenarios

​Create simple products

​Update existing products

​Troubleshooting

​Next steps

Import prices

Prepare your CSV

Catalogs

Product options

Open the import

CSV columns reference

Catalogs and prices

Variant options

Common scenarios

Create simple products

Update existing products

Troubleshooting

Next steps