Skip to main content

Inventory Count Import File Template

Introduction

This topic describes the structure and usage of the Excel template used to import inventory count data into the system. The template supports both Serialized and Non-Serialized inventory counts.


Non Serialized Inventory Count Template

Column NameRequirement
UPCMandatory. Identifies the product.
CountedEnter the total counted quantity for the item.

Serialized Inventory Count Template

Column NameRequirement
Serial NumberMandatory. Unique identifier for each item.
CountedEnter 1 if the item is physically present, otherwise 0.