ZenotiHelp

Audit Import V2 — Filter Products by Batch Tracking

ZTZenoti Docs Team Updated November 10, 2026 5 min readGuide

Audience: Center admin, inventory manager


On this page


The V2 audit import page lets you upload a stock audit template and filter both the exported template and the imported rows by batch-tracking status.

Before you begin

  • Your organization must have inventory enabled and at least one audit in progress or ready for import.
  • You must be signed in to the center whose audit import session you are working with.

Permission: You need the following permissions to perform the actions in this article.

Value (under View Inventory Reports in the Inventory Manager section of the security role) — required to access inventory report and audit import surfaces.

Admin path: Configuration > Security > Security Roles > [your role] > Inventory Manager > View Inventory Reports > Value

Steps

Switch the page to Import mode

The Batch options filter is available on the audit page when batch tracking is enabled for your organization. To navigate to the import surface:

  1. Navigate to Inventory > Audit inventory (V2) > Import.
  2. Open the audit for which you want to import data.
  3. On the audit page, select Import to switch the page to Import mode.

Filter by batch-tracking status

The Batch options filter controls which products are included in both the exported template and the rows processed during import. Products that have batch tracking enabled carry a batch number and an expiry date per imported row; the Batch options filter lets you scope your template and import to exactly the product set you need.

Note: The Batch options filter is displayed only when batch tracking is enabled for your organization. If the filter does not appear, your organization does not have batch tracking enabled.

  1. In the Batch options filter, select one of the following options:

    Option What it includes
    All All products, regardless of whether batch tracking is enabled (default)
    Batch tracking enabled Only products that have batch tracking turned on; imported rows for these products include batch number and expiry date
    Batch tracking not enabled Only products that do not use batch tracking
  2. After selecting an option, use Export to download the audit template pre-filtered to your selection. The downloaded file reflects only the products that match the batch-tracking status you chose.

Note: If your audit includes both batch-tracked and non-batch-tracked products, run two separate imports — one with Batch tracking enabled and one with Batch tracking not enabled — to handle each product set appropriately.

Validate the import file

  1. Select Excel File and upload your completed audit template.

  2. Select Validate to check the file before committing the data.

    After validation completes, the page shows a summary:

    • Total: total rows read from the file
    • Valid: rows that passed all checks
    • Failed: rows that failed validation
  3. Review the Errors and Warnings tabs for details on any rows that did not pass.

Export issue files

After validation, two export actions are available if issues exist:

  • Export Issues — Downloads an Excel workbook named AuditImportIssues.xlsx containing an Errors sheet and a Warnings sheet for the completed validation. This button is visible only when the validation has produced at least one error or warning.
  • Export Issue Rows — Exports rows that the page identified as problematic during client-side parsing, before a server-side import session is created. Use this action when you need to review parse-time problems that occurred before the file was submitted to the server.

To export issues:

  1. After validation, locate the Errors or Warnings tab to confirm issues exist.
  2. Select Export Issues to download AuditImportIssues.xlsx.
  3. Open the workbook and review the Errors sheet first, then the Warnings sheet.
  4. Correct the identified rows in your source template.
  5. Re-upload the corrected file and select Validate again.

To export parse-time issue rows:

  1. If the file fails to parse before a server import session is created, select Export Issue Rows.
  2. Review the downloaded rows to identify formatting or structural problems in the file.
  3. Correct those rows and re-upload.

Tip: Fix all Errors before addressing Warnings. Rows listed under Errors are blocked from import; rows under Warnings are imported but flagged for review.

Tips

  • Match the Batch options filter to your products before exporting the template. If you export with All selected and then import a file that contains batch-tracked products mixed with non-batch-tracked products, validation may flag mismatches. Exporting separate templates for each batch-tracking status reduces errors.
  • Stay signed in to the correct center throughout the session. If you switch centers mid-session, the operation is rejected. Sign back in to the correct center and restart the import from the beginning.
  • Use Export Issues to create a correction record. The AuditImportIssues.xlsx workbook gives you a structured view of every problematic row and reason. Keeping this file alongside your corrected template makes it easier to audit the remediation steps later.
  • Run validation before committing. Committing imports rows into the live audit. Validating first lets you identify and fix all errors and warnings without affecting stock data.

Troubleshooting

The Batch options filter is not visible.

The filter appears only when batch tracking is enabled for your organization. If the control does not appear, your organization does not have batch tracking enabled. Contact your Zenoti administrator to confirm whether batch tracking is active for your organization.

An access error appears when polling status or committing the import.

This error means the import session belongs to a different center than the one you are currently signed in to. Sign out, sign back in to the correct center, and restart the import from the beginning.

The Export Issues button is not visible after validation.

The Export Issues button appears only when the validation produced at least one error or warning. If both the Errors and Warnings tabs show zero rows, the button is intentionally hidden because there is nothing to export.

The downloaded AuditImportIssues.xlsx file is empty or contains only headers.

This can occur if the validation run that produced issues was replaced by a newer, clean validation before you downloaded the file. Re-upload the file that produced errors, run Validate again, and select Export Issues immediately after validation completes.

Parse-time errors appear before the file reaches the server.

If the file fails structural checks before an import session is created, the Export Issue Rows action becomes available. Download the issue rows, correct the formatting problems in your source template — such as missing columns, incorrect date formats, or extra rows — and re-upload.

Validation shows errors for products with batch tracking even though the template was exported with Batch tracking enabled.

Confirm that the products in your file still have batch tracking active. If batch tracking was disabled on a product after the template was exported, the import rows for that product will not match the current product configuration. Re-export the template, update the quantities, and re-import.

Was this article helpful?
Your feedback helps us improve our documentation.