ZenotiHelp

Import and export products

ZTZenoti Docs Team Updated September 11, 2026 4 min readGuide

Use import and export operations to manage product data in bulk through spreadsheet files. Zenoti supports importing and exporting products, vendor-product associations, variant associations, and service-product associations.

Audience: Administrators who manage product data in bulk.

Before you begin

Permission: ImportProduct (under ImportExport in the Administrator section of the security role) — Required for product imports.

Permission: ExportProduct (under ImportExport in the Administrator section of the security role) — Required to export product data.

Permission: ImportVendor_Product (under ImportExport) — Required to import vendor-product associations.

Permission: ExportVendor_Product (under ImportExport) — Required to export vendor-product data.

  • Product categories, brands, centers, and vendors referenced in import files must already exist in Zenoti before importing.
  • Product variant associations can only be imported (not exported).

Supported import and export operations

Operation Import Export
Products Yes Yes
Vendor-product associations Yes Yes
Product variant associations Yes No
Service-product associations Yes Yes

Steps

Export products

  1. Navigate to Inventory > Products.
  2. Click Export.
  3. Select the export format (Excel or CSV).
  4. Download the exported file.

The exported file contains all product records in your organization's catalog with their current data.

Import products

Important: Categories, brands, and other referenced data must exist in Zenoti before importing. Import will fail for records that reference non-existent data.

The product import template includes the following key fields:

  • Product name — Required. Must be unique within the organization. Maximum 256 characters.
  • Product code — Required. Must be unique within the organization. Maximum 32 characters.
  • Category — Required. The category must already exist.
  • Retail — Indicates whether the product is retail (Yes/No).
  • Consumable — Indicates whether the product is consumable (Yes/No).
  • MRP — The maximum retail price at the organization level.
  1. Navigate to Inventory > Products.
  2. Click Import.
  3. Download the import template file.
  4. Populate the template with your product data.
  5. Upload the completed file.
  6. Review the import results — successful records and any errors are reported.

Export vendor-product associations

  1. Navigate to the vendor-product export page.
  2. Apply filters if needed (for example, by center or vendor).
  3. Click Export and download the file.

Import vendor-product associations

  1. Navigate to the vendor-product import page.
  2. Download the import template.
  3. Populate the template with vendor code, product code, center code, purchase price, and other required fields.
  4. Upload the file.
  5. Review the import results.

Import product variant associations

Variant associations link color and size combinations to parent products:

  1. Navigate to the variant association import page.
  2. Download the import template.
  3. Populate the template with parent product code, color, and size combinations.
  4. Upload the file.
  5. Review the import results.

Note: Product variant association import requires the Enable colors and sizes for products organization setting to be active.

Import service-product associations

Service-product associations define which products are consumed during which services:

  1. Navigate to the service-product association import page.
  2. Download the import template.
  3. Populate the template with service code, product code, and quantity.
  4. Upload the file.
  5. Review the import results.

Common import errors

Error Cause Resolution
Duplicate product code The product code already exists in the organization Use a unique code
Category not found The category does not exist Create the category first
Brand not found The brand does not exist Create the brand first
Invalid product type Both Retail and Consumable are blank Set at least one to Yes

Troubleshooting

Import completes but some rows are missing

The import skips invalid rows and imports valid ones. Download the results file after upload — each skipped row includes an error reason. Correct the flagged rows and re-import only those records.

"Category not found" error for rows you believe are correct

Category codes are case-sensitive in the import file. Open Configuration > Products and verify the exact category code, including capitalization, then update your import file to match.

Variant association import fails with a permission or setting error

Variant imports require the Enable colors and sizes for products organization setting to be active. If the setting is off, contact your Zenoti administrator to enable it before attempting the import.

Vendor-product import rows are rejected for products in open purchase orders

Products that appear in purchase orders with a status of Raised, Partially Delivered, or In Transit cannot have vendor associations changed. Deliver or cancel the relevant purchase orders, then re-run the import.

Export returns no data for product-center associations

Confirm you have the Export Product-Centers permission under the Products security object. If the permission is present and the export is still empty, verify that the products are associated with at least one center in Inventory > Products.

Tips

  • Always download and use the provided import template — using your own file format may cause import failures.
  • Include all required fields for each import type — missing required fields will cause records to fail validation.
  • Import large datasets in smaller batches if you encounter performance issues.
  • After importing, verify a sample of records in the UI to confirm the import applied correctly.
Was this article helpful?
Your feedback helps us improve our documentation.