Import and export products
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
- Navigate to Inventory > Products.
- Click Export.
- Select the export format (Excel or CSV).
- 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.
- Navigate to Inventory > Products.
- Click Import.
- Download the import template file.
- Populate the template with your product data.
- Upload the completed file.
- Review the import results — successful records and any errors are reported.
Export vendor-product associations
- Navigate to the vendor-product export page.
- Apply filters if needed (for example, by center or vendor).
- Click Export and download the file.
Import vendor-product associations
- Navigate to the vendor-product import page.
- Download the import template.
- Populate the template with vendor code, product code, center code, purchase price, and other required fields.
- Upload the file.
- Review the import results.
Import product variant associations
Variant associations link color and size combinations to parent products:
- Navigate to the variant association import page.
- Download the import template.
- Populate the template with parent product code, color, and size combinations.
- Upload the file.
- 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:
- Navigate to the service-product association import page.
- Download the import template.
- Populate the template with service code, product code, and quantity.
- Upload the file.
- 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.