Import and export services
Zenoti supports bulk import and export of service data, allowing you to create or update multiple services at once using structured files (Excel or CSV). This is especially useful during initial setup, when onboarding new centers, or when making bulk changes to service configurations.
This article explains the available import and export types, the workflow for each, and best practices for preparing import files.
Audience: Administrators who manage the service catalog and need to create, update, or export service data in bulk.
On this page
- Before you begin
- Available import types
- Import services
- Import service custom fields
- Import service field associations
- Import service-form associations
- Import service-product associations
- Import service variant associations
- Export service data
- Tips
- Troubleshooting
- Related articles
Before you begin
- You have the required import/export permissions.
- You have a properly formatted import file (download the template from Zenoti before filling in your data).
Permission: The check box named for the import type (for example ServiceImport, ServiceCenterAssociationImport, ServiceVariantAssociationImport) under DataIO in the Administrator section — required to validate, import, and export that type on the Import bulk data page.
Available import types
Zenoti supports the following service-related import types on the Import bulk data page. Both import and export are available for each type listed unless otherwise noted.
| Import type | Description |
|---|---|
| Services | Create or update services in bulk, including name, code, duration, category, pricing, and other core fields. |
| Service custom fields | Import custom field definitions for services. |
| Service field associations | Map custom fields to specific services in bulk. |
| Service-form associations | Associate HTML forms with services in bulk. |
| Service Product Association | Link consumable products to services in bulk (for example, products auto-deducted from stock at appointment completion). Both import and export are available. |
| Service Variant Association | Map variants to services and configure center-specific variant availability in bulk. Both import and export are available. |
| Service Center Association | Map services to centers in bulk — service code, center code, tax included, tax group, sale price, member price, show in catalog, and zone. Import this after the Services import: services created by the Services template alone are not associated with any center. Both import and export are available. |
Note: There is no bulk-disable or bulk-deactivation import type. There is also no import type that deactivates or disables a service without deleting it. If your goal is to make services unavailable at multiple centers, the supported path is to remove the service's center associations — via the Centers tab on the service form or by importing a center-association removal row using the Service Center Association import type. A service with no center associations remains in the system and can be reassociated with centers at any time. If you need to permanently delete services in bulk, Zenoti provides a separate Service Void import type (import only, no export) under the Void group on the Import bulk data page — contact your administrator before using this option, as the operation cannot be undone.
Import services
Download the import template
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Services group and the import type (for example, Services).
- Click Download Templates.
- Save the template file to your computer.
The template contains the required columns, formatting guidelines, and example data. Always use the latest template to ensure compatibility.
Prepare the import file
- Open the downloaded template in Excel or a CSV editor.
- Fill in the data for each service. Required columns are marked in the template header.
- Follow these guidelines:
- Service name must be unique within the organization. Zenoti rejects any import row whose name is already used by a different service in the organization.
- Code is the matching key that determines whether a row creates a new service or updates an existing one. If the Code column matches an existing service's code, Zenoti updates that service record — including renaming it if you supply a new Name value. This makes bulk renaming possible: submit an import file with the existing Code and the new Name, and Zenoti renames each matched service. If the code does not match any existing service, Zenoti creates a new service.
- Duration is specified in minutes.
- Category must match an existing category name exactly.
- Leave optional columns blank if not applicable.
- Save the file in the supported format (Excel .xlsx or CSV).
Upload and process the import
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the import type.
- Click Upload and select your prepared file.
- Zenoti validates the file and displays a preview with:
- Total records found
- Records that will be created (new)
- Records that will be updated (existing)
- Records with validation errors
- Choose Validate to check your file without importing, or Validate and Import only valid rows to validate and immediately process all rows that pass.
- Review the validation results. Common validation errors include:
- Duplicate service names (a name already used by a different service in the organization)
- Missing required fields
- Invalid category names
- Data type mismatches (for example, text in a numeric field)
- Fix any errors in the source file and re-upload, or proceed with the valid records.
- Zenoti displays a summary showing the number of records successfully imported and any records skipped due to errors.
Note: Import is not all-or-nothing. Rows with errors are skipped while all valid rows in the same file are imported. Always re-import any skipped rows after correcting the errors.
Worked example: You upload a 50-row Services file to rename 20 existing services and add 30 new ones. The file uses existing service codes for the 20 renames and new codes for the 30 additions. After validation, Zenoti reports 2 rows with errors (duplicate names). Those 2 rows are skipped; the remaining 48 rows — renames and new services — are imported successfully. You correct the 2 error rows in the source file and re-upload those rows.
Import service custom fields
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Service Custom Fields import type.
- Download the template and fill in the custom field definitions (field name, field type, validation rules).
- Upload the file and review the validation results.
- Choose Validate and Import only valid rows to create the custom field definitions.
Import service field associations
This import maps existing custom fields to specific services:
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Service Field Associations import type.
- Download the template and fill in the service-to-field mappings.
- Upload the file and review the validation results.
- Choose Validate and Import only valid rows to create the associations.
Import service-form associations
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Service-Form Associations import type.
- Download the template and fill in the service-to-form mappings.
- Upload the file and review the validation results.
- Choose Validate and Import only valid rows to create the associations.
Import service-product associations
The Service Product Association import links consumable products to services for stock auto-deduction at appointment completion. Only consumable products can be imported — retail-only products will be rejected.
Template columns
Download the import template to get the current column structure and the exact accepted values for the Action column for your Zenoti version. The template includes the following categories of columns:
| Column | Description |
|---|---|
| Service Code | The code of the service to associate the product with. Must match an existing service. |
| Product Code | The code of the consumable product. Must match an existing consumable product. Retail-only products are not accepted. |
| Quantity | Units of the product consumed per appointment for this service. |
| ConsumedByDefault | Controls auto-checkout behavior. Yes — the product is automatically deducted from stock when the appointment is completed (auto-checkout). No — the product appears as a suggested consumption; the provider must confirm it manually before stock is deducted. |
| Action | The operation to perform on the association (create, update, or remove). Download the template to confirm the exact accepted values for your Zenoti version. |
Important: The ConsumedByDefault column directly controls the auto-checkout behavior for each line. Set it intentionally — a row with ConsumedByDefault set to No will not trigger automatic stock deduction on appointment completion, regardless of your org-level auto-checkout setting.
Steps
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Service Product Association import type.
- Download the import template to get the correct column structure and accepted values for Action.
- Fill in the service-to-product mappings, setting ConsumedByDefault and Action for each row.
- Upload the file and review the validation results.
- Choose Validate and Import only valid rows to create, update, or remove the associations.
For inventory consumed during services, see Inventory.
Import service variant associations
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Service Variant Association import type.
- Download the template and fill in the variant-to-service mappings, including center-specific availability.
- Upload the file and review the validation results.
- Choose Validate and Import only valid rows to create the associations.
Export service data
Zenoti supports exporting the following service data:
| Export type | Included data |
|---|---|
| Service data | Service definitions including name, code, duration, category, pricing, active status, and all configured fields. |
| Service Center Association | Service-center mappings: service code, center code, tax included, tax group, sale price, member price, show in catalog, and zone. This type is available both on the Import bulk data page and as a Price list export icon on the Master data > Services listing. |
| Field configurations | Custom field definitions and their service associations. |
Note: The Price list export on the Master data > Services listing requires the Export_ServiceCenters check box under Services in the Administrator section. This is separate from the DataIO permission that gates the Import bulk data page.
Export services
- Navigate to Configuration > Business details > Business setup > Import bulk data (center scope).
- Select the Services group and the type (for example, Services or Service Center Association).
- Configure export filters if available (for example, filter by category or active status).
- Click Export.
- Zenoti queues the export and sends you an email when the file is ready.
- Download and save the exported file.
Tip: Export your current service data before performing a bulk import. This gives you a backup and a reference for the correct data format.
Tips
- Always download the latest template before preparing an import file. Templates may change between Zenoti updates.
- Export before importing to maintain a backup of your current configuration.
- Validate before importing. Use the Validate action to check your file for errors without committing any changes. Fix all reported issues before switching to Validate and Import only valid rows.
- Start with a small batch when importing for the first time. Import a few records to verify the process works as expected before importing the full data set.
- Use Code as your update key. The Code column is the matching key for both create and update operations. If the code matches an existing service, Zenoti updates that record. To rename a service in bulk, supply the existing code alongside the new name — Zenoti updates the existing record rather than creating a duplicate. If the name you supply is already used by a different service in the organization, the row is rejected.
- Import center associations after services. Services created by the Services import are not associated with any center. Run the Service Center Association import immediately after to make new services available at the appropriate centers.
- There is no bulk-disable import type. To make services unavailable at multiple centers, remove their center associations via the Service Center Association import (set the Action column to remove) or through the Centers tab on the service form. A service with no center associations remains in the system and can be reassociated later. No import type deactivates or disables a service without deleting it.
Troubleshooting
Rows are skipped with a "duplicate name" error even though the name looks unique.
- Service name uniqueness is enforced across the entire organization, not within a category or center. Check whether another service elsewhere in the organization already uses that name. Export all services and search the exported file for the name in question.
I uploaded a file to rename services but Zenoti created new services instead.
- The Code column is the matching key. If the code in your import row does not exactly match an existing service code (including case and spaces), Zenoti treats the row as a new service. Verify that the codes in your import file match the codes in the exported service list exactly.
The Service Product Association import rejected a product row with a "retail product not accepted" error.
- Only products configured as consumable products are valid rows in this import. Retail-only products must be excluded. Check the product's configuration and confirm it is set up as a consumable before including it in the file.
The export email has not arrived after several minutes.
- Large exports are queued and processed in the background. Check your spam or junk folder. If the email does not arrive within 30 minutes, verify that your Zenoti user profile has a valid email address on file and try the export again.
Validation passes but the import summary shows zero records imported.
- Confirm you used Validate and Import only valid rows rather than Validate only. The Validate action checks the file but does not import any data.
I cannot find the Import bulk data page.
- The page is center-scoped. Confirm you are viewing a center (not organization or zone level) before navigating to Configuration > Business details > Business setup > Import bulk data. If the page still does not appear, contact your administrator to confirm that import/export is enabled for your organization and that your role has the appropriate DataIO permissions.